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 Number	6	1-6	Numeric	123 = 000123
Job Code	4	7-10	Numeric	Left justified, if 123 = '123'
Regular Hrs	5, 2	11-15	Numeric	37.52 hrs = 03752
Absence Deduction	7, 2	16-22	Numeric	$123.45 = 0012345
Overtime Hours	5, 2	23-27	Numeric	4.52 hrs = 00452
Overtime Amount	7, 2	28-34	Numeric	$123.45 = 0012345
Overtime Budget Fund	3	35-37	Numeric	Fund 199 = 199
Overtime Budget Function	2	38-39	Numeric	Function 11 = 11
Overtime Budget Object	4	40-43	Numeric	Object 6119 = 6119
Overtime Budget Sub Obj	2	44-45	Numeric	Sub Object 00 = 00
Overtime Budget Organization	3	46-48	Numeric	Organization 001 = 001
Overtime Budget Fiscal Yr	1	49	Numeric	If 2013-2014 = ‘4’
Overtime Budget Program	2	50-51	Numeric	Program Codes
Overtime Budget Ed Span	1	52	Numeric	Educational Span Codes
Overtime Budget Project	2	53-54	Numeric	Project Detail Codes
Overtime Code	1	55	Numeric	1, 2, 3, 4, or 5
Supplemental Amount	7, 2	56-62	Numeric	If $123.45 = 0012345
Supplemental Fund	3	63-65	Numeric	Fund 199 = 199
Supplemental Function	2	66-67	Numeric	Function 11 = 11
Supplemental Object	4	68-71	Numeric	Object 6119 = 6119
Supplemental Sub Obj	2	72-73	Numeric	Sub Object 00 = 00
Supplemental Organization	3	74-76	Numeric	Organization 001 = 001
Supplemental Fiscal Yr	1	77	Numeric	If 2002-2003 = ‘3’
Supplemental Program	2	78-79	Numeric	Program Codes
Supplemental Ed Span	1	80	Numeric	Educational Span Codes
Supplemental Project	2	81-82	Numeric	Project Detail Codes
Actual Hours	5, 2	83-87	Numeric	37.52 hrs = 03752
Actual Date	8	88-95	Numeric	20140102

Interfaces