PowerSchool ERP Ohio

eSERS Contribution Report - Detail (CD) Record - File Layout and Data Mapping

The following table lists the positions, lengths, field names, descriptions, and data sources or valid values for the Detail (CD) Record of the eSERS Contribution report.

Position

Length

Field Name

Description

Data Source or Valid Values

1-2

2

Record Type

Identifies the record type.

The valid value is CD.

3-11

9

SSN

The employee's Social Security number. 

Retrieved from the Social Security field on the School Employees Retirement System Data form of the OH eSERS Contribution Report page.

12-36

25

Last Name

The employee's last name.

Retrieved from the Last Name field on the School Employees Retirement System Data form of the OH eSERS Contribution Report page.

37-61

25

First Name

The employee’s first name.

Retrieved from the First Name field on the School Employees Retirement System Data form of the OH eSERS Contribution Report page.

62-86

25

Middle Initial

The employee's middle initial.

Retrieved from the Middle Initial field on the School Employees Retirement System Data form of the OH eSERS Contribution Report page.

87-90

4

Suffix

The employee’s name suffix.

Retrieved from the Suffix field on the School Employees Retirement System Data form of the OH eSERS Contribution Report page.

91-95

5

Employer Code

The School Employees Retirement System (SERS) employer identification number assigned to the district.

Retrieved from the SERS Employer ID field on the Human Resources Profile - State page.

96-103

8

Pay Period Start

The first day of the pay period covered by this contribution record.

Retrieved from the Start Date field on the Pay Period Data form of the OH eSERS Contribution Report - Pay Period page.

104-111

8

Pay Period End

The last day of the pay period covered by this contribution record.

Retrieved from the End Date field on the Pay Period Data form of the OH eSERS Contribution Report - Pay Period page.

112-113

2

Earnings Code

The type of earnings being reported.

Valid values:

  • 01 = Regular

  • 02 = Supplemental

  • 03 = Retro Pay

  • 04 = Stretch Pay

  • 05 = Grievance Pay

  • 51 = Adjustment to Regular Contribution

  • 52 = Adjustment to Supplemental

  • 53 = Adjustment to Retro Pay

  • 54 = Adjustment to Stretch Pay

  • 55 = Adjustment to Grievance Pay

  • 91 = Missed Regular Contribution

  • 92 = Missed Supplemental Contribution

  • 94 = Missed Stretch Pay

Retrieved from the Earnings Code field on the School Employees Retirement System Data form of the OH eSERS Contribution Report page.

114-122

9

Gross Earnings

The total covered compensation (gross earnings) subject to SERS contributions for this pay period.

Retrieved from the Earnings field on the School Employees Retirement System Data form of the OH eSERS Contribution Report page.

123-131

9

Pre-Tax Contribution

The employee's pre-tax contribution amount deducted from earnings for this pay period.

Retrieved from the Pre-Tax Contribution field on the School Employees Retirement System Data form of the OH eSERS Contribution Report page.

132-140

9

Post-Tax Contribution

The employee's post-tax (after-tax) contribution amount deducted from earnings for this pay period.

Retrieved from the Post-Tax Contribution field on the School Employees Retirement System Data form of the OH eSERS Contribution Report page.

141-144

4

Service Days

The number of days for which the employee was paid during the pay period.

Retrieved from the Service Credit Days field on the School Employees Retirement System Data form of the OH eSERS Contribution Report page.

145-151

7

Hours Paid

The total number of hours for which the employee was paid during the pay period.

Retrieved from the Hours Paid field on the School Employees Retirement System Data form of the OH eSERS Contribution Report page.

152-153

2

Employee Status

The employee's current SERS status, if a status change is being reported.

Valid values:

  • 01 = Deceased

  • 02 = Military Leave

  • 03 = Leave of Absence

  • 04 = Workers Comp

  • 05 = Retired

  • 06 = Terminated

  • 07 = Return from Leave

  • 08 = Reemployed

Retrieved from the Employee Status field on the School Employees Retirement System Data form of the OH eSERS Contribution Report page.

154-161

8

Effective Date

The effective date of the employee status change, if applicable.

Retrieved from the Status Date field on the School Employees Retirement System Data form of the OH eSERS Contribution Report page.