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.05: Detail 4 - DC Contributions (DTL4) file layout
| Field Name | Format | Length | Position | Required Field | Explanation |
|---|---|---|---|---|---|
| Section Identifier – DTL4 | X(4) | 4 | 1 – 4 | Yes | This field is used to identify the type of section the record represents. For the DC contributions section, "DTL4" should be used. |
| SSN | 9(9) | 9 | 5 – 13 | Yes | The member's current Social Security number (SSN). 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 | Yes | The member's last name. |
| First Name | X(20) | 20 | 44 – 63 | Yes | The member's first name. |
| Middle Name | X(20) | 20 | 64 – 83 | No | The member's middle name or initial. If you do not provide a middle name, fill with 20 spaces. |
| Begin Date | 9(8) | 8 | 84 – 91 | Yes | Begin date of reporting period (or first day member was paid for in the reporting period being submitted). |
| End Date | 9(8) | 8 | 92 – 99 | Yes | End date of the reporting period (or last day member was paid for in the reporting period being submitted). |
| DC Record Type | 9(2) | 2 | 100 – 101 | Yes | The record type of the DTL4 record being reported. The possible values are listed in 13.04: Detail 4 records - DC record type codes and status change reason codes. |
| Gross Wages | 9(7)v99 | 9 | 102 – 110 | Yes | Member's gross wages. |
| Member DC Contributions | 9(7)v99 | 9 | 111 – 119 | Yes | Dollar amount of member's DC contributions. |
| Member DC Percent (%) | 9(3)v99 | 5 | 120 – 124 | Yes | Percentage of member's wages allocated as DC contributions. |
| Employer DC Contributions | 9(7)v99 | 9 | 125 – 133 | Yes | Dollar amount of employer's DC contributions. |
| Employer DC Match Percent (%) | 9(3)v99 | 5 | 134 – 138 | Yes | Percentage of employer match allocated to member's DC contributions. |
| Status Change Date | 9(8) | 8 | 139 – 146 | Yes | Date of change must be populated if member status has changed. If no status change, fill with 8 zeroes. |
| Status Change Reason Code | 9(2) | 2 | 147 – 148 | Yes | Transaction code for the status change must be populated if the member status has changed. The possible values are listed in 13.04: Detail 4 records - DC record type codes and status change reason codes. If no status change code to report, fill with 2 zeroes. |
| Member PHF Contributions | 9(7)v99 | 9 | 149 – 157 | Yes | Dollar amount of member's DC PHF contributions. |
| Member PHF Percent (%) | 9(3)v99 | 5 | 158 – 162 | Yes | Percentage of member's wages allocated as DC PHF contributions. |
| Employer PHF Contributions | 9(7)v99 | 9 | 163 – 171 | Yes | Dollar amount of employer's match of the employee's DC PHF contributions. |
| Employer PHF Match Percent (%) | 9(3)v99 | 5 | 172 – 176 | Yes | Percentage of employer's match of the employee's DC PHF contributions. |
| Member DC Roth Contributions | 9(7)v99 | 9 | 191 – 199 | Yes | Dollar amount of member's DC PHF Roth contributions. |
| cc | 9(3)v99 | 5 | 186 – 190 | Yes | Percentage of member's wages allocated as DC PHF Roth contributions. |
| Member PHF Roth Contributions | 9(7)v99 | 9 | 191 – 199 | Yes | Dollar amount of member's DC PHF Roth contributions. |
| Member PHF Roth Percent (%) | 9(3)v99 | 5 | 200 – 204 | Yes | Percentage of member's wages allocated as DC PHF Roth contributions. |
| Filler | X(204) | 176 | 205 – 380 | Yes | Record line must end at space 380. |