Parental Leave Upload File Selection
Enables you to select and upload a set of Parental Leave data from a spreadsheet, which has been saved as a comma-separated values (CSV) file. You can validate the CSV file before updating the database, if required.
The types of files that can be uploaded are:
- Parental Leave
- Used to load UKMAT, UKADP, UKPATB or UKPATC data
- Shared Parental Leave
- Used to load UKSHPL Shared Parental Leave data
- KIT/SPLIT
- Used to load KIT/SPLIT days data
The CSV file must be structured using row and column keywords to map columns to parental leave detail fields. The column keywords to use depend on the type of file to be uploaded:
Click 
here to view an example spreadsheet.
| Employee ID | Name | Expected Due Date | Parental Leave Type | Actual Birth / Placement Date | Payments Start Date |
|---|---|---|---|---|---|
|
<DEFN> <EMPID> <DATA> |
|
|
|
|
|
| 1000005 | A Smith | 01/08/2014 | D | 01/08/2014 | 01/08/2014 |
| 1000007 | P Jones | 15/06/2014 | M | 17/06/2014 | 17/06/2014 |
| <EOD> |
Note: It is possible to load a CSV file for each of the three types in the same action. However, as KIT/SPLIT data refers to information that is populated after processing an absence, if the KIT/SPLIT data to be loaded refers to entries being added in the Parental leave or Shared Parental Leave files, it is recommended that the KIT/SPLIT file be uploaded separately after processing the Parental / Shared Parental leave.
Note: When loading a Parental Leave absence which contains multiple records (E.g. Maternity and one or more periods of shared parental leave), records that are wholly or partially paid should be loaded using a Leave Status <LVSTAT> of 'P'. The records within the absence that are wholly unpaid should be loaded with a Leave Status <LVSTAT> of 'E' or a blank status. The Leave Status <LVSTAT> 'C' should be used only for single record absences that are fully complete.
Selection
File On Server
Select this check box if the CSV file you want to load is located on the server or leave blank if the file is on your local PC.
Filename
Enter the name of the CSV file, or click window to display either a file upload window or Select Server File (depending on the file source) where you can browse for the required CSV file.
Process Options
Report Only
Select this check box to validate the file without updating the database and generate the Errors report if any exceptions exist.
Click CONTINUE to load the CSV file, and update the database or validate the file as indicated.
MD341S2