WBL Success Rates Pre-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 are intermediate files in the new measures WBL Success Rates Methodology 2005/06, generated directly from ILR standard files. They provide an input to the Fuzzy Data Matching process that occurs to provide accurate matches in data between years.
Purpose
2 These files provide the main input to the fuzzy matching process and are created during the preparation phase of the WBL Success Rates methodology.
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 One pre-match file is generated for each year from 2001/02 to 2005/06 by matching aims, frameworks, learning aim database and learner files and keeping the needed variables.
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
