7.07.04: Common Error Messages on DTL2 Records

 

Error Message How To Fix

S-The member is reported more than once, each of record's class code and wage code are not unique, begin, end dates overlap.

Our system does not allow more than one DTL2 record using the same wage code/class code combination for the same begin and end dates.

Example: Two DTL2 records using class code 1240 and wage code 01 for the current pay period. If you need to use two records to report wages and hours for one person for the same pay period on the same report you must select a different class code for the second record.

For retirees that need two DTL2 records you must use a different retiree class code on each record. Change the class code on one record to post them both.

If you have entered multiple records for adjustments, you may have not entered the correct begin and end dates. Check the download detail screen, where you can see all the records at once, and see if the begin and end dates are correct. Change the dates on any DTL2 records that are incorrect.

S-The hours are zero and the wage code is 01 or 11 and the employment class code is not 8000.

Wage codes 01 and 11 are for regular wages and our system requires that hours be reported on a record coded as regular wages. Add hours to this record to get it posted. (Class code 8000 is for Workers Comp wages and our system will post a WWC record without hours.)

S-This ORS account is missing at least one of these data elements: First/Last Name, Date of Birth, Address or Gender. If a DTL1 record is on this report with all these elements, no action is required. If no DTL1 record exists, please submit one. The DTL2 record will post after the DTL1 record posts.

The ORS database does not have all the demographics required for this member. We may be missing all of the data or just pieces of the data included on a DTL1 record. Maybe we once had an address and mail was returned as undeliverable so we end dated the bad address and are depending upon you for the most current address.

If there is no DTL1 record on your report you must add one to update our system. You must complete the entire record, including the country code and zip code (skip the postal code field unless the member lives outside of the USA), date of birth and gender. Failure to provide any of that data will suspend the record again.

S-The wage code is 04, 08, 09, 15, 45 or 85 and the retirement hours are greater than zero.

The wage codes listed are all for reporting wages without hours, either original records or positive adjustments. These records cannot contain data in the Retirement Hours field. Delete the hours to post the record.

S-Record reported with wage code 08 and hours are greater than zero.

Wage code 08 is for summer spread wages and by definition there are no hours reported with summer spread wages. Delete the hours from the record.

S-The begin and/or end dates of this record do not match a payroll cycle or fall within a payroll cycle detailed in your calendar. Please verify and update the record.

The payroll calendar for your reporting unit can be seen by clicking on the Work On Payroll Calendar link on your Things To Do Menu. Click on the calendar year for your records, locate the specific pay period and verify that the begin and end dates on your DTL2 record either match or fall between the begin and end dates on the calendar. If not, change the dates as needed.

S-Pay rate < 100 and the hourly rate computed by dividing the Employer rptd Wages by hours < rptd Pay Rate

One of the edits in our validations batch is to calculate a rate of pay for reported wages by dividing the reported wages by the reported hours on a DTL2 record. If the rated calculated by ORS is too much higher or lower than the pay rate on the DTL2 record the record will suspend.

Sometimes the DTL2 record is a combination of wages earned at different rates of pay. If necessary, you can enter more than one DTL2 record to report the wages and hours earned at different rates of pay as long as you select different class codes for each record.

Sometimes the DTL2 record is an adjustment to previously reported wages. Our system will go back and use the original posted wages in the calculation. It will find the original wages and hours; add or subtract the amounts on the DTL2 adjustment record, divide the new amount of wages by the new amount of hours and reach a pay rate. Verify that the amount of wages and amount of hours on the DTL2 record are correct.

You can find prior posted wages and hours on the View Employee Info screens to help you determine what was posted to ORS on the original record. Do the math as needed and adjust either wages, hours or pay rate to make the record valid.

S-The end date is not between the report begin and end date and the wage code is 09 or 11 or wage code is 01, 07 or 08 and job class code is not equal to 8000.

The end date of the DTL2 record is not between the report begin and end date and the wage and class codes on the DTL2 record are not codes that allow an exception to the end date rule.

If you are using wage code 01, 07, 08, 09 or 11 the end date must either match the end date of the report or fall between the begin and end dates of the report. Change the end date as needed.

S-The end date is not between the report begin and end date and the wage code is 09 or 11 or wage code is 01, 07 or 08 and job class code is not equal to 8000.

The end date of the DTL2 record is not between the report begin and end date and the wage and class codes on the DTL2 record are not codes that allow an exception to the end date rule.

If you are using wage code 01, 07, 08, 09 or 11 the end date must either match the end date of the report or fall between the begin and end dates of the report. Change the end date as needed.

S-Pay rate should be greater than zero.
OR
S-The Pay Rate is NOT greater than zero and the wage code is 01, 07, 08, 09 or 11

These DTL2 records require a pay rate. Enter the rate on the record.

S-The pay rate is greater than 100 but the contract begin and end dates are not reported.

When a pay rate is $100.00 or more we assume that the employee is salaried and require contract begin and end dates on the DTL2 record. Enter contract begin and end dates on the record. If there is no contract you may use the begin and end dates of the fiscal year: 7/1/20xx - 6/30/20xx.

S - Temporarily suspend records for new hire MPSERS members.

This record will remain suspended until the Plan Election form has been received and processed by ORS or until the member defaults into a benefit plan per the law.

 

Last updated: 11/29/2012