Column keywords for Hours Load.

Column level keywords define the column usage for each data row and can only follow the keyword <DEFN>. Each column keyword must only occur once, if present.

Column Keywords Description

<EMPID>

The employee number, to which subsequent data in the spreadsheet row applies.

Must be a valid employee number.

It can appear in any column of the definition row, but it is recommended it appears in the first column for spreadsheet clarity.

Mandatory.

<TAX_YEAR>

Tax year.

Format YYYY.

Mandatory.

<TAX_PERIOD>

Tax Period.

Numeric format.

Mandatory.

<NORMAL_HRS>

Employee's normal hours.

Must be a positive integer.

Mandatory.

<WORKED_HRS>

Employee's worked hours.

Must be a positive integer.

Optional.

<FURLOUGH_HRS>

Employee's furlough hours.

Must be a positive integer.

Optional.
<HOLIDAY_HRS>

Employee's furlough holiday hours.

Must be a positive integer.

Optional.