Learning Aims Hierarchy Table
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 This will contain 'Inspection Code' and 'Map Code' and other values for each learning aim.
Purpose
2 To assist providers in producing analyses of success rates and benchmarking, a downloadable file of 'Hierarchy Data' will be made available via the LAD.
3 It is not planned to issue more than one file for each teaching year, as these are intended to be finalised versions of the data.
4 This dataset is part of the following collection
Detailed definition
5 The file contains an entry for each learning aim with the fields taken from the learning aim table and all annual values table using a join on the learning aim reference column. The table is available in a variety of formats from the LSC providers’ website LAD miscellaneous download page where the field names are the same as the LAD field names. A version is also made available in SPSS for internal LSC use which has less columns and uses field names as indicated in the right hand column of the table below.
Table 1 Fields in the Hierarchy Table
| LAD Field name |
Description |
Hierarchy table field name |
|
ACADEMIC_YEAR_CODE |
The teaching year to which the annual values relate. |
|
|
LEARNING_AIM_REF (A09) |
The reference number by which the LSC refers to this learning aim. |
A09 |
|
MAP_CODE_DESC |
|
maptitle |
|
MAP_CODE_CODE |
A code used to group learning aims together in a hierarchy for the purpose of analysis / benchmarking |
mapcode |
|
INSP_CODE_CODE |
A code used to group learning aims together in a hierarchy for Inspection purposes |
inspcode |
|
AWARDING_BODY_CODE |
A code to identify the awarding body associated with each learning aim record. |
mapawb |
|
LEARNING_AIM_TYPE_CODE |
A code used by the Learner Information Suite to assign funding units to certain listed learning aims (eg NVQs and GNVQs). |
mapqty |
|
NOTIONAL_LEVEL_V2_CODE |
A level on the NVQ scale for all learning aims. Enables learning aims to be analysed against the NVQ scale. Notional Levels revised 2004 (v2) to expand levels 4 and 5 to levels 4 – 8. |
|
|
NOTIONAL_NVQ_LEVEL_CODE |
A level on the NVQ scale for all learning aims. Enables learning aims to be analysed against the NVQ scale. Levels 4 and 5 continue to reflect their original (ie pre 0405) values. |
map_nl |
|
AREA_OF_LEARNING_CODE |
A code to classify the learning aim using the Adult Learning Inspectorate (ALI) areas of learning. |
Map_aol |
|
NOTIONAL_NVQ_WIDTH |
Gives the proportion of a full NVQ that the amount of material covered in a learning aim represents. For example, a GCSE has a notional NVQ width of 20%, since five GCSEs are equivalent to a single NVQ level 2. |
|
|
BASIC_SKILL |
Indicates that the Learning Aim is considered a basic skill relating to achievements in literacy, numeracy and language and counts towards basic skills national targets. For 05/06 this field will be populated with the same data as the skills_for_life field |
|
|
BASIC_SKILL_TYPE_CODE |
A sub-category identifying the type of basic skill (eg Adult literacy, ESOL). For 05/06 this field will be populated with the same data as the skills_for_life_type_code field |
|
|
LEVEL2_ENTITLEMENT_CAT_CODE |
A code to indicate the category or ‘family’ to which the learning aim belongs for the purpose of assessing how far the aim contributes to a Full level 2 |
|
|
LEVEL2_PERCENTAGE |
The percentage of a Full Level 2 which a learning aim contributes |
|
|
LEVEL3_ENTITLEMENT_CAT_CODE |
A code to indicate the category or ‘family’ to which the learning aim belongs for the purpose of assessing how far the aim contributes to a Full level 3 |
full3 |
|
LEVEL3_PERCENTAGE |
The percentage of a Full Level 3 which a learning aim contributes |
|
|
KEY_SKILL_CODE |
Identifies whether a learning aim is considered to be a ‘key skill’ for funding calculation purposes in a particular teaching year. |
|
|
SSA_TIER1_CODE |
The broad (Tier 1) classification of the subject of a learning within the QCA Sector Subject Area classification system |
Map_ssa1 |
|
SSA_TIER2_CODE |
The more specialised classification (Tier 2) of the subject of a learning aim within the QCA Sector Subject Area classification system. Represented as Tier1 code <.> Tier 2 code (eg 05.1) |
|
|
SKILLS_FOR_LIFE |
Indicates that the learning aim is considered a skill for life relating to achievements in literacy, numeracy and language and counts towards Skills for Life national targets. |
|
|
SKILLS_FOR_LIFE_TYPE_CODE |
A sub-category identifying the type of basic skill (eg Adult literacy, ESOL). For 05/06 this field will be populated with the same data as the skills_for_life_type_code field |
|
Last Modified: 22 Dec 05
