STRS input file layout needed for STRSAD Merge
- Sara Glore
- Stephanie Schmucker
Position 1-4 | X(4) | District Number |
Position 5-12 | 9(6)V99 | Taxed Deduction FTD Amount Non-annuitized employee amount from 450 payroll item deduction record |
Position 13-16 | X(4) | Report Fiscal Year First year of fiscal year, Report 2023-2024 as 2023. |
Position 17-19 | 9V99 | Service Credit Do not leave blank, For reemployed retirees, enter 000. 2 assumed decimals. 100=100%, 050=50% |
Position 20 | X(1) | Retiree Flag |
Position 21-29 | X(9) | SSN |
Position 30-44 | X(15) | Employee Last Name |
Position 45-59 | X(15) | Employee First Name |
Position 60-67 | 9(6)V99 | Tax-Deferred Member Contribution (pickup) Pickup FTD amount from 591 payroll item record |
Position 68-107 | X(40) | Address Line 1 |
Position 108-147 | X(40) | Address Line 2 |
Position 148-187 | X(40) | Address Line 3 |
Position 188-207 | X(20) | City |
Position 208-209 | X(2) | State |
Position 210-214 | 9(5) | Zip code |
Position 215-218 | 9(4) | Zip code plus 4 If not available enter in 0000 |
Position 219-220 | 9(2) | Delivery point zip |
Position 221-228 | 9(6)V99 | Accrued Contributions Contributions on fiscal year earnings that will not be paid until after July 1. |
Position 229-278 | X(50) | Email Address |
Position 279-288 | 9(10) | Phone Number (no dashes) |
Position 289 | 9(1) | Phone Number Type C = Cell phone H = Home phone |
Position 290 | X(61) | Reserved |
Total Record Length | 350 |
For fields with 9(?)V99 the V means implied decimal.
The 9 means numeric and the X means alphanumeric.
This file should be in an a .csv file extension. There is NO header record and there are no comma's separating it. It is all driven by position.