Detail 4 Record - DC Contributions
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 |