MD Retirement Systems Report - File Layout And Data Mapping

The default file name for the MD Retirement Systems report is mdret1tp.tpe.

The following table lists the field names, descriptions, positions, lengths, and data sources or valid values for the MD Retirement Systems report.

Field Name	Description	Position	Length	Data Source or Valid Values
Transaction Code	The transaction code for the retirement record.	1-3	3	The valid value is 405. Retrieved from the Transaction Code field on the Employee Information form of the MD Retirement Systems Report page.
Payroll End Date	The payroll period end date.	4-11	8	Retrieved from the Payroll End Date field on the MD Retirement Systems Report - Load screen.
Filler	blank	12	1	Fill with spaces.
System Code	The retirement system code.	13	1	Valid values: 1 = Teachers Retirement 2 = Employees Retirement 6 = Teachers Pension 7 = Employees Pension Retrieved from the System Code field on the Employee Information form of the MD Retirement Systems Report page.
Location	The employer location code.	14-21	8	Retrieved from the Location field on the Employee Information form of the MD Retirement Systems Report page.
Filler	blank	22-26	5	Fill with spaces.
Plan Code	The retirement plan code.	27	1	Valid values: blank (no specific plan) 8 = Contributory Pension Plan Retrieved from the Plan Code field on the Employee Information form of the MD Retirement Systems Report page.
Social Security Number	The employee's Social Security number.	28-36	9	Retrieved from the Social Security field on the Employee Information form of the MD Retirement Systems Report page.
Last Name	The employee's last name.	37-53	17	Retrieved from the Last Name field on the Employee Information form of the MD Retirement Systems Report page.
First Name	The employee's first name.	54-65	12	Retrieved from the First Name field on the Employee Information form of the MD Retirement Systems Report page.
Middle Initial	The employee's middle initial.	66	1	Retrieved from the Middle Initial field on the Employee Information form of the MD Retirement Systems Report page.
Current Annual Salary	The employee's current annual salary.	67-73	7	Retrieved from the Actual Annual Salary field on the Employee Information form of the MD Retirement Systems Report page.
Employee Contribution	The employee's retirement contribution amount × 100.	74-82	9	Retrieved from the Employee Contribution field on the Employee Information form of the MD Retirement Systems Report page.
Hours Worked	The employee's hours worked × 10.	83-86	4	Retrieved from the Hours Worked field on the Employee Information form of the MD Retirement Systems Report page.
Standard Hours	The employee's standard hours × 10.	87-90	4	Retrieved from the Standard Worked field on the Employee Information form of the MD Retirement Systems Report page.
Percent Time	The percentage of time worked.	91-92	2	Retrieved from the Percent Time field on the Employee Information form of the MD Retirement Systems Report page.
Base Salary Paid	The employee's base salary × 100.	93-101	9	Retrieved from the Base Salary Paid field on the Employee Information form of the MD Retirement Systems Report page.
Annual Part-Time Salary	The annual part-time salary amount.	102-108	7	Retrieved from the Annual Earnable Salary field on the Employee Information form of the MD Retirement Systems Report page.
Filler	blank	109-124	16	Fill with spaces.
Street Address	The employee's street address.	125-154	30	Retrieved from the Address field on the Employment tab of the Employee Information page.
Filler	blank	155-159	5	Fill with spaces.
Miscellaneous Address	The employee's additional address information.	160-189	30	Retrieved from the Address field on the Employment tab of the Employee Information page.
Filler	blank	190-194	5	Fill with spaces.
City	The employee's city of residence.	195-214	20	Retrieved from the City field on the Employment tab of the Employee Information page.
Filler	blank	215-227	13	Fill with spaces.
State	The employee's state of residence.	228-229	2	Retrieved from the State field on the Employment tab of the Employee Information page.
Zip Code	The employee's five-digit zip code.	230-234	5	Retrieved from the first five characters of the Zip Code field on the Employment tab of the Employee Information page.
Zip Extension	The employee's four-digit zip code extension.	235-238	4	Retrieved from characters 7-10 of the Zip Code field on the Employment tab of the Employee Information page (the four-digit extension after the hyphen).
Filler	blank	239-250	12	Fill with spaces.