Skip to main content

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.