Skip to main content

14.04.06: Basic edits run for DTL3 records

14.04.06: Basic edits run for DTL3 records

Rule

Description

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

SUSPEND 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