This shows you the differences between two versions of the page.
business:import_actual_hours_worked [2018/07/24 12:21] (current)
|Line 1:||Line 1:|
|+||======Import Actual Hours Worked File Layout======|
|+||<WRAP round intro>|
|+||This file record layout is used to import actual hours worked data for variable hour employees. |
|+||^Field ^Length ^Type ^Example ^Description^|
|+|||Employee Number|6|Numeric|123=000123|Required value; program will zero fill||
|+|||Actual Hours Worked Date|8|Numeric|20140102|YYYYMMDD 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.99|Numeric|545.30 or -545.30|Required 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 Code|4|Alphanumeric|0050|Optional value; if left blank, the field defaults to the primary job code. ||
|+||<WRAP Box>**Notes**:\\ \\ The file type is comma-delimited (.txt).\\ \\ The file should include the employee number, actual date in the YYYYMMDD format, and actual hours.|
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.