WBL Success Rates Fuzzy Match Files
Note: This page is from an older version of the Data Dictionary and may therefore contain information that is now out of date. It is included here for reference only.
1 These files are generated by the Fuzzy Data Matching methodology and are broadly similar to the WBL Success Rates Pre-Match Files with the exception that learner numbers have been through a thorough matching process and will now be more consistent between years. They provide the input for the creation of the WBL Success Rates Master File, which is used for all new measures success rate calculations in WBL.
Purpose
2 These files provide the main input to the final matching process that creates the WBL Success Rates Master File.
3 The variables in these files provide the means for matching data between years and deriving all the variables needed in success rate calculations.
4 This dataset is part of the following collections
Detailed definition
5 There is one fuzzy match file for each year from 2001/02 to 2005/06 and within each file the L03 has been updated to the most recent number we found for that learner by looking at the programme of study, national insurance number and date of birth.
6 In 2001/02 the standard files were in a different format to the current ILR so the variables have been renamed to their equivalent from the most recent ILR specifications.
7 The definitions below show the fields that occur in these tables. Fields that are from the Individualised Learner Record (ILR) are defined in the ILR Specification. The hyperlink will take you to the ILR page where you can view the specification for the relevant teaching year.
Table 1 Fields in the Pre-Match Files
Field name | Description |
L01 | Provider number. |
L03 | Learner Reference Number. |
L11 | Date of birth |
L12 | Ethnicity |
L13 | Sex |
L14 | Learning Difficulties and/or Disabilities and/or Health Problems |
L26 | National Insurance Number |
L25 | LSC Number of Funding LSC |
A09 | Learning Aim Reference |
matchv | Matching variable. Its value is either the area of learning (in the case of NVQ only programmes) or the sector framework code from variable A26 (in the case of apprenticeships). |
A15 | Programme Type |
A16 | Programme Entry Route |
A_AOL | Area of Learning |
A_SSA_T1 | Sector Subject Area |
trans | Denotes a learner that has transferred to another course at the same provider |
trans_provider | Denotes a learner that has transferred to a course at a different provider |
leavers | Marks aims for which we have an actual end date of learning, implying the user has finished the aim |
frm_ach | Cases where the framework has been achieved |
frm_ach_timely | Cases where the framework has been achieved either before or within 31 days of the planned end date. |
nvq_ach | Cases where the NVQ has been achieved |
nvq_ach_timely | Cases where the NVQ has been achieved either before or within 31 days of the planned end date. |
A26 | Sector Framework of Learning |
A27 | Learning Start Date |
A28 | Learning Planned End Date |
A31 | Learning Actual End Date |
A40 | Achievement Date |
A43 | Sector Framework Achievement Date |
achieve_dup | Identifies the current achievement status of the learner’s study. Used during the de-duplification phase of the master file creation. |
sfl_(year) | Identifies which year the case came from. For example, slf_0102 would identify if the case came from 2001/02. |
a_start | Indicates whether a record is a true start or a transfer |
plan_break | Whether a learner is taking a planned break from learning agreed with the provider (it is only possible to record this in the ILR from 2005/06 onwards). |
Last Modified: 31 Mar 06
