Customer 360 for Insurance > Predefined Customer 360 for Insurance 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 Organization business entity:
Rule Association Name
Function Name
Applied Field
Description
infac360in_ra_org_reference_period_end_date
Greater Than Date
Reference Period End Date
Validates whether Reference Period End Date is greater than Reference Period Start Date.
infac360in_ra_org_accounting_period_end_date
Greater Than Date
Accounting Period End Date
Validates whether Account Period End Date is greater than Accounting Period Start Date.
infac360in_ra_org_tax_end_date
Greater Than Date
Tax.Effective End Date
Validates whether Tax Effective End Date is greater than Tax Effective Start Date.
infac360in_ra_org_alt_name_end_date
Greater Than Date
Alternate Names.Effective End Date
Validates whether Alternate Names Effective End Date is greater than Alternate Names Effective Start Date.
infac360in_ra_org_status_end_date
Greater Than Date
Status.Effective Start Date
Validates whether Status Effective End Date is greater than Status Effective Start Date.
infac360in_ra_org_identifier_end_date
Greater Than Date
Identifier.Effective End Date
Validates whether Identifier Effective End Date is greater than Identifier Effective Start Date.
infac360in_ra_org_identifier_last_verified_date
No Future Date
Identifier.Last Verified Date
Validates whether Identifier Last Verified Date is not a future date.
infac360in_ra_org_document_valid_to
Greater Than Date
Documents.Valid To
Validates whether Documents Valid To is greater than Documents Validate From.
infac360in_ra_org_document_valid_to
Greater Than Date
Insurance.Effective End Date
Validates whether Insurance Valid To is greater than Insurance Validate From.
infac360in_ra_org_loyalty_end_date
Greater Than Date
Loyalty.Effective End Date
Validates whether Loyalty Effective End Date is greater than Loyalty Effective Start Date.
infac360in_ra_org_customer_since_date
No Future Date
Customer Since Date
Validates that the customer since date is not a future date.
The following table lists the basic rule associations for Person 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.
infac360in_ra_person_death_date
No Future Date
Death Date
Validates whether the Death Date is not a future date.
infac360in_ra_person_missing_date
No Future Date
Missing Date
Validates whether the Missing Date is not a future date.
infac360in_ra_person_customer_since_date
No Future Date
Customer Since Date
Validates that the Customer Since Date is not a future date.
infac360in_ra_person_status_end_date
Greater Than Date
Status.Effective End Date
Validates whether Status Effective End Date is greater than Status Effective Start Date.
infac360in_ra_person_identifier_last_verified_date
No Future Date
Identifier.Last Verified Date
Validates whether Identifier Last Verified Date is not a future date.
infac360in_ra_person_medical_file_update
No Future Date
Medical Detail.Medical File Last Update Date
Validates whether Medical Detail Medical File Last Update Date is not a future date.
infac360in_ra_person_employement_end_date
Greater Than Date
Employment.Effective End Date
Validates whether Employment Effective End Date is greater than Employment Effective Start Date.
infac360in_ra_person_education_end_date
Greater Than Date
Education.Effective End Date
Validates whether Education Effective End Date is greater than Education Effective Start Date.
infac360in_ra_person_tax_end_date
Greater Than Date
Tax Details.Effective End Date
Validates whether Tax Details Effective End Date is greater than Tax Details Effective Start Date.
infac360in_ra_person_alt_name_end_date
Greater Than Date
Alternate Names.Effective End Date
Validates whether Alternate Names Effective End Date is greater than Alternate Names Effective Start Date.
infac360in_ra_person_citizenship_end_date
Greater Than Date
Citizenship.Effective End Date
Validates whether Citizenship Effective End Date is greater than Citizenship Effective Start Date.
infac360in_ra_person_loyalty_end_date
Greater Than Date
Loyalty.Effective End Date
Validates whether Loyalty Effective End Date is greater than Loyalty Effective Start Date.
infac360in_ra_person_identifier_end_date
Greater Than Date
Identifier.Effective End Date
Validates whether Identifier Effective End Date is greater than Identifier Effective Start Date.
infac360in_ra_person_document_valid_to
Greater Than Date
Documents.Valid To
Validates whether Documents Valid To is greater than Documents Validate From.
infac360in_ra_person_insurance_end_date
Greater Than Date
Insurance.Effective End Date
Validates whether Insurance Effective End Date is greater than Insurance Effective Start Date.