Skip to main content

14.04.04: Validations run for DTL2 records

14.04.04: Validations run for DTL2 records

Rule

Description

1

SUSPEND a record if the Begin Date is before the employer became active.

2

FLAG a record if the Pay Rate is not greater than minimum wage and the wage code is NOT 05 (positive adjustment), 06 (negative adjustment), 15 (positive wages without hours adjustment), 16 (negative wages without hours adjustment), 25 (positive adjustment to coaching wages) 26 (negative adjustment to coaching wages), 45 (retroactive wages positive adjustment), 46 (retroactive wages negative adjustment), 75 (positive adjustment to wages without contributions), 76 (negative adjustment to wages without contributions), 85 (positive adjustment to summer spread wages), 86 (negative adjustment to summer spread wages).

3

SUSPEND a record if a member SSN is reported more than once with the same wage code in a report and each of the record's class codes are not unique and the Begin Date and End Date overlap.

4

SUSPEND a record if a member SSN is reported more than once in a report with overlapping begin and end dates if one of the records was reported with an Employment class code of 9003, 9004, 9005, 9013, 9014, 9015, 9023, 9024, 9025, 9033, 9034, 9035, 9043, 9044, and 9045 (Retiree Class Codes) and the other record has a wage code of 01 (regular wages), 09 (wages without hours), or 11 (wages for coaches).

5

FLAG a record if the Member Contributions are greater than zero and the class code is 9003, 9004, 9005, 9013, 9014, 9015, 9023, 9024, 9025, 9033, 9034, 9035, 9043, 9044, or 9045 (Retiree Class Code).

6

SUSPEND a record if the Exception Wages are greater than the Employer Reported Wages.

7

SUSPEND a record if the Employer Reported Wages are equal to zero and the wage code is NOT 06 (negative adjustment), 16 (wages without hours negative adjustment), 26 (negative adjustment for coaching wages), 46 (retroactive wage negative adjustment), 76 (negative adjustment for wages without contributions), or 86 (negative adjustment for summer spread wages).

8

FLAG a record if the Employer Reported Wages are greater than $10,000 for the period.

9

SUSPEND a record if the Exception Wages are equal to zero and the class code is 9001 (professional services leave/professional services released time).

10

SUSPEND a record if the Exception Wages are greater than zero and the class code is not equal to 9001 (professional services leave/professional services released time).

11

FLAG a record if the member's total Employer Reported Wages for the calendar year are greater than IRS limits.

12

SUSPEND a record if the class code is 9003, 9004, 9005, 9013, 9014, 9015, 9023, 9024, 9025, 9033, 9034, 9035, 9043, 9044, or 9045 (Retiree Class Code) and the record's Begin Date is not one (1) month after the member's retirement effective date.

13

SUSPEND a record if the Hours are zero and the wage code is 01 (regular wages) or 11 (coaching wages) and the Employment Class Code is not equal to 8000 (weekly workers' compensation).

14

SUSPEND a record if the Hours are equal to zero and the Employment Class Code is 9003, 9004, 9005, 9013, 9014, 9015, 9023, 9024, 9025, 9033, 9034, 9035, 9043, 9044, or 9045 (Retiree Class Code) and the Wage Code is NOT 04 (retroactive wages), 45 (retroactive wage positive adjustment), 46 (retroactive wage negative adjustment), or 76 (negative adjustment for wages without contributions). Note: Wage codes 05 and 06 are not going to work for employment class codes 9003, 9004, 9005, 9013, 9014, 9015, 9023, 9024, 9025, 9033, 9034, 9035, 9043, 9044, or 9045.

15

SUSPEND a record if the Pay Rate is less than 100, and the Hourly Rate computed by dividing the Employer Reported Wages by the Hours is less than the reported Pay Rate with a margin of five percent (5%) and the class code is not equal to 8000 (weekly workers' compensation).

16

FLAG a record if the Pay Rate is less than 100, so it is assumed to be hourly, and the difference (plus or minus five cents {.05}) between the Pay Rate and the Employer Reported Wages divided by the Hours is more than twenty-five percent (25%) of the calculated amount and the class code is not equal to 8000 (weekly workers' compensation).

17

FLAG a record if the Pay Rate is greater than 100, so it is assumed to be annual or a contract, and the difference (plus or minus five cents {.05}) between the Pay Rate divided by the Frequency of Pay and the Employer Reported Wages is more than fifteen percent (15%) of the calculated amount and the class code is not equal to 8000 (weekly workers' compensation).

18

SUSPEND a record if the Pay Rate is not greater than zero, and the wage code is 01 (regular wages), 07 (wages without contributions), 08 (summer spread wages), 09 (wages without hours), or 11 (coaching wages).

19

SUSPEND a record if the contract begin date is after the contract end date.

20

SUSPEND a record if the Pay Rate is greater than 100, so it is assumed to be annual and the contract begin and end dates were not reported.

21

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

22

SUSPEND a record if the End Date is not between the report's begin and end dates and the wage code is 01 (regular wages) with the class code not equal to 8000, 07 (wages with no contributions), 08 (summer spread wages), 09 (wages without hours), or 11 (wages for coaches).

23

SUSPEND a record if the begin and end dates are between the report's begin and end dates and the wage code is 05 (positive adjustment), 06 (negative adjustment), 15 (wages without hours positive adjustment), or 16 (wages without hours negative adjustment), 25 (positive adjustment for coaching wages), 26 (negative adjustment for coaching wages), 45 (retroactive wage positive adjustment), 46 (retroactive wage negative adjustment), 75 (positive adjustment for wages without contributions), 76 (negative adjustment for wages without contributions), 85 (positive adjustment for summer spread wages), 86 (negative adjustment for summer spread wages).

24

SUSPEND a record if a wage code of 06 (negative adjustment), 16 (wages without hours negative adjustment), 26 (negative adjustment for coaching wages), 46 (retroactive wage negative adjustment), 76 (negative adjustment for wages without contributions), or 86 (negative adjustment for summer spread wages) is reported for a given period and the reported amount of Retirement Hours, Employer Reported Wages, or Exception Wages are greater than the amount posted for the same given period.

25

SUSPEND a record reported with a wage code of 07 (wages without contributions), 75 (positive adjustment for wages without contributions), or 76 (negative adjustment for wages without contributions) and the Employment Class Code is NOT 9003, 9004, 9005, 9013, 9014, 9015, 9023, 9024, 9025, 9033, 9034, 9035, 9043, 9044, or 9045 (retiree class code).

26

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

27

FLAG a record if the Retirement Hours are greater than 200.

28

SUSPEND a record if the wage code is 04 (retroactive wages), 08 (summer spread wages), 09 (wages without hours), 45 retroactive wage positive adjustment), 15 (wages without hours positive adjustment), or 85 (positive adjustment for summer spread wages) and Retirement Hours are greater than zero.

29

SUSPEND a record if the wage code is 09 (wages without hours) or 15 (positive adjustment for wages without hours) and the Begin Date and End Date are not within the same fiscal year (July 1 through June 30).

30

SUSPEND a record if the member is reported with an Employment Class Code of 9003, 9004, 9005, 9013, 9014, 9015, 9023, 9024, 9025, 9033, 9034, 9035, 9043, 9044, 9045 (retiree employment class code) and with a wage code other than 04 (retroactive wages), 45 (retroactive wage positive adjustment), 46 (retroactive wages negative adjustment), 07 (wages without contributions), 75 (positive adjustment to wages without contributions), or 76 (negative adjustment for wages without contributions).

31

SUSPEND a DTL2 record if a different DTL2 record for the same SSN in a prior pay period but of the same fiscal year is not yet posted. This rule will apply only for records with SSNs which don't have a member account in the system yet (new records) or for records with SSNs which have an account in the system with benefit structure as MIP Graded, MIP Plus, or Pension Plus. This rule also applies to the member account that show as BASIC and does not have any wage and contribution transactions after January 1, 1987, causing the account to change to MIP Graded.

32

SUSPEND a record if the wage code is 05 (positive adjustment), 06 (negative adjustment), 15 (wages without hours positive adjustment), 16 (wages without hours negative adjustment), 25 (positive adjustment to coaching wages), 26 (negative adjustment to coaching wages), 45 (retroactive wage positive adjustment), 46 (retroactive wage negative adjustment), 75 (positive adjustment to wages without contributions), 76 (negative adjustment to wages without contributions), 85 (positive adjustment to summer spread wages), 86 (negative adjustment to summer spread wages) if the original record corresponding to the adjustment record is not posted.

33

SUSPEND a negative adjustment record (wage code 06, 16, 26, 46, 76, or 86) if the record causes the member's account balance (for the fiscal year) to go negative.

34

SUSPEND a retroactive wage record (wage code 04) or a retroactive wage positive adjustment (wage code 45) if no original posted record is found for this Employment Class Code during the retroactive period.

35

SUSPEND a retroactive wage record (wage code 04) or retroactive wage positive adjustment (wage code 45) if no original record is posted with wages and the same Employment Class Code for any period fully or partially contained in the pay period of the retroactive wage record.

36

SUSPEND a negative adjustment record (wage codes 06, 26, or 76) if it completely removes the money but not the hours.

37

SUSPEND any adjustment record (wage codes 05 - positive adjustment; 06 - negative adjustment; 15 - wages without hours positive adjustment; 16 - wages without hours negative adjustment; 25 - positive adjustment for coaching wages; 26 - negative adjustment for coaching wages; 45 - retroactive wage positive adjustment; 46 -retroactive wage negative adjustment; 75 - positive adjustment for wages without contributions; 76 - negative adjustment for wages without contributions; 85 - positive adjustment for summer spread wages; and 86 - negative adjustment for summer spread wages) reported for a period end date prior to October 1, 2002.

38

SUSPEND a DTL2 record with wage code 09 (wages without hours), wage code 15 (positive adjustment to wages without hours), 08 (summer spread wages), or 85 (positive adjustment to summer spread wages) if no payroll record is found for the member account with a position corresponding to that employer.

39

SUSPEND a DTL2 record if reported wage code does not exist in the file layout.

40

SUSPEND a DTL2 record if the complete demographic details are not present on the member's account. An account is said to have complete demographic details if it has all the following fields: First Name, Last Name, Date of Birth, Address, and Gender.

41

FLAG a DTL2 record with wage codes 01, 05, 04, 45, 07 (Employment Class Code 8000), 75 (Employment Class Code 8000), 08, 85, 09, 15, 11, or 25 if the account is in death refunded, refunded, or transferred status.

42

SUSPEND any original wage record (wage code 01, 04, 07, 08, 09, 11) if there already exists a different record posted with the same wage code, Employment Class Code, and the same Begin Date and End Date. Note: This removes the ability for reporting multiple (wage code 04) original records for the same pay period.

43

Combine the adjustment record (wage codes 05-06, 45-46, 75-76, 85-86, 15-16, and 25-26) with the corresponding original wage record (wage codes 01, 04, 07, 08, 09, 11) if exists as well as the existing corresponding adjustment records (wage codes 05-06, 45-46, 75-76, 85-86, 16-16, and 25-26) if exists and run the totaled record through the validations. If no original exists, adjustment will stand as original for validations alone.

44

SUSPEND a DTL2 record with a wage code 01 (regular wages) except if 8000 class code which will not suspend, 05 (positive adjustment), except if 8000 class code which will not suspend (wages without contributions), 08 (summer spread wages), or 85 (positive adjustment for summer spread wages) if both the Begin Date and the End Date of the record does 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 other rules suspend negative adjustments if there is not a corresponding original record.

45

FLAG a DTL2 record if the First Name and/or the Last Name reported on the record are different than the First Name and/or the Last Name in the system.

46

FLAG a DTL2 record with wage codes 01 (regular wages) -except if 8000 class code which will not flag, 05 (positive adjustment), 07 (wages without contributions), 75 (positive adjustment for wages without contributions), 08 -except if 8000 class code which will not flag (summer spread wages) , or 85 -except if 8000 class code which will not flag (positive adjustment for summer spread wages) if the begin and end dates do not match the payroll calendar.

47

SUSPEND a DTL2 record with a wage code 07 (wages without contributions) and 8000 class code, 75 (positive adjustment for wages without contributions) and 8000 class code, if the record Begin Date and End Date spread more than one fiscal year, and the Begin Date and the End Date of the record does 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.

48

FLAG a DTL2 record with an active employment class code, i.e. employment class codes other than 9003, 9004, 9005, 9013, 9014, 9015, 9023, 9024, 9025, 9033, 9034, 9035, 9043, 9044, or 9045 (retiree class codes)  if the member is retired and the retirement effective date is before or on the same day as the record begin date-except if the wage code is 08 (summer spread wages), 85 (positive adjustment for summer spread wages), or 86 (negative adjustment for summer spread wages) which will not flag.

49

SUSPEND a DTL2 record with a wage code 07 - and a class code of 8000 (wages without contributions) or 75 - and a class code of 8000 (positive adjustment for wages without contributions) if the record end date or the report load date is on or after 7-1-10.

50

SUSPEND a DTL2 record with a positive adjustment wage code (05, 15, 25 and 45) for any new hire on or after 07/01/2010, if employee health care fund contribution rate indicator (empe_hlth_prcnt_ind) is different from any of the previously posted wages for the same period, and the total of the previously posted wages (including original, positive adjustment and negative adjustment) for that period is not zero.

51

SUSPEND a DTL2 record with a negative adjustment wage code (06, 16, 26 and 46)for any new hire on or after 07/01/2010, if employee health care fund contribution rate indicator (empe_hlth_prcnt_ind) is different from the last posted wage record (original, positive adjustment or negative adjustment) for the same period.

52 

SUSPEND Retiree Job class code 9013, 9014, 9015, 9023, 9024, 9025, 9033, 9034, 9035, 9043, 9044 or 9045 if the record end date or begin date is before 12/27/2012.

53

SUSPEND a DTL2 record for new MPSERS members for the 75 day window, as per the new Hire Rule, if the member has no benefit structure or if a new hire benefit plan election has not been made.

54

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

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

55

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


Last updated: 07/06/2016