User Tools

Site Tools



This shows you the differences between two versions of the page.

Link to this comparison view

business:payroll_leave_transmittal [2018/07/24 12:21] (current)
Line 1: Line 1:
 +======Payroll Leave Transmittal File Layout======
 +<WRAP round intro>
 +This file layout is used to import leave transmittal files into TxEIS leave accounting tables.
 +^Field ​ ^Length ^Type ^Position ^Description ^
 +|Employee Number|6|Numeric|1-6|123 = 000123|
 +|Transaction Key|6|Numeric|7-12|1st = 000001, 2nd = 000002|
 +|Transaction Leave Type|2|Numeric|13-14|State Sick 7 = ‘07’|
 +|Transaction Abs Reason|2|Numeric|15-16|Employee Sick 3 = ‘03’|
 +|Units Taken|6, 3|Numeric|19-24|13.25 = 013250|
 +|Date Leave Taken|8|Numeric|25-32|Oct 22, 2014 = 20141022|
 +<WRAP Box>
 +**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.