User Tools

Site Tools


business:payroll_transmittal

Payroll Transmittal File Layout

This file layout is used to import payroll transmittal files into TxEIS payroll transaction tables.

Field Length Position Type Description
Employee Number61-6Numeric123 = 000123
Job Code47-10NumericLeft justified, if 123 = '123'
Regular Hrs5, 211-15Numeric37.52 hrs = 03752
Absence Deduction7, 216-22Numeric$123.45 = 0012345
Overtime Hours5, 223-27Numeric4.52 hrs = 00452
Overtime Amount7, 228-34Numeric$123.45 = 0012345
Overtime Budget Fund335-37NumericFund 199 = 199
Overtime Budget Function238-39NumericFunction 11 = 11
Overtime Budget Object440-43NumericObject 6119 = 6119
Overtime Budget Sub Obj244-45NumericSub Object 00 = 00
Overtime Budget Organization346-48NumericOrganization 001 = 001
Overtime Budget Fiscal Yr149NumericIf 2013-2014 = ‘4’
Overtime Budget Program250-51NumericProgram Codes
Overtime Budget Ed Span152NumericEducational Span Codes
Overtime Budget Project253-54NumericProject Detail Codes
Overtime Code155Numeric1, 2, 3, 4, or 5
Supplemental Amount7, 256-62NumericIf $123.45 = 0012345
Supplemental Fund363-65NumericFund 199 = 199
Supplemental Function266-67NumericFunction 11 = 11
Supplemental Object468-71NumericObject 6119 = 6119
Supplemental Sub Obj272-73NumericSub Object 00 = 00
Supplemental Organization374-76NumericOrganization 001 = 001
Supplemental Fiscal Yr177NumericIf 2002-2003 = ‘3’
Supplemental Program278-79NumericProgram Codes
Supplemental Ed Span180NumericEducational Span Codes
Supplemental Project281-82NumericProject Detail Codes
Actual Hours5, 283-87Numeric37.52 hrs = 03752
Actual Date888-95Numeric20140102
business/payroll_transmittal.txt · Last modified: 2019/04/18 12:41 by emoreno