ORS-PSERS - Monthly Purchase Agreement Or Payroll Authorization File - File Layout and Data Mapping

The default file name for the Monthly Purchase Agreement or Payroll Authorization file is TDA.<Entity Number>.txt.

The following table lists the positions, names, descriptions, formats, and data source or valid values of the Monthly Purchase Agreement or Payroll Authorization file.

Position	Name	Description	Format	Data Source or Valid Values
1 – 5	RU (Reporting Unit) Number	The five-digit organization number. The first four digits are the number assigned to the individual reporting unit. These should be followed by a zero except for Henry Ford Community College, which has a trailing 1.	9(5)	Retrieved from the TDP Reporting Unit Number field on the Human Resources Profile – State page.
6 – 14	Agreement Number	The employee’s TDP agreement number from the payroll authorization record associated with the TDP deduction code.	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.
15 – 22	Invoice Number	The employee’s TDP invoice number from the payroll authorization record associated with the TDP deduction code.	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.
23 – 25	SSN3	The first three digits of the employee's Social Security Number.	9(3)	Retrieved from the Social Security field on the Demographic tab on the MI ORS-PSERS (Public School Employees Retirement) page.
26 – 27	SSN2	The middle two digits of the employee's Social Security Number.	9(2)	Retrieved from the Social Security field on the Demographic tab on the MI ORS-PSERS (Public School Employees Retirement) page.
28 – 31	SSN4	The last four digits of the employee's Social Security Number.	9(4)	Retrieved from the Social Security field on the Demographic tab on the MI ORS-PSERS (Public School Employees Retirement) page.
32 – 39	Agreement Date	The employee’s TDP agreement date.	MMDDYYYY	Retrieved from the Agreement Date field on the Agreement Information form of the MI ORS-PSERS - Reference Tables - Purchase Agreements page.
40 – 48	Filler	Fill with nine zeros.	9(6)V99	The valid value is 000000000.
49 – 56	Billing Amount	The employee’s TDP billing amount.	9(6)V99	Retrieved from the Billing Amount field on the Agreement Information form of the MI ORS-PSERS - Reference Tables - Purchase Agreements page.
57 – 61	Service Credit Years Available	The number of service credit years available.	9(2)V999	Retrieved from the Service Credit Years Available field on the Agreement Information form of the MI ORS-PSERS - Reference Tables - Purchase Agreements page.
62 – 69	Filler	Fill with nine zeros.	9(6)V99	The valid value is 000000000.
70 – 74	Service Credit Purchased	The number of service credits purchased.	9(2)V999	Retrieved from the Service Credit Purchased field on the Agreement Information form of the MI ORS-PSERS - Reference Tables - Purchase Agreements page.
75 – 82	Scheduled Deduction Amount	The scheduled deduction amount.	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.
83 – 84	Service Purchase Type	This field is no longer used. Fill with two zeros.	99	The valid value is 00.
85 – 86	Frequency of Pay	The employee’s pay frequency.	99	Retrieved from the Frequency of Pay field on the Agreement Information form of the MI ORS-PSERS - Reference Tables - Purchase Agreements page.
87 – 94	Filler	Fill with nine zeros.	9(6)V99	The valid value is 000000000.
95 – 102	Billing Due Date	The billing due date.	MMDDYYYY	Retrieved from the Billing Due Date field on the Agreement Information form of the MI ORS-PSERS - Reference Tables - Purchase Agreements page.