Data Quality Rules

Data quality rules ensure data accuracy, completeness, and validity.

Field Type	Rule	Error Message
Phone Number	Cannot be series of ascending or descending numbers (DQ310)	Error Code:: 667 Error String: Phone number field cannot contain a string of repeating numeric characters (for example 8888888).

	Must meet the proper phone number format	Error Code: 383 Message: Invalid phone number - must enter customer's phone number - please correct and reenter.
	Must contain at least three unique characters (DQ344.1)	Error Code: 4304 Message: Phone number is not a valid format. Please enter again.
Identification	Photo or Legal ID must contain at least one digit, cannot be all alpha-characters only (DQ345.3)	Error Code: 4012 Message: Invalid Photo/Legal ID Number.
Identification	Photo or Legal ID must contain at least three unique characters (DQ333.4)
Address Line 1	Must contain at least 5 characters (DQ13)	Error Code: 4103 Message: The address must contain at least 5 characters.
	Must contain at least 1 alpha character (DQ14)	Error Code: 4104 Message: The address must contain at least one letter (A-Z).
	Field can only contain numbers letters, and limited special characters	Error Code: 379 Message: Only letter, numbers and certain special characters (#./'-,()\") are permitted in the address.
City	Must not contain numbers or special characters except for: . ‘ – (DQ.102.1)	Error Code: 4308 Message: City field can only contain letters (A-Z), period (.), apostrophe (‘) or dash (-).
City	Field can only contain Roman characters (DQ206)	Error Code: 4164 Message: City can only contain Roman characters.
Name	Must not contain numbers or special characters except for: . ‘ – (DQ.102.1)	Error Code: 4309 Message: The name can only contain letters (A-Z), dashes (-), periods (.), and apostrophes (‘).
Name	Field cannot begin with a special character (DQ187.1)	Error Code: 4164 Message: Name fields cannot begin with a special character. NOTE: applied to 1611