Product 360 for Life Sciences > Product 360 for Life Sciences assets > Data quality rule associations
  

Data quality rule associations

You can use the predefined rule associations to cleanse, standardize, and validate the medicinal product and packaged medicinal product records. When you import source records, the rule associations validate and transform the records.
The following table describes the basic rule associations that the Medicinal Product business entity contains:
Rule Association Name
Function Name
Applied Field
Description
MPID Convert Uppercase
Uppercase
Medicinal Product ID
Converts lowercase values to uppercase.
The following table describes the advanced rule associations that the Medicinal Product business entity contains:
Rule Association Name
Rule Specification Name
Applied Field
Description
MPID Check
MPID Rule Check
Medicinal Product ID
Validates whether the applied field value isn't null and is in a valid format.
This rule association internally uses the All ID Country Code Check rule specification to validate the applied field values.
Identifier Type NDC check
NDC Rule Check
Additional Identifiers.Value
Validates whether the applied field value isn't null and is in a valid format.
This rule association internally uses the NDC Value Check rule specification to validate the applied field values.
MPID Rule Check
MPID Rule Check
Medicinal Product ID
Validates the format of the applied field values based on the following conditions:
  • - The first two characters are a valid country code.
  • - The length of the input is less than or equal to 15.
  • - Characters 3 through 15 are numeric and contains two hyphens.
This rule association internally uses All ID Country Code Check rule specification to validate the applied field values.
All ID Country Code Check
All ID Country Code Check
Medicinal Product ID
Converts lowercase values to uppercase.
This rule association internally uses Country Code Dictionary to validate the applied field values.
NDC Rule Check
NDC Rule Check
Additional Identifiers.Value
Validates the format of the values when the identifier type value is equal to National Drug Code.
This rule association internally uses NDC Value Check rule specification to validate the applied field values.
NDC Value Check
NDC Value Check
Additional Identifiers.Value
Validates the format of the applied field values based on the following conditions:
  • - The length of the input is less than or equal to 14.
  • - Characters are numeric.
  • - Contains two hyphens.
This rule association internally uses NDC Length Check rule specification to validate the applied field values.
NDC Length Check
NDC Length Check
Additional Identifiers.Value
Validates whether the length of the applied field value isn't null and is less than or equal to 14.
The following table describes the basic rule associations that the Packaged Medicinal Product business entity contains:
Rule Association Name
Function Name
Applied Field
Description
Check for minimum length of 14
Minimum Length
GTIN
Validates whether the length of the applied field value is greater than or equal to 14.
Check only digits are allowed
Allowed Characters
GTIN
Validates whether the applied field value contains only numbers.
Check only digits are allowed
Allowed Characters
Manufacturer GLN
Validates whether the applied field value contains only numbers.
Check for minimum length of 13
Minimum Length
Manufacturer GLN
Validates whether the length of the applied field value is greater than or equal to 13.
Valid from must be earlier than Valid to
Lesser Than Date
Selling price.Valid from
Validates whether the date value precedes the Validity End Date field value.
PCID Convert Upper
Uppercase
Packaged Medicinal Product ID
Converts lowercase values to uppercase.
The following table describes the advanced rule associations that the Packaged Medicinal Product business entity contains:
Rule Association Name
Rule Specification Name
Applied Field
Description
PCID Check
PCID Rule Check
Packaged Medicinal Product ID
Validates whether the applied field value isn't null and is in a valid format.
This rule association internally uses the All ID Country Code Check rule specification to validate the applied field values.
PCID Rule Check
PCID Rule Check
Packaged Medicinal Product ID
Validates the format of the applied field values based on the following conditions:
  • - First two characters are a valid country code.
  • - Length of the input is less than or equal to 18.
  • - Characters 3 through 18 are numeric and contains three hyphens.
This rule association internally uses All ID Country Code Check rule specification to validate the applied field values.
All ID Country Code Check
All ID Country Code Check
Packaged Medicinal Product ID
Converts lowercase values to uppercase.
This rule association internally uses Country Code Dictionary to validate the applied field values.