14.04.09: Validations run DTL4 records

1

SUSPEND a record if Status Change date is not a date.

2

SUSPEND a record if Status Change code is not a valid code. Following are the possible "Status Change Reason Codes" for DTL4 records:

3

SUSPEND a record if the begin date is before the employer became active.

4

FLAG a record if the member reported is less than 19 years old. This may indicate a student is being reported that may not reportable to ORS.

5

SUSPEND a record if the member's ORS account is missing one or more of the following data elements: 'First Name, Last Name, Date of Birth, Address and Gender. 'An account is said to have complete demographics details if it has all the following fields: First Name, Last Name, Date of Birth, Address and Gender. A gender of Unknown in the system should be treated as missing. A date of birth of 01/01/1900 in the system should be treated as missing. Note: Do not suspend if the address is end-dated, because in that case the last address will be used.

6

FLAG a DTL4 record if the first name and/or the last name reported on the record are different than the first name and/or last name in the system.

7

SUSPEND a record if the Gross Wages are greater than $25,000 for the period.

8

SUSPEND DTL4 record if member is not a Pension Plus member.

9

Do NOT SUSPEND if DTL4 record has only SSN, Status Change Code and Status Change Date. This date can imply the employee has terminated employment, has retired, is deceased, etc.

10

SUSPEND the DTL4 record if the employer DC contribution in DTL4 record is not <=4.

11

If reported wages is greater than 0 then SUSPEND the DTL4 record (Type 01) if employer or employee DC contributions are greater than reported wages. (This is to account for people on military leave, who will have wage=0, but may still get the employer contribution, in which case, contribution will be >wage for them and is still valid).

12

SUSPEND the DTL4 record if the Status Change Date is prior to 9/1/2010, or after 12/31/2999.

13

SUSPEND the DTL4 record if the record has reported gross wages and contributions but the contribution percentage is not present.

14

SUSPEND the DTL4 record if the reported employee DC contribution percentage is not a whole number and greater than zero.

15

SUSPEND any adjustment record (DC Record Type 05 - Positive Adjustment) reported for a period end date prior to 09/01/2010.

16

SUSPEND a DTL4 record with a DC Record Type 01 (Regular Wages) or 05 (Positive Adjustment), if both the begin date and end date of the member record do not match any of the payroll cycle calendar dates or is not completely contained in any of the payroll cycle dates in the payroll cycle calendar approved by ORS. Negative Adjustments do not go through the calendar rule because we have other rules that suspend Negative Adjustments if there are no corresponding original record.

17

FLAG a DTL4 record with DC Record Type 01 (Regular Wages) and 05 (Positive Adjustment) if the begin and end dates do not match the payroll calendar, and the record is completely contained a payroll cycle dates in the payroll cycle calendar approved by ORS.

18

SUSPEND a DTL4 record with a DC Record Type 06 if the Negative Adjustment comes in for amount greater than previous contribution reported.

19

SUSPEND a DTL4 adjustment record if the record's end date is prior to 9/1/2010.

20

FLAG a regular record (DC record type 01) if the record does not have any required DC or PHF contribution or status change information.

21

FLAG a record if the Employer Gross Earnings are greater than $25,000 for the period.

22

SUSPEND DTL4 record (DC record type 01 or 05) if the record end date is before 9/4/2012 if the member is not a Pension Plus with PHF or DC.

23

SUSPEND a Negative Adjustment record (DC record type 06) if the original record is not posted.

24

SUSPEND a Positive Adjustment record (DC record type 05) if the original record is present and not posted.

25

SUSPEND a record if the Negative Adjustment reported earnings is greater than previously posted earnings.

26

SUSPEND a record if the Negative Adjustment contribution % is greater than previously posted contribution %.

27

SUSPEND DTL4 Record submitted for a 3rd Party Employment Class Code 9023, 9024, or 9025. (Refer to employment class codes reported in DTL2 for the same org).

28

SUSPEND DTL1 until the DTL4 is present for any record with a begin date on or after 9/1/10; Benefit Structure effective date must be based on the DTL4 begin date for records with a begin date on or after 9/1/10

29

SUSPEND a DTL4 record if the job class code is 8000 or 8500. (Refer to job class codes reported in DTL2.)

30

Flag an adjustment record (DC record type 05 or 06) if the Employee or Employer DC contribution is greater than reported gross earnings.

31

Flag an adjustment record (DC record type 05 or 06) if the gross earnings are zero but contributions are greater than zero.

32

Combine the adjustment record (DC Record type 05-06,) with the corresponding original DTL4 record (DC Record type 01) if exists as well as the existing corresponding adjustment records (DC Record type 05-06) if exists and run the totaled record through the validations. If no original exists, adjustment will stand as original for validations alone.

Note: If a negative adjustment doesn't have an original record it will be suspended by a different rule.

33

SUSPEND a DTL2 record if the benefit structure (Pension Plus, PURE DC, MIP DC, and BASIC DC) and/or healthcare election PHF require a DTL4 record and the DTL4 record is not present.

34

The DTL2 record should not suspend if the job class code is 8000 or 8500.

35

SUSPEND a record if a member SSN is reported more than once with the same DC record type in a report and the begin and end dates overlap.

36

SUSPEND a record if the begin and end dates are between the report's begin and end dates and the DC record type is 05 (Positive Adjustment) or 06 (Negative Adjustment.)

37

SUSPEND a record if the record's end date is prior to the records begin date.

38

Suspend a DTL4 record if the record dates are prior to the report begin and end date and the wage code is 01.

39

SUSPEND a DTL4 record if the record has a status change reason code but the status change date is not present.

40

SUSPEND a DTL4 record if the record has a status change date but the status change reason code is not present or is not valid.