Skip to main content

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