{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Validation","Summary","ValidLists","Report","ErrorMessages"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":119,"comments":0,"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":"Validation","index":0,"n_rows":24,"n_cols":2,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"DoLS Data Return Validation Tool v1.0"]
[null,"This version is for 2024-25 DoLS Data return only"]
[null,"Please use this tool to validate the DoLS data return (2024-25 Data template) prior to submission to NHS England."]
[null,"NHS England's data processing may reveal further issues that require investigation."]
[null,"Please ensure that prior to running the tool, your return is saved with your LA code first followed by _DoLS_2025"]
[null,"Click the 'Run' button below to validate a DoLS Data Return File."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Please do not delete any sheets from this workbook"]

{"sheet":"Summary","index":1,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[null,"Validation Summary Report - DoLS Data Return"]
[null,"Validation Summary Report for file 'Deprivation_of_Liberty_Safeguards_Return_Data_Template_2023-24_v1.2.xlsx'. Validation commenced on 19/10/2023 13:30:51"]
[null,"The Total number of records on the selected DoLS data return file is: 0"]
[null,"The DoLS Data File selected has passed the Validation."]

{"sheet":"ValidLists","index":2,"n_rows":154,"n_cols":6,"rows_kept":154,"cut":false,"hidden":true,"merged":[]}
["Lacode","Laname",null,null,"Column Ref","Column Name"]
["104","Northumberland",null,null,"B","Person_Reference"]
["106","Gateshead",null,null,"C","LA_Code"]
["107","Newcastle Upon Tyne",null,null,"D","CQC Location Code"]
["108","North Tyneside",null,null,"E","Date application received"]
["109","South Tyneside",null,null,"F","Urgent included"]
["110","Sunderland",null,null,"H","Age Requirement"]
["111","Hartlepool",null,null,"I","Mental Health Requirement"]
["112","Middlesbrough",null,null,"J","Mental Capacity Requirement "]
["113","Redcar & Cleveland ",null,null,"K","No Refusals Requirement"]
["114","Stockton-on-Tees",null,null,"L","Eligibility Requirement"]
["116","Durham",null,null,"M","Best Interests Requirement"]
["117","Darlington ",null,null,"N","Date of last assessment"]
["204","Barnsley",null,null,"O","Application sign off date"]
["205","Doncaster",null,null,"P","Application Status"]
["206","Rotherham",null,null,"Q","Reason Not Granted "]
["207","Sheffield",null,null,"R","DoLS not granted but BIA advises DoL occurring"]
["209","Bradford",null,null,"S","Start Date of Authorisation"]
["210","Calderdale",null,null,"T","Number of reviews"]
["211","Kirklees",null,null,"U","Outcome of latest review"]
["212","Leeds",null,null,"V","Planned end date"]
["213","Wakefield",null,null,"W","Actual end date"]
["214","East Riding of Yorkshire",null,null,"AA","Age"]
["215","Kingston Upon Hull",null,null,"AB","Gender"]
["216","North East Lincolnshire",null,null,"AC","Ethnic Origin"]
["217","North Lincolnshire",null,null,"AD","Sexual Orientation"]
["218","North Yorkshire",null,null,"AE","Disability"]
["219","York "]
["304","Bolton"]
["305","Bury"]
["306","Manchester"]
["307","Oldham"]
["308","Rochdale"]
["309","Salford"]
["310","Stockport"]
["311","Tameside"]
["312","Trafford"]
["313","Wigan"]
["315","Knowsley"]
["316","Liverpool"]
["317","Sefton"]
["318","St Helens"]
["319","Wirral"]
["321","Halton"]
["322","Warrington "]
["323","Lancashire"]
["324","Blackburn With Darwen "]
["325","Blackpool"]
["326","Cheshire East"]
["327","Cheshire West And Chester"]
["404","Warwickshire"]
["406","Birmingham"]
["407","Coventry"]
["408","Dudley"]
["409","Sandwell"]
["410","Solihull"]
["411","Walsall"]
["412","Wolverhampton"]
["413","Staffordshire"]
["414","Stoke-on-Trent"]
["415","Herefordshire "]
["416","Worcestershire"]
["417","Shropshire"]
["418","Telford & Wrekin"]
["503","Lincolnshire"]
["506","Derbyshire"]
["507","Derby "]
["508","Leicestershire"]
["509","Leicester "]
["510","Rutland"]
["511","Nottinghamshire"]
["512","Nottingham"]
["606","Hertfordshire"]
["607","Norfolk"]
["608","Oxfordshire"]
["609","Suffolk"]
["611","Luton"]
["613","Milton Keynes "]
["614","Bracknell Forest"]
["615","West Berkshire"]
["616","Reading"]
["617","Slough"]
["618","Windsor & Maidenhead "]
["619","Wokingham "]
["620","Essex"]
["621","Southend"]
["622","Thurrock "]
["623","Cambridgeshire"]
["624","Peterborough "]
["625","Bedford Borough"]
["626","Central Bedfordshire"]
["702","Camden"]
["703","Greenwich"]
["704","Hackney"]
["705","Hammersmith & Fulham"]
["706","Islington"]
["707","Kensington & Chelsea"]
["708","Lambeth"]
["709","Lewisham"]
["710","Southwark"]
["711","Tower Hamlets"]
["712","Wandsworth"]
["713","Westminster"]
["714","City of London"]
["716","Barking and Dagenham"]
["717","Barnet"]
["718","Bexley"]
["719","Brent"]
["720","Bromley"]
["721","Croydon"]
["722","Ealing"]
["723","Enfield"]
["724","Haringey"]
["725","Harrow"]
["726","Havering"]
["727","Hillingdon"]
["728","Hounslow"]
["729","Kingston Upon Thames"]
["730","Merton"]
["731","Newham"]
["732","Redbridge"]
["733","Richmond Upon Thames"]
["734","Sutton"]
["735","Waltham Forest"]
[738,"Bournemouth, Christchurch & Poole"]
["803","Isle of Wight"]
["805","Surrey"]
["807","West Sussex"]
["809","Dorset"]
["812","Hampshire"]
["813","Portsmouth"]
["814","Southampton"]
["815","East Sussex"]
["816","Brighton & Hove"]
["817","Wiltshire"]
["819","Swindon "]
["820","Kent"]
["821","Medway Towns"]
["902","Cornwall"]
["904","Gloucestershire"]
["905","Somerset"]
["906","Isles Of Scilly"]
["908","Bath & North East Somerset"]
["909","Bristol "]
["910","North Somerset"]
["911","South Gloucestershire"]
["912","Devon"]
["913","Plymouth "]
["914","Torbay "]
[916,"Buckinghamshire"]
["U6Q5Z","West Northamptonshire"]
["Z9D4Z","North Northamptonshire"]
["H6X4G","Cumberland"]
["W8X1Q","Westmorland and Furness"]

{"sheet":"Report","index":3,"n_rows":2,"n_cols":6,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[null,"Validation Report for the Local Authority:  ()"]
["Row Number","Person Reference id","Column with invalid Entry","Value Entered","Error Message","Error Reference"]

{"sheet":"ErrorMessages","index":4,"n_rows":124,"n_cols":3,"rows_kept":124,"cut":false,"hidden":true,"merged":[]}
["ErrRef","ErrCode","ErrMessage"]
[1,"BLNK","This field cannot be left blank. Please enter a valid value"]
[2,"BLNK2","Blank Rows"]
[3,"C1","Please check that your file name begins with your LA code and that all your records have the same LA code"]
[4,"TOTAL","Total number of records on the selected DoLS data file"]
[5,"E1","Date Application Received entered is not valid. It should be a valid date in the format dd-mm-yyyy"]
[6,"E2","Date Application Received entered is not within the expected range 01-01-2015 and 31-03-2025. Please ignore this error if the application had been received at an earlier date"]
[7,"F1","Urgent Included entered is not valid. It should be 0 or 1"]
[8]
[9]
[10,"H1","Age Requirement entered is not valid. It should be  0, 1, 2 or 3"]
[11,"H2","Age Requirement entered is not valid. It should be 1 or 3 when Application Status = 1"]
[12,"I1","Mental Health Requirement entered is not valid. It should be 0, 1, 2 or 3"]
[13,"I2","Mental Health Requirement entered is not valid. It should be 1 or 3 when Application Status' = 1"]
[14,"J1","Mental Capacity Requirement entered is not valid. It should be 0, 1, 2 or 3"]
[15,"J2","Mental Capacity Requirement entered is not valid. It should be 1 or 3 when Application Status = 1"]
[16,"K1","No Refusals Requirement entered is not valid. It should be 0, 1, 2 or 3"]
[17,"K2","No Refusals Requirement entered is not valid. It should be 1 or 3 when Application Status = 1"]
[18,"L1","Eligibility Requirement entered is not valid. It should be 0, 1, 2 or 3"]
[19,"L2","Eligibility Requirement entered is not valid. It should be 1 or 3 when Application Status = 1"]
[20,"M1","Best Interests Requirement entered is not valid. It should be 0, 1, 2 or 3"]
[21,"M2","Best Interests Requirement entered is not valid. It should be 1 or 3 when Application Status = 1"]
[22,"N1","Date Of Last Assessment should record the date of the most recent assessment in the format dd-mm-yyyy, where at least one assessment has been completed"]
[23,"N2","Date Of Last Assessment is not within the expected range 01-01-2020 and todays date. Please ignore this error if the latest assessment took place at an earlier date."]
[24,"N3","Date Of Last Assessment should be blank where none of the assessments have been completed (ie. All of columns G-L = 0)"]
[25,"O1","Application Sign Off Date entered is not valid. It should be a valid date in the format dd-mm-yyyy or blank if the application has not been signed off"]
[26,"O2","Application Sign Off Date entered is not within the expected range 01-01-2021 and todays date. Please correct if this is an error."]
[27,"O3","Application Sign Off Date entered is not valid. It should be blank where Application Status is 3 (Not Yet Signed Off)"]
[28,"O4","Application Sign Off Date should not be blank where Application Status is 1 (Granted) or 0 (Not Granted). Please record the date when application was signed off as granted or not granted"]
[29,"O5","Application Sign Off Date entered is not valid. It should be on or after Date Application Received"]
[30,"P1","Application Status entered is not valid. It should be 0, 1 or 3"]
[31,"P2","Application Status should not be 1 (Granted) where all six assessments are not either 1 or 3. Application can be granted only when all 6 six assessments are satisfied (G-L: 1 or 3)"]
[32,"P3","Application Status should be 0 (Not Granted) where application is signed off (Application Sign Off Date is populated with a date) & at least one of the six assessment criteria was not satisfied"]
[33,"Q1","Reason Not Granted entered is not valid. It should be 1, 2, 3, 4 or 9"]
[34,"Q2","Reason Not Granted should record the reason for not granting the application where Application Status = 0. It should be entered as 1, 2, 3 or 4"]
[35,"Q3","Reason Not Granted entered is not valid. It should be 9 when Application Status = 1 (Granted) or 3 (Not Yet Signed Off)"]
[36,"R1","DoLS Not Granted But BIA advises DoL occurring entered is not valid. It should be either 0, 1 or 9"]
[37,"R2","DoLS Not Granted But BIA advises DoL occurring entered is not valid. It should be 9 where the Application Status = 1 or 3"]
[38,"R3","DoLS Not Granted But BIA advises DoL occurring should be entered as 9 where Application Status = 0 and Best Interests Requirement = 0"]
[39,"R4","DoLS Not Granted But BIA advises DoL occurring should not be 9 where Application Status = 0 and Best Interests Requirement = 1, 2 or 3. It should be either 1 or 0 based on the conclusion made by the BI Assessor"]
[40,"T1","Number of Reviews entered is not valid. This should record the number of reviews (0 or above) where the Application Status is 1"]
[41,"T2","Number of Reviews entered is not valid. It should be blank where Application Status is not 1"]
[42,"T3","Number of Reviews entered is not valid. It should be a whole number greater than or equal to 0 where Application Status is 1"]
[43,"U1","Outcome of Most Recent Review entered is not valid. It should be between 0 and 9"]
[44,"U2","Outcome of Most Recent Review entered is not valid. It should be 9 where the Application Status is not 1"]
[45,"U3","Outcome of Most Recent Review entered is not valid. It should be 0 to 8 where the Application Status is 1"]
[46,"U4","Outcome of Most Recent Review entered is not valid. It should not be 0 or 9 where Number of Reviews is greater than 0. It should be 1 to 8 based on the outcome of the most recent review."]
[47,"V1","Planned End Date entered is not valid. It should be a valid date in the format dd-mm-yyyy where Application Status = 1"]
[48,"V2","Planned End Date entered is not within the expected range 01-01-2023 and 31-03-2026. Please correct if this is an error."]
[49,"V3","Planned End Date entered is not valid. It should be blank where Application Status is not 1"]
[50,"V4","Planned End Date entered is not valid. It should not be blank where Application Status is 1"]
[51,"V5","Planned End Date entered is not valid. It should be on or after Start Date of Authorisation where Application Status is 1"]
[52,"W1","Actual End Date entered is not valid. It should be a valid date in the format dd-mm-yyyy or blank if not applicable"]
[53,"W2","Actual End Date, where a date is entered, should be between 01-04-2023 and 31-03-2025. Please leave this blank if the DoLS had not ended as of 31-03-2025"]
[54,"W3","Actual End Date entered is not valid. It should be blank where the 'Application Status' is not 1"]
[55,"W4","Actual End Date should be on or before Planned End Date. Please ignore the error if this is not an error and the DoL had actually ended after the Planned End Date."]
[56,"W5","Actual End Date entered is not valid. It should not be blank where the Outcome of Most Recent Review is 1-7 (DoLS terminated) and should record the date the DoL terminated."]
[57,"W6","Actual End Date should not be blank where the Planned End Date is on or before 31st March 2025 and the Application Status = 1 ('Granted')"]
[58]
[59,"S6","Start Date of Authorisation entered is not valid. It should be blank if not applicable or a valid date of format dd-mm-yyyy"]
[60]
[61]
[62]
[63]
[64]
[65]
[66,"AA1","Age entered is not valid. It should be greater than 15 and less than 121"]
[67,"AA2","Age entered is not valid. It should not be less than 18 where Application Status is equal to 1"]
[68,"AB1","Gender entered is not valid. It should be 1 (Male) or 2 (Female)"]
[69,"AC1","Ethnic Origin entered is not valid. It should be between 1 and 7"]
[70,"AD1","Sexual Orientation entered is not valid. It should be between 0 and 5"]
[71,"AE1","Disability entered is not valid. It should be between 0 and 8"]
[72,"B0","Person Reference should not be blank"]
[73,"C0","LA Code should not be blank"]
[74,"D0","CQC Location Code should not be  blank"]
[75,"E0","Date Application Received should not be blank"]
[76,"F0","Urgent Included should not be blank"]
[77]
[78,"H0","Age Requirement should not be blank"]
[79,"I0","Mental Health Requirement should not be blank"]
[80,"J0","Mental Capacity Requirement should not be blank"]
[81,"K0","No Refusals Requirement should not be blank"]
[82,"L0","Eligibility Requirement should not be blank"]
[83,"M0","Best Interests Requirement should not be blank"]
[84]
[85]
[86,"P0","Application Status should not be blank"]
[87,"Q0","Reason Not Granted entered is not valid. It should be 1 (1 = any of the assessment criteria not satisfied) only where at least one of the six assessment criteria is not satisfied"]
[88,"Q5","Reason Not Granted should not be blank"]
[89]
[90,"T0","Outcome of Most Recent Review should not be blank"]
[91]
[92]
[93]
[94]
[95]
[96]
[97,"AB0","Gender should not be blank"]
[98,"AC0","Ethnic Origin should not be blank"]
[99,"AD0","Sexual Orientation should not be blank"]
[100,"AE0","Disability should not be blank"]
[101,"N5","Date of Last Assessment entered is not valid. It should be on or after the Date Application Received"]
[102,"W6","Actual End Date entered is not valid. It should not be before the Start Date Of Authorisation"]
[103,"P4","If all the six assessment criteria are either 1 or 3 then Application Status should be 1, or 0 where Reason Not Granted is either 2 (Change in circumstances) or 3 (Death of person)"]
[104,"N6","Date of Last Assessment should be a valid date of the format dd-mm-yyyy, where at least one of the 6 assessments is completed"]
[105,"O6","Application Sign Off Date should be on or after the Date of Last Assessment"]
[110,"AA0","Age entered is not valid"]
[112,"C2","LA Code entered is not valid"]
[113]
[114,"Q4","Reason Not Granted entered is not valid. It should not be 1 (1 = any of the assessment criteria not satisfied) where all the six assessment criteria are satisfied"]
[115,"U5","Outcome of Most Recent Review entered is not valid. It should be 0 where Number of Reviews is 0 for granted applications"]
[116,"S1","Start Date Of Authorisation entered is not valid. It should be blank where Application Status is 0 - Not Granted or 3 - Not Yet Signed Off"]
[117,"S2","Start Date Of Authorisation entered is not valid. It should be a valid date of the format dd-mm-yyyy, where 'Application Status' is 1 (Granted)."]
[118,"S3","Start Date Of Authorisation entered is not valid. It should be a valid date of the format dd-mm-yyyy when 'Application Status' = 1"]
[119,"S4","Start Date Of Authorisation entered is before Application Sign Off Date (column N). It should be on or after Application Sign Off Date."]
[120,"S5","Start Date Of Authorisation is not within the expected range 01-01-2022 and 31-03-2025 for granted applications. Please correct if this is an error."]
[121]
[122]
[123]
[124]
[125]
[126]
[127]
[128,"AR1","Application Reference has not been generated for this row. Please ensure both the LA Code and Person Reference fields have valid entries."]