Column Keywords for the Parental Leave Upload File Selection.

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
<EMPNO>

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.
<EXPDUEDATE>

Expected Confinement Date.

Format DD/MM/YYYY.

Mandatory.
<KITSPLITDAYDATE>

KIT/SPLIT Day Date

Format DD/MM/YYYY.

Mandatory.
<KITSPLITDAYTYPE>

KIT/SPLIT Day Type.

Must be either K or S.

Mandatory.
<KITSPLITDAYAMT>

KIT/SPLIT Day Amount

Must be numeric.
<KITSPLITOSAMT>

KIT/SPLIT Offset Amount

Must be numeric.
<DERIVEKITSPLITOS>

Derive the Kit/SPLIT Offset amount?

Must be Y or blank.