|
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.
|
|
Expected Confinement Date.
Format DD/MM/YYYY.
Mandatory.
|
|
Payment Start Date
Format DD/MM/YYYY
Mandatory
|
|
The Parental Leave Absence Type.
Must be UKPATB (Paternity - Birth), UKPATC (Paternity - Adoption), UKADP (Adoption) or UKMAT (Maternity).
Mandatory.
|
|
The leave status.
If entered, must be: E (Entered - use when importing leave periods to be processed in the bulk process), P (Part-Paid - use when importing an in-progress leave period) or C (Completed - use when importing historic leave periods).
If this keyword does not exist, the imported leave period defaults to E.
Optional.
|
|
Actual Birth / Placement date.
Format DD/MM/YYYY.
Mandatory.
|
|
OMP Start Date.
Format DD/MM/YYYY.
Only required if different from the statutory.
|
|
Start Year/Period.
This only applies when importing historic absences.
Must exist as a valid tax period.
Format YYYY/PP.
Optional.
|
|
Payment method.
Must be WEEKLY or PERIOD.
If this keyword does not exist, the payment method defaults to the one specified against the employee's control group.
Optional.
|
|
Contracted hours of work.
This only applies to occupational schemes, and if entered, overrides the employee's current contract hours.
Must be numeric.
Optional.
|
|
Service start date.
This only applies to occupational schemes, and if entered, overrides the employee's service start date.
Format DD/MM/YYYY.
Optional.
|
|
Certification received date.
Format DD/MM/YYYY.
Mandatory.
|
|
Mother Deceased indicator.
Must be Y or blank.
|
|
Partner Deceased indicator.
Must be Y or blank.
|
|
Mortality indicator.
Must exist in the PLMORT narrative category.
|
|
RTW Flag
Must be Y or N.
Mandatory.
|
|
Curtailment Date.
Format DD/MM/YYYY.
Only applicable to MAT/ADPT
|
|
Interim RTW Date.
Format DD/MM/YYYY.
If MPP/APP End Date provided and the Interim is not, interim will be populated as MPP/APP End + 1
Only applicable to MAT/ADPT
|
|
MPP/APP End Date
Format DD/MM/YYYY.
Only applicable to MAT/ADPT
|
|
Final RTW Date
Format DD/MM/YYYY.
|
|
Paternity RTW Date
Format DD/MM/YYYY.
Only applicable to Paternity.
|
|
Expected leave date.
Format DD/MM/YYYY.
Optional.
|
|
Revocation date.
If curtailment date exists, the curtailment date will be removed.
Format DD/MM/YYYY.
Optional.
|
|
Average Weekly Pay Amount.
Must be numeric.
|
|
Normal Weekly Pay Amount.
Must be numeric.
|
|
Lump Sum Indicator STAT.
Must be Yor blank.
|
|
Lump Sum Indicator OCC.
Must be Yor blank.
|
|
Qualifying week start date.
This only applies when importing historic absences.
Format DD/MM/YYYY.
Mandatory.
|
|
Total statutory payments.
This only applies when importing historic absences.
Must be numeric.
Mandatory.
|
|
Total occupational payments.
This only applies when importing historic absences.
Must be numeric.
Mandatory.
|
|
The date up to which payments have been paid.
Format DD/MM/YYYY.
Mandatory if the <LVSTAT> keyword = P.
|
|
The amount of statutory payments paid.
Must be numeric.
Mandatory if the <LVSTAT> keyword = P.
|
|
The amount of occupational payments paid.
Must be numeric.
Mandatory if the <LVSTAT> keyword = P.
|
|
Allow Differing Daily Rates.
Must be numeric.
Only applicable for part paid.
|