Contribution Report - Detail (Type 04) Record - File Layout and Data Mapping

The following table lists the field names, descriptions, positions, lengths, formats, and data sources or valid values for the Contribution report’s Detail (Type 04) record.

Field Name	Description	Position	Length	Format	Data Source or Valid Values
Record Type	Identifies the type of record.	1-2	2	Left-justified	The valid value is 04.
Full Name	The employee’s name. The format is last name, first name, middle initial.	3-57	55	Left-justified	Constructed from the Last Name, First Name, and Middle Initial fields on the Member tab of the Employee Information form on the MN TRA Retirement Report - Demographic page.
Address Line 1	The first line of the employee's address.	58-87	30	Left-justified	Retrieved from the Address Line 1 field on the Address tab of the Employee Information form on the MN TRA Retirement Report - Demographic page.
Address Line 2	The second line of the employee's address.	88-117	30	Left-justified	Retrieved from the Address Line 2 field on the Address tab of the Employee Information form on the MN TRA Retirement Report - Demographic page.
City	The employee's city of residence.	118-137	20	Left-justified	Retrieved from the City field on the Address tab of the Employee Information form on the MN TRA Retirement Report - Demographic page.
State	The employee's state of residence.	138-139	2	Left-justified	Retrieved from the State field on the Address tab of the Employee Information form on the MN TRA Retirement Report - Demographic page.
Zip Code	The employee's zip code with extension.	140-150	11	Left-justified	Constructed from the Zip and Zip Extension fields on the Address tab of the Employee Information form on the MN TRA Retirement Report - Demographic page.
Social Security Number	The employee's Social Security number.	151-159	9	Numeric, no hyphens	Retrieved from the Social Security field on the Member tab of the Employee Information form on the MN TRA Retirement Report - Demographic page.
Employee ID	The employee’s identification (ID) number.	160-170	11	Right-justified	Retrieved from the Employee Number field on the Member tab of the Employee Information form on the MN TRA Retirement Report - Demographic page.
TRA Number	The six-digit numeric identifier assigned to the member by TRA.	171-176	6	Right-justified, zero-filled	Retrieved from the TRA Number field on the Employment tab of the Employee Information form on the MN TRA Retirement Report - Demographic page.
Birth Date	The employee's date of birth.	177-184	8	YYYYMMDD	Retrieved from the Birthdate field on the Member tab of the Employee Information form on the MN TRA Retirement Report - Demographic page.
Exempt Status	Indicates whether the employee is exempt from TRA participation.	185	1	Left-justified	Valid values: A = Exempt Annuitant B = Exempt Technical College C = Exempt Independent Consultant or Contractor Retrieved from the TRA Exempt Status field on the Employment tab of the Employee Information form on the MN TRA Retirement Report - Demographic page.
Filler	Fill with spaces.	186-193	8	spaces	Not applicable
Employee Status	Indicates the member's current employment status with the district.	194-195	2	Left-justified	Valid values: 01 = First Employed 02 = Terminate Employment 03 = Resume Employment 04 = Disability 05 = Sabbatical Leave 06 = Medical Leave 07 = Parental Leave 08 = Extended Leave 09 = Military Leave 10 = Family Leave 11 = Other Leave 12 = Workers’ Comp 13 = Death 14 = Legislative Leave 15 = Unrequested/Layoff 16 = Voluntary Leave, State Only 17 = Union Leave 18 = Part-Time Teacher Program Retrieved from the TRA Employee Status field on the Employment tab of the Employee Information form on the MN TRA Retirement Report - Demographic page.
Status Date	The date when the employee's current TRA Employee Status became effective.	196-203	8	YYYYMMDD	Retrieved from the TRA Employee Status Date field on the Employment tab of the Employee Information form on the MN TRA Retirement Report - Demographic page.
Gender	The employee's gender.	204	1	Left-justified	Valid values: M = Male F = Female Retrieved from the Gender field on the Member tab of the Employee Information form on the MN TRA Retirement Report - Demographic page.
Eligibility Code	A code that identifies the member's position type or job classification for TRA reporting purposes.	205-206	2	Left-justified	Valid values: 01 = Teacher (Full or Part Time) 02 = Teacher/Administrator 03 = Substitute Teacher 04 = Superintendent 05 = College Instructor 06 = Community Education Director 07 = Counselor 08 = Curriculum Writer 09 = Director of Joint Power Unit 10 = Drivers Education Instructor 11 = Early Childhood Instructor 12 = Employee or Officer of a Professional Org 13 = Head Coach (Certified) 14 = Homebound Instructor 15 = Librarian 16 = Nurse 17 = Principal 18 = Psychologist 19 = Retired Teacher (Not TRA Annuitant) 20 = Social Worker 21 = State High School League Coordinator 22 = Therapist 23 = Title Instructor (Licensed) 24 = Tutor Retrieved from the TRA Eligibility field on the Employment tab of the Employee Information form on the MN TRA Retirement Report - Demographic page.
Filler	Fill with spaces.	207-276	70	spaces	Not applicable