Skip to main content

14.04.01: Basic edits run for DTL1 records

Rules and descriptions

1: BAD FORMAT a record if the following fields are not numeric: SSN, Old SSN, Zip-1, Zip-2, and Date of Birth.

2: SUSPEND a record if the Last Name, First Name, or Middle Name contains: characters other than A-Z, spaces, hyphens (-), apostrophes ('), and commas (,).

3: SUSPEND a record if the Last Name or First Name fields are blank.

4: BAD FORMAT a record if the Date of Birth is not a valid date.

5: BAD FORMAT a record if the Date of Birth is before January 1, 1900, or after December 31, 2999.

6: SUSPEND a record if the State abbreviation is not a valid state abbreviation.

7: SUSPEND a record if the Country Code is not a valid country code.

8: BAD FORMAT a record if the Gender is not M, F, or blank.

9: BAD FORMAT a record if an SSN is reported with all zeros or all nines.

10: SUSPEND a record if the SSN is blank.

11: BAD FORMAT a record if the Date of Birth is a future date.

12: SUSPEND a record if Zip-1 is reported and is not five digits or Zip-2 is reported and is not four digits.

Last updated: 04/13/2012