This task allows the upload of employee normal hours to be held in the Hours Maintenance screen (MD312S29), using the CSV from the Hours Extract task (MD312S25).

The CSV file must be structured using row and column keywords to map columns to employee data fields.

Click to view an example spreadsheet for hours load.
Emp No. Tax Year Tax Period Normal Hours Worked Hours Furlough Hours Furlough Holiday Hours

<DEFN>

<EMPID>

<DATA>



<TAX_YEAR>



<TAX_PERIOD>



<NORMAL_HRS>



<WORKED_HRS>



<FURLOUGH_HRS>



<HOLIDAY_HRS>

COV100

2020

4

164

17

20

 

COV105

2020

4

164

 

105

35
COV117 2020 4 164 60 20 20

<EOD>

To delete an entry, enter zero i.e . “0”, in all hours columns.

Note: If Worked Hours are more than Normal Hours, Furlough hours should not be present.

Selection

File on Server

Select this check box if the CSV file you want to load is located on the server or leave it blank if the file is on your local PC.

File Name

Enter the name of the CSV file, or click WINDOW to display either a file upload window or Select Server File (depending on the file source), where you can browse for the required CSV file.

Process Option

Report Only

Enter Y to validate the file without updating the database and generate a report detailing the number of records validated, total successes and total errors.

Click CONTINUE to load the CSV file, and update the database or validate the file as indicated.

MD312S27

Related knowledgebase articles