Location 360 > Location 360 assets > Data quality rules
  

Data quality rules

You can associate data quality rules with the Location business entity fields to cleanse, standardize, and validate the field values. When you import the source records, the rule associations validate and transform the records in MDM SaaS.
The following table lists the advanced rule associations for the Location business entity:
Rule Association Name
Rule Specification Name
Applied Field
Description
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.
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.
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.
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.
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.
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.