CLIENT: UT System Components
APPLICATION: Flex Remittance Layout
MEDIA: FTP datasets
FORMAT: ASCII
RECORD LENGTH: 240
DESCRIPTION FIELD LENGTH REQUIRED TYPE COMMENTS START BYTE END BYTE
Record Type 1 Y N =H (Header Record) 1 1
State Agency Code 3 Y N Component State Agency Code 2 4
File Date 8 Y D File Creation Date - YYYYMMDD 5 12
Payroll Date 8 N D Payroll Date for Deductions on File - YYYYMMDD 13 20
Filler 219 Y A/N 21 239
Last Byte 1 Y A/N Value "Z" 240 240
DESCRIPTION FIELD LENGTH REQUIRED TYPE COMMENTS START BYTE END BYTE
Record Type 1 Y N =D (detail Record) 1 1
State Agency Code 3 Y N Component State Agency Code 2 4
Social Security Number 9 Y N Required 5 13
EE ID 30 N A/N Internal Employee ID Number. This field can be used freeform for whatever identifier the component chooses. (name, employee number...) 14 43
Dir Deposit Acct Number 20 N A/N Bank Acct for Direct Deposit Participation 44 63
Dir Deposit Routing Number 9 N N Bank Number for Direct Deposit Participation 64 72
Dir Deposit Acct Type 2 N A/N 22=Personal Checking, 32=Personal Savings 73 74
Employment Status 1 Y A/N =A(ctive), T(erminated), L(eave) 75 75
Date of Hire 8 N D =CCYYMMDD 76 83
Eligibility Date 8 Y D =CCYYMMDD 84 91
Date of Termination 8 N D =CCYYMMDD 92 99
Pay Frequency 1 Y A/N =B(iweekly), W(eekly), S(emi-Monthly), M(onthly) 100 100
Pay Cycle Code 2 Y A/N Employees Pay Cycle 101 102
FSC code 2 N N Family Status Change Code 103 104
FSC Edate 8 N D Family Status Change Effective Date CCYYMMDD 105 112
Day Care Per Pay Deduction Sign 1 Y A/N + or - 113 113
Day Care Per Pay Deduction Amt 6 Y N 999999 with implied decimal 114 119
Day Care Election Sign 1 Y A/N + or - 120 120
Day Care Election Amt 6 Y N 999999 with implied decimal 121 126
Day Care Election Start Date 8 Y D =CCYYMMDD 127 134
Day Care Election Stop Date 8 N D =CCYYMMDD 135 142
Day Care Filler 7 N A/N 143 149
Htlh Care Per Pay Deduction Sign 1 Y A/N + or - 150 150
Htlh Care Per Pay Deduction 6 Y N 999999 with implied decimal 151 156
Htlh Care Election - Sign 1 Y A/N + or - 157 157
Htlh Care Election 6 Y N 999999 with implied decimal 158 163
Htlh Care Election Start Date 8 Y D =CCYYMMDD 164 171
Htlh Care Election Stop Date 8 N D =CCYYMMDD 172 179
Htlh Care Election filler 7 N A/N 180 186
Employee paid Fee 4 N N 9999 with implied decimal 187 190
Component paid Fee 4 N N 9999 with implied decimal 191 194
Error Field 45 N A/N Used by EGI to send errors back to Components 195 239
Last Byte 1 Y A/N Value "Z" 240 240
DESCRIPTION FIELD LENGTH REQUIRED TYPE COMMENTS START BYTE END BYTE
Record Type 1 Y N =T (Trailer Record) 1 1
Total Records 10 Y N Total Number of detail records on file 2 11
Total Day Care Deductions Sign 1 Y N + or - 12 12
Total Day Care Deductions 10 Y N Required if Day Care Deductions with implied decimal 13 22
Total Day Care Elections 10 Y N Required if Day Care Elections with implied decimal 23 32
Total Htlh Care Deductions Sign 1 Y N + or - 33 33
Total Htlh Care Deductions 10 Y N Required if Htlh Care Deductions with implied decimal 34 43
Total Htlh Care Elections 10 Y N Required if Htlh Care Elections with implied decimal 44 53
Total Employee Paid Fees 10 Y N Required if Employee Paid Fees with implied decimal 54 63
Total Component Paid Fees 10 Y N Required if Component Paid Fees with implied decimal 64 73
Filler 166 Y A/N 74 239
Last Byte 1 Y A/N Value "Z" 240 240