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 DTL4 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 DTL4. |
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 beginning date of the reporting period (or the first day the member was paid for in the reporting period being submitted). |
84-91 |
8 |
9(8) |
Retrieved from the Start field on the Defined Contributions form of the Defined Contributions tab on the MI ORS-PSERS (Public School Employees Retirement) page. |
Required |
|
End Date |
The ending date of the reporting period (or the last day the member was paid for in the reporting period being submitted). |
92-99 |
8 |
9(8) |
Retrieved from the End field on the Defined Contributions form of the Defined Contributions tab on the MI ORS-PSERS (Public School Employees Retirement) page. |
Required |
|
DC Record Type |
The record type of the Detail 4 record being reported.
|
100-101 |
2 |
9(2) |
For a list of valid values, refer to 13.04: Detail 4 records - DC record type codes and status change reason codes. |
Required |
|
Gross Wage |
The member's reportable wages paid during the reporting period. |
102-110 |
9 |
9(7)v99 |
Retrieved from the Wages field on the Defined Contributions form of the Defined Contributions tab on the MI ORS-PSERS (Public School Employees Retirement) page. |
Required |
|
Member DC Contributions |
The dollar amount of the member's DC contributions. |
111-119 |
9 |
9(9)v99 |
Retrieved from the Member Contribution field on the Defined Contributions form of the Defined Contributions tab on the MI ORS-PSERS (Public School Employees Retirement) page. |
Required |
|
Member DC Percent (%) |
The percentage of the member's wages allocated as DC contributions. |
120-124 |
5 |
9(3)v99 |
Retrieved from the Member Percentage field on the Defined Contributions form of the Defined Contributions tab on the MI ORS-PSERS (Public School Employees Retirement) page. |
Required |
|
Employer DC Contributions |
The dollar amount of the employer's DC contributions. |
125-133 |
9 |
9(7)v99 |
Retrieved from the Employer Contribution field on the Defined Contributions form of the Defined Contributions tab on the MI ORS-PSERS (Public School Employees Retirement) page. |
Required |
|
Employer DC Match Percent (%) |
The percentage of the employer match allocated to the member's DC contributions. |
134-138 |
5 |
9(3)v99 |
Retrieved from the Employer Percentage field on the Defined Contributions form of the Defined Contributions tab on the MI ORS-PSERS (Public School Employees Retirement) page. |
Required |
|
Status Change Date |
The date of the status change. Required if the member’s status has changed. If there is no status change, enter eight zeros. |
139-146 |
8 |
9(8) |
Retrieved from the Status Date field on the Defined Contributions form of the Defined Contributions tab on the MI ORS-PSERS (Public School Employees Retirement) page. |
Required |
|
Status Change Reason Code |
The transaction code for the status change. Required if the member’s status has changed. |
147-148 |
2 |
9(2) |
For a list of valid values, refer to 13.04: Detail 4 records - DC record type codes and status change reason codes. |
Required |
|
Member PHF Contributions |
The dollar amount of the member's DC PHF contributions. |
149-157 |
9 |
9(7)v99 |
Retrieved from the Member PHF Contribution field on the Defined Contributions form of the Defined Contributions tab on the MI ORS-PSERS (Public School Employees Retirement) page. |
Required |
|
Member PHF Percent (%) |
The percentage of the member's wages allocated as DC PHF contributions. |
158-162 |
5 |
9(3)v99 |
Retrieved from the Member PHF Percentage field on the Defined Contributions form of the Defined Contributions tab on the MI ORS-PSERS (Public School Employees Retirement) page. |
Required |
|
Employer PHF Contributions |
The dollar amount of the employer's match of the employee's DC PHF contributions. |
163-171 |
9 |
9(7)v99 |
Retrieved from the Employer PHF Contribution field on the Defined Contributions form of the Defined Contributions tab on the MI ORS-PSERS (Public School Employees Retirement) page. |
Required |
|
Employer PHF Match Percent (%) |
The percentage of the employer's match of the employee's DC PHF contributions. |
172-176 |
5 |
9(3)v99 |
Retrieved from the Employer PHF Percentage field on the Defined Contributions form of the Defined Contributions tab on the MI ORS-PSERS (Public School Employees Retirement) page. |
Required |
|
Member DC Roth Contributions |
The dollar amount of the member's DC Roth contributions. |
177-185 |
9 |
9(7)v99 |
Retrieved from the Member DC Roth Contribution field on the Defined Contributions form of the Defined Contributions tab on the MI ORS-PSERS (Public School Employees Retirement) page. |
Required |
|
Member DC Roth Percent (%) |
The percentage of the member's wages allocated as DC Roth contributions. |
186-190 |
5 |
9(3)v99 |
Retrieved from the Member DC Roth Percentage field on the Defined Contributions form of the Defined Contributions tab on the MI ORS-PSERS (Public School Employees Retirement) page. |
Required |
|
Member PHF Roth Contributions |
The dollar amount of the member's DC PHF Roth contributions. |
191-199 |
9 |
9(7)v99 |
Retrieved from the Member PHF Roth Contribution field on the Defined Contributions form of the Defined Contributions tab on the MI ORS-PSERS (Public School Employees Retirement) page. |
Required |
|
Member PHF Roth Percent (%) |
The percentage of the member's wages allocated as DC PHF Roth contributions. |
200-204 |
5 |
9(3)v99 |
Retrieved from the Member PHF Roth Percentage field on the Defined Contributions form of the Defined Contributions tab on the MI ORS-PSERS (Public School Employees Retirement) page. |
Required |
|
Filler |
Fill with blanks. |
205-380 |
176 |
X(176) |
spaces |
Required |