User Tools

Site Tools


Payroll Leave Transmittal File Layout

This file layout is used to import leave transmittal files into TxEIS leave accounting tables.

Field Length Type Position Description
Employee Number6Numeric1-6123 = 000123
Transaction Key6Numeric7-121st = 000001, 2nd = 000002
Transaction Leave Type2Numeric13-14State Sick 7 = ‘07’
Transaction Abs Reason2Numeric15-16Employee Sick 3 = ‘03’
Units Taken6, 3Numeric19-2413.25 = 013250
Date Leave Taken8Numeric25-32Oct 22, 2014 = 20141022


Transaction Key is a sequence number in case the employee has multiple leave records for the same day.

Transaction Leave Type is the leave type code (e.g. 01 = Local Personal Leave, 02 = Without Pay, etc.). The leave type entered here has to match a leave code in the TxEIS Leave Type table. These codes are user-defined.

Transaction Abs Reason is the absence reason code (e.g. 05 = Jury Duty, 08 = Family Illness, etc.). It can be blank, but if there is something there, the absence reason entered has to match an absence record code in the TxEIS Absence Reason table. These codes are user-defined.

Units Taken can indicate either hours or days. The TxEIS applications will take the number entered here, and, depending on how the Days/Hours code is set for the leave type indicated in the record, will treat this number as either hours or days. It is numeric and needs to be right-justified.

The system will take this data and create leave transmittal records.

business/payroll_leave_transmittal.txt · Last modified: 2020/01/20 10:00 by emoreno