When creating a data export and selecting the fields to include, you must specify the data location for each field. To identify this, follow the steps below.
In the Admin Tool, click Menus.
Double-click the relevant HR admin menu set.
Navigate to the area where the data is stored, then double-click the relevant process.
Double-click the relevant form, then click the padlock icon to unlock it.
Under Form Layout, select the field you want to export and note the Field Name.
For example, if you're looking at the Start Time field on an absence record, the data location may be: SelectHR\Absence.History.Start Time
This path can be broken down as:
SelectHR – the database
Absence – the schema
History – the table name
Start Time – the field name