Skip to main content
Skip table of contents

ORS-PSERS - Retiree Report - File Layout and Data Mapping

The following table shows the columns, column names, descriptions, and data sources or valid values for the ORS-PSERS Retiree report.

Column

Column Name

Description

Data Source or Valid Values

A

SOCIAL SECURITY NUMBER

The employee's Social Security number. 

Retrieved from the Social Security field on the Demographic tab on the MI ORS-PSERS (Public School Employees Retirement) page.

B

MEMBER NAME

The employee’s name.

The format is Last Name, First Name Middle Name.

Retrieved from the First Name, Middle Name, and Last Name fields on the Demographic tab on the MI ORS-PSERS (Public School Employees Retirement) page.

C

CLASS

The position that the member holds.

For a list of valid values, refer to 13.02.01: Detail 2 records - employment class codes and definitions.

Retrieved from the Class field on the MIP Wage and Service form of the MIP Wage and Service tab on the MI ORS-PSERS (Public School Employees Retirement) page.

D

WAGE

The member's reportable wages paid during the reporting period.

Retrieved from the Wages field on the MIP Wage and Service form of the MIP Wage and Service tab on the MI ORS-PSERS (Public School Employees Retirement) page.

E

CD

The transaction code for the member record.

For a list of valid values, refer to 13.02.02: Detail 2 records - wage codes.

Retrieved from the Wage Code field on the MIP Wage and Service form of the MIP Wage and Service tab on the MI ORS-PSERS (Public School Employees Retirement) page.

F

MEMBER CONTRIBUTION

The pre-tax contributions withheld from the member's reportable wages.

Retrieved from the EE Contrib. field on the MIP Wage and Service form of the MIP Wage and Service tab on the MI ORS-PSERS (Public School Employees Retirement) page.

G

EMPLOYER CONTRIBUTION

The contributions that the employer pays to ORS on behalf of the member. This represents the percentage of reportable wages a member is paid.

Retrieved from the ER Contrib. field on the MIP Wage and Service form of the MIP Wage and Service tab on the MI ORS-PSERS (Public School Employees Retirement) page.

H

HOURS

The total hours the member worked.

Retrieved from the Hours field on the MIP Wage and Service form of the MIP Wage and Service tab on the MI ORS-PSERS (Public School Employees Retirement) page.

I

EXCPT WAGE

The wages a member receives while on professional services leave or professional services released time.

Retrieved from the Excpt. Wage field on the MIP Wage and Service form of the MIP Wage and Service tab on the MI ORS-PSERS (Public School Employees Retirement) page.

J

RATE

The employee’s pay rate.

The pay rate is required to be reported in each pay period based on the member's classification:

  • Hourly employees - Report the hourly rate based on the pay schedule.

  • Contract/salaried employees - Report pay rate representing the full amount of compensation allowed by the contract that is recognized as compensation by law and would be earned in the entire school year, even if only part of the year is worked.

Retrieved from the Pay Rate field on the MIP Wage and Service form of the MIP Wage and Service tab on the MI ORS-PSERS (Public School Employees Retirement) page.

K

BEGIN DATE

The first day the member was paid for in the reporting period being submitted (usually the same date as the beginning of the reporting period). If there are multiple records for the same member within a pay period, the Begin Date will be the first day the member was paid for, using a unique status code or employment class code.

The format is MMDDYY.

Retrieved from the Start field on the MIP Wage and Service form of the MIP Wage and Service tab on the MI ORS-PSERS (Public School Employees Retirement) page.

L

END DATE

The last day the member was paid for in the reporting period being submitted (usually the same date as the end date of the reporting period). If there are multiple records for the same member within a pay period, the end date will be the last day the member was paid for, using a unique status code or employment class code.

The format is MMDDYY.

Retrieved from the End field on the MIP Wage and Service form of the MIP Wage and Service tab on the MI ORS-PSERS (Public School Employees Retirement) page.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.