Enables you to load employee ancillary data from a spreadsheet, which has been saved as a comma-separated values (CSV) file. You can upload the CSV file without updating the database to validate the file first, if required.

To access this screen, enter fast path HR480S91.

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

Click to view an example spreadsheet.
Employee ID Surname Employee Type Notice Period

<DEFN>

<EMPID>

<DATA>


<EMPTYP>


<NOTICE>
1000005 Smith FULL UNKN
1000007 Jones PART 01 MTH
<EOD>

Selection

File On Server

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

CSV 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 Options

Cut-Off Date

Enter a date if you would like to prevent ancillary data being loaded for employees who have left before this date.

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. A file upload window is displayed where you can browse for the CSV file you want to upload.

MD480S91