Detail 3 Record - TDP deduction
The following table shows the field names, descriptions, positions, lengths, formats, data sources or valid values, and whether the field is required for the ORS-PSERS Retirement report’s DTL3 record.
Field Name | Description | Position | Length | Format | Data Source or Valid Values | Required or Optional |
|---|---|---|---|---|---|---|
Section Identifier | Identifies the type of section the record presents. | 1-4 | 4 | X(4) | The valid value is DTL3. | Required |
SSN | The employee's Social Security number. | 5-13 | 9 | 9(9) | Retrieved from the Social Security field on the Demographic tab on the MI ORS-PSERS (Public School Employees Retirement) page. | Required |
Last Name | The employee's last name. | 14-43 | 30 | X(30) | Retrieved from the Last Name field on the Demographic tab on the MI ORS-PSERS (Public School Employees Retirement) page. | Required |
First Name | The employee's first name. | 44-63 | 20 | X(20) | Retrieved from the First Name field on the Demographic tab on the MI ORS-PSERS (Public School Employees Retirement) page. | Required |
Middle Name | The employee’s middle name. | 64-83 | 20 | X(20) | Retrieved from the Middle Name field on the Demographic tab on the MI ORS-PSERS (Public School Employees Retirement) page. | Optional |
TDP Deduction Amount | The amount deducted from the member's pay for TDP. | 84-91 | 8 | 9(6)v99 | Retrieved from the Deduction Amt field on the Tax Deferred Payments (TDP) form on the Tax Deferred Payments (TDP) tab of the MI ORS-PSERS (Public School Employees Retirement) page. | Required |
Agreement Number | The number on the member's TDP Agreement. | 92-100 | 9 | 9(9) | Retrieved from the Agreement No. field on the Tax Deferred Payments (TDP) form on the Tax Deferred Payments (TDP) tab of the MI ORS-PSERS (Public School Employees Retirement) page. | Required |
Invoice Number | The number on the member's service purchase billing statement. | 101-108 | 8 | 9(8) | Retrieved from the Invoice No. field on the Tax Deferred Payments (TDP) form on the Tax Deferred Payments (TDP) tab of the MI ORS-PSERS (Public School Employees Retirement) page. | Required |
Pay Period End Date | The pay date for which the TDP deduction is made. The format is MMDDYYYY. | 109-116 | 8 | 9(8) | Retrieved from the Pay Period field on the Tax Deferred Payments (TDP) form on the Tax Deferred Payments (TDP) tab of the MI ORS-PSERS (Public School Employees Retirement) page. | Required |
Deduction Reason | The deduction reason code. | 117-118 | 2 | 9(2) | For a list of valid values, refer to 13.03: Detail 3 records - TDP adjustment record type codes and deduction reason codes. Retrieved from the Reason field on the Tax Deferred Payments (TDP) form on the Tax Deferred Payments (TDP) tab of the MI ORS-PSERS (Public School Employees Retirement) page. | Required |
Zero-Filled | Fill with two zeros. | 119-120 | 2 | 9(2) | The valid value is 00. | Not required |
Adjustment Type | Indicates whether the record represents a TDP payment or a TDP adjustment. | 121-122 | 2 | 9(2) | For a list of valid values, refer to 13.03: Detail 3 records - TDP adjustment record type codes and deduction reason codes. Retrieved from the Adjustment Type field on the Tax Deferred Payments (TDP) form on the Tax Deferred Payments (TDP) tab of the MI ORS-PSERS (Public School Employees Retirement) page. | Not required |
Filler | Fill with blanks. | 123-380 | 260 | X(260) | spaces | Not applicable |