Detail 2 Record - Wage and Service

Section ID

X(4)

1-4

Always set to “DTL2.”

SSN

9(9)

5-13

The member’s social security number.

Last Name

X(30)

14-43

The member’s last name.

First Name

X(20)

44-63

The member’s first name.

Middle Name

X(20)

64-83

The member’s middle name.

Begin Date

9(8)

84-91

The first day the member worked in the pay period being submitted.

If there are multiple records for the same member within a pay period, the begin date is the first day the member worked with the unique status code or employee class code.

End Date

9(8)

92-99

The last day the member worked in the pay period being submitted.

If there are multiple records for the same member within a pay period, the end date is the last day the member worked with the unique status code or employee class code.

Retirement Hours

9(4)v99

100-105

The total hours the member worked.

Reported Wage Code

9(2)

106-107

The transaction code for the member record.

Valid values:

• 01 – Regular wage

• 04 – Retroactive payment

• 05 – Positive adjustment

• 06 – Negative adjustment

• 07 – Wages nut no member contributions, third-party Weekly Workers Compensation payments

• 08 – Wages but no service hours

• 09 – Longevity payment

• 11 – Coach's wages

• 15 – Positive longevity adjustment

• 16 – Negative longevity adjustment

• 25 – Positive coach wages

• 26 – Negative coach wages

• 45 – Positive retro-wages

• 46 – Negative retro-wages

• 75 – Positive wages w/o contributions (WWC, or post-retirement)

• 76 – Negative wages w/o contributions (WWC, or post-retirement)

• 85 – Positive summer spread wages

• 86 – Negative summer spread wages

Reported Wage

9(7)v99

108-116

The member’s gross reportable wages.

Zero Filled

9(9)

117-125

Always set to “000000000.”

Exception Wage

9(7)v99

126-134

The wages a member earned while on a professional service leave or a professional service released time.

Member Contributions

9(7)v99

135-143

The MIP pre-tax contributions withheld from the wages.

Employer Contributions

9(7)v99

144-152

The contributions that the employer pays to ORS on behalf of the member.

Zero Filled

9(9)

153-161

Always set to “000000000.”

Pay Rate

9(7)v99

162-170

The annual rate for salaried or contractual positions and hourly rate for other positions.

Class Code

X(4)

171-174

The position that the member holds.

Contract Begin Date

9(8)

175-182

The start date of the member’s contract.

Only used for contractual positions; zero-filled for non-contract positions. 

For non-contract salaried employees, the fiscal year's start date is used.

Contract End Date

9(8)

183-190

The end date of the member’s contract.

Only used for contractual positions; zero-filled for non-contract positions. 

For non-contract salaried employees, the fiscal year's end date is used.

Zero Filled

9(12)

191-202

Always set to “000000000000.”

Frequency of Pay

X(2)

203-204

The number of pay periods for which the member is paid.

Indicator code

X(1)

205-205

Health Care Indicator code.

Valid values:

• 1 - 1.5% - Employees whose first day of work is on or after 7/1/2010 and starting salary is less than $18,000

• 0 - 3% - Employees whose first day of work is on or after 7/1/2010 and starting salary is more than $18.000

Filler

X(175)

206-380

NA