LARS table and field definitions version 011 applicable from August 2025
Source: data.gov.uk (2026-01-13)

Learning Aim Reference Service. Learning Aim Reference Service (LARS) offers a web based search facility.  It allows users to search by most commonly used fields for Qualifications, Units, Apprenticeship Frameworks and Apprenticeship Standards and their associated validity and funding details.

LARS downloads are available to allow colleges, training organisations and employers (providers) to interrogate the same LARS data set that is used in the Funding Information System (FIS).

Table and field 
definitions for  
the Learning Aim 
Reference Service 
Version 11 
 
June 2025 

2 
Table of contents 
Introduction 
6 
Changes from the 2024 to 2025 version 
7 
Renamed tables in version 011’s structure 
7 
Deleted tables 
7 
Existing tables amended in version ‘011’ structure 
7 
New tables created in version 011’s structure 
8 
Version 011 table and field definitions – core tables 
8 
LARS_Annual Value 
9 
LARS_ApprenticeshipFunding 
10 
LARS_ApprenticeshipFunding - Continued 
11 
LARS_CareerLearningPilot 
12 
LARS_DataGeneration 
12 
LARS_Devolved_Funding 
13 
LARS_Framework 
14 
LARS_Framework - Continued 
15 
LARS_FrameworkAims 
16 
LARS_FrameworkCmnComp 
17 
LARS_Funding 
18 
LARS_HECoS 
18 
LARS_LearningDelivery 
19 
LARS_LearningDelivery – continued 
20 
LARS_LearningDelivery – continued 
21 
LARS_LearningDelivery – continued 
22 
LARS_LearningDeliveryCategory 
23 
LARS_Programme 
23 
LARS_ProgrammeAims 
24 
LARS_ProgrammeFunding 
25 
LARS_Section96 
26 
LARS_Standard 
27 
LARS_StandardAims 
28 
LARS_StandardCommonComponent 
28 
LARS_StandardFunding 
29 

3 
LARS_StandardValidity 
30 
LARS_TechnicalRoute 
30 
LARS_TLevelPathway 
31 
LARS_Validity 
31 
LARS_Version 
32 
Version 011 table and field definitions – reference tables 
33 
LARS_A2LevelIndicator_Lookup 
33 
LARS_AcademicYear_Lookup 
34 
LARS_AccessHEIndicator_Lookup 
34 
LARS_AdultSkillsFundingBand_Lookup 
34 
LARS_ALevelIndicator_Lookup 
35 
LARS_ApprenticeshipComponentType_Lookup 
35 
LARS_ApprenticeshipStandardType_Lookup 
35 
LARS_AreaCode_Lookup 
35 
LARS_ASLevelIndicator_Lookup 
35 
LARS_AwardOrgCode_Lookup 
36 
LARS_BandNumber_Lookup 
36 
LARS_BasicSkills_Lookup 
37 
LARS_BasicSkillsBroadType_Lookup 
37 
LARS_BasicSkillsParticipation_Lookup 
37 
LARS_BasicSkillsType_Lookup 
37 
LARS_Category_Lookup 
37 
LARS_CommonComponent_Lookup 
37 
LARS_CreditBasedFwkType_Lookup 
37 
LARS_DanceandDramaIndicator_Lookup 
38 
LARS_Devolved_SoF_Lookup 
38 
LARS_EFACOFType_Lookup 
38 
LARS_EnglandFEHEStatus_Lookup 
38 
LARS_EngPrscID_Lookup 
38 
LARS_EntrySubLevel_Lookup 
38 
LARS_FullLevel2EntitlementCategory_Lookup 
39 
LARS_FullLevel3EntitlementCategory_Lookup 
39 
LARS_FunctionalSkillsIndicator_Lookup 
39 
LARS_FundingCategory_Lookup 
39 

4 
LARS_GCEIndicator_Lookup 
39 
LARS_GCSEIndicator_Lookup 
39 
LARS_HECoSCode_Lookup 
40 
LARS_IssuingAuthority_Lookup 
40 
LARS_KeySkillsIndicator_Lookup 
40 
LARS_LearnAimRefType_Lookup 
40 
LARS_LearnDirectClassSystemCode_Lookup 
41 
LARS_LearningDeliveryGenre_Lookup 
41 
LARS_MI_Fulllevel2Indicator_Lookup 
41 
LARS_MI_Fulllevel3Indicator_Lookup 
41 
LARS_MI_NotionalNVQLevel_Lookup 
41 
LARS_MI_NotionalNVQLevelv2_Lookup 
41 
LARS_NotionalNVQLevel_Lookup 
41 
LARS_NotionalNVQLevelv2_Lookup 
41 
LARS_OccupationalIndicator_Lookup 
41 
LARS_OfQualOfferedEngland_Lookup 
42 
LARS_OfQualValid19Plus_Lookup 
42 
LARS_ProgType_Lookup 
42 
LARS_QCFCertificateIndicator_Lookup 
42 
LARS_QCFDiplomaIndicator_Lookup 
42 
LARS_QCFindicator_Lookup 
42 
LARS_QltyAssAgencyType_Lookup 
42 
LARS_RecognisedHEForOfSFundingPurposes_Lookup 
43 
LARS_Route_Lookup 
43 
LARS_Section96ApprovalStatus_Lookup 
44 
LARS_Section96Valid16to18_Lookup 
44 
LARS_Section96Valid18plus_Lookup 
44 
LARS_Section96ValidPre16_Lookup 
44 
LARS_SectorSubjectArea_Lookup 
45 
LARS_SectorSubjectAreaTier1_Lookup 
45 
LARS_SectorSubjectAreaTier2_Lookup 
45 
LARS_SFAApprovalStatus_Lookup 
45 
LARS_SFAFundedIndicator_Lookup 
46 
LARS_SourceURLLinkType_Lookup 
46 

5 
LARS_StandardSectorCode_Lookup 
46 
LARS_SuccessRateMapCode_Lookup 
46 
LARS_ValidityCategory_Lookup 
47 
LARS_ValidityFundingMapping_Lookup 
47 
 
 
 
 
 

6 
Introduction 
This document provides the table and field definitions that will be available in the 
downloadable database produced from the Learning Aim Reference Service (LARS).     
To allow structural changes to the LARS database within an academic year the 
downloads will be identified by a version number. This document describes version ‘011’ 
which will apply from 1 August 2025.  Version ‘010’ will still be produced until the end of 
the 2024 to 2025 collection year in October 2025. 
For software suppliers and providers that write their own software this issue is a draft 
version.  This version may be subject to change prior to finalisation depending upon 2025 
to 2026 requirements. 
Available versions of LARS for download can be found on the FALA Download page. 
This document identifies two categories of tables: 
• core tables – these hold the main (‘base’) details relating to learning aims, 
apprenticeship frameworks, apprenticeship standards, validity rules (for when the 
record is available for funding) and funding rates 
• reference tables – these hold details of the reference data used within the core 
tables 
 
 

7 
Changes from the 2024 to 2025 version 
This section outlines the changes that have been made from the 2024 to 2025 funding 
year structure.  
Renamed tables in version 011’s structure 
We have not renamed any tables for version ‘011‘. 
Deleted tables 
No reference tables (_Lookup) have been deleted for version ‘011’. 
No CORE tables have been deleted for version ‘011’. 
Existing tables amended in version ‘011’ structure 
From version ‘011’ the following tables have additional fields as shown below: 
Table Name 
Content description 
LARS_ApprenticeshipFunding 
FoundationAppFirstEmpPayment 
LARS_ApprenticeshipFunding 
FoundationAppSecondEmpPayment 
LARS_ApprenticeshipFunding 
FoundationAppThirdEmpPayment 
LARS_ApprenticeshipFunding 
ReservedValue4 
LARS_Standard 
ApprenticeshipStandardTypeCode 
LARS_Standard 
Reference 
 
 
 

8 
New tables created in version 011’s structure 
The new tables created for the version ‘011’ download are: 
Table Name 
Content description 
LARS_ApprenticeshipStanda
rdTypeCode_Lookup 
Details the Code and Code description relating 
to the Apprenticeship Standard. 
Version 011 table and field definitions – core tables 
Four fields are common to every core table in the downloadable database, except the 
“LARS_DataGeneration” table which only has “creation details”. These fields are not 
included in the table definitions in this document to avoid duplication: 
Field Name 
Data Type 
Description 
Created On 
Date/Time 
The date and time the record was created 
Created By 
Text 
The user (or process) which created the record 
Modified On 
Date/Time 
The date and time the record was last updated 
Modified By 
Text 
The user (or process) which last updated the record 
The remaining sections describe the contents of each table including the field name, the 
data type of the field and a description of the field.  
 
 

9 
LARS_Annual Value 
This table contains the learning aim detail which may be changed over time. This is 
controlled by the “Effective from” and “Effective To” date fields. 
Field Name 
Data Type 
Description 
LearnAimRef 
Text 
The learning aim reference 
EffectiveFrom 
Date 
The date the contents of the record are applicable 
(“effective”) from 
EffectiveTo 
Date 
The date the contents of the record are applicable 
(“effective”) to 
BasicSkills 
Int 
Whether the learning aim is considered a basic skill relating 
to achievements in literacy, numeracy and language and 
counts towards Basic Skills national targets 
BasicSkillsBroadTyp
e 
Int 
The broad categorisation of basic skill 
BasicSkillsType 
Int 
The sub-category of the type of basic skill (e.g. Adult literacy, 
ESOL) 
BasicSkillsParticipati
on 
Int 
If the aim counts towards basic skills participation targets 
FullLevel2Entitleme
ntCategory 
Int 
The category or ‘family’ which the learning aim belongs to for 
assessing how far the aim contributes to a Full level 2 
FullLevel2Percent 
Decimal 
The percentage the aim contributes to a Full Level 2  
FullLevel3Entitleme
ntCategory 
Int 
The category or ‘family’ to which the learning aim belongs to 
for assessing how far the aim contributes to a Full level 3 
FullLevel3Percent 
Decimal 
The percentage the aim contributes to a Full Level 3 
MI_FullLevel2 
Int 
If the aim contributes to a Full Level 2 (only used for MI 
purposes) 
MI_FullLevel2Perce
nt 
Decimal 
The percentage the aim contributes to a Full Level 2 (only 
used for MI purposes) 
MI_FullLevel3 
Int 
If the aim contributes to a Full Level 3 (only used for MI 
purposes) 
MI_FullLevel3Perce
nt 
Decimal 
The percentage a learning aim contributes to a Full Level 3 
(only used for MI purposes) 
OfQualValid19Plus 
Int 
If the learning aim is valid for the defined age group, as 
recorded by Ofqual. 
SfaApprovalStatus 
Int 
The status of this aim in the Agency’s Approval process. 

10 
LARS_ApprenticeshipFunding 
This table contains the funding rates for a funding category for an apprenticeship 
covering standards and frameworks. 
Field Name 
Data Type 
Description 
ApprenticeshipTy
pe 
Text 
Whether funding is for a standard (STD) or a 
framework (FWK) 
ApprenticeshipC
ode 
Int 
The standard or framework code  
ProgType 
Int 
The ProgType for a framework – set to “25” for a 
standard 
PwayCode 
Int 
The pathway within the framework level – set to “0” 
for a standard 
FundingCategory 
Text 
The funding category of the apprenticeship funding 
EffectiveFrom 
Date 
The date from which this funding detail relates 
EffectiveTo 
Date 
The date to which this funding detail relates 
BandNumber 
Int 
The funding band applicable to the apprenticeship 
CoreGovContrib
utionCap 
Decimal 
This field is not being used, the values will be set to 
zero 
1618Incentive 
Decimal 
The total of the additional payments for both 
providers and employers, and framework uplift (if 
applicable) for recruitment of younger or 
disadvantaged apprenticeships 
1618ProviderAdd
itionalPayment. 
Decimal 
The value of the additional payment to a Provider for 
recruitment of younger or disadvantaged 
apprenticeships. 
1618EmployerAd
ditionalPayment. 
Decimal 
The value of the additional payment to an Employer 
for recruitment of younger or disadvantaged 
apprenticeships. 
1618Framework
Uplift 
Decimal 
The value of the additional payment for undertaking 
Framework Apprenticeships. 
FoundationAppFi
rstEmpPayment 
Decimal 
The value for the foundation apprenticeship first 
employer additional payment. 
 
 

11 
LARS_ApprenticeshipFunding - Continued 
 
Field Name 
Data Type 
Description 
FoundationAppSec
ondEmpPayment 
Decimal 
The value for the foundation apprenticeship second 
employer additional payment. 
FoundationAppThir
dEmpPayment 
Decimal 
The value for the foundation apprenticeship third 
employer additional payment 
Duration 
Decimal 
The typical expected duration of the apprenticeship 
in months 
CareLeaverAdditio
nalPayment 
Decimal 
The value of the additional payment to an apprentice 
for recruitment of care leavers 
ReservedValue2 
Decimal 
This field is reserved for future use. 
ReservedValue3 
Decimal 
This field is reserved for future use. 
ReservedValue4 
Decimal 
This field is reserved for future use. 
MaxEmployerLevy
Cap 
Decimal 
The maximum employer levy contribution for the 
band 
FundableWithoutE
mployer 
Text 
This field is not being used, the values will be set to 
‘N’ 
 
 
 

12 
LARS_CareerLearningPilot 
This table contains the funding rates associated with a learning aim within areas that are 
eligible for the Career Learning Pilot.  
 
Field Name 
Data Type 
Description 
LearnAimRef 
Text 
The learning aim reference 
AreaCode 
Text 
The areas that are eligible within the pilot 
EffectiveFrom 
Date 
The date from which the funding detail applies 
EffectiveTo 
Date 
The date the funding detail applies to 
MaxLoanAmount 
Decimal 
Maximum loan amount for the Learning Aim that we 
will subsidise under the career learning pilot 
SubsidyPercent 
Decimal 
The proportion of the Learning Aim that we will 
subsidise under the career learning pilot 
SubsidyRate 
Decimal 
The rate we will pay for the Learning Aim delivered 
under the career learning pilot 
LARS_DataGeneration 
This table defines when the database was generated. This record is only generated when 
a download is created. When the next database is generated, that date will replace the 
previous date, however there will be no audit trail of what was modified and when. 
 
Field Name 
Data Type 
Description 
DataGeneratedOn 
DateTime 
The date and time that the dataset was generated 
Description 
Text 
The description of the LARS version 
Comment 
Text 
Comments about the production of the dataset.  This 
is completed by exception only 

13 
LARS_Devolved_Funding 
This table contains funding rates defined by Devolved Authorities for a learning aim.  
Field Name 
Data Type 
Description 
LearnAimRef 
Text 
The learning aim reference 
SourceOfFunding 
Int 
The SourceOfFunding eligible  
EffectiveFrom 
Date 
The date from which the funding detail applies 
EffectiveTo 
Date 
The date the funding detail applies to 
RateWeighted 
Decimal 
The aim’s weighted funding rate 
RateUnWeighted 
Decimal 
The aim’s un-weighted funding rate 
SpecialistUplift 
Decimal 
The SpecialistUplift applied to the funding 
 
 
 

14 
LARS_Framework 
This table contains the details for a framework. At present the table holds details for 
“apprenticeship frameworks”, “T Level transition”, “T Level” and “14-19 Diplomas”. A 
record in this table is uniquely identified by a combination of the following fields:  
• FworkCode – the framework code  
• ProgType – the programme type 
• PwayCode – the pathway code 
 
Field Name 
Data Type 
Description 
FworkCode 
Int 
The framework 
ProgType 
Int 
The level of the framework and/or programme area 
PwayCode 
Int 
The pathway within the framework level 
PathwayName 
Text 
The pathway description 
EffectiveFrom 
Date 
The date the record is effective from  
EffectiveTo 
Date 
The date the record is effective to (or null if no date 
is set)  
SectorSubjectAreaTi
er1 
Decimal 
The broad (Tier 1) classification of the subject of the 
framework within the QCA Sector Subject Area 
(SSA) classification system 
SectorSubjectAreaTi
er2 
Decimal 
The more detailed (Tier 2) classification of the 
subject of the framework within the QCA SSA 
classification system 
NASTitle 
Text 
The title of the framework 
ImplementDate 
Date 
The date the framework was implemented 
IssuingAuthorityTitle 
Text 
The title set by the Issuing Authority for the 
framework where appropriate 
IssuingAuthority 
Text 
The Issuing Authority of the framework where 
appropriate 
DataReceivedDate 
Date 
The date the framework documentation was 
received for processing 
MI_FullLevel2 
Int 
Indicates if the aim contributes to a Full Level 2 (for 
MI purposes only) 
 
 
 

15 
LARS_Framework - Continued 
 
 
Field Name 
Data Type 
Description 
MI_FullLevel2Percent 
Decimal 
The percentage the learning aim contributes to a Full 
Level 2 (for MI purposes only) 
MI_FullLevel3 
Int 
If the aim contributes to Full Level 3 (for MI purposes 
only) 
MI_FullLevel3Percent 
Decimal 
The percentage the learning aim contributes to a Full 
Level 3 (for MI purposes only) 
CurrentVersion 
Text 
The version of the framework supplied by the Issuing 
Authority 
 
 
 

16 
LARS_FrameworkAims 
This table contains the learning aims that are associated with a framework. A record in 
this table is uniquely identified by a combination of the following fields: 
• FworkCode – the framework code 
• ProgType – the programme type 
• PwayCode – the pathway code 
• LearnAimRef – the learning aim reference 
 
Field Name 
Data Type 
Description 
FworkCode 
Int 
The framework 
ProgType 
Int 
The level of the framework and/or programme area 
PwayCode 
Int 
The pathway within the framework level 
LearnAimRef 
Text 
The learning aim reference 
EffectiveFrom 
Date 
The date the record is effective from  
EffectiveTo 
Date 
The date the record is effective to (or null if no date 
has been set) 
FrameworkCompo
nentType 
Int 
The component type of the aim within the framework 
e.g. a Technical Certificate as referenced in 
“LARS_ApprenticeshipComponentType_Lookup” 
 
 

17 
LARS_FrameworkCmnComp 
This table defines the common components that can be used in a framework. A record in 
this table is uniquely identified by a combination of: 
• FworkCode 
• ProgType 
• PwayCode 
• CommonComponent 
 
Field Name 
Data Type 
Description 
FworkCode 
Int 
The framework 
ProgType 
Int 
The level of the framework and/or programme area 
PwayCode 
Int 
The pathway within the framework level 
CommonCompone
nt 
Int 
The type of common component (e.g. Functional 
Skill) 
EffectiveFrom 
Date 
The date the record is effective from  
EffectiveTo 
Date 
The date the record is effective to (or null if no date 
has been set) 
MinLevel 
Text 
The minimum level for the common component 
within this framework 
 
 

18 
LARS_Funding 
This table contains the funding rates associated with a funding category for a learning 
aim.  
Field Name 
Data Type 
Description 
LearnAimRef 
Text 
The learning aim reference 
FundingCategory 
Text 
The funding category of the aim 
EffectiveFrom 
Date 
The date from which the funding detail applies 
EffectiveTo 
Date 
The date the funding detail applies to 
RateWeighted 
Decimal 
The aim’s weighted funding rate 
RateUnWeighted 
Decimal 
The aim’s un-weighted funding rate 
WeightingFactor 
Text 
The aim’s funding rate weighting factor 
AdultSkillsFunding
Band 
Text 
The adult skills funding band for the aim 
FundedGuidedLear
ning Hours 
Int 
The funded guided learning hours value for the aim 
LARS_HECoS 
This table contains the funding rates associated with a funding category for a learning 
aim.  
Field Name 
Data Type 
Description 
LearnAimRef 
Text 
The learning aim reference 
HECoSCode 
Int 
The code for the aim 
EffectiveFrom 
Date 
The date from which the HECoS code applies 
EffectiveTo 
Date 
The date the HECoS code applies to 
 
 

19 
LARS_LearningDelivery 
This table contains fields relating to a learning aim. The old LAD and LARA flags have 
been replaced by individually named fields on the table. 
Field Name 
Data Type 
Description 
LearnAimRef 
Text 
The learning aim reference 
EffectiveFrom 
Date 
The date the record is effective from  
EffectiveTo 
Date 
The date the record is effective to (or null if no date 
has been set) 
LearnAimRefTitle 
Text 
The full title associated with the learning aim 
LearnAimRefType 
Text 
The learning aim type of the learning aim 
NotionalNVQLevel 
Text 
The level of the NVQ. Note levels 4 and 5 continue 
to reflect their pre 2004 to 2005 values 
NotionalNVQLevelv2 
Text 
The level of the NVQ. This field is the same as the 
“NotionalNVQLevel” field, except levels 4 and 5 are 
expanded to levels 4 – 8   
AwardOrgAimRef 
Text 
The learning aim’s awarding organisation aim 
reference 
CertificationEndDate 
Date 
The last date the learning aim can be certificated  
OperationalStartDate 
Date 
The operational start date recorded by Ofqual (or 
other sources if relevant) 
OperationalEndDate 
Date 
The operational end date recorded by Ofqual (or 
other sources if relevant) 
EnglandFEHEStatus 
Text 
If it is a Further Education (FE) aim or a Higher 
Education (HE) aim 
CreditBasedFwkType 
Int 
The credit based framework type 
QltyAssAgencyType 
Int 
The Qualifications Assurance Agency (QAA) type for 
this learning aim 
OfqualGlhMin 
Int 
The minimal guided learning hours (GLH) value 
defined by Ofqual for this learning aim 
OfqualGlhMax 
Int 
The maximum GLH value defined by Ofqual for this 
learning aim 
 
 
 

20 
LARS_LearningDelivery – continued 
 
Field Name 
Data Type 
Description 
FrameworkCommonCo
mponent 
Int 
The common component type within a framework 
(e.g. Functional Skill). The lookup table for this field 
is called “CommonComponent_Lookup” 
EntrySubLevel 
Text 
The sub-entry levels of an Entry Level aim. This can 
be a combination (e.g. "Entry 2 + Entry 3") as well as 
single values 
SuccessRateMapCode 
Text 
The code used to group learning aims together for 
analysis and benchmarking 
EngPrscID 
Int 
If it is a prescribed higher education learning aim, as 
defined by the Education (Prescribed Courses of 
Higher Education) (Wales) (Amendment) 
Regulations 1998 
AwardOrgCode 
Text 
The Awarding Organisation associated with the 
learning aim 
UnitType 
Text 
The learning aim’s unit type 
LearningDeliveryGenre 
Text 
The genre of the learning delivery (e.g. prescribed 
HE, generic class code, QAA regulated qualification, 
Ofqual regulated qualification, Ofqual regulated unit) 
OfQualOfferedEngland 
Int 
If the learning aim is offered in England, as defined 
by Ofqual  
RgltnStartDate 
Date 
The learning aim’s regulated start date as 
appropriate 
SourceQualType 
Text 
The learning aim’s source qualification type 
SourceSystemRef 
Text 
The identifier for the learning aim provided by the 
data source (e.g. the Ofqual reference or QAA 
reference) 
SourceURLRef 
Text 
The source system’s URL for this learning aim 
SourceURLLinkType 
Int 
The learning aim’s source URL type 
OccupationalIndicator 
Int 
If the learning aim is an occupational learning aim 
AccessHEIndicator 
Int 
If the learning aim is an Access to Higher Education 
(“Access to HE”) aim 
 

21 
LARS_LearningDelivery – continued 
 
Field Name 
Data Type 
Description 
KeySkillsIndicator 
Int 
If the learning aim is a key skill 
FunctionalSkillsIndi
cator 
Int 
If the learning aim is a functional skill 
GCEIndicator 
Int 
If the learning aim is a GCE  
GCSEIndiactor 
Int 
If the learning aim is a GCSE aim 
ASLevelIndicator 
Int 
If the learning aim is an AS level aim 
A2LevelIndicator 
Int 
If the learning aim is an A2 level 
ALevelIndicator 
Int 
If the learning aim is an A level  
QCFIndicator 
Int 
If the learning aim is a Qualifications and Credit 
Framework (QCF) aim 
QCFDiplomaIndicat
or 
Int 
If the learning aim is a QCF Diploma  
QCFCertificateIndic
ator 
Int 
If the learning aim is a QCF Certificate 
EFACOFType 
Int 
The EFACOFType (EFA condition of funding type) 
code assigned to the learning aim 
SFAFundedIndicat
or 
Int 
If the learning aim is, or will be, funded by the SFA 
DanceandDramaIn
dicator 
Int 
If the learning aim is a dance or drama aim 
Note 
Text 
To record any additional relevant information for the 
learning aim 
LearnDirectClassS
ystemCode1 
Text 
The code for the subject areas for the learning aim 
using the Learning Directory Classification System 
(LDCS) 
LearnDirectClassS
ystemCode2 
Text 
The code for the subject areas for the learning aim 
using the Learning Directory Classification System 
(LDCS) 
LearnDirectClassS
ystemCode3 
Text 
The code for the subject areas for the learning aim 
using the Learning Directory Classification System 
(LDCS) 
 
 

22 
LARS_LearningDelivery – continued 
 
Field Name 
Data Type 
Description 
RegulatedCreditValu
e 
Int 
The learning aim’s credit value within a regulated 
credit framework 
SectorSubjectAreaTi
er1 
Decimal 
The broad (Tier 1) classification of a learning aim 
within the Qualification and Curriculum Authority 
(QCA) SSA classification system 
SectorSubjectAreaTi
er2 
Decimal 
The more detailed (Tier 2) classification of a learning 
aim within the QCA SSA classification system 
MI_NotionalNVQLeve
l 
Int 
The level on the NVQ scale for all learning aims. 
Note levels 4 and 5 continue to reflect their original 
pre 2004 to 2005 values. This field is for MI 
purposes only 
MI_NotionalNVQLeve
lv2 
Decimal 
The level on the NVQ scale for all learning aims. 
This field is the same as the “MI_NotionalNVQLevel” 
field apart from levels 4 and 5 are expanded to 
levels 4 – 8. This field is for MI purposes only 
GuidedLearningHour
s 
Int 
The guided learning hours, defined by Ofqual for this 
learning aim 
TotalQualificationTim
e 
Int 
The total qualification time, defined by Ofqual for this 
learning aim 
RecognisedHEForOf
SFundingPurposes 
Int 
To record HE for OfS funding purposes 
 
 
 

23 
LARS_LearningDeliveryCategory 
This table allows categories to be added to individual learning aims for analysis.  
Field Name 
Data Type 
Description 
LearnAimRef 
Text 
The learning aim reference 
CategoryRef 
Int 
The code representing the categorisation of the 
learning aim 
EffectiveFrom 
Date 
The date the record is effective from 
Effective To 
Date 
The date the record is effective to 
 
LARS_Programme 
This table contains the funding details related to the delivery of a programme. Initially this 
will support Adult funding and T Level programmes but may be expanded to other 
programmes. 
Field Name 
Data Type 
Description 
ProgrammeCode 
Int 
The framework code 
ProgType 
Int 
The level of the framework and/or programme area 
PwayCode 
Int 
The pathway within the framework level 
EffectiveFrom 
Date 
The date the record is effective from  
LastDateforNewSta
rts 
Date 
The last date for new starts on the programme 
EffectiveTo 
Date 
The date the record is effective to (or null if no date 
is set) 
FundingCategory 
Text 
The funding category of the programme 
ProgrammeArea 
Text 
The area of the programme 
CoreAim 
Decimal 
The value of Core Aim for the specified programme 
Specialism 
Decimal 
The value of specialism for the specified programme 
SubSpecialism 
Decimal 
The value of sub specialism for the specified 
programme 
 
 
 

24 
LARS_ProgrammeAims 
This table is designed to join details from the LARS_Programme table to the 
LARS_Delivery table. 
Field Name 
Data Type 
Description 
ProgrammeCode 
Int 
The framework code 
ProgType 
Int 
The level of the framework and/or programme area 
PwayCode 
Int 
The pathway within the framework level 
LearningAimRef 
Text 
The learning aim reference 
EffectiveFrom 
Date 
The date the record is effective from  
EffectiveTo 
Date 
The date the record is effective to 
 
 
 

25 
LARS_ProgrammeFunding 
This table contains the details related to the delivery of a programme linked to the 
LARS_Programme table. Initially this will support Adult funding and T Level programmes 
but may be expanded to other programmes.  
Field Name 
Data Type 
Description 
ProgrammeCode 
Int 
The framework code 
ProgType 
Int 
The level of the framework and/or programme area 
PwayCode 
Int 
The pathway within the framework level 
Identfier 
Int 
Identifier for each programme funding band and rate 
EffectiveFrom 
Date 
The date the record is effective from  
EffectiveTo 
Date 
The date the record is effective to 
FundingBand 
Text 
The funding band applicable to the programme 
FundingFactor 
 
Decimal 
Freeformat 
RateWeighted 
Decimal 
The programme's weighted funding rate taken from 
the Funding_Lookup 
RateUnWeighted 
Decimal 
The programme's unweighted funding rate taken 
from the Funding_Lookup 
ProgrammeCostW
eightingFactor 
Decimal 
 
ProgrammeCostW
eightingFactorDesc 
Text 
Freeformat 
WorkExperience 
Int 
The length of days/weeks the programme runs for 
Hours 
Int 
Freeformat 
Duration 
Int 
The duration of the programme 
 
 

26 
LARS_Section96 
This table contains the Section 96 details for a learning aim. These were previously held 
on the “LARS_AnnualValue” table. 
Field Name 
Data Type 
Description 
LearnAimRef 
Text 
The learning aim reference 
EffectiveFrom 
Date 
The date the record is effective from 
EffectiveTo 
Date 
The date the record is effective to 
Section96Valid16to
18 
Int 
If the learning aim is valid for the 16 - 18 age group 
in accordance with Section 96 funding status 
Section96Valid18pl
us 
Int 
If the learning aim is valid for the 18 plus age group 
in accordance with the Section 96 funding status  
Section96Approval
Status 
Int 
The Section 96 approval status of the learning aim 
Section96Approval
StartDate 
Date 
The start date of Section 96 approval for the learning 
aim 
Section96ReviewD
ate 
Date 
The date the approval under Section 96 will be 
reviewed 
Section96ValidPre
16 
Int 
If the learning aim is valid for the pre-16 age group in 
accordance with the Section 96 funding status 
 
 

27 
LARS_Standard 
This table contains the details for apprenticeship standard. 
Field Name 
Data Type 
Description 
StandardCode 
Int 
The apprenticeship standard code 
Version 
Int 
The version number of the apprenticeship standard  
ApprenticeshipStan
dardTypeCode 
Text 
The code for the apprenticeship standard type 
StandardName 
Text 
The name of the apprenticeship standard  
StandardSectorCo
de 
Text 
The sector code of the apprenticeship standard  
NotionalEndLevel 
Text 
The attainment level for the apprenticeship standard 
based upon the “NotionalNVQLevelv2” field 
EffectiveFrom 
Date 
The date the apprenticeship standard is effective 
from 
LastDateStarts 
Date 
The last date an apprenticeship standard can be 
started 
EffectiveTo 
Date 
The date the apprenticeship standard is effective to 
Reference 
Text 
The reference for the apprenticeship standard 
UrlLink 
Text 
The URL link to details of the apprenticeship 
standard where appropriate 
SectorSubjectArea
Tier1 
Decimal 
The broad (Tier 1) classification of the 
apprenticeship standard within the QCA SSA 
classification system 
SectorSubjectArea
Tier2 
Decimal 
The more detailed (Tier 2) classification of the 
apprenticeship standard within the QCA SSA 
classification system 
IntegratedDegreeSt
andard 
Text 
Used to indicate if this standard is considered as an 
Integrated Degree Standard [Y (YES) or N (NO)] 
OtherBodyApproval
Required 
Text 
Identify if the Standard requires approval for delivery 
by Provider 
 
 

28 
LARS_StandardAims 
This table contains the learning aims that are linked with an apprenticeship standard.  
Currently this only includes the relevant learning aim class code linked to a particular 
Standard. A record in this table is uniquely identified by a combination of the following 
fields: 
• StandardCode – the standard code 
• LearnAimRef – the learning aim reference 
 
 
Field Name 
Data Type 
Description 
StandardCode 
Int 
The standard 
LearnAimRef 
Text 
The learning aim reference 
EffectiveFrom 
Date 
The date the record is effective from  
EffectiveTo 
Date 
The date the record is effective to (or null if no date 
has been set) 
StandardCompone
ntType 
Int 
The component type of the aim within the framework 
as referenced in 
“LARS_ApprenticeshipComponentType_Lookup” 
LARS_StandardCommonComponent 
This table defines the common components that can be used within an apprenticeship 
standard. A record in this table is uniquely identified by a combination of: 
• StandardCode – standard code 
• CommonComponent – common component 
 
Field Name 
Data Type 
Description 
StandardCode 
Int 
The apprenticeship standard code  
CommonCompone
nt 
Int 
The common component type (e.g. Functional Skill) 
EffectiveFrom 
Date 
The date this record is effective from  
EffectiveTo 
Date 
The date this record is effective to (or null if no date 
has been set yet) 
MinLevel 
Text 
The minimum level of the common component within 
the apprenticeship standard 

29 
LARS_StandardFunding 
This table contains the funding rates for a funding category for an apprenticeship 
standard. 
Field Name 
Data Type 
Description 
StandardCode 
Int 
The apprenticeship standard code 
FundingCategory 
Text 
The funding category of the apprenticeship standard 
EffectiveFrom 
Date 
The date from which this funding detail relates 
EffectiveTo 
Date 
The date to which this funding detail relates 
BandNumber 
Int 
The funding cap band applicable to the 
apprenticeship standard 
CoreGovContributi
onCap 
Decimal 
The maximum government contribution for the band 
1618Incentive 
Decimal 
The incentive value for recruitment of a 16- to 18-
year-old for the band 
SmallBusinessInce
ntive 
Decimal 
The incentive value for small businesses (<50) for 
the band. 
AchievementIncenti
ve 
Decimal 
The value for completion of the standard for the 
band 
FundableWithoutE
mployer 
Text 
If the standard can be delivered without an 
employer. This is not used 
 
 

30 
LARS_StandardValidity 
This table shows when a standard can be offered for a validity category. 
Field Name 
Data Type 
Description 
StandardCode 
Int 
The apprenticeship standard code 
ValidityCategory 
Text 
The validity category for the apprenticeship standard  
StartDate 
Date 
When the apprenticeship standard is valid from for 
the validity category 
LastNewStartDate 
Date 
The last date for starts for this apprenticeship 
standard on this category 
EndDate 
Date 
When an apprenticeship standard is no longer valid 
for the particular validity category 
 
LARS_TechnicalRoute 
This table defines the Technical Route that can be used in conjunction with the Technical 
Level Pathway. A record in this table is uniquely identified by a combination of: 
• LearnAimRef – Learning Aim Reference 
• RouteId – Route Identifier 
 
Field Name 
Data Type 
Description 
LearnAimRef 
Text 
The learning aim reference 
RouteId 
Int 
Link to the Technical RouteId 
EffectiveFrom 
Date 
The date the record is valid from 
EffectiveTo 
Date 
The date the record is valid to 
 
 
 

31 
LARS_TLevelPathway 
This table defines the Technical Level Pathway that can be used in conjunction with the 
Technical Route. A record in this table is uniquely identified by a combination of: 
• StandardCode – Standard Code 
• RouteId – Route Identifier 
 
 
Field Name 
Data Type 
Description 
StandardCode 
Int 
The standard code 
RouteId 
Int 
Link to the Technical RouteId 
EffectiveFrom 
Date 
The date the record is valid from 
EffectiveTo 
Date 
The date the record is valid to 
 
LARS_Validity 
This table shows when a learning aim can be offered for a validity category. 
 
Field Name 
Data Type 
Description 
LearnAimRef 
Text 
The learning aim reference 
ValidityCategory 
Text 
The validity category this aim relates to 
StartDate 
Date 
When the aim is valid for the validity category 
EndDate 
Date 
When the aim is no longer valid for the validity 
category 
LastNewStartDate 
Date 
The last date for new starts for this aim on this 
category 
 
 
 

32 
LARS_Version 
This table identifies the version of the database being used. 
Field Name 
Data Type 
Description 
MajorNumber 
Int 
The sequence of major changes that have been 
made to the database structures e.g. new tables 
MinorNumber 
Int 
The sequence of minor changes that have been 
made to the database structures, within major 
changes e.g. a new field 
MaintenanceNumb
er 
Int 
The sequence of maintenance changes, within minor 
changes, to the database e.g. correcting the spelling 
of a field name 
MainDataSchemaN
ame 
Text 
The name of the schema of the core data 
RefDataSchemaNa
me 
Text 
The name of the schema of the reference data 
ActivationDate 
Date 
The date this version became active 
ExpiryDate 
Date 
The date this version becomes inactive 
Description 
Text 
A description of the version 
Comment 
Text 
Any comments relating to this version 
 
 
 

33 
Version 011 table and field definitions – reference 
tables 
The structure of the reference tables contained in the download database is detailed 
below. If a reference table does not follow this format, it will be defined in detail. 
All reference tables have a naming convention of “LARS_ReferenceTable_Lookup” 
where “ReferenceTable” is the name of the particular reference or lookup field. Each 
table contains the following fields with “ReferenceTable” replaced by the relevant field 
name.  See example for LARS_A2LevelIndicator_Lookup. 
Field Name 
Data Type 
Description 
ReferenceTable 
Int 
The reference table code 
ReferenceTableDesc 
Text 
The description of the reference table code 
ReferenceTableDesc
2 
Text 
The short description for the reference table code 
EffectiveFrom 
Date 
Identifies the date the reference or lookup code is 
valid from 
EffectiveTo 
Date 
Identifies the date the reference or lookup code is 
valid to 
 
LARS_A2LevelIndicator_Lookup 
This table defines the codes for the next field A2LevelIndicator. 
Field Name 
Data Type 
Description 
A2LevelIndicator 
Int 
The reference table code 
A2LevelIndicatorDe
sc 
Text 
The description of the reference table code 
A2LevelIndicatorDe
sc2 
Text 
The short description for the reference table code 
EffectiveFrom 
Date 
Identifies the date the reference or lookup code is 
valid from 
EffectiveTo 
Date 
Identifies the date the reference or lookup code is 
valid to 
 
 
 

34 
LARS_AcademicYear_Lookup 
This table defines the funding year codes. Although the lookup table and the field names 
for the table refer to academic year, these refer to the funding year. We have not updated 
the names in order to reduce the amount of changes required.  
Field Name 
Data Type 
Description 
AcademicYear 
Text 
The academic (funding) year code 
AcademicYearDes
c 
Text 
The description of the academic (funding) year code 
AcademicYearDes
c2 
Text 
The short description of the academic (funding) year 
code 
StartDate 
Date 
The start date for the academic (funding) year 
EndDate 
Date 
The end date of the academic (funding) year 
EffectiveFrom 
Date 
The date the academic (funding) year code is valid 
from 
EffectiveTo 
Date 
The date the academic (funding) year code is valid 
to 
LARS_AccessHEIndicator_Lookup 
This table defines the codes for the field AccessHEIndicator. 
LARS_AdultSkillsFundingBand_Lookup 
This table defines the codes for the field Adult Skills Band. 
Field Name 
Data Type 
Description 
AdultSkillsFunding
Band 
Text 
The adult skills funding band  
AdultSkillsFunding
BandRate 
Decimal 
The hourly adult skills funding rate 
EffectiveFrom 
Date 
The date the hourly adult skills funding rate is valid 
from 
EffectiveTo 
Date 
The date the hourly Adult Skills funding rate is valid 
to 

35 
LARS_ALevelIndicator_Lookup 
This table defines the codes for the field ALevelIndicator. 
LARS_ApprenticeshipComponentType_Lookup 
This table defines the codes for the fields called FrameworkComponentType and 
StandardComponentType. 
LARS_ApprenticeshipStandardType_Lookup 
This table defines the codes for the Apprenticeship Standard. 
Field Name 
Data Type 
Description 
ApprenticeshipStandardType
Code 
Text 
The apprenticeship standard type code 
ApprenticeshipStandardType
CodeDesc 
Text 
The apprenticeship standard type code 
description 
EffectiveFrom 
Date 
The date the apprenticeship standard is 
valid from 
EffectiveTo 
Date 
The date the apprenticeship standard is 
valid to 
LARS_AreaCode_Lookup 
This table defines the area codes for use within the Career Learning Pilot. 
LARS_ASLevelIndicator_Lookup 
This table defines the codes for the field ASLevelIndicator. 
 
 
 

36 
LARS_AwardOrgCode_Lookup 
This table contains the codes for Awarding Organisations. Note the field type is “Text” 
and not “Int. 
Field Name 
Data Type 
Description 
AwardOrgCode 
Text 
The Awarding Organisation code 
AwardOrgUKPRN 
Int 
The Awarding Organisation UKPRN value 
AwardOrgName 
Text 
The Awarding Organisation name 
AwardOrgShortNa
me 
Text 
The short name for the Awarding Organisation 
AswardOrgAcrony
m 
Text 
The acronym of the Awarding Organisation 
AwardOrgNonExta
nt 
Text 
The value “Y” indicates the Awarding Organisation is 
no longer in operation 
AwardOrgNotes 
Text 
Comments about the Awarding Organisation such as 
mergers, name changes 
AwardOrgHigherEd
ucationInst 
Text 
If the Awarding Organisation is classed as a Higher 
Education Institution as defined by Office for 
Students. This field contains only “Yes” or “No” 
EffectiveFrom 
Date 
Identifies the date the Awarding Organisation code is 
valid from 
EffectiveTo 
Date 
Identifies the date the Awarding Organisation code is 
valid to 
 
LARS_BandNumber_Lookup 
This table defines the allowable Band Numbers for use within the StandardFunding and 
ApprenticeshipFunding tables. 
 
 

37 
LARS_BasicSkills_Lookup 
This table defines the codes for the field BasicSkills. 
LARS_BasicSkillsBroadType_Lookup 
This table defines the codes for the field BasicSkillsBroadType 
LARS_BasicSkillsParticipation_Lookup 
This table defines the codes for the field BasicSkillsParticipation. 
LARS_BasicSkillsType_Lookup 
This table defines the codes for the field BasicSkillsType. 
LARS_Category_Lookup 
This table defines the category codes. 
Field Name 
Data Type 
Description 
CategoryRef 
Int 
The category reference code 
ParentCategoryRef 
Int 
The parent category reference code where 
appropriate 
CategoryName 
Text 
The name of the category reference 
Target 
Text 
The purpose of the category 
EffectiveFrom 
Date 
The date the category code is valid from 
EffectiveTo 
Date 
The date the category code is valid to 
LARS_CommonComponent_Lookup 
This table defines the codes for the field CommonComponent. 
LARS_CreditBasedFwkType_Lookup 
This table defines the codes for the field CreditBasedFwkType. 
 

38 
LARS_DanceandDramaIndicator_Lookup 
This table defines the codes for the field DanceandDramaIndicator. 
LARS_Devolved_SoF_Lookup 
This table defines the Source of Funding codes and associated names for Devolved 
Authorities. 
Field Name 
Data Type 
Description 
SourceOfFunding 
Int 
The SourceOfFunding code 
MCAGLAShortCod
e 
Text 
The Devolved Authority Short name 
Name 
Text 
The Devolved Authority name 
EffectiveFrom 
Date 
The date the Devolved Authority name is valid from 
EffectiveTo 
Date 
The date the Devolved Authority name is valid to 
LARS_EFACOFType_Lookup 
This table defines the codes for the field EFACOFType (EFA condition of funding type). 
LARS_EnglandFEHEStatus_Lookup 
This table defines the codes for the field EnglandFEHEStatus. The field type is “Text” and 
not “Int”. 
LARS_EngPrscID_Lookup 
This table defines the codes for the field EngPrscID. 
LARS_EntrySubLevel_Lookup 
This table defines the codes for the field EntrySubLevel. The field type is “Text” and not 
“Int”.  
 
 

39 
LARS_FullLevel2EntitlementCategory_Lookup 
This table defines the codes for the field FullLevel2EntitlementCategory. 
LARS_FullLevel3EntitlementCategory_Lookup 
This table defines the codes for the field FullLevel3EntitlementCategory. 
LARS_FunctionalSkillsIndicator_Lookup 
This table defines the codes for the field FunctionalSkillsIndicator.  
LARS_FundingCategory_Lookup 
This table defines the codes for the field FundingCategory. The field type is “Text” and 
not “Int”. 
Field Name 
Data Type 
Description 
FundingCategory 
Text 
The funding category code 
FundingCategoryD
esc 
Text 
The description of the funding category code 
FundingCategoryD
esc2 
Text 
The short description for the funding category code 
EffectiveFrom 
Date 
The date the funding category code is valid from 
EffectiveTo 
Date 
The date the funding category code is valid to 
TargetIndicator 
Text 
Identifies if the validity category relates to learning 
aims (AIM), apprenticeships (APP) or standards 
(STD) for use in input validation of validity records 
onto the database 
LARS_GCEIndicator_Lookup 
This table defines the codes for the field GCEIndicator. 
LARS_GCSEIndicator_Lookup 
This table defines the codes for the field GCSEIndicator. 
 
 

40 
LARS_HECoSCode_Lookup 
This table defines the codes for the field HECoS. 
Field Name 
Data Type 
Description 
HECoSCode 
Int 
The HECoS category code 
HECoSCodeDesc 
Text 
The description of the HECoS category code 
HECoSCodeDesc2 
Text 
The description of the HECoS category code 
EffectiveFrom 
Date 
The date the HECoS category code is valid from 
EffectiveTo 
Date 
The date the HECoS category code is valid to 
LARS_IssuingAuthority_Lookup 
This table defines the Issuing Authority codes. 
Field Name 
Data Type 
Description 
Issuing Authority 
Int 
The Issuing Authority code 
IssuingAuthorityDe
sc 
Text 
The Issuing Authority Name 
IssuingAuthorityDe
sc2 
Text 
The Issuing Authority short name 
IssuingAuthorityUK
PRN 
Int 
The UKPRN number for the Issuing Authority 
EffectiveFrom 
Date 
The date the Issuing Authority code is valid from 
EffectiveTo 
Date 
The date the Issuing Authority code is valid to 
LARS_KeySkillsIndicator_Lookup 
This table defines the codes for the field KeySkillsIndicator. 
LARS_LearnAimRefType_Lookup 
This table defines the codes for the field LearnAimRef. The field type is “Text” and not 
“Int”. 
 
 

41 
LARS_LearnDirectClassSystemCode_Lookup 
This table defines the codes for the field(s) LearnDirectClassSystemCode1-2-3. The field 
type is “Text” and not “Int”. 
LARS_LearningDeliveryGenre_Lookup 
This table defines the codes for the field LearningDeliveryGenre. The field type is “Text” 
and not “Int”. 
LARS_MI_Fulllevel2Indicator_Lookup 
This table defines the codes for the field MI_FullLevel2Indicator. 
LARS_MI_Fulllevel3Indicator_Lookup 
This table defines the codes for the field MI_FullLevel3Indicator. 
LARS_MI_NotionalNVQLevel_Lookup 
This table defines the codes for the field MI_NotionalNVQLevel. 
LARS_MI_NotionalNVQLevelv2_Lookup 
This table defines the codes for the field MI_NotionalNVQLevelv2. The field type is 
“Decimal” and not “Int”. 
LARS_NotionalNVQLevel_Lookup 
This table defines the codes for the field NotionalNVQLevel. The field type is “Text” and 
not “Int”. 
LARS_NotionalNVQLevelv2_Lookup 
This table defines the codes for the field NotionalNVQLevelv2. The field type is “Text” 
and not “Int”. 
LARS_OccupationalIndicator_Lookup 
This table defines the codes for the field OccupationalIndicator 

42 
LARS_OfQualOfferedEngland_Lookup 
This table defines the codes for the field OfQualOfferedEngland. 
LARS_OfQualValid19Plus_Lookup 
This table defines the codes for the field OfQualValid19Plus.  
Field Name 
Data Type 
Description 
OfQualValid19Plus 
Int 
The OfQualValid19Plus code 
OfQualValid19Plus
Desc 
Text 
The description of the OfQualValid19Plus code 
OfQualValid19Plus
Desc2 
Text 
The short description for the OfQualValid19Plus 
code 
EffectiveFrom 
Date 
The date the OfQualValid19Plus code is valid from 
EffectiveTo 
Date 
The date the OfQualValid19Plus code is valid to 
LARS_ProgType_Lookup 
This table defines the codes for the field ProgType. 
LARS_QCFCertificateIndicator_Lookup 
This table defines the codes for the field QCFCertificateIndiactor. 
LARS_QCFDiplomaIndicator_Lookup 
This table defines the codes for the field QCFDiplomaIndicator. 
LARS_QCFindicator_Lookup 
This table defines the codes for the field QCFindicator. 
LARS_QltyAssAgencyType_Lookup 
This table defines the codes for the field QltyAssAgencyType.  

43 
LARS_RecognisedHEForOfSFundingPurposes_Lookup 
This table defines Addition link to new Learning Delivery field in 
LARS_RecognisedHEForOfSFundingPurposes table.   
Field Name 
Data Type 
Description 
RecognisedHEFor
OfSFundingPurpos
es 
Int 
The OfS Funding ID  
RecognisedHEFor
OfSFundingPurpos
esDesc 
Text 
The description of whether the HE aim if funded by 
OfS 
RecognisedHEFor
OfSFundingPurpos
esDesc2 
Text 
The short description of OfS Funding 
EffectiveFrom 
Date 
The date the code is valid from 
EffectiveTo 
Date 
The date the code is valid to 
LARS_Route_Lookup 
This table defines the route and target. 
Field Name 
Data Type 
Description 
RouteId 
Int 
The Route Identifier code 
ParentRouteId 
Int 
Indicates the Route Identifier connection to the 
parent 
RouteName 
Text 
Description of the Route 
RouteShortName 
Text 
Short Description of the Route 
Target 
Text 
Identifies if Technical Route or T Level Pathway 
EffectiveFrom 
Date 
The date the record is valid from 
EffectiveTo 
Date 
The date the record is valid to 
 
 

44 
LARS_Section96ApprovalStatus_Lookup 
This table defines the codes for the field Section96ApprovalStatus. 
LARS_Section96Valid16to18_Lookup 
This table defines the codes for the field Section96Valid16to18. 
LARS_Section96Valid18plus_Lookup 
This table defines the codes for the field Section96Valid18plus. 
LARS_Section96ValidPre16_Lookup 
This table defines the codes for the field Section96ValidPre16. 
 
 

45 
LARS_SectorSubjectArea_Lookup 
This table defines the codes for SectorSubjectArea (SSA). The field type is “Decimal” and 
not “Int”. 
Field Name 
Data Type 
Description 
SectorSubjectArea
Tier1 
Decimal 
The SSA (Tier 1) code 
SectorSubjectArea
Tier1Desc 
Text 
The SSA (Tier 1) code description 
SectorSubjectArea
Tier1Desc2 
Text 
The SSA (Tier 1) code description short name 
SectorSubjectArea
Tier1_EffFrom 
Date 
The date the SSA (Tier 1) code is valid from 
SectorSubjectArea
Tier1_EffTo 
Date 
The date the SSA (Tier 1) code is valid to 
SectorSubjectArea
Tier2 
Decimal 
The SSA (Tier 2) code 
SectorSubjectArea
Tier2Desc 
Text 
The SSA (Tier 2) code description 
SectorSubjectArea
Tier2Desc2 
Text 
The SSA (Tier 2) code description short name 
SectorSubjectArea
Tier2_EffFrom 
Date 
The date the SSA (Tier 2) code is valid from 
SectorSubjectArea
Tier2_EffTo 
Date 
The date the SSA (Tier 2) code is valid to 
LARS_SectorSubjectAreaTier1_Lookup 
This table defines the codes for the field SectorSubjectAreaTier1. The field type is 
“Decimal” and not “Int”. 
LARS_SectorSubjectAreaTier2_Lookup 
This table defines the codes for the field SectorSubjectAreaTier2. The field type is 
“Decimal” and not “Int”. 
LARS_SFAApprovalStatus_Lookup 
This table defines the codes for the field SFAApprovalStatus. 

46 
LARS_SFAFundedIndicator_Lookup 
This table defines the codes for the field SFAFundedIndicator. 
LARS_SourceURLLinkType_Lookup 
This table defines the source URL link type codes. 
Field Name 
Data 
Type 
Description 
SourceURLLinkType 
Int 
The source URL link type code 
SourceURLLinkType
Desc 
Text 
The description of the source URL link type 
SourceURLLinkType
Desc 
Text 
The source URL link type short name 
SourceURLLink 
Text 
The URL link details 
EffectiveFrom 
Date 
The date the source URL link type code is valid from 
EffectiveTo 
Date 
The date the source URL link type code is valid to 
LARS_StandardSectorCode_Lookup 
This table defines the codes for the field StandardSectorCode. The field type is “Text” 
and not “Int”. 
LARS_SuccessRateMapCode_Lookup 
This table defines the codes for the field SuccessRateMapCode. The field type is “Text” 
and not “Int”. 
 
 

47 
LARS_ValidityCategory_Lookup 
This table defines the codes for the field ValidityCategory. The field type is “Text” and not 
“Int”. 
Field Name 
Data Type 
Description 
ValidityCategory 
Text 
The validity category code 
ValidityCategoryDe
sc 
Text 
The description of the validity category code 
ValidityCategoryDe
sc2 
Text 
The short description for the validity category code 
EffectiveFrom 
Date 
The date the validity category code is valid from 
EffectiveTo 
Date 
The date the validity category code is valid to 
TargetIndicator 
Text 
Identifies if the validity category relates to learning 
aims (AIM), apprenticeships (APP) or standards 
(STD) for use in input validation of validity records 
onto the database. 
LARS_ValidityFundingMapping_Lookup 
This table defines the relationship between the validity categories and the funding 
categories. 
Field Name 
Data Type 
Description 
ValidityCategory 
Text 
The validity category code 
FundingCategory 
Text 
The funding category code 
EffectiveFrom 
Date 
The date the relationship is valid from 
EffectiveTo 
Date 
The date the relationship is valid to 
Comments 
Text 
Comments regarding the relationship 
 
 
 

48 
 
© Crown copyright 2025 
This publication is licensed under the terms of the Open Government Licence v3.0, 
except where otherwise stated. To view this licence, visit 
nationalarchives.gov.uk/doc/open-government-licence/version/3.  
 
Where we have identified any third-party copyright information, you will need to obtain 
permission from the copyright holders concerned. 
 
About this publication: 
 
enquiries  https://www.gov.uk/contact-dfe   
download  www.gov.uk/government/publications  
Follow us on X: @educationgovuk 
Connect with us on Facebook: facebook.com/educationgovuk