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
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