User Tools

Site Tools


business:import_actual_hours_worked

Import Actual Hours Worked File Layout

This file record layout is used to import actual hours worked data for variable hour employees.

Field Length Type Example Description
Employee Number6Numeric123=000123Required value; program will zero fill
Actual Hours Worked Date8Numeric20140102YYYYMMDD format; if left blank, the field defaults to the pay period end date for the selected pay date. If the actual date is blank, then the pay period ending date from the employee’s pay date record is used as the actual date. If the actual date is populated, it must be a valid date.
Actual Hours Worked-999.99Numeric545.30 or -545.30Required value; hours can range from -999.99 to 999.99. A decimal and two decimal places should be entered. If a whole number without a decimal is entered, a decimal and two decimal places are automatically added. The value can be negative or positive.
Job Code4Alphanumeric0050Optional value; if left blank, the field defaults to the primary job code.

Notes:

The file type is comma-delimited (.txt).

The file should include the employee number, actual date in the YYYYMMDD format, and actual hours.

business/import_actual_hours_worked.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.