CLIENT: UT System Components
APPLICATION: Flex Remittance Layout
MEDIA: FTP datasets
FORMAT: ASCII
RECORD LENGTH: 250
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 229 Y A/N 21 249
Last Byte 1 Y A/N Value "Z" 250 250
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 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 3 Y A/N =A(ctive), T(erminated), L(eave) 75 77
Date of Hire 8 N D =CCYYMMDD 78 85
Eligibility Date 8 Y D =CCYYMMDD 86 93
Date of Termination 8 N D =CCYYMMDD 94 101
Pay Frequency 1 Y A/N =B(iweekly), W(eekly), S(emi-Monthly) 102 102
Pay Cycle Code 15 Y A/N Employees Pay Cycle 103 117
FSC code 15 N N Family Status Change Code 118 132
FSC Edate 8 N D Family Status Change Effective Date CCYYMMDD 133 140
Dep Care Per Pay Deduction Sign 1 Y A/N + or - 141 141
Dep Care Per Pay Deduction Amt 6 Y N 999999 with implied decimal 142 147
Dep Care Election Sign 1 Y A/N + or - 148 148
Dep Care Election Amt 6 Y N 999999 with implied decimal 149 154
Dep Care Election Start Date 8 Y D =CCYYMMDD 155 162
Dep Care Election Stop Date 8 N D =CCYYMMDD 163 170
Dep Care Filler 7 N A/N 171 177
Htlh Care Per Pay Deduction Sign 1 Y A/N + or - 178 178
Htlh Care Per Pay Deduction 6 Y N 999999 with implied decimal 179 184
Htlh Care Election - Sign 1 Y A/N + or - 185 185
Htlh Care Election 6 Y N 999999 with implied decimal 186 191
Htlh Care Election Start Date 8 Y D =CCYYMMDD 192 199
Htlh Care Election Stop Date 8 N D =CCYYMMDD 200 207
Htlh Care Election filler 7 N A/N 208 214
Employee paid Fee 4 N N 9999 with implied decimal 215 218
Component paid Fee 4 N N 9999 with implied decimal 219 222
Error Field 27 N A/N Used by EGI to send errors back to Components 223 249
Last Byte 1 Y A/N Value "Z" 250 250
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 Dep Care Deductions 12 Y N Required if Dep Care Deductions with implied decimal 12 23
Total Dep Care Elections 12 Y N Required if Dep Care Elections with implied decimal 24 35
Total Htlh Care Deductions 12 Y N Required if Htlh Care Deductions with implied decimal 36 47
Total Htlh Care Elections 12 Y N Required if Htlh Care Elections with implied decimal 48 59
Total Employee Paid Fees 12 Y N Required if Employee Paid Fees with implied decimal 60 71
Total Component Paid Fees 12 Y N Required if Component Paid Fees with implied decimal 72 83
Filler 166 Y A/N 84 249
Last Byte 1 Y A/N Value "Z" 250 250