Aims Standard File 2009/2010

 

NOTE: Standard File Views are open to change

1. The Learning Aims Standard File has one row of data per aim.

PURPOSE

2. The Learning Aims Standard File is used for the analysis of aims level data. For example, creating reports indicating the proportion of sector subject areas studied (A_SSA_T1 and A_SSA_T2) within various geographical areas.

3. This dataset is part of the following collections

  • The Standard Files Collection

DETAILED DEFINITION

4. The standard files are created by running the 'standard code' on the raw data collected using the Individualised Learner Record (ILR). The standard code introduces a number of derived variables to the data which are stored in the standard files. The data is converted to both SPSS and Crystal format for analysis and reporting.

5. A learner can have a number of aim records and each aim record is uniquely identified by a combination of the Provider Number (L01), the Learner Reference Number (L03) fields and the Learning aim data set sequence (A05) fields.

6. The table below shows the fields within the Learning Aims Standard File.

7. Where the variable name is of the form 'Lxx' or 'Axx' (where xx is a two digit number) then this is taken from the field of the same name in the Individualised Learner Record (ILR) datasets. Definitions for these variables are available in the 2008/09 ILR Specification on the Information Authority Website.

8. The definitions for the aims level Derived Variables (those with 'A_' prefix) and some learner level Derived Variables (those with 'L_' prefix) can be found by following the hyperlinks in the Variable Name column of the table.

Figure 1. Fields in the Learning Aims Standard File

Variable Name Variable Label Data Definition Field Type Field Length
Year YEAR Academic Year of Dataset String 8
COLLECTION Collection Funding Stream
(LR, ER, ESF SR, UfI, ACL)		   String 3
PERIOD PERIOD Collection Period
Data Contains		 Period Numeric
L01 L01 Provider Number   Numeric 6
L03 L03 Learner Reference Number   String 12
A05 A05 Leaning Aim Data Set Sequence   Numeric 2
A02 A02 Contract Allocation Type   Numeric 2
A04 A04 Data Set Identifier Code   Numeric 2
A07 A07 HE Data Sets   Numeric 2
A08 A08 Data Set Format   Numeric 1
A09 A09 Aim Reference   String 8
A10 A10 LSC Funding Stream   Numeric 2
A11A A11a Source Of Funding   Numeric 3
A11B A11b Source Of Funding   Numeric 3
A13 A13 Tuition Fee Received
For Year		   Numeric 5
A14 A14 Reason For Partial
Or Full Non Payment Of Fees		   Numeric 2
A15 A15 Programme Type   Numeric 2
A16 A16 Programme Entry Route   Numeric 2
A17 A17 Delivery Mode   Numeric 1
A18 A18 Main Delivery Method   Numeric 2
A19 A19 Employer Role   Numeric 1
A20 A20 Resit   Numeric 1
A21 A21 Franchised Out And
Partnership Arrangements		   Numeric 2
A22 A22 Franchised Out And
Partnership Delivery
Provider Number		   String 8
A23 A23 Delivery Location Postcode   String 8
A26 A26 Sector Framework
Of Learning		   Numeric
A27 A27 Learning Start Date   Date
A28 A28 Learning Planned End Date   Date
A31 A31 Learning Actual End Date   Date
A32 A32 Guided Learning Hours   Numeric 5
A34 A34 Completion Status   Numeric 1
A35 A35 Learning Outcome   Numeric 1
A36 A36 Learning Outcome Grade   String 6
A40 A40 Achievement Date   Date
A44 A44 Employer Identifier   String 30
A45 A45 Workplace Location Postcode   String 8
A46A A46a National Aim
Monitoring Instance		   Numeric 3
A46B A46b National Aim
Monitoring Instance		   Numeric 3
A47A A47a Local Aim
Monitoring Instance 1 Of 2		   Numeric 12
A47B A47b Local Aim
Monitoring Instance 2 Of 2		   Numeric 12
A48A A48a Provider Specified
Aim Data Instance 1 Of 2		   String 12
A48B A48b Provider Specified
Aim Data Instance 2 Of 2 		   String 12
A49 A49 Special Projects
And Pilots		   String 5
A50 A50 Reason Learning Ended   Numeric 2
A51A A51a  Proportion Of
Funding Remaining		   Numeric 3
A52 A52 Distance Learning SLN   Numeric 5,3
A53 A53 Additional Learning Needs   Numeric 2
A54 A54 Broker Contract Number   String 10
A55 A55 Unique Learner Number   Numeric 10
A56 A56 UK Provider
Reference Number 		   Numeric 8
A57 A57 Source of Tuition Fees   Numeric 2
A58 A58 ASL provision type   Numeric 2
A59 A59 Planned credit   Numeric 3
A60 A60 Credit achieved   Numeric 3
A61 A61 Project Dossier Number String 9
A62 A62 ESF Local Project Number Numeric 3
A63 A63 National Skills
Academy		 Numeric 2
A64 A64 Planned Group
Based Hours		 Numeric 5
A65 A65 Planned One to One
Contact Hours		 Numeric 5
A66 A66 Employment Status
on Day Before Starting
Learning Aim		 Numeric 2
A67 A67 Length of Unemployment
Before Starting ESF Project		 Numeric 2
A68 A68 Employment Outcome Numeric 2
P_ACTIVE P_ACTIVE Programme Active Active Numeric 1
A_ACTIVE A_ACTIVE Aim Active
for the current academic year		 Active Numeric 1
A_FUNDINGSOURCE A_FUNDINGSOURCE
Source of funding for the aim		 Funding Sources Numeric 1
A_AGEST A_AGEST Age Of The Learner
As At The Start Date Of Aim		 Age Numeric 5
A_AGESTB A_AGESTB Age Of The Learner
As At The Start Date Of
Aim Banded		 Age Numeric 1
A_AGESTBAND A_AGESTBAND Age of
the learner as at the start
date of aim banded as
16-18 and 19+		 Age Numeric 1
A_ATYPE A_ATYPE Type Of Aim Aim Type Numeric 2
A_DPLA A_DPLA Local Authority
Based On The Aim DP Postcode		 Location of the Delivery Provider (Aim Level) Data Definition String 8
A_DPLLSC A_DPLLSC LLSC Of
The Aim Delivery Provider,
Based On The DP Postcode		 Location of the Delivery Provider (Aim Level) Numeric
A_DPREG A_DPREG Region Of
The Aim Delivery Provider,
Based On The DP Postcode 		 Location of the Delivery Provider (Aim Level) String 4
A_DPWA01 A_DPWA01 Local Authority
Ward Code Of The Aim
Delivery Provider 		 Location of the Delivery Provider (Aim Level) String 6
A_DPWA03 A_DPWA03 Local Authority
Ward Code Of The
Aim Delivery Provider 		 Location of the Delivery Provider (Aim Level) String 6
A_DPWARD A_DPWARD Local Authority
Ward Code Of The
Aim Delivery Provider 		 Location of the Delivery Provider (Aim Level) String 6
A_FE_PROVMIX_MATRIX A_FE_PROVMIX_MATRIX
FE provision mix matrix		 Provision Mix Matrix Numeric 3
A_FE_PROVMIX_
MATRIX_SUMM		 A_FE_PROVMIX_MATRIX
SUMM FE provision
mix matrix summary		 Provision Mix Matrix Summary Numeric
A_OPROV A_OPROV Aim Other Provision Other Provision Flag Numeric 1
A_FRANCH A_FRANCH Franchised Aim Franchised Aim Numeric 1
A_QCF A_QCF Qualification and
Credit Framework Aim		 Qualifications and Credit Framework Numeric 1
A_IL_P1 A_IL_P1 In-Learning In
Period 1, 0809		 In Learning Numeric 1
A_IL_P2 A_IL_P2 In-Learning In
Period 2, 0809		 In Learning Numeric 1
A_IL_P3 A_IL_P3 In-Learning In
Period 3, 0809		 In Learning Numeric 1
A_IL_P4 A_IL_P4 In-Learning In
Period 4, 0809		 In Learning  Numeric 1
A_IL_P5 A_IL_P5 In-Learning In
Period 5, 0809		 In Learning Numeric 1
A_IL_P6 A_IL_P6 In-Learning In
Period 6, 0809		 In Learning Numeric 1
A_IL_P7 A_IL_P7 In-Learning In
Period 7, 0809		 In Learning Numeric 1
A_IL_P8 A_IL_P8 In-Learning In
Period 8, 0809		 In Learning Numeric 1
A_IL_P9 A_IL_P9 In-Learning In
Period 9, 0809		 In Learning Numeric 1
A_IL_P10 A_IL_P10 In-Learning In
Period 10, 0809		 In Learning Numeric 1
A_IL_P11 A_IL_P11 In-Learning In
Period 11, 0809		 In Learning Numeric 1
A_IL_P12 A_IL_P12 In-Learning In
Period 12, 0809		 In Learning Numeric 1
A_ILAVY2 A_ILAVY2 Average
Number Of Periods
In-Learning In Current
Year To Date		 In Learning Numeric 15,5
A_ILPY2D A_ILPY2D Number Of
Periods In-Learning In
Current Year,
Year To Date		 In Learning Numeric 2
A_INYR_ACTUAL_GLH A_INYR_ACTUAL_GLH
Aim Actual current year GLH		 Current year Guided Learning Hours (CYGLH) Numeric 15,5
A_INYR_EXPECTED_GLH A_INYR_EXPECTED_GLH
Aim Expected current year GLH		 Current year Guided Learning Hours (CYGLH) Numeric 15,5
A_JAN A_JAN Aim Active On
1 January In This Year		 Active on Census Date Numeric 1
A_OCT A_OCT Aim Active On
1 October In This Year		 Active on Census Date Numeric 1
A_NOV A_NOV Aim Active On
1 November In This Year		 Active on Census Date Numeric 1
A_L2WID A_L2WID Level 2 width
for full level 2 and GCSE aims
 Aim Contribution to Full level 2 and Full level 3 Numeric 15,5
A_L3WID A_L3WID Level 3 width
for full level 3 and As/A2 aims		 Aim Contribution to Full level 2 and Full level 3 Numeric 15,5
A_LEAVEP A_LEAVEP Period Left In Leave Period Numeric 2
A_NOTIONLEV A_NOTIONLEV Notional
NVQ Level Of The Aim		 Notional NVQ Level Numeric 1
A_SFL A_SFL Counts towards
Skills For Life Target		 Skills for Life Flags Numeric 1
A_SFL_LEITCH_LIT A_SFL_LEITCH_LIT
Leitch Skills For Life
Literacy Aim		 Skills for Life (SFL) LEITCH Literacy Numeric 1
A_SFL_LEITCH_LIT_ACH A_SFL_LEITCH_LIT_ACH
Leitch Skills For
Life Literacy Achiever		 Skills for Life (SFL) LEITCH Literacy Achievers  Numeric 1
A_SFL_LEITCH_NUM A_SFL_LEITCH_NUM 
Leitch Skills For
Life Numeracy Aim		 Skills for Life (SFL) LEITCH Numeracy Numeric 1
A_SFL_LEITCH_NUM_ACH A_SFL_LEITCH_NUM_ACH
Leitch Skills For
Life Numeracy Achiever		 Skills for Life (SFL) LEITCH Numeracy Achievers Numeric 1
A_SFLP A_SFLP Skills For Life
Participation		 Skills for Life Participation Numeric 1
A_SFLTY A_SFLTY Skills For Life
type		 Skills for Life Participation Numeric 1
A_SFLTYP A_SFLTYP Advanced Skills
For Life Type including Level
and Awarding Body		   Numeric 2
  A_SLN Standard Learner
Number DO NOT USE		   String 5
A_SSA_T1 LAD SSA Tier 1 Code Sector Subject Areas String 5
A_SSA_T2 LAD SSA Tier 2 Code Sector Subject Areas String 15
A_SECTOR_LEAD A_SECTOR_LEAD SSC
Other Body With Aim
Within Footprint		 String 2
A_STARTP A_STARTP Period
Started In 		 Start Period Numeric 1
A_TTGAIN A_TTGAIN Train To Gain Aim Train To Gain Numeric 1
A_TTGBROKE A_TTGBROKE
Train To Gain Brokerage		 Train To Gain Numeric 15,5
P_AVIL P_AVIL Learner average
in learning at Programme Level		 Learner average in learning at Programme Level Numeric 15,5
P_AVILY2D P_AVILY2D Learner
average in learning at
Programme Level
year to date		 Learner average in learning at Programme Level Numeric
P_NVQ_ACH_DATE P_NVQ_ACH_DATE
Achievement of NVQ		 Programme Achievement of NVQs Date 2
P_PROG_STATUS P_PROG_STATUS
Status of NVQ  Framework		 Programme Status Numeric
L11 L11 Date Of Birth   Date 2
L12 L12 Ethnicity   Numeric 1
L13 L13 Sex   String 1
L14 L14 Learning Difficulties
And Or Disabilities
And Or Health Problems		   Numeric 2
L15 L15 Disability   Numeric 2
L16 L16 Learning Difficulty   Numeric 8
L17 L17 Home Postcode   String 8
L22 L22 Current Postcode   String 8
L25 L25 LSC Number Of
Funding LSC		   Numeric 2
L25_REG L25_REG Region of the
Funding LSC		 Region of the Funding LSC String 1
L27 L27 Restricted Use Indicator   Numeric 6,4
L33 L33 Disadvantage Uplift Factor   Numeric 2
L35 L35 Prior Attainment Level   Numeric 2
L39 L39 Destination   Numeric
L44 L44 Ncs Delivery LSC
Number		   Numeric 10
L45 L45 Unique Learner
Number		   Numeric 8
L46 L46 UK Provider Reference
Number		   Numeric 1
L_ACTIVE L_ACTIVE Learner
Active for the current
academic year		 Active Numeric 1
L_FUND L_FUND Sources Of
Funding For The Learner		 Sources of Funding Numeric 1
L_FUNDINGSOURCE L_FUNDINGSOURCE
Source of funding
 for the learner		 Numeric 1
L_INYR_ACTUAL_GLH L_INYR_ACTUAL_GLH
Actual In Year GLH		 Current Year Guided Learning Hours (CYGLH) Numeric 15,5
L_INYR_EXPECTED_GLH L_INYR_EXPECTED_GLH 
Expected In Year GLH		 Current Year Guided Learning Hours (CYGLH) Numeric 15,5
L_AGE L_AGE Age Of The
Learner As At 31 August		 Age Numeric 5
L_AGEB L_AGEB Age Of
Learner As At 31
August Banded		 Age Numeric 1
L_AGEBAND L_AGEBAND Age of
learner as at 31 August
16-18 and 19+ Bands		 Age Numeric 1
L_ATYPE L_ATYPE In-Year Aim
Type For A The Learner		 Aim Type Numeric
L_DISADV L_DISADV Learner
Disadvantaged		 Disadvantaged Learner Numeric 1
L_DPLA L_DPLA Local Authority
Based on the Delivery
Location Postcode		 Location of the Delivery Provider String 4
L_DPLLSC L_DPLLSC LLSC of the
Delivery Location Postcode		 Location of the Delivery Provider Numeric
L_DPREG L_DPREG Region of the
Delivery Location Postcode		 Location of the Delivery Provider (Learner Level) String 2
L_DPWA01 L_DPWA01 Local
Authority Ward of the
Delivery Location
Postcode (2001 Census)		 Location of the Delivery Provider (Learner Level) String 6
L_DPWA03 L_DPWA03 Local
Authority Ward of the
Delivery Location
Postcode (2003 Census)		 Location of the Delivery Provider (Learner Level) String 6
L_DPWARD L_DPWARD Local
Authority Ward of the
Delivery Location
Postcode (1991 Census)		 Location of the Delivery Provider (Learner Level) String 6
L_QCF L_QCF Qualifications
and Credit Framework
Learner		 Qualifications and Credit Framework Numeric 1
L_FULLLEVEL2 L_FULLLEVEL2 Full
Level 2 Learner		 Full Level 2 and 3 Numeric 1
L_FULLLEVEL2_ACHIEVE L_FULLLEVEL2_ACHIEVE
Full Level 2 Achievement Learner		 Full Level 2 and 3 Achievement Numeric 1
L_FULLLEVEL2_COMPLETE L_FULLLEVEL2_COMPLETE
Full Level 2 Completion Learner		 Full Level 2 and 3 Completion Numeric 1
L_FIRST_FULLLEVEL2 L_FIRST_FULLLEVEL2
First Full Level 2 Learner		 First Full Level 2 and 3 and First Full Level 2 and 3 Achievement Numeric 1
L_FIRST_FULLLEVEL2
_ACHIEVE		 L_FIRST_FULLLEVEL2_
ACHIEVE
First Full Level 2
Achievement Learner		 First Full Level 2 and 3 and First Full Level 2 and 3 Achievement Numeric 1
L_FULLLEVEL3 L_FULLLEVEL3
Full Level 3 Learner		 Full Level 2 and 3 Numeric 1
L_FULLLEVEL3_ACHIEVE L_FULLLEVEL3_ACHIEVE
Full Level 3 Achievement Learner		 Full Level 2 and 3 Achievement Numeric 1
L_FULLLEVEL3_COMPLETE L_FULLLEVEL3_COMPLETE
Full Level 3 Completion Learner		 Full Level 2 and 3 Completion Numeric 1
L_FIRST_FULLLEVEL3 L_FIRST_FULLLEVEL3
First Full Level 3 Learner		 First Full Level 2 and 3 and First Full Level 2 and 3 Achievement Numeric 1
L_FIRST_FULLLEVEL3
_ACHIEVE		 L_FIRST_FULLLEVEL3_
ACHIEVE
First Full Level 3 Achievement Learner		 First Full Level 2 and 3 and First Full Level 2 and 3 Achievement Numeric 1
L_FRANCH L_FRANCH Franchised Aims Franchised Aim Numeric 1
L_FTELP L_FTELP Full Time Equivalent Full Time Equivalent Numeric
L_OCT L_OCT Learner Active
On 1 October In This Year		 Active on Census Date Numeric 1
L_NOV L_NOV Learner Active
On 1 November In This Year		 Active on Census Date Numeric 1
L_JAN L_JAN Learner Active
On 1 January In This Year		 Active on Census Date Numeric 1
L_LLLSC L_LLLSC Home LSC
of Learner Postcode		 Location of the Learner Numeric
L_LREG L_LREG Home Region
of Learner Postcode		 Location of the Learner String 2
L_LLA L_LLA Local Authority
of Learner Postcode		 Location of the Learner String 4
L_LWAR01 L_WAR01 Local Authority
Ward Code of
Learner Postcode (2001 Census)		 Location of the Learner String 6
L_LWAR03 L_WAR03 Local Authority
Ward Code of Learner
Postcode (2003 Census)		 Location of the Learner String 6
L_LWARD L_LWARD Local Authority
Ward Code of
Learner Postcode (1991 Census)		 Location of the Learner String 6
L_MODE_B L_MODE_B Learners
Mode Of Attendence
Using 1 Oct 1 Feb 15 May		 Mode of Attendance Numeric
L_NOTIONLEV L_NOTIONLEV
Notional NVQ Level Of Learner		 Notional NVQ Level Numeric
L_PLLSC L_PLLSC LLSC
Based On The 1-1
Owner Relationship
UPIN To LLSC		 Location of the Provider Numeric
L_PREG L_PREG Region Of
The Owning Provider		 Location of the Provider String 2
L_PLA L_PLA Local Authority
Based On The Provider Postcode		 Location of the Provider String 4
L_PWAR01 L_PWAR01 Local
Authority Ward
Code Of The Owning
Provider Postcode (2001 Census)		 Location of the Provider String 6
L_PWAR03 L_PWAR03 Local Authority
Ward Code Of The
Owning Provider Postcode
(2003 Census) 		 Location of the Provider String 6
L_PWARD L_PWARD Local Authority
 Ward Code Of The
Owning Provider Postcode
(1991 Census) 		 Location of the Provider String 6
L_SFL L_SFL Learner Counts
Towards Skills For Life Target		 Skills for Life Flags Numeric 1
L_SFL_LEITCH_LIT L_SFL_LEITCH_LIT
Leitch Skills For Life
Literacy Learner		 Skills for Life (SFL) LEITCH Literacy Numeric 1
L_SFL_LEITCH_LIT_ACH L_SFL_LEITCH_ACH
Leitch Skills For Life
Literacy Achiever		 Skills for Life (SFL) LEITCH Literacy Achievers Numeric 1
L_SFL_LEITCH_NUM L_SFL_LEITCH_NUM
Leitch Skills For Life
 Numeracy Learner		 Skills for Life (SFL) LEITCH Numeracy Numeric 1
L_SFL_LEITCH_NUM_ACH L_SFL_LEITCH_NUM_ACH
 Leitch Skills For
Life Numeracy Achiever		 Skills for Life (SFL) LEITCH Numeracy Achievers Numeric 1
L_SLN L_SLN Standard Learner
 Number (DO NOT USE)		   1
L_TTGAIN L_TTGAIN Train To
Gain Learner		 Train to Gain Numeric 15,5
L_UPLF0910 L_UPLF0910 0910
Widening Participation
Uplift Factor Based
On Learner Postcode		 Widening Participation Uplift Factors Numeric 15,5
L_UPLF78 L_UPLF78 0708
Widening Participation
Uplift Factor Based
On Learner Postcode		 Widening Participation Uplift Factors Numeric 15,5
L_UPLF89 L_UPLF89 0809 Widening
Participation Uplift Factor
Based On Learner Postcode		 Widening Participation Uplift Factors Numeric 1
A_IY_QUALIFYING
_SLN_PERIOD		 A_IY_QUALIFYING_
SLN_PERIOD Aim
Passes In Year Qualifying
Period to be Eligible to
Generate SLN		 In Year Qualifying SLN Period Numeric 1
A_TODATE_QUALIFYING
_SLN_PERIOD		 A_TODATE_QUALIFYING_
SLN_PERIOD Aim Passes the Qualifying Period in Any Year to be Eligible to Generate SLN		 To Date Qualifying SLN Period Numeric
A_IY_SLN_PAYMENT A_IY_SLN_PAYMENT Does the Aim generate SLN or receive an In Year Payment, up to the current period In Year SLN Payment Numeric
P_IY_SLN_PAYMENT P_IY_SLN_PAYMENT Programme generates SLN or receives an In Year Payment, up to the current period In Year SLN Payment Numeric
L_IY_SLN_PAYMENT L_IY_SLN_PAYMENT Learner Received SLN or Payment This Year To Date In Year SLN Payment Numeric
A_PRIOR_SLN_PAYMENT A_PRIOR_SLN_PAYMENT Has the Aim generated SLN or received a Payment in Previous Years Prior SLN Payment Numeric
P_PRIOR_SLN_PAYMENT P_PRIOR_SLN_PAYMENT Programme generated SLN or received a Payment Prior to this Year Prior SLN Payment Numeric
L_PRIOR_SLN_PAYMENT L_PRIOR_SLN_PAYMENT Learner Received an SLN or Payment in Previous Year(s) Prior SLN Payment Numeric
A_TO_DATE_SLN_PAYMENT A_TO_DATE_SLN_PAYMENT Aim generated SLN or received a Payment in Previous Years or In this Year To Date SLN Payment Numeric
P_TO_DATE_SLN_PAYMENT P_TO_DATE_SLN_PAYMENT Programme generated SLN or received a Payment in Previous Years or In this Year To Date SLN Payment Numeric
L_TO_DATE_SLN_PAYMENT L_TO_DATE_SLN_PAYMENT Learner generated SLN or received Payment in Previous Years or In this Year To Date SLN Payment Numeric
A_IL_IY A_IL_IY Aim in learning in Year In Learning in Year Numeric 1
P_IL_IY P_IL_IY Programme in learning in Year In Learning in Year Numeric 1
L_IL_IY L_IL_IY Learner in learning in Year In Learning in Year Numeric 1
A_FULLY_FUNDED A_FULLY_FUNDED Aim fully funded Fully Funded Numeric 3
A_FUNDED_AGE_BAND A_FUNDED_AGE_BAND Age Band Used in DLF Funding Calc Age Numeric 3

Date last modfied: 28th July 2009