User Tools

Site Tools


Sidebar

Table of Contents

humanresources:utilities:importactualhoursworked

This is an old revision of the document!


Import Actual Hours Worked - HRS7950

Human Resources > 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.

File layout

Import actual hours worked file:

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

Click Browse, 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.
  • Click Browse to select the folder and import file. Click Open to select the file name, or click Cancel to close the dialog box without selecting a file.
  • The File name 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 any errors are encountered during the import process, the Import Actual Hours Worked Errors report is displayed.

Review the report.

Click Continue to continue.

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.

Click Cancel to return to the Import Actual Hours page.

Create a backup.

If you clicked Process, a message is displayed indicating that the records were successfully imported. You can verify imported transactions by retrieving the desired employee record and date range on the Maintenance > Actual Hours Worked page.

humanresources/utilities/importactualhoursworked.1513202979.txt.gz · Last modified: 2017/12/13 17:09 (external edit)