Location of the Provider Data Definition 2008/2009
L_PLLSC, L_PREG, L_PLA, L_PWARD, L_PWAR01, L_PWAR03
DATA DEFINITION
1. The geographical areas in which the provider is located.
PURPOSE
2. These fields classify the geographical areas in which the provider is located 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 Provider.
| Field Name | Label | Dataset |
|---|
| L01 | L01 Provider Number | Aims Standard File |
DERIVED VARIABLES AND DATASETS
4. The definition produces the following derived variable(s)
| Field Name | Label | Dataset |
|---|
| L_PLLSC | L_PLLSC LLSC based on the 1-1 Owner Relationship UPIN to LLSC | Learner, Aims, ESF and HE Standard Files |
| L_PWARD | L_PWARD Local Authority ward code of the owning provider postcode (1991 census) | Learner, Aims, ESF and HE Standard Files |
| L_PWAR01 | L_PWAR01 Local Authority ward code of the owning provider postcode (2001 census) | Learner, Aims, ESF and HE Standard Files |
| L_PWAR03 | L_PWAR03 Local Authority ward code of the owning provider postcode (2003 census) | Learner, Aims, ESF and HE Standard Files |
| L_PREG | L_PREG Region of the Owning Provider | Learner, Aims, ESF and HE Standard Files |
| L_PLA | L_PLA Local Authority based on the Provider postcode | Learner, Aims, ESF and HE Standard Files |
VALUES
5. The table below outlines the categories for L_PREG.
| 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. LLSC based on the 1-1 'owner' relationship UPIN to LLSC (L_PLLSC) is taken from the Provider Information Management System (PIMS). It is the LSC office that the provider has its main contract with. The provider postcode is also obtained from PIMS for the next stage.
7. The postcode of the provider is then matched to the postcode file for that year to obtain the Region of the Owning Provider (L_PREG), the Local Authority of the Owning Provider and the three Local Authority ward fields (L_PWARD, L_PWAR01 and L_PWAR03) that the provider is based in.
Location of the Provider Sample Code
1. The following SPSS code is provided to illustrate the Location of the Provider data definition.
L_PLLSC, L_PREG, L_PLA, L_PWARD, L_PWAR01, L_PWAR03
2. The following table shows the steps required to derive L_PREG
| Step | Condition | Action/Action if true | Action if false |
|---|
| 1 | If L_PLLSC=2 | L_PREG=NC | |
| 2 | If L_PLLSC=3 | L_PREG=NS | |
| 3 | If L_PLLSC is in the inclusive range (60 to 110) | L_PREG=EE | |
| 4 | If L_PLLSC is in the inclusive range (10 to 50) | L_PREG=EM | |
| 5 | If L_PLLSC is in the inclusive range (120 to 160) | L_PREG=GL | |
| 6 | If L_PLLSC is in the inclusive range (170 to 200) | L_PREG=NE | |
| 7 | If L_PLLSC is in the inclusive range (210 to 250) | L_PREG=NW | |
| 8 | If L_PLLSC is in the inclusive range (260 to 310) | L_PREG=SE | |
| 9 | If L_PLLSC is in the inclusive range (320 to 370) | L_PREG=SW | |
| 10 | If L_PLLSC is in the inclusive range (380 to 430) | L_PREG=WM | |
| 11 | If L_PLLSC is in the inclusive range (440 to 470) | L_PREG=YH | |
| 12 | If L_PLLSC=490 | L_PREG=NO | |
| 13 | If no value in L_PLLSC | L_PREG=NA | |
3. The following SPSS code illustrates how to match Location of the Provider fields on to the Learner or Aims data set.
/* Match the UPIN to LLSC look up onto the file in order to get the providers postcode.
SORT CASES L01.
MATCH FILES /FILE=*
/TABLE=’……………………….UPIN to LLSC Lookup.sav’
/BY L01.
RECODE L_PLLSC (SYSMIS=-99).
SORT CASES P_POSTCODE. /* Rename the providers postcode so that it matches the name of the postcode field in the postcode file.
RENAME VARIABLES (p_postcode=postcode).
MATCH FILES /FILE=*
/TABLE = ‘…………………………POSCTODE data set.sav’
/BY POSTCODE. /* Rename the ward variables matched on from the postcode file.
RENAME VARIABLE (LAUAcode=L_PLA) (WARD_91=L_PWARD) (WARD_01=L_PWAR01) (WARD_04=L_PWAR03).
VARIABLE LABELS L_PLLSC 'L_PLLSC LLSC based on the 1-1 owner relationship UPIN to LLSC'
/L_PWARD 'L_PWARD Local Authority ward code of the Owning Provider Postcode (1991 Census)'
/L_PWAR01 'L_PWAR01 Local Authority ward code of the Owning Provider Postcode (2001 Census)'
/L_PWAR03 'L_PWAR03 Local Authority ward code of the Owning Provider Postcode (2003 Census)'
/L_PLA ‘L_PLA Local Authority based on the Provider postcode’. IF L_PLLSC=2 L_PREG='NC'.
IF L_PLLSC=3 L_PREG='NS'.
IF RANGE(L_PLLSC, 60, 110) L_PREG='EE'.
IF RANGE(L_PLLSC, 10, 50) L_PREG='EM'.
IF RANGE(L_PLLSC, 120, 160) L_PREG='GL'.
IF RANGE(L_PLLSC, 170, 200) L_PREG='NE'.
IF RANGE(L_PLLSC, 210, 250) L_PREG='NW'.
IF RANGE(L_PLLSC, 260, 310) L_PREG='SE'.
IF RANGE(L_PLLSC, 320, 370) L_PREG='SW'.
IF RANGE(L_PLLSC, 380, 430) L_PREG='WM'.
IF RANGE(L_PLLSC, 440, 470) L_PREG='YH'.
IF L_PLLSC=490 L_PREG='NO'.
IF MISSING(L_PLLSC) OR L_PLLSC=-1 L_PREG='NA'. RECODE L_PLLSC (SYSMIS=-1). VARIABLE LABELS L_PREG ‘L_PREG Region of the Owning Provider’. |
Date last modified: 19th January 2009
