Location of the Learner Data Definition 2009/2010
L_LLLSC, L_LWARD, L_LWAR01, L_LWAR03, L_LREG, L_LLA
Note: The ESF Standard FIle Dataset is not in use for 2009/2010 and where referenced for this variable in 2008/2009, has now been removed and this variable is marked as 'Amended' for 2009/2010.
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 and HE Standard Files |
| L_LWARD |
L_WARD Local Authority Ward Code of Learner Postcode (1991 census) |
Learner, Aims and HE Standard Files |
| L_LWAR01 |
L_LWAR01 Local Authority Ward Code of Learner Postcode (2001 census) |
Learner, Aims and HE Standard Files |
| L_LWAR03 |
L_LWAR03 Local Authority Ward Code of Learner Postcode (2003 census) |
Learner, Aims and HE Standard Files |
| L_LREG |
L_LREG Home Region of Learner Postcode |
Learner, Aims and HE Standard Files |
| L_LLA |
L_LLA Local Authority of Learner Postcode |
Learner, Aims 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_LREG
| 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’ |
3. The following SPSS code illustrates how to match Location of the Learner fields on to the Learner data set.
|
select
L01, L03
,LAUAcode as L_LLA
,LLSC as L_LLLSC
,WARD_04 as L_LWA03
,WARD_01 as L_LWA01
,WARD_91 as L_LWARD
from
dbo.ILR0910_E_LEARNER learners
left outer join
dbo.postcode0910 post
on learners.L17=post.pst_postcode
--L_LREG
select
L01, L03
, case when L_LLLSC=2 then 'NC'
when L_LLLSC=3 then 'NS'
when L_LLLSC>=60 and L_LLLSC<=110 then 'EE'
when L_LLLSC>=10 and L_LLLSC<=50 then 'EM'
when L_LLLSC>=120 and L_LLLSC<=160 then 'GL'
when L_LLLSC>=170 and L_LLLSC<=200 then 'NE'
when L_LLLSC>=210 and L_LLLSC<=250 then 'NW'
when L_LLLSC>=260 and L_LLLSC<=310 then 'SE'
when L_LLLSC>=320 and L_LLLSC<=370 then 'SW'
when L_LLLSC>=380 and L_LLLSC<=430 then 'WM'
when L_LLLSC>=440 and L_LLLSC<=470 then 'YH'
when L_LLLSC=490 then 'NO'
else 'NA' end as L_LREG
from
dbo.ILR0910_E_LEARNER |
Date last modified: 07th January 2010
