Aims Standard File

Note: This page is from an older version of the Data Dictionary and may therefore contain information that is now out of date. It is included here for reference only.

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. The definition of each variable is given in the ILR specification. The hyperlink will take you to the ILR page where you can view the latest specification.

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 last column of the table.

Figure 1 Fields in the Learning Aims Standard File

Field name

Description

Data Definition

COLLECTION

Collection (FE, WBL, ESFSE, UFI, ACL)

PERIOD

Period of the year this file relates to

Period

L01

Provider Number

L03

Learner reference number

A05

Learning aim data set sequence

A02

Contract/Allocation type

A04

Data set identifier code

A06

ESF co-financing data sets

A07

HE data sets

A08

Data set format

A09

Learning aim reference

A10

LSC Funding stream

A11A

Source of funding instance 1 of 2 (FE)

A11B

Source of funding instance 2 of 2 (FE)

A12A

Implied rate of LSC FE funding for ESF which is not LSC ESF co-financed (FE)

A12B

Implied rate of LSC FE funding for ESF which is not LSC ESF co-financed (FE)

A13

Tuition fee received for year (FE)

A14

Reason for partial or full non payment of fees (FE)

A15

Programme type (WBL)

A16

Programme entry route (WBL)

A17

Delivery mode (FE)

A18

Main delivery method (FE)

A19

Employer role (FE)

A20

Resit (FE)

A21

Franchised out and partnership arrangement (FE)

A22

Franchised out and partnership delivery provider number

A23

Delivery location postcode

A24

SOC 2000 occupation code relating to learner aim

A26

Sector framework of learning (WBL)

A27

Learning start date

A28

Learning planned end date

A31

Learning actual end date

A32

Guided learning hours (FE)

A33

Enhanced guided learning hours (FE)

A34

Completion status

A35

Learning outcome

A36

Learning outcome grade (FE)

A37

Number of units completed

A38

Number of units to achieve a full qualification

A39

Eligibility for achievement funding (FE)

A40

NVQ Achievement date (WBL)

A43

Sector framework achievement date (WBL)

A44

Placement employer name (WBL)

A45

Placement employer location postcode (WBL)

A46A

National learning aim monitoring instance 1 of 2

A46B

National learning aim monitoring instance 2 of 2

A47A

Local learning aim monitoring instance 1 of 2

A47B

Local learning aim monitoring instance 2 of 2

A48A

Provider specified learning aim data instance 1 of 2

A48B

Provider specified learning aim data instance 2 of 2

A49

Special Projects and pilots

A50

Reason learning ended

A51A

Proportion of funding remaining

A52

Distance learning funding

A53

Additional learning needs

A54

Broker contract number

A55

Unique learner numbe

A56

UK provider reference number

A_SSA_T1

LAD - SSA Tier 1 Code

Sector Subject Areas

A_SSA_T2

LAD - SSA Tier 2

Sector Subject Areas

A_ACT_A

DV - Actual current year GLH using 1 Nov 1 Feb 15 May (method A)

Current Year Guided Learning Hours

A_ACT_B

DV - Actual current year GLH using 1 Oct as first census date

Current Year Guided Learning Hours

A_AGEST

DV - Age of the learner as at the start date of aim

Age

A_AGESTB

DV - Age of the learner as at the start date of aim banded

Age

A_ATYPE

DV - Type of Aim

Aim Type

A_SFL

DV - 1/0 flag to indicate if the aim is basic skills or not

Skills for Life

A_DPLLSC

DV - LLSC of the Delivery Provider, based on the DP postcode/ L44 NCS delivery LSC number

Location of the Delivery Provider (Aim level)

A_DPREG

DV - Region of the Delivery Provider, based on the DP postcode/ L44 NCS delivery LSC number

Location of the Delivery Provider (Aim level)

A_DPWA01

DV - Local Authority ward code of the Delivery Provider (2001 census)

Location of the Delivery Provider (Aim level)

A_DPWA03

DV - Local Authority ward code of the Delivery Provider (2003 census)

Location of the Delivery Provider (Aim level)

A_DPWARD

DV - Local Authority ward code of the Delivery Provider (1991 census)

Location of the Delivery Provider (Aim level)

A_ESF

DV - Type of ESF aim

Type of ESF Aim

A_EXP_A

DV - Expected current year GLH using 1 Nov 1 Feb 15 May (method A)

Current Year Guided Learning Hours

A_EXP_B

DV - Expected current year GLH using 1 Oct as first census date

Current Year Guided Learning Hours

A_IL_P1

DV - In-Learning in Period 1

In Learning

A_IL_P2

DV - In-Learning in Period 2

In Learning

A_IL_P3

DV - In-Learning in Period 3

In Learning

A_IL_P4

DV - In-Learning in Period 4

In Learning

A_IL_P5

DV - In-Learning in Period 5

In Learning

A_IL_P6

DV - In-Learning in Period 6

In Learning

A_IL_P7

DV - In-Learning in Period 7

In Learning

A_IL_P8

DV - In-Learning in Period 8

In Learning

A_IL_P9

DV - In-Learning in Period 9

In Learning

A_IL_P10

DV - In-Learning in Period 10

In Learning

A_IL_P11

DV - In-Learning in Period 11

In Learning

A_IL_P12

DV - In-Learning in Period 12

In Learning

A_ILPY2D

DV - Number of periods in-learning in current year, year to date

In Learning

A_ILAVY2

DV - Average number of periods in-learning in current year to date

In Learning

A_LIS_FG

DV - LIS Funding Flag

LIS Funding Generated

A_JAN

DV - Aim was active on 1 Jan in this year

Active on Census Date

A_LEAVEP

DV - Period Left in

Leave Period

A_LIVE_A

DV - Status of aim for inclusion in analysis using 1 Nov as first census date (method A)

Status for Inclusion in Analysis

A_LIVE_B

DV - Status of aim for inclusion in analysis using 1 Oct as first census date (Method B)

Status for Inclusion in Analysis

A_NOV

DV - Aim was active on 1 Nov in this year

Active on Census Date

A_NVQLEV

DV - Notional NVQ level of the aim

Notional NVQ Level

A_OCT

DV - Aim was active on 1 October in this year

Active on Census Date

A_OPROV

DV - Is the aim other provision (1/0 flag)

Other Provision Flag

A_STARTP

DV - Period Started in

Start Period

A_STREAM

DV - Sources of funding for the aim

Source of Funding for the Aim

A_ACHIEVE

DV - NVQ Achieved Only on AIMS File

Achievement of NVQs

A_PROVMIX

DV - Other Provision Flag

Provision Mix Category

A_FFA

DV - Framework for Achievement Aim

Framework for Achievement

A_TTGAIN

DV - Train to Gain Aim

Train to Gain

A_TTGBROKE

DV - Train to Gain Brokered

Train to Gain

A_SFLPAR

DV - Skills For Life Participation

Skills For Life Participation

A_SFLTYA

DV - Advanced Skills For Life Type

Skills For Life Participation

L11

Date of birth

L12

Ethnicity

L13

Sex

L14

Learning difficulties and/or disabilities and/or health problems

L15

Disability

L16

Learning difficulty

L17

Home Postcode

L22

Current Postcode

L25

LSC number of funding LSC

L33

Disadvantage uplift factor (FE)

L35

Prior attainment level

L36

Learner status on last working day before learning (WBL)

L39

Destination (WBL)

L44

NCS delivery LSC number

L_ACT_B

DV - Actual current year GLH using 1 Oct 1 Feb 15 May

Current Year Guided Learning Hours

L_AGE

DV - Age of the learner as at 31 August 2003

Age

L_AGEB

DV - Age of the learner as at 31 August 2003 banded

Age

L_ATYPE

DV - In-year aim type of the learner

Aim Type

L_SFL

DV - 1/0 flag to indicate if the learner is a basic skills learner or not

Skills for Life

L_DISADV

DV - 1/0 flag to indicate IF the learner is considered to be disadvantaged or not

Disadvantaged Learner

L_DPLLSC

DV - LLSC of the Delivery Provider, based on the DP postcode/ L44 NCS delivery LSC number

Location of the Delivery Provider (Learner level)

L_DPREG

DV - Region of the Delivery Provider, based on the DP postcode/ L44 NCS delivery LSC number

Location of the Delivery Provider (Learner level)

L_DPLA

DV - Local Authority based on the Learner DP postcode

Location of the Delivery Provider (Learner level)

L_DPWA01

DV - Local Authority ward code of the Delivery Provider (2001 census)

Location of the Delivery Provider (Learner level)

L_DPWA03

DV - Local Authority ward code of the Delivery Provider (2003 census)

Location of the Delivery Provider (Learner level)

L_DPWARD

DV - Local Authority ward code of the Delivery Provider (1991 census)

Location of the Delivery Provider (Learner level)

L_EXP_B

DV - Expected current year GLH using 1 Oct 1 Feb 15 May

Current Year Guided Learning Hours

L_FRANCH

DV - does the learner have any franchised aims (1/0 flag)

Franchised Aim

L_FTELP

DV - Full time equivalent learner profile method i.e expected learner cyglh/450, up to a maximum value of 1 FTE.

Full Time Equivalent

L_FULLLEVEL2

DV - Full NVQ level 2 learner flag

Full Level 2 & 3 

L_FULLLEVEL3

DV - Full NVQ level 3 learner flag

Full Level 2 & 3

L_FUND

DV - Sources of funding for the learner

Source of Funding

L_OCT

DV - Learner was active on 1 Oct in this year

Active on Census Date

L_LIVE_B

DV - Status of aim for inclusion in analysis using 1 Oct as first census date (Method B)

Status for Inclusion in Analysis

L_LLLSC

DV - Home LSC of the Learner, based on the Learner postcode

Location of the Learner

L_LREG

Home Region of the Learner, based on the Learner postcode

Location of the Learner

L_LLA

DV - Local Authority based on the Learner postcode

Location of the Learner

L_LWAR01

DV - Local Authority ward code of the Learner (2001 census)

Location of the Learner

L_LWAR03

DV - Local Authority ward code of the Learner (2003 census)

Location of the Learner

L_LWARD

DV - Local Authority ward code of the Learner (1991 census)

Location of the Learner

L_MODE_B

DV - Learners mode attendance using 1 Nov, 1 Feb, 15 May (Method B)

Mode of Attendance

L_NVQLEV

DV - NVQ level of the learner

Notional NVQ Level

L_LIS_FG

DV - LIS Funding Flag

LIS Funding Generated

L_PLLSC

DV - LLSC based on the 1-1 'owner' relationship UPIN to LLSC

Location of the Provider

L_PREG

DV - Region of the Owning Provider, based on the Learner postcode

Location of the Provider

L_PLA

DV - Local Authority based on the Provider postcode

Location of the Provider

L_PWAR01

DV - Local Authority ward code of the Owning Provider (2001 census)

Location of the Provider

L_PWAR03

DV - Local Authority ward code of the Owning Provider (2003 census)

Location of the Provider

L_PWARD

DV - Local Authority ward code of the Owning Provider (1991 census)

Location of the Provider

L_UPLF56

DV - 05/06 Widening participation uplift factor based on learners postcode prior to enrolling

Widening Participation Uplift Factors

L_UPLF67

DV - 06/07 Widening participation uplift factor based on learners postcode prior to enrolling

Widening Participation Uplift Factors

L_TTGAIN

DV - Train to Gain Learner

Train to Gain

Creator

Analysis and MI Team

Date issued

26 September 2006

Date created

18 October 2005

Document ref.

G:\Organisational Data\DCA\A&MI\Documentation\web data dictionary\200607\Datasets\nat-aimsstandardfile-report-26sep2006.doc

LSC office

Learning and Skills Council
Cheylesmore House Quinton Road Coventry CV1 2WT
T 0845 019 4170 F 024 7682 3675 www.lsc.gov.uk

Last Modified: 27 Sep 06