14.04.06: Basic edits run for DTL3 records

Rules and descriptions

1: BAD FORMAT a record if the following fields are not numeric: Agreement Number, Invoice Number, SSN, Deduction Reason Code, Pay Period End Date, and Deduction Amount.

2: SUSPEND a record if the Agreement and Invoice Number are equal. (i.e. 012345678 and 12345678).

3: SUSPEND a record if the Deduction Reason Code is not a valid code.

4: BAD FORMAT a record with dates before Jan. 1, 1900, or after Dec. 31, 2999.

5: BAD FORMAT a record with begin or end dates that are not valid.

6: USPEND a record if the following fields are empty: SSN, Pay Period End Date, Agreement Number, or Invoice Number.

7: BAD FORMAT a record if the SSN is reported with all zeros or all nines.

Last updated: 04/13/2012