14.04.08: Basic edits run for DTL4 records

1

BAD FORMAT a record if the following fields are not numeric: SSN, Employer Number, Begin Date, End Date, Gross Wages, Member DC Contributions, Employer DC Contributions, Member DC %, Employer DC Match %, Member PHF Contributions, Employer PHF Contributions, Member PHF %, Employer PHF Match %, Status Change Date, and Status Change Code. (The Employer Number is a system added field not visible on the screen. This is for consistency purposes only.)

2

BAD FORMAT a record with dates before January 1, 1900 or after December 31, 2999.

3

BAD FORMAT a record with dates that are not valid.

4

SUSPEND a record if a DC Record Type is present and the following fields are not reported: SSN, Begin Date, and End Date. (The Employer Number is a system added field not visible on the screen. This is for consistency purpose only.)

5

SUSPEND a record if the Record's Begin Date is after the Record's End Date.

6

SUSPEND a record if the reported DC Record Type is not a valid DC Record Type (01,05,06).

7

BAD FORMAT a record if a SSN is reported with all zero's or all nines or is not (9) numeric values.

8

SUSPEND a DTL 4 record if the Record's End Date is prior to 9/1/2010.

9

All the Contributions must be calculated based on the reported gross earnings and the percentages on the feedback file or default. (See Default DC Deferrals)