{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Claim Deliverables Guidance","Claim Deliverables","Cleansed","ExportReady","Data"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":1,"defined_names":51,"comments":1,"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":"Claim Deliverables Guidance","index":0,"n_rows":40,"n_cols":6,"rows_kept":40,"cut":false,"hidden":false,"merged":[[15,0,28,0],[29,0,38,0],[5,0,14,0]]}
["ESF Claim Deliverable Details"]
[]
[]
[]
[null,"Data Label","Data Description","Data Type","Other Rules","Error on Validation"]
["Basic information","Line Number","Input row number per line of data","Numeric","no duplicate line numbers ","line number is a required Field"]
[null,"Project Identifier","Must be unique to each Project","Alpha-numeric","For the purposes of the PDS when we say Project please read as operation","project Identifier is a required field, this should match you Project Number"]
[null,"Participant Identifier","Must be unique to each participant per Project","Alpha-numeric","Participant identifier per project.\nA participant must be able to attend projects in different operations, including those organised by the same CFO, and have a unique identifier for each operation. \n\nIf the participant benefits from more than one project within an operation, the start date and output indicators should remain unchanged but the results indicators must be updated. We need to be able to identify any participant returning to an project so the existing immediate and longer-term results for the individual record can be deleted/reset, and the info propagated to adjust the aggregates. \n\nA maximum number of characters, including the prefix signifier, should be 22 characters. ","participant identifier is required and must be unique for this project for new entries"]
[null,"Participant Status","Used to mark if participant is New, Update, Delete or marked for Correction","Alpha String",null,"participant status is a required field"]
[null,"Date Of Entry To The Project","Date format limited to the range 01-01-2014 through to 31-12-2020. Used to determine age categories of claimants. Without this fixed point a system might have trouble tracking the participant age at entry to the programme. For example if a participant enters the programme aged 49 and their record is amended the following year they could accidentally slip into the 50 and over age bracket on a technicality","Date",null,"This is a new record and as such date of entry to the project is a required field"]
[null,"Match, ESF Or Both (mix)","Selected from drop down list with only 3 potential options","Alpha String\n","If the project/Participant ID relates to the Big Lottery Opt-In then the option for match should be unselectable as they provide cash match not match in kind","This is a new record and as such match, ESF or both is a required field"]
[null,"Claim Period Participant Falls Under","Selected from drop down list. Allows participant data to easily fit into reporting back to the ESIF Committees ","Alpha-numeric",null,"This is a new record and as such claim period participant falls under is a required field, also the Claim period must be the present or a previous period"]
[null,"Category Of Region Claimed Under","Selected from drop down list. Must link back to an individual claim number to match the MI up to  the claims data more effectively. It would also allow easier tracking of adjustment and corrections","Alpha string",null,"This is a new record and as such Category of region claimed under is a required field"]
[null,"Investment Priority Claimed Under","Selected from drop down list. ","Alpha-numeric",null,"This is a new record and as such Investment priority is a required field, also the Investment Priority must be present in the Call you have applied against for your project"]
[null,"Activity Postcode","AA00 0AA\nBold characters denote letters or numbers that must be optional to allow for the full range of UK Postcodes","Alpha-numeric",null,"This is a new record and as such activity postcode is a required field, also the postcode must be a valid UK postcode"]
["Personal data","Gender","Selected from drop down list with only 4 potential options","Alpha string",null,"This is a new record and as such Gender is a required field"]
[null,"Date Of Birth ","Used with entry date to the program to determine which age category the participant fits into","Date",null,"This is a new record and as such Date of birth  is a required field"]
[null,"Participant's Residential Postcode","Standard Valid Postcode","Alpha-numeric","Not required for homless participants with the exception of  under investment priority 1.3a. YEI participants must be from a YEI area to be eligible for support. In these instances a range of postcode options can be used including one representing the regular area the participant stays, a postcode of a shelter used by the participant, the postcode of a charitable organisation supporting the participant. This list is not exhaustive please discuss with your contract manager if needed. ","This is a new record and as such Participant's residential postcode is a required field, also the postcode must be a valid UK postcode"]
[null,"Labour Market Status That Best Describes Situation ","Selected from drop down list with only 5 potential options","Alpha-numeric",null,"This is a new record and as such labour market status that best describes situation  is a required field"]
[null,"Participant Has Basic Skills","Selected from drop down list with only 3 potential options","Alpha string","The YES would require the participant to declare they have two of the following:\nEntry Level Maths qualification (or higher)\nEntry Level English qualification (or higher)\nESOL qualification (English as a second language)\n\n","This is a new record and as such Participant has basic skills? is a required field"]
[null,"Highest Educational Attainment Upon Joining","Selected from drop down list with only 6 potential options","Alpha-numeric",null,"This is a new record and as such highest educational attainment upon joining is a required field"]
[null,"Engaged In Education Or Training","Selected from drop down list with only 3 potential options","Alpha string",null,"This is a new record and as such Engaged in education or training? is a required field"]
[null,"Jobless Household","Selected from drop down list with only 4 potential options","Alpha string",null,"This is a new record and as such jobless household?  is a required field"]
[null,"Jobless Household With Dependent Children","Selected from drop down list with only 4 potential options","Alpha string","If answered \"Yes\" must have answered \"Yes\" to \"Jobless Household?\" question.","This is a new record and as such Jobless household with dependent children? is a required field, also if you have answered Yes to jobless household, then an answer is required here."]
[null,"Single Adult Household With Dependent Children (Lone Parent)","Selected from drop down list with only 4 potential options select","Alpha string",null,"This is a new record and as such single adult household with dependent children (lone parent) is a required field"]
[null,"Ethnicity","Drop-down list of minority status as taken from the ONS recommended categories ","Alpha string","Sensitive data","This is a new record and as such ethnicity is a required field"]
[null,"Disability Status","Selected from drop down list with only 4 potential options","Alpha string","Sensitive data","This is a new record and as such disability status is a required field"]
[null,"Other Disadvantages - Offender/Ex-Offender","Selected from drop down list with only 4 potential options","Alpha string","Sensitive data","This is a new record in investment priority 1.4 as such offender status is a required field"]
[null,"Other Disadvantages – Homeless (Broad Definition)","Selected from drop down list with only 3 potential options","Alpha string",null,"This is a new record and as such other disadvantages  – homeless (broad definition) is a required field"]
["Immediate results indicators","Leaving Date","Date format limited to the range 01-01-2014 through to 31-12-2020. Used to determine age categories of claimants. Without this fixed point a system might have trouble tracking the participant age at entry to the programme. For example if a participant enters the programme aged 49 and their record is amended the following year they could accidentally slip into the 50 and over age bracket on a technicality","Date",null,"This date of leaving can not be before the Participant Start Date"]
[null,"Employment Status on Leaving","Selected from drop down list with only 5 potential options","Alpha string"]
[null,"Engaged in Education or Training on Leaving","Selected from drop down list with only 2 potential options","Alpha string"]
[null,"Qualification Gained on Leaving","Selected from drop down list with only 2 potential options","Alpha string"]
[null,"Basic Skills on Leaving","Selected from drop down list with only 2 potential options","Alpha string",null,"This field must state Yes if any skills qualification has been achieved"]
[null,"Below Level 2 Skills on Leaving","Selected from drop down list with only 3 potential options","Alpha string"]
[null,"Above Level 3 Skills on Leaving","Selected from drop down list with only 3 potential options","Alpha string"]
[null,"Higher Education on Leaving","Selected from drop down list with only 6 potential options","Alpha-numeric"]
[null,"Completed YEI Supported Intervention","Specific to YEI – Selected from drop down list with only 3 potential options","Alpha string",null,"You cannot select Not Applicable to this question as the Investment Priority is YEI"]
[null,"YEI - received an offer of employment, continued education, apprenticeship or traineeship upon leaving","Specific to YEI – Selected from drop down list with only 3 potential options","Drop down selection of qualification levels ",null,"You cannot select Not Applicable to this question as the Investment Priority is YEI"]
["Completeness requirement","Data Complete","Selection from drop down list with only 4 potential options to indicate the status of a record. There are a number of types of complete and incomplete and we must collect data about where we can and can't collect data","Alpha string","\n ","You have not met the requirements from the previous sections to complete this field with the answer you have selected, please refer to the guidance notes."]

{"sheet":"Claim Deliverables","index":1,"n_rows":7,"n_cols":35,"rows_kept":7,"cut":false,"hidden":false,"merged":[[4,24,4,33],[5,24,5,31],[5,32,5,33],[4,0,4,9],[5,0,5,9],[4,10,4,23],[5,10,5,19],[5,20,5,22]]}
["ESF Claim Deliverable Details"]
[]
["Version 10"]
[]
["On starting – the participant's characteristics and situation when they join an operation",null,null,null,null,null,null,null,null,null,"On starting – the participant's characteristics and situation when they join an operation",null,null,null,null,null,null,null,null,null,null,null,null,null,"On leaving – the participant's characteristics and situation after leaving an operation (the next day or within 4 weeks of leaving) ",null,null,null,null,null,null,null,null,null,"On joining and leaving"]
["Basic information",null,null,null,null,null,null,null,null,null,"Personal data, including common output indicators",null,null,null,null,null,null,null,null,null,"Sensitive personal data, including common output indicators",null,null,"Personal Data ","All participants",null,null,null,null,null,null,null,"YEI only",null,"All participants"]
["Line Number","Project Identifier","Participant Identifier","Participant Status","Date Of Entry To The Project","Match, ESF Or Both (mix)","Claim Period Participant Falls Under","Category Of Region Claimed Under","Investment Priority Claimed Under","Activity Postcode","Gender","Date Of Birth ","Participant's Residential Postcode","Labour Market Status That Best Describes Situation ","Participant Has Basic Skills","Highest Educational Attainment Upon Joining","Engaged In Education Or Training","Jobless Household","Jobless Household With Dependent Children","Single Adult Household With Dependent Children (Lone Parent)","Ethnicity","Disability Status","Other Disadvantaged - Offender/Ex-Offender","Other Disadvantaged – Homeless (Broad Definition)","Leaving Date","Employment Status on Leaving","Engaged in Education or Training on Leaving","Qualification Gained on Leaving","Basic Skills Gained on Leaving","Gaining Level 2 Skills or below on Leaving","Gaining Level 3 Skills or above on Leaving","Highest Education on Leaving","Completed YEI Supported Intervention","YEI - received an offer of employment, continued education, apprenticeship or traineeship upon leaving","Data Complete"]

{"sheet":"Cleansed","index":2,"n_rows":1,"n_cols":35,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["line-number","project-identifier","participant-identifier","participant-status","date-of-entry-to-the-project","match-or-esf","claim-period","category-of-region","investment-priority","activity-postcode","gender","date-of-birth","participant-postcode","labour-market-status","basic-skills","highest-education","engaged-in-education-or-training","jobless-household","jobless-household-with-children","single-household-with-children","ethnicity","disability-status","other-disadvantages-offender","other-disadvantages-homeless","leaving-date","employment-status-on-leaving","engaged-in-education-or-training-on-leaving","qualification-on-leaving","basic-skills-on-leaving","gaining-level-2-skills-or-below-on-leaving","gaining-level-3-skills-or-above-on-leaving","highest-education-on-leaving","completed-yei-supported-intervention","yei-received-an-offer-of-employment-continued-education-apprenticeship-or-traineeship-upon-leaving","data-complete"]

{"sheet":"ExportReady","index":3,"n_rows":1,"n_cols":35,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["line-number","project-identifier","participant-identifier","participant-status","date-of-entry-to-the-project","match-or-esf","claim-period","category-of-region","investment-priority","activity-postcode","gender","date-of-birth","participant-postcode","labour-market-status","basic-skills","highest-education","engaged-in-education-or-training","jobless-household","jobless-household-with-children","single-household-with-children","ethnicity","disability-status","other-disadvantages-offender","other-disadvantages-homeless","leaving-date","employment-status-on-leaving","engaged-in-education-or-training-on-leaving","qualification-on-leaving","basic-skills-on-leaving","gaining-level-2-skills-or-below-on-leaving","gaining-level-3-skills-or-above-on-leaving","highest-education-on-leaving","completed-yei-supported-intervention","yei-received-an-offer-of-employment-continued-education-apprenticeship-or-traineeship-upon-leaving","data-complete"]

{"sheet":"Data","index":4,"n_rows":42,"n_cols":12,"rows_kept":42,"cut":false,"hidden":true,"merged":[[0,0,0,10]]}
["Drop Down Lists [The bracketed text after the list title denotes the list name if it is different from the title]"]
["Priority Axis and Investment Priority Claimed Under",null,"Gender",null,"Ethnic Minority Status (Ethnicity)",null,"Claim_Period",null,"Match or ESF (Match)",null,"Data Completion (Data_Comp)"]
[1.1000000000000001,null,"male",null,"white - english/welsh/scottish/northern irish/british",null,"2014 - Q01",null,"match",null,"yes - all data present"]
[1.2,null,"female",null,"white - irish",null,"2014 - Q02",null,"esf",null,"yes - mandatory data are present but the participant has withheld certain personal sensitive data and signed the questionnaire to acknowledge refusal"]
["1.3a",null,"other",null,"white - roma, gypsy or irish traveller",null,"2014 - Q03",null,"mix",null,"no - mandatory data are present but personal sensitive data is missing - no signature from participant to exempt completion"]
[1.4,null,"participant failed to say (no signed exemption)",null,"white - other",null,"2014 - Q04",null,null,null,"no - mandatory data items missing"]
[1.5,null,null,null,"mixed/multiple - white and black caribbean",null,"2015 - Q01",null,"Completed YEI intervention (YEI)",null,null,{"$f":"LOWER(K7)","v":""}]
[2.1,null,"YN_Clean",null,"mixed/multiple - white and black african",null,"2015 - Q02",null,"completed",null,"YN_Sensitive"]
[2.2000000000000002,null,"yes",null,"mixed/multiple - white and asian",null,"2015 - Q03",null,"early exit",null,"yes"]
[3,null,"no",null,"mixed/multiple - other",null,"2015 - Q04",null,"not applicable",null,"no"]
[null,null,null,null,"asian/asian british - indian",null,"2016 - Q01",null,null,null,"participant chose not to say (signed exemption)"]
[null,null,"YN_NA",null,"asian/asian british - pakistani",null,"2016 - Q02",null,"Participant Economic Status (Emp_Status)",null,"participant failed to say (no signed exemption)"]
[null,null,"yes",null,"asian/asian british - bangladeshi",null,"2016 - Q03",null,"unemployed (short term)",null,null,""]
[null,null,"no",null,"asian/asian british - chinese",null,"2016 - Q04",null,"long-term unemployed",null,"Category of Region Claimed Under (CoR)"]
[null,null,"not applicable",null,"asian/asian british - other",null,"2017 - Q01",null,"inactive (in education or training)",null,"less developed"]
[null,null,null,null,"black/african/caribbean/black british - african",null,"2017 - Q02",null,"inactive (not in education or training)",null,"transitional"]
[null,null,"YN_Failed",null,"black/african/caribbean/black british - caribbean",null,"2017 - Q03",null,"employed including self-employed",null,"more developed"]
[null,null,"yes",null,"black/african/caribbean/black british - other",null,"2017 - Q04",null,null,null,null,""]
[null,null,"no",null,"other ethnic group - arab",null,"2018 - Q01",null,"Number of qualifications gained",null,"Education"]
[null,null,"participant failed to say (no signed exemption)",null,"other ethnic group - other",null,"2018 - Q02",null,0,null,"not applicable"]
[null,null,null,null,"participant chose not to say (signed exemption)",null,"2018 - Q03",null,1,null,"below primary education (below isced level 1) - other disadvantaged"]
[null,null,"Participant Status",null,"participant failed to say (no signed exemption)",null,"2018 - Q04",null,2,null,"primary education or equivalent (isced 1)"]
[null,null,"new",null,null,null,"2019 - Q01",null,3,null,"lower secondary education or equivalent (isced 2)"]
[null,null,"update",null,"childcare",null,"2019 - Q02",null,4,null,"upper secondary education or equivalent (isced 3)"]
[null,null,"correction",null,"Yes: received childcare support",null,"2019 - Q03",null,"5+",null,"post-secondary (non-tertiary) education or equivalent (isced 4)"]
[null,null,"delete",null,"No: has childcare needs but not received childcare support",null,"2019 - Q04",null,null,null,"tertiary education or equivalent (isced 5-8)"]
[null,null,null,null,"No: does not have childcare needs",null,"2020 - Q01"]
[null,null,"YEI_YN",null,null,null,"2020 - Q02"]
[null,null,"yes - traineeship",null,null,null,"2020 - Q03"]
[null,null,"yes - education",null,null,null,"2020 - Q04"]
[null,null,"yes - apprenticeship",null,null,null,"2021 - Q01"]
[null,null,"yes - employment",null,null,null,"2021 - Q02"]
[null,null,"no",null,null,null,"2021 - Q03"]
[null,null,"not applicable",null,null,null,"2021 - Q04"]
[null,null,"unknown",null,null,null,"2022 - Q01"]
[null,null,null,null,null,null,"2022 - Q02"]
[null,null,null,null,null,null,"2022 - Q03"]
[null,null,null,null,null,null,"2022 - Q04"]
[null,null,null,null,null,null,"2023 - Q01"]
[null,null,null,null,null,null,"2023 - Q02"]
[null,null,null,null,null,null,"2023 - Q03"]
[null,null,null,null,null,null,"2023 - Q04"]