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. |
| 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 (-). |
| 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 (‘). |
| 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 |
Updated 5 months ago
Did this page help you?
