The web Browser you are currently using is unsupported, and some features of this site may not work as intended. Please update to a modern browser such as Chrome, Firefox or Edge to experience all features Michigan.gov has to offer.
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. |