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:
| 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. |