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.

<POSTID>

The post, to which subsequent details in the spreadsheet row applies.

This can be the actual post ID, MAIN - which uses the employee's main post holding as of the effective date, or EMPLOYEE - which uses the EMPLOYEE post.

Mandatory.

<SDATE>

Transaction Date.

For Adjustment type transactions, this should be the Balance as of Date.

Format <dd/mm/yyyy> - employee must be employed as of this date.

Mandatory.
<HRS>

Entitlement adjustments in hours.

Optional.
<DAYS>

Entitlement adjustments in days.

Optional.
<ABSTYPE>

Absence type.

Must be a valid absence type.

Mandatory.
<REASON>

Reason for the entitlement transaction.

Must exist in the BSRSN narrative category.

Optional.
<C1_DAYS>

Entitlement adjustment for the first category or dual level in days.

Optional.
<C1_HRS>

Entitlement adjustment for the first category or dual level in hours.

Optional.
<C2_DAYS>

Entitlement adjustment for the second category or dual level in days.

Optional.
<C2_HRS>

Entitlement adjustment for the second category or dual level in hours.

Optional.