14.01.04: Detail 3 - TDP Deductions (DTL3) file layout

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

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