MDM 360 for Retail > Predefined MDM 360 for Retail assets > Data quality rule associations
  

Data quality rule associations

Add predefined data quality rule associations to the business entity fields to cleanse, standardize, and validate the field values. When you import source records, the data quality rule associations validate and transform the records in MDM 360 for Retail.
The following table describes the advanced rule associations that MDM 360 for Retail uses:
Rule Association Name
Rule Specification Name
Applied Field
Description
GLN Checkdigit
GLN Checkdigit
Manufacturer GLN
Validates whether the GLN number provided is valid or not.
This rule uses check digit logic internally.
GTIN Checkdigit
GTIN Checkdigit
GTIN
Validates whether the GLN number provided is valid or not.
This rule uses check digit logic internally.
AllDayend Check
AllDayend Check
  • - Operating Hours.End Time (Hours)
  • - Operating Hours.End Time (Minutes)
  • - Operating Hours.End Time (Seconds)
Validates whether the applied field values are set to null when the All Day field is set to True.
It internally uses the Endtime Rule to validate the applied fields.
AllDaystart Check
AllDaystartCheck
  • - Operating Hours.Start Time (Hours)
  • - Operating Hours.Start Time (Minutes)
  • - Operating Hours.Start Time (Seconds)
Validates whether the applied field values are set to null when the All Day field is set to True.
It internally uses the Starttime Rule to validate the applied fields.
Endtime Rule
Endtime Rule
  • - Operating Hours.End Time (Hours)
  • - Operating Hours.End Time (Minutes)
  • - Operating Hours.End Time (Seconds)
Validates whether the applied field values are null.
Latitude Check
Latitude Check
Postal Address.Latitude
Validates whether the latitude value is in between -90 and +90.
Longitude Check
Longitude Check
Postal Address.Longitude
Validates whether the longitude value is between -180 and +180.
PostalCode Check
PostalCode Check
Postal Address.Postal Code
Validates whether the applied field value is equal to five when the Postal Code field isn't null.
It internally uses the PostalCode Rule to validate the applied field.
PostalCode Rule
PostalCode Rule
Postal Address.Postal Code
Validates whether the length of the field value is equal to five.
Starttime Rule
Starttime Rule
  • - Operating Hours.Start Time (Hours)
  • - Operating Hours.Start Time (Minutes)
  • - Operating Hours.Start Time (Seconds)
Validates whether the applied field values are null.
State Check
State Check
Postal Address.State
Validates whether the applied field value is equal to USA when the State field isn't null.
It internally uses the State Rule to validate the applied field.
State Rule
State Rule
Postal Address.State
Validates whether the value is equal to USA.
URL Check
URL Rule
URL
Validates whether the value has a valid URL format.