Analytical LAD Dataset

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 Analytical LAD is an export from the Learning Aims Database (LAD) into flat file format.

Purpose

2 The Analytical LAD contains information about all LSC-recognised learning aims offered by providers and enables more detailed analysis of provider provision.

Detailed definition

3 The LAD is a relational database with 14 main tables of data and approximately 40 lookup tables. An export in flat file format is produced by a Structured Query Language (SQL) query which joins tables with output fields named according to the mappings shown in Table 1.

4 In addition to data taken directly from the LAD there are a number of derived variables. The hyperlink from the field name for these derived variables is to the appropriate data definition.

Table 1 Fields in the Analytical LAD

LAD table

LAD field

Description

Analytical LAD field

LEARNING_AIM

LEARNING_AIM_REF

Learning Aim Reference

A09

LEARNING_AIM

LEARNING_AIM_TITLE

Learning Aim Title

A09_TITL

AWARDING_BODIES

AWARDING_BODY_CODE

Awarding Body Code

A_AWARDB

AWARDING_BODIES

NON_EXTANT

Awarding Body No Longer in Existence

A_AB_NEF

LEARNING_AIM

AWBODY_AIM_REF

Awarding Body Reference

A_QUALID

LEARNING_AIM

LEARNING_AIM_TYPE_CODE

Learning Aim Type

A_LATYPE

LEARNING_AIM

NOTIONAL_NVQ_LEVEL_CODE

Notional NVQ Level

A_NOTION

LEARNING_AIM

NOTIONAL_LEVEL_V2_CODE

Notional NVQ Level v2

A_NOTLV2

LEARNING_AIM

RECOMMENDED_INDICATOR_CODE

Recommended Indicator

A_RECIND

LEARNING_AIM

SUPERSEDING_LEARNING_AIM_REF

Superseding Aim Reference

A_SUPLAF

LEARNING_AIM

GENERIC_AIM_CODE

Generic Aim

A_GENAIM

LEARNING_AIM

TEMPORARY_AIM_CODE

Temporary Aim

A_TEMPIA

LEARNING_AIM

LEARNING_AIM_ON_ENTRY

Learning Aim On Entry

A_AIMENT

LEARNING_AIM

BASIC_SKILLS_DIAG_TEST

Basic Skills Diagnostic Test

A_BSKDIA

ALL_ANNUAL_VALUES

INDEP_LIVING_SKILLS

Independent Living Skill

A_INDLS

ALL_ANNUAL_VALUES

BASIC_SKILL

Counts towards Basic Skills Target

A_BSFLAG

ALL_ANNUAL_VALUES

BASIC_SKILL_TYPE_CODE

Basic Skills Type

A_BSTYPE

DV - Advanced Basic Skills Type

A_BSTYPA

DV - Basic Skills Participation

A_BSPAR

ALL_ANNUAL_VALUES

KEY_SKILL_CODE

Key Skill Type

A_KSCODE

ALL_ANNUAL_VALUES

LEVEL2_ENTITLEMENT_CAT_CODE

Full Level 2 Category

A_L2CAT

ALL_ANNUAL_VALUES

LEVEL2_PERCENTAGE

Full Level 2 %

A_L2PCT

ALL_ANNUAL_VALUES

LEVEL3_ENTITLEMENT_CAT_CODE

Full Level 3 Entitlement Category

A_L3CAT

ALL_ANNUAL_VALUES

LEVEL3_PERCENTAGE

Full Level 3 %

A_L3PCT

LEARNING_AIM

INSP_CODE_CODE

INSP Code

A_INSP_C

LEARNING_AIM

MAP_CODE_CODE

MAP Code

A_MAP_C

LEARNING_AIM

QCA_GLH

GLH from QCA

A_QCAGLH

ALL_ANNUAL_VALUES

AREA_OF_LEARNING_CODE

Area of Learning

A_AOL

ALL_ANNUAL_VALUES

SSA_TIER1_CODE

SSA Tier 1 Code

A_SSA_T1

ALL_ANNUAL_VALUES

SSA_TIER2_CODE

SSA Tier 2 Code

A_SSA_T2

ALL_ANNUAL_VALUES

LDCS_CODE_CODE

Learn Direct Classification System Code

A_LDCS

LEARNING_AIM

ENGLAND_FE_HE_STATUS_CODE

England FE/HE Status

A_ENGLEV

LEARNING_AIM

ENGLAND_PROG_AREA_CODE

Programme Area

A_PAREA

LEARNING_AIM

ENG_SUB_PROG_AREA_CODE

Sub Programme Area

A_SUBPRG

LEARNING_AIM

SUPERCLASS_CODE

1st Superclass Code

A_SUPRCL

LEARNING_AIM

SUPERCLASS2_CODE

2nd Superclass Code

A_SUPRC2

LEARNING_AIM

SUPERCLASS3_CODE

3rd Superclass Code

A_SUPRC3

LEARNING_AIM

LEAP_CODE

Leap Code

A_LEAP_C

LEARNING_AIM

ENGLAND_PRESCRIBED_ID_CODE

England Prescribed Code

A_ENG_PR

LEARNING_AIM

ENGLAND_SCHED2_CODE

England Schedule 2

A_ENG_S2

LEARNING_AIM

FLAG10

Accredited, not current DfES approved

FLAG10

LEARNING_AIM

FLAG11

Framework completion class code

FLAG11

LEARNING_AIM

FLAG12

Only for use on designated Approval Employer Framework

FLAG12

LEARNING_AIM

FLAG13

Accredited, but may not be DfES approved

FLAG13

LEARNING_AIM

FLAG14

Not in current use

FLAG14

ALL_ANNUAL_VALUES

SEC_96_PRE_16

Section96 Pre-16 Age Category

A_S96P16

ALL_ANNUAL_VALUES

SEC_96_16_18

Section96 16-18 Age Category

A_S96168

ALL_ANNUAL_VALUES

SEC_96_18_PLUS

Section96 18+ Age Category

A_S9618P

ALL_ANNUAL_VALUES

SEC_97_19_PLUS

Section97 19+ Age Category

A_S9719P

ALL_ANNUAL_VALUES

LSC_FUNDING_STATUS_CODE

LSC Funded Status

A_FUN_ST

FE_ANNUAL_VALUES

NATIONAL_RATE1

National Base Rate 1

A_NATRA1

FE_ANNUAL_VALUES

NATIONAL_RATE2

National Base Rate 2

A_NATRA2

FE_ANNUAL_VALUES

NATIONAL_RATE3

National Base Rate 3

A_NATRA3

FE_ANNUAL_VALUES

PROGRAMME_WGT_FACTOR_CODE

Programme Weighting Factor

A_PWFC

FE_ANNUAL_VALUES

FE_STATUS_CODE

FE Annual Value Status

A_FEAVC

WBL_ANNUAL_VALUES

TECHNICAL_CERTIFICATE

Technical Certificate

A_TECH_C

WBL_ANNUAL_VALUES

TECH_CERT_GLH

Technical Certificate GLH (not used from 0506 onwards)

A_TCGLH

WBL_ANNUAL_VALUES

FUNDING_CATEGORY_CODE

Funding Category

A_FUND_C

WBL_ANNUAL_VALUES

FUNDING_CAT_WEIGHTING

Funding Category Weighting

A_FCW

WBL_ANNUAL_VALUES

TC_RATE_1618

TC Rate 16-18 (used pre-0405)

A_TC1618

WBL_ANNUAL_VALUES

TC_RATE_19PLUS

TC Rate 19+ (used pre-0405)

A_TC19PL

WBL_ANNUAL_VALUES

RATE_1618

WBL Rate 16-18 (used from 0405 onwards)

A_WBL168

WBL_ANNUAL_VALUES

RATE_19PLUS

WBL Rate 19+ (used from 0405 onwards)

A_WBL19P

WBL_ANNUAL_VALUES

WBL_ANNUAL_VALUE_STATUS_CODE

WBL Annual Value Status

A_WBLAVC

ACL_ANNUAL_VALUES

ACL_ANNUAL_VAL_STATUS_CODE

ACL Annual Value Status

A_ACLAVC

ALL_ANNUAL_VALUES

AIM_NO_LONGER_OFFERED

Aim Reference No Longer Offered

A_NOLOFF

LEARNING_AIM

AIM_DISCONTINUED_DATE

Aim Reference Discontinued Date

A_ADISDA

ALL_ANNUAL_VALUES

NON_LSC_FUNDED_STATUS_CODE

All Annual Value Status

A_NLSCFC

LEARNING_AIM

DATE_AIM_LAST_CHANGED

Date Aim Last Changed

A_DALC

ALL_ANNUAL_VALUES

SKILLS_FOR_LIFE

Counts towards Skills For Life Target

A_SFL

ALL_ANNUAL_VALUES

SKILLS_FOR_LIFE_TYPE_CODE

Skills For Life Type

A_SFLTYP

DV - Advanced Skills For Life Type

A_SFLTYA

DV - Skills For Life Participation

A_SFLPAR

DV - Provision Mix of the aim

A_PROVMIX

Creator

Analysis and MI Team

Date issued

23 March 2006

Date created

17 February 2006

Document ref.

G:\Organisational Data\DCA\A&MI\Documentation\web data dictionary\Datasets\nat-analyticallad-report-23mar2006.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: 23 Mar 06