TRS of Illinois http://trs.illinois.gov
TEACHERS' RETIREMENT SYSTEM OF THE STATE OF ILLINOIS


Import File Specifications

Most payroll software vendors have incorporated a process in the payroll software program to compile data from the payroll system and format the information in the fixed-length specifications noted below. The file can be imported into the web Annual Report to save data entry time. TRS strongly recommends that employers verify the accuracy of the data prior to completing and submitting the Annual Report.

ASCII Fixed Length Format Specifications

Record Length: 98

Data # Data Name From Thru Size Picture Comments
1 Letter Code 1 1 1 A Letter A
2 Social Security Number 2 10 9 999999999  
3 Name 11 40 30 x(30)  
4 Gender 41 41 1 X M or F
5 Date of Birth 42 49 8 99999999 MMDDYYYY
6 Type of Employment 50 50 1 X  
7 Number of Days in Employment Agreement 51 53 3 999  
8 Total Number of Days Paid 54 56 3 999  
9 Annual Salary Rate 57 66 10 9999999.99 Include decimal point
10 Creditable Earnings 67 76 10 9999999.99 Include decimal point
11 Member TRS Contributions 77 86 10 9999999.99 Include decimal point
12 Federal Funds 87 96 10 999999999. Include decimal point
13 End of Line 97 98 2   Carriage return line feed