DTL2 (Wage and Service) Record Layout
The DTL2 (Wage and Service) record reports new wages, corrects old wages, and adds wages to a past pay period (retroactive wages).
The following table shows the position, field names, description, data source or valid values, and whether the field is required for the OR PERS report’s DTL2 records.
Position | Field Name | Description | Data Source or Valid Values | Required or Optional |
---|---|---|---|---|
1-4 | Record Type Identifier | Identifies the record type. | The valid value is DTL2. | Required |
5-9 | PERS Employer Number | The employer's four-digit PERS number preceded by a zero. | Retrieved from the Employer PERS Number field on the Human Resources Profile – State page. | Required |
10-18 | Social Security Number | The employee's social security number (SSN). If a correction to a social security number is being reported, use this field for the new social security number. | Retrieved from the Social Security field on the Service tab of the Employee Information form accessed from the OR PERS Report page. | Required |
19-48 | Last Name | The employee's social security number. | Retrieved from the Last Name field on the Service tab of the Employee Information form accessed from the OR PERS Report page. | Required |
49-68 | First Name | The employee’s first name.
| Retrieved from the First Name field on the Service tab of the Employee Information form accessed from the OR PERS Report page. | Required |
69-76 | Pay Date | The date the employee was paid. The date in this field cannot be earlier than the date in the Work Period End Date field. | Retrieved from the Pay Date field on the Service tab of the Employee Information form accessed from the OR PERS Report page. | Required |
77-82 | Hours Worked (Regular) | The regular hours worked by the employee during the pay period. | Retrieved from the Hours Worked (Regular) field on the Service tab of the Employee Information form accessed from the OR PERS Report page. | Required |
83-88 | Hours Worked (Overtime) | The overtime hours worked by the employee during the pay period. | Retrieved from the Hours Worked (Overtime) field on the Service tab of the Employee Information form accessed from the OR PERS Report page. | Required |
89-90 | Reported Wage Code | The employee’s wage code. For more information about how this field value maps to the Old PERS Stat field value on the Payroll Information - State Required page, refer to Old PERS Stat field logic. For more information about wage codes, refer to EDX Wage Codes on the Oregon PERS website. | Retrieved from the Reported Wage Code field on the Wages tab of the Employee Information form accessed from the OR PERS Report page. Valid values:
| Required |
91-99 | Subject Salary, Regular | The employee’s regular salary for the pay period, excluding overtime pay and amounts expressly considered non-subject to PERS contributions, paid to the employee on the given pay date. | Retrieved from the Subject Salary,Regular field on the Wages tab of the Employee Information form accessed from the OR PERS Report page. | Required |
100-108 | Subject Salary, Overtime | The employee’s overtime salary for the pay period, excluding regular pay and amounts expressly considered non-subject to PERS contributions, paid to the employee on the given pay date for hours worked beyond those used to compute Subject Salary, Regular. | Retrieved from the Subject Salary,Overtime field on the Wages tab of the Employee Information form accessed from the OR PERS Report page. | Required |
109-117 | Gross Salary | The total of subject salary, regular, non-subject salary, lump sum payoff, and lump sum payoff vacation. For more information about how this field value maps to the Old PERS Stat field value on the Payroll Information - State Required page, refer to Old PERS Stat field logic. | Retrieved from the Gross Salary field on the Wages tab of the Employee Information form accessed from the OR PERS Report page. | Required |
118-126 | Non-Subject Salary | The salary excluded from PERS and OPSRP contributions totaled from payments by contribution selection for the pay period. For example, a check issued for expense reimbursement. | Retrieved from the Non-Subject Salary field on the Wages tab of the Employee Information form accessed from the OR PERS Report page. | Required |
127-135 | Lump Sum Payoff | The lump-sum payoff for everything other than vacation includes accrued compensatory time, severance pay for involuntary termination (except retirement severance), and bonuses (except retirement bonus). | Retrieved from the Lump Sum Payoff field on the Wages tab of the Employee Information form accessed from the OR PERS Report page. | Required |
136-144 | Member Paid After-Tax Contribution | The contribution totaled from payments with specific deductions. IAP contributions must equal 6% of total subject salaries. Enter the member IAP contribution in this field if it is deducted from the employee’s pay on an after-tax basis. | Retrieved from the Member Paid After-Tax field on the Contribution tab of the Employee Information form accessed from the OR PERS Report page. | Required |
145-153 | Member Paid Pre-Tax Contribution | The contribution totaled from payment with the specific deductions. IAP contributions must equal 6% of the total reported subject salaries. If the member IAP contribution is deducted from the employee's pay on a pre-tax basis, enter it in this field. | Retrieved from the Member Paid Pre-Tax field on the Contribution tab of the Employee Information form accessed from the OR PERS Report page. | Required |
154-162 | Unit Contribution | The total of deductions to police and firefighters. | Retrieved from the Unit Contribution field on the Contribution tab of the Employee Information form accessed from the OR PERS Report page. | Required |
163-171 | Employer Paid Pre-Tax Contribution | IAP contributions made by the employer are totaled from contributions with the selected codes. IAP contributions must equal 6% of subject salaries. | Retrieved from the Employer Paid Pre-Tax field on the Contribution tab of the Employee Information form accessed from the OR PERS Report page. | Required |
172 | Optional Employer Matching Contributions Percentage for IAP | An optional contribution made by employers to employees’ IAP accounts. The contribution is in addition to required member contributions and must be between 1% and 6% of the total subject salary. | Retrieved from the Employer IAP Percentage field on the Contribution tab of the Employee Information form accessed from the OR PERS Report page. | Required |
173-181 | Optional Employer Matching Contributions Amount for IAP | The optional amount totaled from check amounts that have the selected code. This is the dollar amount of the calculated contributions represented by the percentage selected in the Optional Employer Matching Contributions Percentage for IAP field. | Retrieved from the Employer IAP Amount field on the Contribution tab of the Employee Information form accessed from the OR PERS Report page. | Required |
182-183 | PERS Job Class Code | The PERS code for the employee’s job class. If the employee has changed their job class, you can update the code in this field. An update in this field also requires selecting a value in the Average Overtime Hours Code field. For more information about job class codes, refer to EDX Job Class Codes on the Oregon PERS website. | Retrieved from the PERS Job Class Code field on the Wages tab of the Employee Information form accessed from the OR PERS Report page. | Optional |
187-188 | Average Overtime Hours Code | The employee’s average overtime hours code. If you report a new employee or the PERS Job Class Code field contains a value, select the number of annual overtime hours considered average or reasonable for the employee's job class. The designated hours provide a reasonableness cap on how many overtime hours are used for calculating a retiree's final average salary. An update in this field also requires selecting a value in the PERS Job Class Code field. | Retrieved from the Average Overtime Hours Code field on the Wages tab of the Employee Information form accessed from the OR PERS Report page. | Optional |
132-139 | Employer Site Distribution Code | Blank
| spaces | Not applicable |
252-259 | Work Period Begin Date | The beginning work date of the pay period. The Work Period Begin Date and Work Period End Date fields are used to allocate wages to the periods in which they were earned. The hours and salary must be allocated to pay periods and along month boundaries. | Retrieved from the Work Period Begin Date field on the Service tab of the Employee Information form accessed from the OR PERS Report page. | Required |
260-267 | Work Period End Date | The ending work date of the pay period. The Work Period Begin Date and Work Period End Date fields are used to allocate wages to the periods in which they were earned. The hours and salary must be allocated to pay periods and along month boundaries. | Retrieved from the Work Period End Date field on the Service tab of the Employee Information form accessed from the OR PERS Report page. | Required |
268-276 | Lump Sum Vacation Payoff | The lump sum vacation payoff total summed from payments with the selected lump sum vacation codes. Lump-sum vacation payoff payments are made to the employee for accrued vacation only. | Retrieved from the Lump Sum Vacation Payoff field on the Wages tab of the Employee Information form accessed from the OR PERS Report page. | Required |