User Tools

Site Tools


business:payroll_leave_transmittal

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’
Blank2Numeric17-18Spaces
Units Taken6, 3Numeric19-2413.25 = 013250
Date Leave Taken8Numeric25-32Oct 22, 2014 = 20141022

Notes:

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 (BHR_EMP_LV_XMITAL).

business/payroll_leave_transmittal.txt · Last modified: 2018/07/24 12:21 (external edit)

Americans with Disabilities Act (ADA) and Web Accessibility

The Texas Computer Cooperative (TCC) is committed to making its websites accessible to all users. It is TCC policy to ensure that new and updated content complies with Web Content Accessibility Guidelines (WCAG) 2.0 Level AA. We welcome comments and suggestions to improve the accessibility of our websites. If the format of any material on our website interferes with your ability to access the information, use this form to leave a comment about the accessibility of our website.