The web Browser you are currently using is unsupported, and some features of this site may not work as intended. Please update to a modern browser such as Chrome, Firefox or Edge to experience all features Michigan.gov has to offer.
14.01.03: Detail 2 - Wage and Service (DTL2) file layout
14.01.03: Detail 2 - Wage and Service (DTL2) file layout
Field Name | Format | Length | Position | Required Field | Explanation |
Section Identifier - DTL2 | X(4) | 4 | 1-4 | Y | This field is used to identify the type of section the record represents. For the Wage and Service section "DTL2" should be used. |
SSN | 9(9) | 9 | 5-13 | Y | The member's current social security number. This field will also be used to report a corrected SSN for a member whose SSN has changed. |
Last Name | X(30) | 30 | 14-43 | Y | The member's last name. |
First Name | X(20) | 20 | 44-63 | Y | The member's first name. |
Middle Name | X(20) | 20 | 64-83 | If you wish to provide; otherwise, fill with 20 spaces. | The member's middle name or initial. |
Begin Date | 9(8) | 8 | 84-91 | Y | The first day the member was paid for in the reporting period being submitted (normally this would be the same date as the begin date of the reporting period.) If there are multiple records for the same member within a pay period, then the Begin Date will be the first day the member was paid for with a unique status code or employment class code. It should be formatted as MMDDYYYY. |
End Date | 9(8) | 8 | 92-99 | Y | The last day the member was paid for in the reporting period begin submitted (normally this would be the same date as the end date of the reporting period.) If there are multiple records for the same member within a pay period, then the end date will be the last day the member was paid for with a unique status code or employment class code. It should be formatted as MMDDYYYY. |
Retirement Hours | 9(4)v99 | 6 | 100-105 | Required for original records, post retirement wages, and adjustments involving hours. | The total hours the member worked. |
Reported Wage Code | 9(2) | 2 | 106-107 | Y | The transaction code for the member record. The possible values are listed in section 13.02.02: Detail 2 records - wage codes. |
Employer Reported Wages | 9(7)v99 | 9 | 108-116 | Required for all records unless it is for an adjustment to hours only. | The member's reportable wages paid during the reporting period. |
Not Used - Report as all zeros "000000000" | 9(9) | 9 | 117-125 | ||
Exception Wages | 9(7)v99 | 9 | 126-134 | Class code of 9001 | 9001 - The wages a member receives while on professional services leave or professional services released time. |
Member Contributions | 9(7)v99 | 9 | 135-143 | Required for original records and record adjustment, if wages are included in the adjustment. | The pre-tax contributions withheld from the member's reportable wages. |
Employer Contributions | 9(7)v99 | 9 | 144-152 | Not mandatory | The contributions that the employer pays to ORS on behalf of the member. This is a percentage of the reportable wages a member is paid. |
Not Used - Report as all zeros "000000000" | 9(9) | 9 | 153-161 | Y | |
Pay Rate | 9(7)v99 | 9 | 162-170 | Y - All original records | 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. See chapter 4: Reporting Compensation. |
Employment Class Code | X(94) | 4 | 171-174 | Y | The position that the member holds. All possible values are listed in section 13.02.01: Detail 2 records - employment class codes and definitions. |
Contract Begin Date | 9(8) | 8 | 175-182 | Y - All original records with pay rates greater than 100 | The start date of a contract the member is working. This is only used for members who are on contract or are salaried employees. The contract begin date should be in the format of MMDDYYYY and should be all zeros for a member who is not on a contract. The fiscal year begin date can be used for non-contractual salaried employees. |
Contract End Date | 9(8) | 8 | 183-190 | Y - All original records with pay rates greater than 100 | The finish date of a contract the member is working. This is only used for employees who are on a contract or are salaried employees. The contract end date should be in the format of MMDDYYYY and should be all zeros for a member who is not on a contract. The fiscal year end date can be used for non-contractual salaried employees. |
Not Used - Report as all zeros "000000000000" | 9(12) | 12 | 191-202 | Y | |
Frequency of Pay | X(2) | 2 | 203-204 | Y - All original records and summer spread records | Whether hourly or salaried, report the total number of pays that the member would be paid, as if he or she is working the entire year (i.e. 21 or 26). |
Health Care % Indicator | 9(1) | 1 | 205 | Y | For a member who first worked on or after 7/1/10, use a 1 if starting salary for 7/1/10 to 6/30/11, is less that $18,000. If more than $18,000, enter a zero (0) or a space. |
Filler | X(175) | 175 | 206-380 | Optional |
Last updated: 07/06/2016