Learner Level Delivery Location Postcode Data Definition 2008/2009
L_A23
DATA DEFINITION
1. Postcode of the Learner's Delivery Provider.
PURPOSE
2. Identifies the delivery location postcode of the learner in order to generate learner delivery location areas.
RELEVANT COLLECTIONS
- ILR (LR)
- ILR (ER)
- ILR (ESF SR)
- ILR (UfI)
- ILR (ASL)
SOURCE DATA
3. The following variables are used as source data for the calculation of Learner Level Delivery Location Postcode.
| Field Name | Label | Dataset |
|---|
| A10 | A10 LSC Funding stream | Aims Standard File |
| A23 | A23 Delivery Location Postcode | Aims Standard File |
| A27 | A27 Learning Start Date | Aims Standard File |
A_INYR_
ACTUAL_GLH | A_INYR_ACTUAL_GLH Aim Actual Current Year GLH | Aims Standard File |
| A_NVQLEV | A_NVQLEV Notional NVQ Level of the Aim | Aims Standard File |
DERIVED VARIABLES AND DATASETS
4. The definition produces the following derived variable(s)
| Field Name | Label | Dataset |
|---|
| L_A23 | L_A23 Learner Level Delivery Location Postcode | Learner Standard File |
DETAILED DEFINITION
5. For LR, the Learner Level Delivery Location Postcode (L_A23) is derived using the Delivery Location Postcode of the aim (A23) with the highest Notional NVQ Level (A_NVQLEV). If there is more that one aim with that NVQ level then the aim with the highest total Actual Current Year Guided Learning Hours (A_INYR_ACTUAL_GLH) is used. If there is more than one Delivery Location Postcode (A23) with the same total Actual Current Year Guided Learning Hours (A_INYR_ACTUAL_GLH) then the Postcode of the Learners Delivery Provider (L_A23) is set to 'MIX DP', and delivery provider locations (e.g. L_DPLLSC) will not be derived for the learner.
6. For ER, the aims that are used for deriving Postcode of the Learners Delivery Provider (L_A23) are those Programme aims (A04=35) that are active in the current academic year (A_ACTIVE=1), and are not an apprenticeship (A15 = 2, 3 or 10), and are ER funded (A10=45), ER main funded aim (A10=46) LSC ESF co-financed (A10=70), other LSC funding stream (A10=80) or Non LSC funded (A10=99). Of these, the aim with the latest Learning Start Date (A27) is used to provide the Learner Level Delivery Location Postcode (L_A23).
Learner Level Delivery Location Postcode Sample Code
1. The following SPSS code is provided to illustrate the Learner Level Delivery Location Postcode data definition.
L_A23
ER & ESF SR 2. The following table shows the steps required to derive L_A23 for LR and ESF SR
| Step | Condition | Action/Action if true | Action if false |
|---|
| 1 | Does A_ACTIVE = 1 and A04=35 OR (A10=45, 46, 70, 80 or 99) AND A15 does not = 2,3, or 10 | Go to 2. | |
| 2 | (Aggregation)
For all aims where the Learner (L03) and provider (L01) are the same, does the Aim have the latest start date (A27) of all aims for the learner. | Set L_A23=A23 | |
| Step | Condition | Action/Action if true | Action if false |
|---|
| 1 | Does L_A23 contain a value | None | Set L_A23 = NA |
3. The following SPSS code illustrates how to derive L_A23 for ER & ESF SR.
/*This is carried out on the aims file.
GET FILE ‘…………AIMS data set’. /* For WBL the L_A23 belongs to the programme type with the latest start date.
SELECT IF A_ACTIVE=1 and A04=35 OR (ANY(A10,45,46,70,80,99) AND NOT ANY(A15,2,3,10)).
SORT CASES L01 L03 A27.
AGGREGATE OUTFILE ….LA23AGG.sav
/BREAK=L01 L03
/L_A23=LAST(A23). GET FILE ‘…………LEARNER data set’.
SORT CASES L01 L03.
MATCH FILE
/FILE= *
/TABLE=’……LA23AGG.SAV’
/BY L01 L03. IF LA23=”” LA23=’NA’.
SAV OUT ‘…….L_A23.sav’ /KEEP L01 L03 L_A23. |
LR, UfI & ASL
For LR, the Learner Level Delivery Location Postcode (L_A23) is derived using the Delivery Location Postcode of the aim (A23) with the highest Notional NVQ Level (A_NVQLEV).
If there is more that one aim with that NVQ level then the aim with the highest total Actual Current Year Guided Learning Hours (A_INYR_ACTUAL_GLH) is used.
If there is more than one Delivery Location Postcode (A23) with the same total Actual Current Year Guided Learning Hours (A_INYR_ACTUAL_GLH) then the Postcode of the Learners Delivery Provider (L_A23) is set to 'MIX DP', and delivery provider locations (e.g. L_DPLLSC) will not be derived for the learner.
4. The following table shows the steps required to derive L_A23 for LR, UfI & ASL
| Step | Condition | Action/Action if true | Action if false |
|---|
| 1 | Does A_ACTIVE =1 | Go to 2. | |
| 2 | (Aggregation)
For all aims where the learner (L03) and provider (L01) are the same. Do the aims have the highest Notional NVQ Level (A_NVQLEV), learner. | Go to 3. | |
| 3 | Do the aims have the same value in A_23 | Set L_A23=A23 | Go to 4 |
| 4 | Do the aims have the highest total Actual Current Year Guided Learning Hours (A_INYR_ACTUAL_GLH) | Go to 5 | |
| 5 | Do the aims have the same value in A_23 | Set L_A23=A23 | Set L_A23=Mix_DP |
| Step | Condition | Action/Action if true | Action if false |
|---|
| 1 | Does L_A23 contain a value | None | Set L_A23 = NA |
2. The following SPSS code illustrates how to derive L_A23 for LR, UfI & ASL.
GET FILE ………….AIMS.SAV'.
/* For LR L_A23 belongs to the aim with the highest NVQ, level. Where there is more than one aim with the same highest NVQ level and different delivery provider postcodes, we take into account the actual cyglh associated with each postcode.
/* Exclude those aims which are not included for analytical purposes.
SELECT IF A_ACTIVE=1. RECODE A_NVQLEV (9=0). AGGREGATE OUTFILE *
MODE=ADDVAR
/BREA=L01 L03
/MAX_NVQ=MAX(A_NVQLEV). SELECT IF MAX_NVQ=A_NVQLEV. AGGREGATE OUTFILE *
MODE=ADDVAR
/BREA=L01 L03
/MAX_ACTUAL_GLH=max(A_INYR_ACTUAL_GLH). SELECT IF (MAX_ACTUAL_GLH=A_INYR_ACTUAL_GLH). AGGREGATE OUTFILE *
MODE=ADDVAR
/BREA=L01 L03
/Min_A23=MIN(A23)
/Max_A23=MAX(A23). STRING L_A23 (A8). DO IF Min_A23=Max_A23.
COMPUTE L_A23=Min_A23.
ELSE.
COMPUTE L_A23='MIX_DP'.
END IF. IF MISSING(L_A23) L_A23=’NA’. SAV OUT ‘…….L_A23.sav’ /KEEP L01 L03 L_A23. |
Date last modified: 15th January 2009
