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.04: Detail 3 - TDP Deductions (DTL3) file layout
| Field Name | Format | Length | Position | Required Field | Explanation |
| Section Identifier – DTL3 | X(4) | 4 | 1 – 4 | Y | This field is used to identify the type of section the record represents. For the TDP deductions section, DTL3 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 correct 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. |
| TDP Deduction Amount | 9(6)v99 | 8 | 84 – 91 | Y | The amount deducted from the member's pay for TDP. |
| TDP Agreement Number | 9(9) | 9 | 92 – 100 | Y | The number on the member's TDP Agreement. |
| TDP Invoice Number | 9(8) | 8 | 101 – 108 | Y | The number on the member's service purchase billing statement. |
| Reporting Period End Date | 9(8) | 8 | 109 – 116 | Y | The pay date for which the TDP deduction is made. It should be formatted as MMDDYYYY. |
| TDP Deduction Reason Code | 9(2) | 2 | 117 – 118 | Y | The possible values are listed in section 13.03: Detail 3 records – TDP adjustment record type codes and deduction reason codes. |
| >Not Used – Report as "00" | 9(2) | 2 | 119 – 120 | N | N/A |
| TDP Record Type | 9(2) | 2 | 121 – 122 | N | This field indicates whether the record is a TDP payment or a TDP adjustment. The possible values are listed in section 13.03: Detail 3 records – TDP adjustment record type codes and deduction reason codes. |
| Filler | X(260) | 260 | 123 – 380 | Optional | N/A |
Last updated: 12/05/2012