Customer 360 for Life Sciences > Customer 360 for Life Sciences assets > Data quality rules
  

Data quality rules

You can associate data quality rules to the business entity fields to cleanse, standardize, or validate the field values. When you import the source records, the rule associations validate and transform the records in Customer 360.
The following table lists the basic rule associations for HCO business entity:
Rule Association Name
Function Name
Applied Field
Description
infac360ls_ra_hco_fullname
Title Case
Full Name
Converts first letter of word in uppercase.
infac360ls_ra_hco_doi
No Future Date
Date of Incorporation
Validates whether the date of incorporation is not a future date.
infac360ls_ra_hco_phone_eedate
Greater Than Date
Phone.Effective End Date
Validates whether Phone Effective End Date is greater than Phone Effective Start Date.
infac360ls_ra_hco_email_eedate
Greater Than Date
Email.Effective End Date
Validates whether Email Effective End Date is greater than Phone Effective Start Date.
infac360ls_ra_hco_alternatername_eedate
Greater Than Date
Alternate Names.Effective End Date
Validates whether Alternate Names Effective End Date is greater than Alternate Names Effective Start Date.
infac360ls_ra_hco_identifier_eedate
Greater Than Date
Identifier.Effective End Date
Validates whether Identifier Effective End Date is greater than Identifier Effective Start Date.
infac360ls_ra_hco_status_edate
Greater Than Date
Status.End Date
Validates whether Status Effective End Date is greater than Status Effective Start Date.
infac360ls_rex_dea_number
Regular Match
DEA.DEA Number
Validates whether DEA number matches with the specified regular expression pattern.
infac360ls_ra_hco_dea_edate
Greater Than Date
DEA.End Date
Validates whether DEA End Date is greater than DEA Start Date.
The following table lists the basic rule associations for HCP business entity:
Rule Association Name
Function Name
Applied Field
Description
NO_FUTURE_DATE
No Future Date
Birth Date
Validates whether birth date is not a future date.
CONCAT_WITH_SPACES
Concatenate With Spaces
Full Name
Concatenates first name, middle name, and last name to form full name.
infac360ls_ra_hcp_fname
Title Case
First Name
Capitalizes the first character in the first name and converts all other characters to lowercase.
infac360ls_ra_hcp_mname
Title Case
Middle Name
Capitalizes the first character in the middle name and converts all other characters to lowercase.
infac360ls_ra_hcp_lname
Title Case
Last Name
Capitalizes the first character in the last name and converts all other characters to lowercase.
infac360ls_ra_hcp_ddate
No Future Date
Deceased Date
Validates whether death date is not a future date.
infac360ls_ra_hcp_email_eedate
Greater Than Date
Email.Effective End Date
Validates whether Email Effective End Date is greater than Phone Effective Start Date.
infac360ls_ra_hcp_empl_eedate
Greater Than Date
Employment.Effective End Date
Validates whether Employment Effective End Date is greater than Employment Effective Start Date.
infac360ls_ra_hcp_altname_eedate
Greater Than Date
Alternate Names.Effective End Date
Validates whether Alternate Names Effective End Date is greater than Alternate Names Effective Start Date.
infac360ls_ra_hcp_identifier_eedate
Greater Than Date
Identifier.Effective End Date
Validates whether Identifier Effective End Date is greater than Identifier Effective Start Date.
infac360ls_ra_hcp_status_eedate
Greater Than Date
Status.End Date
Validates whether Status Effective End Date is greater than Status Effective Start Date.
infac360ls_ra_hcp_citiz_eedate
Greater Than Date
Citizenship.Effective End Date
Validates whether Citizenship Effective End Date is greater than Citizenship Effective Start Date.
infac360ls_ra_hcp_edu_eedate
Greater Than Date
Education.Effective End Date
Validates whether Education Effective End Date is greater than Education Effective Start Date.
infac360ls_ra_hcp_sln_exdate
Greater Than Date
License.Expiry Date
Validates whether license end date is greater than license start date.
infac360ls_ra_hcp_sln_graceEnddate
Greater Than Date
License.Grace Period End Date
Validates whether License Grace Period End Date is greater than License Grace Period Start Date.
infac360ls_rel_hcp_dea_number
Regular Match
DEA.DEA Number
Validates whether DEA number matches with the specified regular expression pattern.
infac360ls_ra_hcp_dea_edate
Greater Than Date
DEA.End Date
Validates whether DEA End Date is greater than DEA Start Date.