Skip to main content

14.04.01: Basic edits run for DTL1 records

14.04.01: Basic edits run for DTL1 records

Rule

Description

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