{"text_format":"1","workbook":"xlsx","n_sheets":39,"sheets":["Welcome","Validation Format Example","Appraisals","Dependants","CPD Summary","Competencies","Disciplinary","Equipment Issued","Eye Tests","Fitness Assessments","Flexible Working","Grievances","Incidents","Languages","Medical Reports","Previous Employment","Professional Qualifications","Qualifications","Qualification Units","Referees","Return to Work","Risk Assessments","Stat Adoption","KIT Days Adoption","Statutory Maternity","KIT Days Maternity","Stat Paternity Adoption","Stat Paternity Birth","Stat Shared Par Leave Adopt","ShPL Adopt Leave Request","ShPL Adopt SPLIT Days","Stat Shared Par Leave Birth","ShPL Birth Leave Request","ShPL Birth SPLIT Days","Training Courses (Bookings)","Training Needs","Training Sponsorship","Training Unavailability","Vehicle Allocations"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":38,"comments":37,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Welcome","index":0,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[null,"Welcome to the Advanced HR Data Migration Templates."]
[]
[null,"Before populating your templates, please read our Data Migration Template overview and best practice Guide for more information."]

{"sheet":"Validation Format Example","index":1,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Character","Logic","Date","Numeric","Notes"]
[5,"TRUE/FALSE","DD/MM/YYYY","5,2",8000]
["Header","Header","Header","Header","Header"]
["a",true]
["aa",false,"01/01/1989","123.12"]
["bbb",null,"01/05/1920",".235"]
["cccccc",null,"1st Feb"]
[]
[null,null,null,null,"This line, has commas, that need, to be, removed"]

{"sheet":"Appraisals","index":2,"n_rows":4,"n_cols":77,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Character","Character","Character","Date","Character","Character","Date","Character","Character","Character","Character","Character","Character","Character","Character","Character","Character","Character","Character","Character","Character","Character","Character","Character","Character","Character","Character","Character","Character","Character","Character","Character","Character","Character","Character","Character","Character","Character","Character","Character","Character","Character","Character","Character","Character","Character","Character","Character","Character","Character","Character","Character","Character","Character","Character","Character","Character","Character","Character","Character","Character","Character","Character","Character","Character","Character","Character","Character","Character","Character","Character","Character","Character","Character","Character","Character","Character"]
[8,35,35,"DD/MM/YYYY",8,40,"DD/MM/YYYY",8000,8000,40,20,8000,8000,40,20,8000,8000,40,20,8000,8000,40,20,8000,8000,40,20,8000,8000,40,20,8000,8000,40,20,8000,8000,40,20,8000,8000,40,20,8000,8000,40,20,8000,8000,40,20,8000,8000,40,20,8000,8000,40,20,8000,8000,40,20,8000,8000,40,20,8000,8000,8000,8000,80000,8000,8000,8000,8000,8000]
["Employee ID","Surname","Forename","Appraisal Date","Appraisal Manager Staff Number","Appraisal Manager Name","Date Signed Off","Achievements Emp","Achievements Man","Personal Competency 1","Personal Rating 1","Personal Comments 1 Emp","Personal Comments 1 Man","Personal Competency 2","Personal Rating 2","Personal Comments 2 Emp","Personal Comments 2 Man","Personal Competency 3","Personal Rating 3","Personal Comments 3 Emp","Personal Comments 3 Man","Personal Competency 4","Personal Rating 4","Personal Comments 4 Emp","Personal Comments 4 Man","Personal Competency 5","Personal Rating 5","Personal Comments 5 Emp","Personal Comments 5 Man","Professional Competency 1","Professional Rating 1","Professional Comments 1 Emp","Professional Comments 1 Man","Professional Competency 2","Professional Rating 2","Professional Comments 2 Emp","Professional Comments 2 Man","Professional Competency 3","Professional Rating 3","Professional Comments 3 Emp","Professional Comments 3 Man","Professional Competency 4","Professional Rating 4","Professional Comments 4 Emp","Professional Comments 4 Man","Professional Competency 5","Professional Rating 5","Professional Comments 5 Emp","Professional Comments 5 Man","Managerial Competency 1","Managerial Rating 1","Managerial Comments 1 Emp","Managerial Comments 1 Man","Managerial Competency 2","Managerial Rating 2","Managerial Comments 2 Emp","Managerial Comments 2 Man","Managerial Competency 3","Managerial Rating 3","Managerial Comments 3 Emp","Managerial Comments 3 Man","Managerial Competency 4","Managerial Rating 4","Managerial Comments 4 Emp","Managerial Comments 4 Man","Managerial Competency 5","Managerial Rating 5","Managerial Comments 5 Emp","Managerial Comments 5 Man","Area of Responsibility 1","Objective 1","Area of Responsibility 2","Objective 2","Area of Responsibility 3","Objective 3","General Comments Emp","General Comments Man"]
["00000001",null,null,"DD/MM/YYYY",null,null,"DD/MM/YYYY"]

{"sheet":"Dependants","index":3,"n_rows":5,"n_cols":15,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Character","Character","Character","Character","Character","Date","Logic","Date","Logic","Date","Logic","Logic","Integer","Numeric","Character"]
[8,35,35,35,20,"DD/MM/YYYY","TRUE/FALSE","DD/MM/YYYY","TRUE/FALSE","DD/MM/YYYY","TRUE/FALSE","TRUE/FALSE",null,"3,1"]
["Employee ID","Surname","Forename","Name","Relationship","Date of Birth","Adopted","Date of Adoption","Legal Responsibility","Date of Responsibility","Disabled","Not Eligible for Parental Leave","Child Number","Parental Leave Previously Taken","Notes"]
["00000001",null,null,null,null,"DD/MM/YYYY",true,"DD/MM/YYYY",true,"DD/MM/YYYY",true,true]
[null,null,null,null,null,null,false,null,false,null,false,false]

{"sheet":"CPD Summary","index":4,"n_rows":4,"n_cols":14,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Character","Character","Character","Date","Date","Integer","Integer","Numeric","Numeric","Numeric","Numeric","Numeric","Numeric","Character"]
[8,35,35,"DD/MM/YYYY","DD/MM/YYYY",null,null,"4,2","4,2","4,2","4,2","4,2","4,2"]
["Employee ID","Surname","Forename","CPD Date From","CPD Date To","Accredited Percentage","Non Accredited Percentage","External Seminar Hours","Internal Seminar Hours","Video With Discussion Hours","Video Alone Hours","Other Accredited Hours","Non Accredited Hours","Notes"]
["00000001"]

{"sheet":"Competencies","index":5,"n_rows":4,"n_cols":9,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Character","Character","Character","Character","Character","Integer","Date","Integer","Character"]
[8,35,35,80,20,null,"DD/MM/YYYY",null,8000]
["Employee ID","Surname","Forename","Competency","Competency Rating","Actual Score","Date Achieved","Status","Notes"]
["00000001",null,null,null,null,null,"DD/MM/YYYY"]

{"sheet":"Disciplinary","index":6,"n_rows":4,"n_cols":11,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Character","Character","Character","Date","Character","Character","Date","Date","Character","Date","Character"]
[8,35,35,"DD/MM/YYYY",30,30,"DD/MM/YYYY","DD/MM/YYYY",30,"DD/MM/YYYY",8000]
["Employee ID","Surname","Forename","Meeting Date","Reason","Result","Date Appeal Made","Date Appeal Held","Result of Appeal","Disciplinary Expiry","Notes"]
["00000001",null,null,"DD/MM/YYYY",null,null,"DD/MM/YYYY","DD/MM/YYYY",null,"DD/MM/YYYY"]

{"sheet":"Equipment Issued","index":7,"n_rows":4,"n_cols":8,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Character","Character","Character","Character","Date"," Date","Character","Character"]
[8,35,35,30,"DD/MM/YYYY","DD/MM/YYYY",20]
["Employee ID","Surname","Forename","Equipment","Date Issued","Date Returned","Serial Number","Notes"]
["00000001",null,null,null,"DD/MM/YYYY","DD/MM/YYYY"]

{"sheet":"Eye Tests","index":8,"n_rows":5,"n_cols":9,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Character","Character","Character","Date","Logic","Numeric","Numeric","Character"," Character"]
[8,35,35,"DD/MM/YYYY","TRUE/FALSE","9,2","9,2",3]
["Employee ID","Surname","Forename","Date of Test","Glasses Required","Total Cost","Amount Claimed","Currency","Notes"]
["00000001",null,null,"DD/MM/YYYY",true]
[null,null,null,null,false]

{"sheet":"Fitness Assessments","index":9,"n_rows":5,"n_cols":16,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Character","Character","Character","Date","Character","Character","Logic","Logic","Logic","Logic","Character","Character","Date","Date","Logic","Character"]
[8,35,35,"DD/MM/YYYY",8000,19,"TRUE/FALSE","TRUE/FALSE","TRUE/FALSE","TRUE/FALSE",8000,30,"DD/MM/YYYY","DD/MM/YYYY","TRUE/FALSE"]
["Employee ID","Surname","Forename","Fitness Assessment Date","Fitness Conditions","Fitness for Work","Phased Return to Work","Altered Hours","Amended Duties","Workplace Adaptations","Fitness Comments","Fitness Constraint Period","Fitness Constraint Start","Fitness Constraint End","Reassess Fitness for Work","Notes"]
["00000001",null,null,"DD/MM/YYYY",null,"Is not Fit for Work",true,true,true,true,null,null,"DD/MM/YYYY","DD/MM/YYYY",true]
[null,null,null,null,null,"May be Fit for Work",false,false,false,false,null,null,null,null,false]

{"sheet":"Flexible Working","index":10,"n_rows":8,"n_cols":24,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Character","Character","Character","Date","Character","Character","Logic","Logic","Date","Character","Date","Character","Character","Date","Character","Character","Character","Date","Character","Date","Character","Character","Character","Character"]
[8,35,35,"DD/MM/YYYY",28,null,"TRUE/FALSE","TRUE/FALSE","DD/MM/YYYY",null,"DD/MM/YYYY",null,null,"DD/MM/YYYY",10,null,30,"DD/MM/YYYY",null,"DD/MM/YYYY",10,null,30]
["Employee ID","Surname","Forename","Request Made","Reason for Request","Other Reason","Eligible","Extension Agreed","Agreed Extension Date","Reason for Extension","Formal Meeting Date","Meeting Notes","Additional Meetings","Date of Decision","Decision","Decision Notes","Decision Made By","Date Appeal Made","Reason for Appeal","Appeal Meeting Date","Appeal Outcome","Appeal Notes","Appeal Held By","Notes"]
["00000001",null,null,"DD/MM/YYYY","Childcare (Legal Guidelines)",null,true,true,"DD/MM/YYYY",null,"DD/MM/YYYY",null,null,"DD/MM/YYYY","Approved",null,null,"DD/MM/YYYY",null,"DD/MM/YYYY","Approved"]
[null,null,null,null,"Other Dependant Care",null,false,false,null,null,null,null,null,null,"Compromise",null,null,null,null,null,"Compromise"]
[null,null,null,null,"Retirement Preparation",null,null,null,null,null,null,null,null,null,"Declined",null,null,null,null,null,"Declined"]
[null,null,null,null,"Health Reasons",null,null,null,null,null,null,null,null,null,"Withdrawn",null,null,null,null,null,"Withdrawn"]
[null,null,null,null,"Other"]

{"sheet":"Grievances","index":11,"n_rows":4,"n_cols":10,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Character","Character","Character","Date","Character","Character"," Date"," Date","Character","Character"]
[8,35,35,"DD/MM/YYYY",30,30,"DD/MM/YYYY","DD/MM/YYYY",30]
["Employee ID","Surname","Forename","Meeting Date","Reason","Result","Date Appeal Made","Date Appeal Held","Result of Appeal","Notes"]
["00000001",null,null,"DD/MM/YYYY",null,null,"DD/MM/YYYY","DD/MM/YYYY"]

{"sheet":"Incidents","index":12,"n_rows":5,"n_cols":20,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Character","Character","Character","Date","Character","Character","Character","Character","Character","Logic","Logic","Numeric","Logic","Date","Character","Character","Logic","Date","Character","Character"]
[8,35,35,"DD/MM/YYYY",5,30,30,8,30,"TRUE/FALSE","TRUE/FALSE","4,1","TRUE/FALSE","DD/MM/YYYY",30,20,"TRUE/FALSE","DD/MM/YYYY",20]
["Employee ID","Surname","Forename","Date of Incident","Time of Incident","Incident Type","Location","On Off Site","Nature of Injury","Accident Book","Hospital Required","Working Days Lost","RIDDOR","RIDDOR Date","RIDDOR Category","RIDDOR Reference","Insurance Claim","Insurers Notified","Claim Reference","Notes"]
["00000001",null,null,"DD/MM/YYYY","99:99",null,null,"On Site",null,true,true,null,true,"DD/MM/YYYY",null,null,true,"DD/MM/YYYY"]
[null,null,null,null,null,null,null,"Off Site",null,false,false,null,false,null,null,null,false]

{"sheet":"Languages","index":13,"n_rows":4,"n_cols":8,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Character","Character","Character","Character","Character","Character","Character","Character"]
[8,35,35,15,15,15,20]
["Employee ID","Surname","Forename","Language Name","Spoken Fluency","Written Fluency","Overall Level","Notes"]
["00000001"]

{"sheet":"Medical Reports","index":14,"n_rows":4,"n_cols":13,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Character","Character","Character","Date","Character","Character","Date","Date","Numeric","Character","Character","Character","Character"]
[8,35,35,"DD/MM/YYYY",20,40,"DD/MM/YYYY","DD/MM/YYYY","9,2",40,20]
["Employee ID","Surname","Forename","Report Requested","Medical Type","Reason","Date of Medical","Report Received","Cost of Report","Doctor Name","Doctor Contact Number","Doctor Details","Notes"]
["00000001",null,null,"DD/MM/YYYY",null,null,"DD/MM/YYYY","DD/MM/YYYY"]

{"sheet":"Previous Employment","index":15,"n_rows":4,"n_cols":8,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Character","Character","Character","Date","Date","Character","Character","Character"]
[8,35,35,"DD/MM/YYYY","DD/MM/YYYY",40,40]
["Employee ID","Surname","Forename","Employed From","Employed To","Employed By","Employed As","Notes"]
["00000001",null,null,"DD/MM/YYYY","DD/MM/YYYY"]

{"sheet":"Professional Qualifications","index":16,"n_rows":4,"n_cols":9,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Character","Character","Character","Date","Character","Character","Character","Date","Character"]
[8,35,35,"DD/MM/YYYY",75,60,25,"DD/MM/YYYY"]
["Employee ID","Surname","Forename","Date Qualified","Qualification","Professional Body","Membership Number","Date of Expiry","Notes"]
["00000001",null,null,"DD/MM/YYYY",null,null,null,"DD/MM/YYYY"]

{"sheet":"Qualifications","index":17,"n_rows":4,"n_cols":11,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Character","Character","Character","Numeric","Character","Character","Character","Character","Character","Character","Character"]
[8,35,35,"4,0",40,20,40,7,40,85]
["Employee ID","Surname","Forename","Year of Qualification","Qualification","Qualification Level","Subject","Grade","Educational Institute","Awarding Body","Notes"]
["00000001"]

{"sheet":"Qualification Units","index":18,"n_rows":4,"n_cols":11,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Character","Character","Character","Character","20 Character","Character","75 Character","10 Character"," Date","3,1 Numeric","Character"]
[8,35,35,40,null,40]
["Employee ID","Surname","Forename","Qualification","Qualification Level","Subject","Unit Title","Reference Number","Date Completed","Credits","Notes"]
["00000001",null,null,null,null,null,null,null,"DD/MM/YYYY"]

{"sheet":"Referees","index":19,"n_rows":4,"n_cols":20,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Character","Character","Character","Character","Date","Date","Character","Character","Character","Character","Character","Character","Character","Character","Character","Character","Character","Character","Character","Character"]
[8,35,35,15,"DD/MM/YYYY","DD/MM/YYYY",35,35,10,30,30,30,30,30,20,8,45,20,60]
["Employee ID","Surname","Forename","Type","Date Requested","Date Received","Forenames","Surname","Title","Profession","Address 1","Address 2","Address 3","Town","County","Postcode","Country","Telephone","Email","Notes"]
["00000001",null,null,null,"DD/MM/YYYY","DD/MM/YYYY"]

{"sheet":"Return to Work","index":20,"n_rows":6,"n_cols":18,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Character","Character","Character","Date","Date","Character","Character","Date","Date","Character","Character","Logic","Character","Date","Date","Logic","Date","Character"]
[8,35,35,"DD/MM/YYYY","DD/MM/YYYY",8,40,"DD/MM/YYYY","DD/MM/YYYY",40,17,"TRUE/FALSE",22,"DD/MM/YYYY","DD/MM/YYYY","TRUE/FALSE","DD/MM/YYYY"]
["Employee ID","Surname","Forename","RTW Process Started","RTW Interview Date","Interview With Staff Number","Interview With Name","Sickness From","Sickness To","Sickness Reason","Outcome","Referred to Occupational Health","Special Arrangements","Pay Change Date","Review Date","Sick Pay Reinstated","Date Reinstated","Notes"]
["00000001",null,null,"DD/MM/YYYY","DD/MM/YYYY","00000001",null,"DD/MM/YYYY","DD/MM/YYYY",null,"Caution Issued",true,"Full Pay","DD/MM/YYYY","DD/MM/YYYY",true,"DD/MM/YYYY"]
[null,null,null,null,null,null,null,null,null,null,"Under Review",false,"Half Pay",null,null,false]
[null,null,null,null,null,null,null,null,null,null,"No Further Action",null,"SSP Only"]

{"sheet":"Risk Assessments","index":21,"n_rows":5,"n_cols":8,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Character","Character","Character","Date","Character","Logic","Date","Character"]
[8,35,35,"DD/MM/YYYY",30,"TRUE/FALSE","DD/MM/YYYY"]
["Employee ID","Surname","Forename","Date of Assessment","Reason","Equipment Issued","Date of Issue","Notes"]
["00000001",null,null,"DD/MM/YYYY",null,true,"DD/MM/YYYY"]
[null,null,null,null,null,false]

{"sheet":"Stat Adoption","index":22,"n_rows":5,"n_cols":10,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Character","Character","Character","Date","Date","Logic","Date","Date","Date","Character"]
[8,35,35,"DD/MM/YYYY","DD/MM/YYYY","TRUE/FALSE","DD/MM/YYYY","DD/MM/YYYY","DD/MM/YYYY"]
["Employee ID","Surname","Forename","Matching Certificate Date","Child Expected Date","Work up to Placement","Actual Placed Date","Leave Start","Leave End","Notes"]
["00000001",null,null,"DD/MM/YYYY","DD/MM/YYYY",true,"DD/MM/YYYY","DD/MM/YYYY","DD/MM/YYYY"]
[null,null,null,null,null,false]

{"sheet":"KIT Days Adoption","index":23,"n_rows":6,"n_cols":9,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Character","Character","Character","Date","Date","Date","Date","Character","Character"]
[8,35,35,"DD/MM/YYYY","DD/MM/YYYY","DD/MM/YYYY","DD/MM/YYYY",30]
["Employee ID","Surname","Forename","Matching Certificate Date","Child Expected Date","Start Date","End Date","Reason","Notes"]
["00000001",null,null,"DD/MM/YYYY","DD/MM/YYYY","DD/MM/YYYY","DD/MM/YYYY"]
[]
["Import Definition will need to be created with columns you require"]

{"sheet":"Statutory Maternity","index":24,"n_rows":5,"n_cols":15,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Character","Character","Character","Date","Date","Date","Date","Character","Date","Character","Date","Date","Logic","Date","Character"]
[8,35,35,"DD/MM/YYYY","DD/MM/YYYY","DD/MM/YYYY","DD/MM/YYYY",10,"DD/MM/YYYY",6,"DD/MM/YYYY","DD/MM/YYYY","TRUE/FALSE","DD/MM/YYYY"]
["Employee ID","Surname","Forename","MATB1 Date","Baby Due Week","MATB1 Received","Leave Confirmation Sent","Leave Type","Leave Start","Intention","Actual Date of Birth","Expected Return Date","Overwrite Expected Return Date","Actual Return Date","Notes"]
["00000001",null,null,"DD/MM/YYYY","DD/MM/YYYY","DD/MM/YYYY","DD/MM/YYYY","Ordinary","DD/MM/YYYY","Resign","DD/MM/YYYY","DD/MM/YYYY",true,"DD/MM/YYYY"]
[null,null,null,null,null,null,null,"Additional",null,"Return",null,null,false]

{"sheet":"KIT Days Maternity","index":25,"n_rows":4,"n_cols":8,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Character","Character","Character","Date","Date","Date","Character","Character"]
[8,35,35,"DD/MM/YYYY","DD/MM/YYYY","DD/MM/YYYY",30]
["Employee ID","Surname","Forename","MATB1 Date","Start Date","End Date","Reason","Notes"]
["00000001",null,null,"DD/MM/YYYY","DD/MM/YYYY","DD/MM/YYYY"]

{"sheet":"Stat Paternity Adoption","index":26,"n_rows":5,"n_cols":10,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Character","Character","Character","Date","Date","Logic","Date","Date","Date","Character"]
[8,35,35,"DD/MM/YYYY","DD/MM/YYYY","TRUE/FALSE","DD/MM/YYYY","DD/MM/YYYY","DD/MM/YYYY"]
["Employee ID","Surname","Forename","SC4 Date","Child Expected Date","Work up to Placement","Actual Placed Date","Leave Start","Leave End","Notes"]
["00000001",null,null,"DD/MM/YYYY","DD/MM/YYYY",true,"DD/MM/YYYY","DD/MM/YYYY","DD/MM/YYYY"]
[null,null,null,null,null,false]

{"sheet":"Stat Paternity Birth","index":27,"n_rows":5,"n_cols":10,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Character","Character","Character","Date","Date","Date","Logic","Date","Date","Character"]
[8,35,35,"DD/MM/YYYY","DD/MM/YYYY","DD/MM/YYYY","TRUE/FALSE","DD/MM/YYYY","DD/MM/YYYY"]
["Employee ID","Surname","Forename","SC3 Date","SC3 Received","Actual Date of Birth","Still Birth","Leave Start","Leave End","Notes"]
["00000001",null,null,"DD/MM/YYYY","DD/MM/YYYY","DD/MM/YYYY",true,"DD/MM/YYYY","DD/MM/YYYY"]
[null,null,null,null,null,null,false]

{"sheet":"Stat Shared Par Leave Adopt","index":28,"n_rows":6,"n_cols":30,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Character","Character","Character","Character","Date","Date","Integer","Integer","Integer","Date","Date","Character","Character","Character","Character","Character","Character","Character","Character","Logic","Character","Character","Character","Character","Character","Character","Logic","Logic","Date","Character"]
[8,35,35,13,"DD/MM/YYYY","DD/MM/YYYY",null,null,null,"DD/MM/YYYY","DD/MM/YYYY",30,30,30,30,30,30,8,9,"TRUE/FALSE",30,30,30,30,30,8,"TRUE/FALSE","TRUE/FALSE","DD/MM/YYYY"]
["Employee ID","Surname","Forename","Main Other Adopter","Placement Date","SAP Curtailment Date","SAP Weeks Paid","ShPP Weeks Employee","ShPP Weeks Partner","Intended ShPL Start Date","Intended ShPL End Date","Partner Forename","Partner Surname","Partner Address 1","Partner Address 2","Partner Address 3","Partner Address 4","Partner Postcode","Partner NI Number","No NI Number Declaration","Partner Employer Name","Partner Employer Address 1","Partner Employer Address 2","Partner Employer Address 3","Partner Employer Address 4","Partner Employer Postcode","Declaration from Employee","Declaration from Other Adopter","Date Notification Received","Notes"]
["00000001",null,null,"Main Adopter","DD/MM/YYYY","DD/MM/YYYY",null,null,null,"DD/MM/YYYY","DD/MM/YYYY",null,null,null,null,null,null,null,"AA999999A",true,null,null,null,null,null,null,true,true,"DD/MM/YYYY"]
[null,null,null,"Other Adopter",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,null,null,null,null,false,false]
["Import Definition will need to be created with columns you require"]

{"sheet":"ShPL Adopt Leave Request","index":29,"n_rows":6,"n_cols":11,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Character","Character","Character","Date","Date","Date","Date","Logic","Logic","Logic","Character"]
[8,35,35,"DD/MM/YYYY","DD/MM/YYYY","DD/MM/YYYY","DD/MM/YYYY","TRUE/FALSE","TRUE/FALSE","TRUE/FALSE"]
["Employee ID","Surname","Forename","SAP Curtailment Date","Date of Request","Date Requested From","Date Requested To","Binding Request","Consent from Other Adopter","Request Cancelled","Notes"]
["00000001",null,null,"DD/MM/YYYY","DD/MM/YYYY","DD/MM/YYYY","DD/MM/YYYY",true,true,true]
[null,null,null,null,null,null,null,false,false,false]
["Import Definition will need to be created with columns you require"]

{"sheet":"ShPL Adopt SPLIT Days","index":30,"n_rows":5,"n_cols":8,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Character","Character","Character","Date","Date","Date","Character","Character"]
[8,35,35,"DD/MM/YYYY","DD/MM/YYYY","DD/MM/YYYY",30]
["Employee ID","Surname","Forename","SAP Curtailment Date","Start Date","End Date","Reason","Notes"]
["00000001",null,null,"DD/MM/YYYY","DD/MM/YYYY","DD/MM/YYYY"]
["Import Definition will need to be created with columns you require"]

{"sheet":"Stat Shared Par Leave Birth","index":31,"n_rows":6,"n_cols":32,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Character","Character","Character","Character","Date","Date","Date","Integer","Integer","Integer","Date","Date","Character","Character","Character","Character","Character","Character","Character","Character","Logic","Character","Character","Character","Character","Character","Character","Character","Logic","Logic","Date","Character"]
[8,35,35,14,"DD/MM/YYYY","DD/MM/YYYY","DD/MM/YYYY",null,null,null,"DD/MM/YYYY","DD/MM/YYYY",30,30,30,30,30,30,8,9,"TRUE/FALSE",30,30,30,30,30,8,30,"TRUE/FALSE","TRUE/FALSE","DD/MM/YYYY"]
["Employee ID","Surname","Forename","Mother Father Partner","Expected Birth Date","Actual Birth Date","SMP Curtailment Date","SMP Weeks Paid","ShPP Weeks Employee","ShPP Weeks Partner","Intended ShPL Start Date","Intended ShPL End Date","Partner Forename","Partner Surname","Partner Address 1","Partner Address 2","Partner Address 3","Partner Address 4","Partner Postcode","Partner NI Number","No NI Number Declaration","Partner Employer Name","Partner Employer Address 1","Partner Employer Address 2","Partner Employer Address 3","Partner Employer Address 4","Partner Employer Postcode","Location of Birth","Declaration from Employee","Declaration from Other Parent","Date Notification Received","Notes"]
["00000001",null,null,"Mother","DD/MM/YYYY","DD/MM/YYYY","DD/MM/YYYY",null,null,null,"DD/MM/YYYY","DD/MM/YYYY",null,null,null,null,null,null,null,"AA999999A",true,null,null,null,null,null,null,null,true,true,"DD/MM/YYYY"]
[null,null,null,"Father/Partner",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,null,null,null,null,null,false,false]
["Import Definition will need to be created with columns you require"]

{"sheet":"ShPL Birth Leave Request","index":32,"n_rows":6,"n_cols":11,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Character","Character","Character","Date","Date","Date","Date","Logic","Logic","Logic","Character"]
[8,35,35,"DD/MM/YYYY","DD/MM/YYYY","DD/MM/YYYY","DD/MM/YYYY","TRUE/FALSE","TRUE/FALSE","TRUE/FALSE"]
["Employee ID","Surname","Forename","SMP Curtailment Date","Date of Request","Date Requested From","Date Requested To","Binding Request","Consent from Other Parent","Request Cancelled","Notes"]
["00000001",null,null,"DD/MM/YYYY","DD/MM/YYYY","DD/MM/YYYY","DD/MM/YYYY",true,true,true]
[null,null,null,null,null,null,null,false,false,false]
["Import Definition will need to be created with columns you require"]

{"sheet":"ShPL Birth SPLIT Days","index":33,"n_rows":5,"n_cols":8,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Character","Character","Character","Date","Date","Date","Character","Character"]
[8,35,35,"DD/MM/YYYY","DD/MM/YYYY","DD/MM/YYYY",30]
["Employee ID","Surname","Forename","SMP Curtailment Date","Start Date","End Date","Reason","Notes"]
["00000001",null,null,"DD/MM/YYYY","DD/MM/YYYY","DD/MM/YYYY"]
["Import Definition will need to be created with columns you require"]

{"sheet":"Training Courses (Bookings)","index":34,"n_rows":5,"n_cols":45,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Character","Character","Character","Character","Character","Character","Character","Character","Date","Character","Date","Character","Numeric","Date","Character","Character","Character","Character","Logic","Date","Date","Logic","Character","Numeric","Date","Date","Date","Date","Date","Character","Numeric","Date","Numeric","Logic","Numeric","Numeric","Character","Integer","Integer","Integer","Integer","Integer","Integer","Logic","Character"]
[8,35,35,40,250,40,8,100,"DD/MM/YYYY",5,"DD/MM/YYYY",5,"6,2","DD/MM/YYYY",11,2,20,4,"TRUE/FALSE","DD/MM/YYYY","DD/MM/YYYY","TRUE/FALSE",30,"4,2","DD/MM/YYYY","DD/MM/YYYY","DD/MM/YYYY","DD/MM/YYYY","DD/MM/YYYY",20,"9,2","DD/MM/YYYY","9,2","TRUE/FALSE","9,2","9,2",3,null,null,null,null,null,null,"TRUE/FALSE"]
["Employee ID","Surname","Forename","Course Title","Event Title","Event Reference","Course Type","Course Group","Start Date","Start Time","End Date","End Time","Actual Hours","Date Booked","Booking ID","Booking Status","Status Description","Result","Did Not Attend","Valid From","Valid To","CPD Accredited","CPD Type","CPD Hours","Provisional Booking Sent","Invoice Sent","Payment Received","Joining Instructions Sent","Cancellation Date","Cancellation Reason","Cancellation Fee","Cancellation Charge Sent","Course Cost","Override Course Cost","Travel Costs","Other Expenses","Currency","Standard of Presentation","Effectiveness of Speakers","Course Content","Administration","Venue","Relevance to Job","Recommended","Notes"]
["00000001",null,null,null,null,null,null,null,"DD/MM/YYYY","99:99","DD/MM/YYYY","99:99",null,"DD/MM/YYYY",null,"B","Booked","Pass",true,"DD/MM/YYYY","DD/MM/YYYY",true,null,null,"DD/MM/YYYY","DD/MM/YYYY","DD/MM/YYYY","DD/MM/YYYY","DD/MM/YYYY",null,null,"DD/MM/YYYY",null,true,null,null,null,null,null,null,null,null,null,true]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"Attended"]

{"sheet":"Training Needs","index":35,"n_rows":4,"n_cols":7,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Character","Character","Character","Character","Date","Date","Character"]
[8,35,35,40,"DD/MM/YYYY","DD/MM/YYYY"]
["Employee ID","Surname","Forename","Course Title","Date Identified","Required By","Notes"]
["00000001",null,null,null,"DD/MM/YYYY","DD/MM/YYYY"]

{"sheet":"Training Sponsorship","index":36,"n_rows":5,"n_cols":31,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Character","Character","Character","Numeric","Character","Character","Character","Character","Character","Date","Date","Date","Character","Character","Date","Date","Character","Numeric","Numeric","Logic","Numeric","Logic","Numeric","Logic","Numeric","Logic","Numeric","Logic","Logic","Character","Character"]
[8,35,35,"4,0",40,20,40,60,20,"DD/MM/YYYY","DD/MM/YYYY","DD/MM/YYYY",15,30,"DD/MM/YYYY","DD/MM/YYYY",15,"5,1","9,2","TRUE/FALSE","9,2","TRUE/FALSE","9,2","TRUE/FALSE","9,2","TRUE/FALSE","9,2","TRUE/FALSE","TRUE/FALSE"]
["Employee ID","Surname","Forename","Academic Year","Course Title","Course Type","Educational Institute","Professional Body","Study Method","Date Started","Date Due to Finish","Actual Date Finished","Duration of Course","Approved By","Date Approved","Agreement Signed","Tie In Period","Approved Study Days","Course Costs","Course Costs Paid","Exam Costs","Exam Costs Paid","Material Costs","Material Costs Paid","Other Costs","Other Costs Paid","Maintenance Grant","Maintenance Grant Paid","Deposit Reimbursed","Results","Notes"]
["00000001",null,null,null,null,null,null,null,null,"DD/MM/YYYY","DD/MM/YYYY","DD/MM/YYYY",null,null,"DD/MM/YYYY","DD/MM/YYYY",null,null,null,true,null,true,null,true,null,true,null,true,true]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,false,null,false,null,false,null,false,false]

{"sheet":"Training Unavailability","index":37,"n_rows":5,"n_cols":7,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Character","Character","Character","Date","Date","Character","Character"]
[8,35,35,"DD/MM/YYYY","DD/MM/YYYY",7]
["Employee ID","Surname","Forename","Date From","Date To","Notification","Notes"]
["00000001",null,null,"DD/MM/YYYY","DD/MM/YYYY","Error"]
[null,null,null,null,null,"Warning"]

{"sheet":"Vehicle Allocations","index":38,"n_rows":4,"n_cols":13,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Character","Character","Character","Character","Date","Date","Character","Date","Date","Character","Date","Date","Character"]
[8,35,35,10,"DD/MM/YYYY","DD/MM/YYYY",20,"DD/MM/YYYY","DD/MM/YYYY",20,"DD/MM/YYYY","DD/MM/YYYY"]
["Employee ID","Surname","Forename","Registration Number","Date of Issue","Date of Return","Fuel Card Number","Fuel Card Expiry Date","Fuel Card Date Ordered","Fuel Card Order Reference","Fuel Card Date Sent to Driver","Fuel Card Date Returned","Notes"]
["00000001",null,null,null,"DD/MM/YYYY","DD/MM/YYYY",null,"DD/MM/YYYY","DD/MM/YYYY",null,"DD/MM/YYYY","DD/MM/YYYY"]