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.03: Basic edits run for DTL2 records
Rules and descriptions
1: BAD FORMAT a record if the following fields are not numeric: SSN, Begin Date, End Date, Retirement Hours, Employer Reported Wages, Exception Wages, Member contributions, Employer Contributions, Pay rate, Contract Begin Date, Contract End Date, and Frequency of Pay.
2: BAD FORMAT a record with record begin and end dates before January 1, 1900, or after December 31, 2999.
3: BAD FORMAT a record with record begin and end dates that are not valid.
4: SUSPEND a record if the reported Class Code is not a valid Class Code.
5: SUSPEND a record if the following fields are not reported: SSN, Begin Date, End Date, and Wage Code.
6: BAD FORMAT a record if the following fields are not reported (blank) or are reported less than zero: Reported Wages Amount, Employee Contribution, Employer Contribution, Pay Rate, Class Code, Begin Date, and End Date.
7: SUSPEND a record if the record's Begin Date is after the record's End Date.
8: SUSPEND a record if the reported Wage Code is not a valid wage code.
9: SUSPEND a record with wage code equal to 04 (retroactive wages) or 45 (positive adjustment to retroactive wages) if the record's End Date is not before the report header's Begin Date.
10: BAD FORMAT a record if a SSN is reported with all zeros or all nines.
11: SUSPEND a record if the pay rate is greater than 300,000.00.
Last updated: 04/13/2012