Detail 2 Record - Wage and Service
The following table shows the field names, descriptions, positions, lengths, formats, data sources or valid values, and whether the field is required for the ORS-PSERS Retirement report’s DTL2 record.
Field Name | Description | Position | Length | Format | Data Source or Valid Values | Required or Optional |
|---|---|---|---|---|---|---|
Section Identifier | Identifies the type of section the record presents. | 1-4 | 4 | X(4) | The valid value is DTL2. | Required |
SSN | The employee's Social Security number. | 5-13 | 9 | 9(9) | Retrieved from the Social Security field on the Demographic tab on the MI ORS-PSERS (Public School Employees Retirement) page. | Required |
Last Name | The employee's last name. | 14-43 | 30 | X(30) | Retrieved from the Last Name field on the Demographic tab on the MI ORS-PSERS (Public School Employees Retirement) page. | Required |
First Name | The employee's first name. | 44-63 | 20 | X(20) | Retrieved from the First Name field on the Demographic tab on the MI ORS-PSERS (Public School Employees Retirement) page. | Required |
Middle Name | The employee’s middle name. | 64-83 | 20 | X(20) | Retrieved from the Middle Name field on the Demographic tab on the MI ORS-PSERS (Public School Employees Retirement) page. | Optional |
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 MMDDYYYY. | 84-91 | 8 | 9(8) | 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. | Required |
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 MMDDYYYY. | 92-99 | 8 | 9(8) | 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. | Required |
Retirement Hours | The total hours the member worked. | 100-105 | 6 | 9(4)v99 | 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. | Required for original records, post-retirement wages, and adjustments involving hours. |
Reported Wage Code | The transaction code for the member record. | 106-107 | 2 | 9(2) | 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. | Required |
Reported Wage | The member's reportable wages paid during the reporting period. | 108-116 | 9 | 9(7)v99 | 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. | Required for all records unless it is for an adjustment to hours only. |
Zero-Filled | Fill with nine zeros. | 117-125 | 9 | 9(9) | The valid value is 000000000. | Not required |
Exception Wage | The wages a member receives while on professional services leave or professional services released time. | 126-134 | 9 | 9(7)v99 | 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. | Class code of 9001. |
Member Contributions | The pre-tax contributions withheld from the member's reportable wages. | 135-143 | 9 | 9(7)v99 | 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. | Required for original records and record adjustments, if wages are included in the adjustment. |
Employer Contributions | The contributions that the employer pays to ORS on behalf of the member. This represents the percentage of reportable wages a member is paid. | 144-152 | 9 | 9(7)v99 | 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. | Optional |
Zero-Filled | Fill with nine zeros. | 153-161 | 9 | 9(9) | The valid value is 000000000. | Not required |
Pay Rate | The employee’s pay rate. The pay rate is required to be reported in each pay period based on the member's classification:
| 162-170 | 9 | 9(7)v99 | 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. | Y - All original records |
Class Code | The position that the member holds. | 171-174 | 4 | X(4) | 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. | Required |
Contract Begin Date | The start date of a contract for which the member is working. This is only used for members who are on contract or are salaried employees. You can use the fiscal year beginning date for non-contractual salaried employees. The format is MMDDYYYY. | 175-182 | 8 | 9(8) | Retrieved from the Cont. Begin 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. | Y - All original records with pay rates greater than 100. |
Contract End Date | The finish date of a contract that the member is working on. This is only used for employees who are on a contract or are salaried employees. You can use the fiscal year beginning date for non-contractual salaried employees. The format is MMDDYYYY. | 183-190 | 8 | 9(8) | Retrieved from the Cont. 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. | Y - All original records with pay rates greater than 100. |
Zero-Filled | Fill with 12 zeros. | 191-202 | 12 | 9(12) | The valid value is 000000000000. | Not required |
Frequency of Pay | Whether hourly or salaried, report the total number of pay periods for which the member would be paid, assuming they work the entire year (21 or 26 pay periods per year). | 203-204 | 2 | X(2) | Retrieved from the Freq. 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. | Y - All original records and summer spread records. |
Health Care % Indicator | The health care indicator code. | 205-205 | 1 | X(1) | Valid values:
| Required |
Filler | Fill with blanks. | 206-380 | 175 | X(175) | spaces | Not applicable |