Detail 3 Record - TDP deduction
The following table lists the Detail 3 record field names, format, position, and description. Data is from the TDP work file unless indicated.
Field Name | Format | Position | Description |
|---|---|---|---|
Section ID | X(4) | 1-4 | Always set to “DTL3.” |
SSN | 9(9) | 5-13 | The member’s social security number. |
Last Name | X(30) | 14-43 | The member’s last name. |
First Name | X(20) | 44-63 | The member’s first name. |
Middle Name | X(20) | 64-83 | The member’s middle name. |
TDP Deduction Amount | 9(6)v99 | 84-91 | The amount deducted from a member’s pay for TDP. |
Agreement Number | 9(9) | 92-100 | The number on the member’s TDP credit purchase agreement or payroll authorization form. |
Invoice Number | 9(8) | 101-108 | The number on the member’s service purchase bill. |
Pay Period End Date | 9(8) | 109-116 | The ending date of the pay period of the TDP deduction, formatted as MMDDYYYY. |
Deduction Reason | 9(2) | 117-118 | The reason why a TDP is or is not withheld. |
Zero Filled | 9(2) | 119-120 | Always set to “00.” |
Adjustment Type | 9(2) | 121-122 | TDP Adjustment Type code. Valid values:
|
Filler | X(260) | 123-380 | NA |