14.04.03: Basic edits run for DTL2 records

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.