Location of the Learner Data Definition 2008/2009
L_LLLSC, L_LWARD, L_LWAR01, L_LWAR03, L_LREG, L_LLA
DATA DEFINITION
1. Identifies the geographical areas in which the learner is residing.
PURPOSE
2. These fields classify the geographical areas based on the learner’s home postcode and are used in travel to learn analysis.
RELEVANT COLLECTIONS
- ILR (LR)
- ILR (UfI)
- ILR (ER)
- ILR (ESF SR)
- ILR (ASL)
SOURCE DATA
3. The following variables are used as source data for the calculation of Location of the Learner.
| Field Name | Label | Dataset |
|---|
| L17 | L17 Home Postcode | Learner Standard File |
DERIVED VARIABLES AND DATASETS
4. The definition produces the following derived variable(s)
| Field Name | Label | Dataset |
|---|
| L_LLLSC | L_LLLSC Home LSC of Learner Postcode | Learner, Aims, ESF and HE Standard Files |
| L_LWARD | L_WARD Local Authority Ward Code of Learner Postcode (1991 census) | Learner, Aims, ESF and HE Standard Files |
| L_LWAR01 | L_LWAR01 Local Authority Ward Code of Learner Postcode (2001 census) | Learner, Aims, ESF and HE Standard Files |
| L_LWAR03 | L_LWAR03 Local Authority Ward Code of Learner Postcode (2003 census) | Learner, Aims, ESF and HE Standard Files |
| L_LREG | L_LREG Home Region of Learner Postcode | Learner, Aims, ESF and HE Standard Files |
| L_LLA | L_LLA Local Authority of Learner Postcode | Learner, Aims, ESF and HE Standard Files |
VALUES
5. The table below outlines the categories for L_LREG
| L25_REG value | Label |
|---|
| NC | National Employer Service |
| NS | National Apprenticeship Service |
| EE | East of England |
| EM | East Midlands |
| GL | Greater London |
| NE | North East |
| NW | North West |
| SE | South East |
| SW | South West |
| WM | West Midlands |
| YH | Yorkshire and the Humber |
| NO | National Office |
| NA | Not Applicable |
DETAILED DEFINITION
6. The Learner Home Postcode field (L17) is matched to the postcode file for that year to obtain the LSC Office of the Learner (L_LLLSC), the Region of the Learner (L_LREG). The Local Authority of the Learner (L_LLA) and the three Local Authority ward fields (L_LWARD, L_LWAR01 and L_LWAR03) that the learner’s home is based in.
Location of the Learner Sample Code
1. The following SPSS code is provided to illustrate the Location of the Learner data definition.
L_LLLSC, L_LWARD, L_LWAR01, L_LWAR03, L_LREG, L_LLA
2. The following table shows the steps required to derive L_LLLSC, L_LWARD, L_LWAR01, L_LWAR03, L_LREG, L_LLA
| Step | Condition | Action if true | Action if false |
|---|
| 1 | If L_LLLSC=2 | L_LREG=NC | |
| 2 | If L_LLLSC=3 | L_LREG=NS | |
| 3 | If L_LLLSC is in the inclusive range (60 to 110) | L_LREG=EE | |
| 4 | If L_LLLSC is in the inclusive range (10 to 50) | L_LREG=EM | |
| 5 | If L_LLLSC is in the inclusive range (120 to 160) | L_LREG=GL | |
| 6 | If L_LLLSC is in the inclusive range (170 to 200) | L_LREG=NE | |
| 7 | If L_LLLSC is in the inclusive range (210 to 250) | L_LREG=NW | |
| 8 | If L_LLLSC is in the inclusive range (260 to 310 | L_LREG=SE | |
| 9 | If L_LLLSC is in the inclusive range (320 to 370) | L_LREG=SW | |
| 10 | If L_LLLSC is in the inclusive range (380 to 430) | L_LREG=WM | |
| 11 | If L_LLLSC is in the inclusive range (440 to 470) | L_LREG=YH | |
| 12 | If L_LLLSC=490 | L_LREG=NO | |
| 13 | If no value in L_LLLSC | L_LREG=NA | |
3. The following SPSS code illustrates how to match Location of the Learner fields on to the Learner data set.
GET FILE '………………..LEARNERS data set'.
SORT CASES BY L17. /* Rename the learners postcode so that it matches the name of the postcode field in the postcode file.
RENAME VARIABLES (L17=postcode).
MATCH FILES /FILE=*
/TABLE = '…………………………POSCTODE data set.sav'
/BY POSTCODE. RENAME VARIABLES (LLSC=L_LLLSC) (LAUAcode=L_LLA) (WARD_91=L_LWARD) (WARD_01=L_LWA01) (WARD_04=L_LWA03) (POSTCODE=L_A23). VARIABLE LABELS L_LLLSC 'L_LLLSC Home LSC of Learner Postcode'
/L_LWARD 'L_LWARD Local Authority Ward Code of Learner Postcode (1991 Census)'
/L_LWAR01 'L_LWAR01 Local Authority Ward Code of Learner Postcode (2001 Census)'
/L_LWAR03 'L_LWAR03 Local Authority Ward Code of Learner Postcode (2003 Census)'
/L_LLA 'L_LLA Local Authority of Learner Postcode'. IF L_LLLSC=2 L_LREG='NC'.
IF L_LLLSC=3 L_LREG='NS'.
IF RANGE(L_LLLSC, 60, 110) L_LREG='EE'.
IF RANGE(L_LLLSC, 10, 50) L_LREG='EM'.
IF RANGE(L_LLLSC, 120, 160) L_LREG='GL'.
IF RANGE(L_LLLSC, 170, 200) L_LREG='NE'.
IF RANGE(L_LLLSC, 210, 250) L_LREG='NW'.
IF RANGE(L_LLLSC, 260, 310) L_LREG='SE'.
IF RANGE(L_LLLSC, 320, 370) L_LREG='SW'.
IF RANGE(L_LLLSC, 380, 430) L_LREG='WM'.
IF RANGE(L_LLLSC, 440, 470) L_LREG='YH'.
IF L_LLLSC=490 L_LREG='NO'.
IF MISSING(L_LLLSC)OR L_LLLSC=-1 L_LREG='NA'. RECODE L_LLLSC (SYSMIS=-1). VARIABLE LABELS ‘L_LREG Home Region of Learner Postcode’ |
Date last modified: 19th January 2009
