Bulk temporary movements

EmpowerHR's Bulk Temporary Movements feature is useful when you need to add many temporary position movements at once, such as higher duties allowances or secondments, instead of adding each one individually.

Information This procedure is separate from crossboarding temporary movements via Background Jobs > Bulk Data Take-On > Crossboarding. The path documented here loads through the Tasks menu and isn't run as a background job.

What do I need to prepare?

Create a Microsoft Excel spreadsheet with one row per temporary movement and the columns listed below. Save the spreadsheet as XML Spreadsheet 2003 (one of the file types available in Excel's Save As dialog).

Information Tip: Exclude the column header row from the saved file. The loader reads from row 1 and expects each row to be a data row.

Bulk temporary movements file format

Column
Description
Field length Req?
Notes
A
Employee Code 10 y
B Employment 3 y
C
From Date 9 y Format:

yyyymmdd.

D Upto Date 9 n Format:

yyyymmdd.

Leave blank for an open-ended movement.

E
Position Number 10
y Alphanumeric, up to 10 characters, with leading zeros.
F Position Movement Reason 4 y Must be a valid reason code on the Position Movements Reason Codes control table.
G
Reason Code 4 y Must be a valid reason code on the Acting/Secondment Reason control table.
H
Narrative 180 n


Load a Bulk Temporary Movements file

To load a Bulk Temporary Movements file:
  1. Go to Tasks > Employees > Temporary Movements > Bulk Temporary Movements.
  2. At File Name, select the XML Spreadsheet 2003 file you prepared.
  3. Click Process.
  4. EmpowerHR validates each row in turn. If any row fails validation, the error message displays alongside that row. Common errors include:
    • Movement not added as it already exists.
    • Movement not added as employee is not employed at this date.
    • Movement not added as movement already exists on this day.
    • Movement not added as employee is on External Secondment at this date.
    • Movement not added as employee is set up to be terminated before this date.
  5. Correct any errors in the source spreadsheet, save it again as XML Spreadsheet 2003, and repeat the procedure to reload.


Next topic

Bulk update regular transactions

© 2023 Fusion5. All rights reserved.