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

Payment Start Date

Format DD/MM/YYYY

Mandatory
<ABSTYPE>

The Parental Leave Absence Type.

Must be UKSHPL (Shared Parental Leave).

Mandatory.
<LVSTAT>

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

Actual Birth / Placement date.

Format DD/MM/YYYY.

Mandatory.
<MATADPT>

Maternity / Adoption flag.

Must be either MATERNITY or ADOPTION.
<STARTYRPRD>

Start Year/Period.

This only applies when importing historic absences.

Must exist as a valid tax period.

Format YYYY/PP.

Optional.
<PAYMTHD>

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

Contracted hours of work.

This only applies to occupational schemes, and if entered, overrides the employee's current contract hours.

Must be numeric.

Optional.
<SERVSTDT>

Service start date.

This only applies to occupational schemes, and if entered, overrides the employee's service start date.

Format DD/MM/YYYY.

Optional.
<CERRECDT>

Certification received date.

Format DD/MM/YYYY.

Mandatory.
<MOTHDEC>

Mother Deceased indicator.

Must be Y or blank.
<PARTDEC>

Partner Deceased indicator.

Must be Y or blank.
<MORTIND>

Mortality indicator.

Must exist in the PLMORT narrative category.
<RTWFLAG>

RTW Flag

Must be Y or N.

Mandatory.
<CURTDATE>

Curtailment Date.

Format DD/MM/YYYY.

Only applicable to MAT/ADPT
<INTRTWDATE>

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

MPP/APP End Date

Format DD/MM/YYYY.

Only applicable to MAT/ADPT
<FINRTDATE>

Final RTW Date

Format DD/MM/YYYY.
<EXPLVDT>

Expected leave date.

Format DD/MM/YYYY.

Optional.
<REVOCDATE>

Revocation date.

If curtailment date exists, the curtailment date will be removed.

Format DD/MM/YYYY.

Optional.
<MAXLVWKS>

Maximum Leave Weeks.

Must be numeric and not >50.

Mandatory.
<MAXPAYWKS>

Maximum Payment Weeks.

Must be numeric and not >37.

Optional.
<AVEWKPAYAMT>

Average Weekly Pay Amount.

Must be numeric.
<NORMWKPAYAMT>

Normal Weekly Pay Amount.

Must be numeric.
<NOTPAYSHPL>

Don't Pay Shared Parental Leave flag.

Must be Y or blank.
<ABSENDDATE>

Absence End Date.

Format DD/MM/YYYY.

Used for discreet blocks of Shared Parental Leave.
<PARTFORENAME> Partner Forename
<PARTSURNAME> Partner Surname
<PARTNINO>

Partner NI Number

Must be a valid NI Number
<PARTADDR1> Partner Address Line 1
<PARTADDR2> Partner Address Line 2
<PARTADDR3> Partner Address Line 3
<PARTADDR4> Partner Address Line 4
<PARTTOWN> Partner Address Town
<PARTCOUNTY> Partner Address County
<PARTCOUNTRY> Partner Address Country
<PARTPSTCD> Partner Address Postcode
<PARTERNAME> Partner Employer Name
<PARTERADDR1> Partner Employer Address Line 1
<PARTERADDR2> Partner Employer Address Line 2
<PARTERADDR3> Partner Employer Address Line 3
<PARTERADDR4> Partner Employer Address Line 4
<PARTERTOWN> Partner Employer Address Town
<PARTERCOUNTY> Partner Employer Address County
<PARTERCOUNTRY> Partner Employer Address Country
<PARTERPSTCD> Partner Employer Address Postcode
<ADPTAGCYNAME> Adoption Agency Name
<ADPTAGCYADDR1> Adoption Agency Address Line 1
<ADPTAGCYADDR2> Adoption Agency Address Line 2
<ADPTAGCYADDR3> Adoption Agency Address Line 3
<ADPTAGCYADDR4> Adoption Agency Address Line 4
<ADPTAGCYTOWN> Adoption Agency Address Town
<ADPTAGCYCOUNTY> Adoption Agency Address County
<ADPTAGCYCOUNTRY> Adoption Agency Address Country
<ADPTAGCYPSTCD> Adoption Agency Address Postcode
<QWSTART>

Qualifying week start date.

This only applies when importing historic absences.

Format DD/MM/YYYY.

Mandatory.
<STATPAID>

Total statutory payments.

This only applies when importing historic absences.

Must be numeric.

Mandatory.
<OCCPAID>

Total occupational payments.

This only applies when importing historic absences.

Must be numeric.

Mandatory.
<PAIDTODT>

The date up to which payments have been paid.

Format DD/MM/YYYY.

Mandatory if the <LVSTAT> keyword = P.
<STATPAIDTO>

The amount of statutory payments paid.

Must be numeric.

Mandatory if the <LVSTAT> keyword = P.
<OCCPAIDTO>

The amount of occupational payments paid.

Must be numeric.

Mandatory if the <LVSTAT> keyword = P.
<DIFFDAILYRATE>

Allow Differing Daily Rates.

Must be numeric.

Only applicable for part paid.