{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Welcome","Validation Format Example","Personnel Record 1st Import","Personnel Records 2nd Import","Personnel Records 3rd Import","Employment","Address","Absence","Emergency Contacts","Working Patterns","Leave Transactions","Employee Login Information"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":10,"comments":10,"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":"Personnel Record 1st Import","index":2,"n_rows":5,"n_cols":39,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Character","Character","Character","Character","Character","Date","Date","Date","Integer","Character","Logic","Date","Integer","Character","Date","Character","Character","Character","Numeric","Character","Date","Character","Logic","Character","Character","Logic","Numeric","Character","Character","Character","Character","Character","Character","Character","Character","Character","Character","Character","Logic"]
["8",35,35,10,35,"DD/MM/YYYY"," DD/MM/YYYY"," DD/MM/YYYY",999,6,"TRUE/FALSE"," DD/MM/YYYY",999,6," DD/MM/YYYY",40,8,40,"4,2",20," DD/MM/YYYY",9,"TRUE/FALSE",20,5,"TRUE/FALSE","5,2",30,6,9,6,40,8,18,8,40,18,8000,"TRUE/FALSE"]
["Employee ID","Surname","Forename","Title","Known As","Date of Birth","Start Date","Continuous Service Date","Probation Period","Probation In","Probation Extended","Probation End","Notice Period","Notice In","Leaving Date","Leaving Reason","Line Manager Employee ID","Line Manager Name","Standard Hours","Contract Type","Contract End Date","Full Part Time","Force Restriction","Shift","Absence In","Override Entitlement","Leave Entitlement","Payroll Company","Payment Method","NI Number","Gender","Bank Name 1","Bank Sort Code 1","Bank Account Name 1","Bank Account Number 1","BSociety Name 1","BSociety Roll Number 1","Notes","Imported during implementation"]
["00000001",null,null,null,null,"DD/MM/YYYY","DD/MM/YYYY","DD/MM/YYYY",null,"Weeks",true,"DD/MM/YYYY",null,"Weeks","DD/MM/YYYY",null,null,null,null,null,"DD/MM/YYYY","Full Time",true,null,"Days",true,null,null,null,"AA999999A","Male",null,"99-99-99",null,null,null,null,null,true]
[null,null,null,null,null,null,null,null,null,"Months",false,null,null,"Months",null,null,null,null,null,null,null,"Part Time",false,null,"Hours",false,null,null,null,null,"Female"]

{"sheet":"Personnel Records 2nd Import","index":3,"n_rows":24,"n_cols":40,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["Character","Character","Character","Character","Character","Character","Character","Character","Character","Character","Numeric","Character","Character","Character","Character","Character","Character","Character","Logic","Character","Logic","Date","Logic","Date","Logic","Logic","Character","Date","Logic","Date","Logic","Character","Date","Logic","Logic","Character","Date","Date","Character","Logic"]
["8",35,35,40,40,20,20,250,20,20,"4,1",8,40,1,30,60,40,15,"TRUE/FALSE",8000,"TRUE/FALCE"," DD/MM/YYYY","TRUE/FALSE"," DD/MM/YYYY","TRUE/FALSE","TRUE/FALSE",35," DD/MM/YYYY","TRUE/FALSE"," DD/MM/YYYY","TRUE/FALSE",30," DD/MM/YYYY","TRUE/FALSE","TRUE/FALSE",18," DD/MM/YYYY"," DD/MM/YYYY",20,"TRUE/FALSE"]
["Employee ID","Surname","Forename","Marital Status","Nationality","Home Telephone","Personal Mobile","Email Home","Work Telephone","Work Mobile","Sickness Entitlement","Alternative Approver Employee ID","Alernative Approver Name","Ethnic Group","Ethnic Group Description","Ethnic Origin","Religion","Sexual Orientation","Disabled","Special Requirements","First Aider","First Aid Certificate Date","Fire Warden","Fire Warden Certificate Date","Driving Licence Required","Driving Licence Seen","Passport Number","Passport Expiry Date","Work Permit Required","Work Permit Expiry Date","Visa Required","Visa Type","Visa Expiry Date","Right to Work in UK","DBS Check Required","DBS Check Type","DBS Date Requested","DBS Date Issued","DBS Disclosure Number","DBS Certificate Available On Line"]
["00000001",null,null,null,null,null,null,null,null,null,null,null,null,"A","White","English, Welsh, Scottish, Northern Irish or British","Agnostic",null,true,null,true,"DD/MM/YYYY",true,"DD/MM/YYYY",true,true,null,"DD/MM/YYYY",true,"DD/MM/YYYY",true,null,"DD/MM/YYYY",true,true,"Standard","DD/MM/YYYY","DD/MM/YYYY",null,true]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"A","White","Any other White background","Atheist",null,false,null,false,null,false,null,false,false,null,null,false,null,false,null,null,false,false,"Enhanced",null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"A","White","Gypsy or Irish Traveller","Bah'ai",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enhanced with List"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"A","White","Irish","Buddist"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"A","White","Roma","Christian - Catholic"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"B","Black, Black British, Caribbean or African","African","Christian - Protestant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"B","Black, Black British, Caribbean or African","Any other Black, Black British, or Caribbean background","Christian - Other"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"B","Black, Black British, Caribbean or African","Caribbean","Hindu"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"C","Asian or Asian British","Any other Asian background","Humanism"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"C","Asian or Asian British","Bangladeshi","Jain"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"C","Asian or Asian British","Chinese","Jewish"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"C","Asian or Asian British","Indian","Muslim"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"C","Asian or Asian British","Pakistani","Pagan"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"D","Mixed or multiple ethnic groups","Any other Mixed or multiple ethnic background","Rastafarian"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"D","Mixed or multiple ethnic groups","White and Asian","Scientology"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"D","Mixed or multiple ethnic groups","White and Black African","Shinto"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"D","Mixed or multiple ethnic groups","White and Black Caribbean","Sikh"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"E","Other ethnic group","Arab","Zoroastrian"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"E","Other ethnic group","Other ethnic group            ","No religion or belief"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Prefer not to say"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Any other religion or belief"]

{"sheet":"Personnel Records 3rd Import","index":4,"n_rows":5,"n_cols":33,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Character","Character","Character","Character","Logic","Character","Character","Date","Character","Character","Character","Logic","Logic","Date","Character","Logic","Date","Logic","Character","Date","Character","Character","Character","Character","Character","Character","Numeric","Character","Logic","Character","Date","Date","Character"]
["8",35,35,35,"TRUE/FALSE",20,250," DD/MM/YYYY",5,40,200,"TRUE/FALSE","TRUE/FALSE"," DD/MM/YYYY",3,"TRUE/FALSE"," DD/MM/YYYY","TRUE/FALSE",29," DD/MM/YYYY",40,8,30,8,40,18,"9,2",1,"TRUE/FALSE",20," DD/MM/YYYY"," DD/MM/YYYY",8000]
["Employee ID","Surname","Forename","Previous Name","Date of Birth Verified","Place of Birth","Email Group","Exit Interview Date","Exit Interview Time","Exit Interview With","Exit Interview Notes","Irregular Payment Indicator","Apprentice","Apprentice Start Date","PAE Scheme","PAE Worker Postponement Applies","PAE Worker Postponement End Date","PAE EJ Postponement Applies","PAE Postponement Notice Type","Pension Eligible","Bank Name 2","Bank Sort Code 2","Bank Account Name 2","Bank Account Number 2","BSociety Name 2","BSociety Roll Number 2","Bank 2 Value","Bank 2 Amount Percentage","CPD Applicable","Solicitor Roll Number","Solicitor Date Admitted","CPD Date From","CPD Notes"]
["00000001",null,null,null,true,null,null,"DD/MM/YYYY","99:99",null,null,true,true," DD/MM/YYYY",null,true," DD/MM/YYYY",true,null," DD/MM/YYYY",null,"99-99-99",null,null,null,null,null,"A",true,null,"DD/MM/YYYY","DD/MM/YYYY"]
[null,null,null,null,false,null,null,null,null,null,null,false,false,null,null,false,null,false,null,null,null,null,null,null,null,null,null,"P",false]

{"sheet":"Employment","index":5,"n_rows":19,"n_cols":24,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Character","Character","Character","Date","Date","Character","Character","Character","Character","Character","Character","Character","Numeric","Numeric","Character","Character","Logic","Character","Character","Character","Character","Character","Character","Numeric"]
[8,35,35,"DD/MM/YYYY","DD/MM/YYYY",25,40,40,40,15,40,6,"4,2","9,2",6,3,"TRUE/FALSE",11,3,3,8000,50,null,"6,4"]
["Employee ID","Surname","Forename","Start Date","End Date","Change Reason","Division","Department","Location","Cost Centre","Job Title","Grade","Hours Per Day","Salary Amount","Pay Type","Currency","Do Not Send to Payroll","Payment Frequency","OMP Scheme","OSP Scheme","Notes","Leave Entitlement Policy","Leave Year","FTE used for pro ration"]
["00000001",null,null,"DD/MM/YYYY","DD/MM/YYYY",null,null,null,null,null,null,null,null,null,"Annual",null,true,"Weekly"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hourly",null,false,"2-Weekly"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4-Weekly"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Monthly"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Quarterly"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Half Yearly"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yearly"]
[]
[]
[]
[]
[]
[]
[]
[]
[" "]

{"sheet":"Address","index":6,"n_rows":7,"n_cols":15,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Character","Character","Character","Character","Logic","Date","Date","Character","Character","Character","Character","Character","Character","Character","Character"]
[8,35,35,15,"TRUE/FALSE","DD/MM/YYYY","DD/MM/YYYY",30,30,30,30,20,8,45]
["Employment ID","Surname","Forename","Type","Primary Address","Date From","Date To","Address 1","Address 2","Address 3","Town","County","Postcode","Country","Notes"]
["00000001",null,null,"Home",true,"DD/MM/YYYY","DD/MM/YYYY"]
[null,null,null,"Tempoary",false]
[null,null,null,"Term-Time"]
[null,null,null,"Working"]

{"sheet":"Absence","index":7,"n_rows":5,"n_cols":19,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Character","Character","Character","Character","Character","Date","Character","Numeric","Logic","Date","Character","Numeric","Numeric","Numeric","Logic","Character","Integer","Logic","Character"]
[8,35,35,40,40,"DD/MM/YYYY",2,"4,2","TRUE/FALSE","DD/MM/YYYY",2,"4,2","5,2","4,1","TRUE/FALSE",1,null,"TRUE/FALSE"]
["Employee ID","Surname","Forename","Absence Type","Reason","Start Date","Start Session","Hours taken on first day","Continuous Absence","End Date","End Session","Hours taken on final day","Duration Hours","Duration Days","Override Absence Duration","Certificate","Child Number","Do not send to payroll","Notes"]
["00000001",null,null,null,null,"DD/MM/YYYY","AM",null,true,"DD/MM/YYYY","PM",null,null,null,true,"D",null,true]
[null,null,null,null,null,null,null,null,false,null,null,null,null,null,false,"S",null,false]

{"sheet":"Emergency Contacts","index":8,"n_rows":4,"n_cols":14,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Character","Character","Character","Character","Character","Character","Character","Character","Character","Character","Character","Character","Character","Character"]
[8,35,35,20,20,35,35,10,20,20,20,20,250]
["Employee ID","Surname","Forename","Contact Type","Relationship","Forenames","Surname","Title","Home Telephone","Personal Mobile","Work Telephone","Work Mobile","Email","Notes"]
["00000001"]

{"sheet":"Working Patterns","index":9,"n_rows":8,"n_cols":14,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Character","Character","Character","Date","Character","Character","Numeric","Numeric","Numeric","Numeric","Numeric","Numeric","Numeric","Character"]
[8,35,35,"DD/MM/YYYY",14,15,"4,2","4,2","4,2","4,2","4,2","4,2","4,2"]
["Employee ID","Surname","Forename","Effective Date","Working Pattern","Regional ID","Sunday Hours","Monday Hours","Tuesday Hours","Wednesday Hours","Thursday Hours","Friday Hours","Saturday Hours","Notes"]
["00000001",null,null,"DD/MM/YYYY","SSMMTTWWTTFFSS","England"]
[null,null,null,null,"  MMTTWWTTFF","N. Ireland"]
[null,null,null,null,"  MM  WW  FF","No Bank Hols"]
[null,null,null,null,null,"Rep of Ireland"]
[null,null,null,null,null,"Scotland"]

{"sheet":"Leave Transactions","index":10,"n_rows":6,"n_cols":11,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Character","Character","Character","Character","Numeric","Character","Date","Date","Date","Logic","Numeric"]
[8,35,35,15,"5,2",14," DD/MM/YYYY"," DD/MM/YYYY"," DD/MM/YYYY","TRUE/FALSE","5,2"]
["Employee ID","Surname","Forename","Transaction Type","Transaction Value","Transaction Origin","Date Effective","Date Authorised","Use by Date","Use by Date Override","Amount Used by Used by Date"]
["00000001",null,null,"Purchased",null,"Manually Input"]
[null,null,null,"Sold"]
[null,null,null,"Brought Forward"]

{"sheet":"Employee Login Information","index":11,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Character","Character","Character","Character","Character","Character"]
[8,35,35,14,250,250]
["Employee ID","Surname","Forename","User Group","Work Email","Employee Login"]
["00000001",null,null,"Employees"]
[null,null,null,"Managers"]
[null,null,null,"HR Advisors"]
[null,null,null,"HR Managers"]
[null,null,null,"Administrators"]