User Tools

Site Tools


Sidebar

Table of Contents

payroll:utilities:importactualhoursworked

Import Actual Hours Worked - HRS7950

Payroll > Utilities > Import Actual Hours Worked

This utility is used to upload a comma-delimited (.txt) file containing actual hours worked data for variable hour employees.

The file should include the employee number, actual date in the YYYYMMDD format, and actual hours. 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.

Note: You must be logged onto a current year pay frequency to access this page.

Import Actual Hours Worked File Layout

Import actual hours worked file:

FieldDescription
Pay DateType the pay date to which you want to import actual hours worked.

❏ Click Choose File, and perform one of the following functions:

  • Type the drive and folder name from where you want to import the tables and click Open to accept the import file name and return to the Import Actual Hours Worked page.
  • The Import Path field should be set to ActHrsWrked#.txt, where the # is the pay frequency that reflects the data contained in the file. Each file should contain data for the pay frequency listed in the file name.

❏ Click Execute to start the import function.

If errors are encountered during the import process, the Import Actual Hours Worked Errors report is displayed. Review the report.

❏ Click Continue to continue. Or, click Cancel to return to the Import Actual Hours page.

If no errors are encountered during the import process, the Import Actual Hours Worked report is displayed. Review the report.

❏ Click Process to continue. You are prompted to create a backup.

A message is displayed indicating that the records were imported successfully.


❏ Click Cancel to return to the Import Actual Hours page.

Use the Payroll > Maintenance > Actual Hours Worked page to verify imported transactions by employee and date range.

payroll/utilities/importactualhoursworked.txt · Last modified: 2023/05/15 18:55 by emoreno