LARS table and field definitions: version 010 (applicable from August 2024)
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 version 010 
 
Page 1 of 33 
 
 
 
 
 
 
 
 
 
 
 
Table and field definitions for the 
Learning Aim Reference Service 
 
Version 1.5 
This document provides the table and field definitions that will be available in the 
downloadable database produced from the Learning Aim Reference Service (LARS) 
as Version ‘010’.  This version will apply from 1 August 2024 for the 2024 to 2025 
academic year.   
 
 
 
 
 
 
 
 
 
 
 
 
May 2024 
 
Of interest to software suppliers and providers that write their own software.  
This issue is a draft version and may be subject to change prior to finalisation 
depending upon 2024 to 2025 requirements. 
 
 
 

Table and field definitions for version 010 
 
Page 2 of 33 
Table of contents 
 
Introduction .......................................................................................................................... 4 
Renamed tables in version 010’s structure .......................................................................... 5 
Deleted tables ...................................................................................................................... 5 
Existing tables amended in version ‘010’ structure ............................................................... 5 
New tables created in version 010’s structure ...................................................................... 5 
Version 010 table and field definitions – core tables ......................................................... 6 
LARS_AnnualValue ............................................................................................................. 6 
LARS_ApprenticeshipFunding ............................................................................................. 7 
LARS_CareerLearningPilot .................................................................................................. 8 
LARS_DataGeneration ........................................................................................................ 8 
LARS_Devolved_Funding .................................................................................................... 9 
LARS_Framework ............................................................................................................... 9 
LARS_FrameworkAims...................................................................................................... 10 
LARS_FrameworkCmnComp............................................................................................. 11 
LARS_Funding .................................................................................................................. 11 
LARS_HECoS ................................................................................................................... 12 
LARS_LearningDelivery ..................................................................................................... 12 
LARS_LearningDeliveryCategory ...................................................................................... 15 
LARS_Programme ............................................................................................................. 15 
LARS_ProgrammeAims ..................................................................................................... 16 
LARS_ProgrammeFunding ................................................................................................ 16 
LARS_Section96 ............................................................................................................... 17 
LARS_Standard ................................................................................................................. 17 
LARS_StandardAims ......................................................................................................... 18 
LARS_StandardCommonComponent ................................................................................ 18 
LARS_StandardFunding .................................................................................................... 19 
LARS_StandardValidity ..................................................................................................... 19 
LARS_TechnicalRoute....................................................................................................... 20 
LARS_TLevelPathway ....................................................................................................... 20 
LARS_Validity .................................................................................................................... 21 
LARS_Version ................................................................................................................... 21 
Version 010 table and field definitions – reference tables .............................................. 21 
LARS_A2LevelIndicator_Lookup ....................................................................................... 22 
LARS_AcademicYear_Lookup........................................................................................... 22 
LARS_AccessHEIndicator_Lookup .................................................................................... 23 
LARS_AdultSkillsFundingBand_Lookup ............................................................................ 23 
LARS_ALevelIndicator_Lookup ......................................................................................... 23 
LARS_ApprenticeshipComponentType_Lookup ................................................................ 23 
LARS_AreaCode_Lookup .................................................................................................. 23 
LARS_ASLevelIndicator_Lookup ....................................................................................... 23 
LARS_AwardOrgCode_Lookup ......................................................................................... 23 
LARS_BandNumber_Lookup ............................................................................................. 24 
LARS_BasicSkills_Lookup ................................................................................................. 24 
LARS_BasicSkillsBroadType_Lookup ............................................................................... 24 
LARS_BasicSkillsParticipation_Lookup ............................................................................. 24 
LARS_BasicSkillsType_Lookup ......................................................................................... 24 
LARS_Category_Lookup ................................................................................................... 25 
LARS_CommonComponent_Lookup ................................................................................. 25 
LARS_CreditBasedFwkType_Lookup ................................................................................ 25 
LARS_DanceandDramaIndicator_Lookup ......................................................................... 25 

Table and field definitions for version 010 
 
Page 3 of 33 
LARS_Devolved_SoF_Lookup .......................................................................................... 25 
LARS_EFACOFType_Lookup ........................................................................................... 26 
LARS_EnglandFEHEStatus_Lookup ................................................................................. 26 
LARS_EngPrscID_Lookup ................................................................................................. 26 
LARS_EntrySubLevel_Lookup........................................................................................... 26 
LARS_FullLevel2EntitlementCategory_Lookup ................................................................. 26 
LARS_FullLevel3EntitlementCategory_Lookup ................................................................. 26 
LARS_FunctionalSkillsIndicator_Lookup ........................................................................... 26 
LARS_FundingCategory_Lookup ...................................................................................... 26 
LARS_GCEIndicator_Lookup ............................................................................................ 27 
LARS_GCSEIndicator_Lookup .......................................................................................... 27 
LARS_HECoSCode_Lookup ............................................................................................. 27 
LARS_IssuingAuthority_Lookup ........................................................................................ 27 
LARS_KeySkillsIndicator_Lookup ...................................................................................... 28 
LARS_LearnAimRefType_Lookup ..................................................................................... 28 
LARS_LearnDirectClassSystemCode_Lookup .................................................................. 28 
LARS_LearningDeliveryGenre_Lookup ............................................................................. 28 
LARS_MI_Fulllevel2Indicator_Lookup ............................................................................... 28 
LARS_MI_Fulllevel3Indicator_Lookup ............................................................................... 28 
LARS_MI_NotionalNVQLevel_Lookup ............................................................................... 28 
LARS_MI_NotionalNVQLevelv2_Lookup ........................................................................... 28 
LARS_NotionalNVQLevel_Lookup .................................................................................... 28 
LARS_NotionalNVQLevelv2_Lookup ................................................................................. 29 
LARS_OccupationalIndicator_Lookup ............................................................................... 29 
LARS_OfQualOfferedEngland_Lookup .............................................................................. 29 
LARS_OfQualValid19Plus_Lookup .................................................................................... 29 
LARS_ProgType_Lookup .................................................................................................. 29 
LARS_QCFCertificateIndicator_Lookup ............................................................................. 29 
LARS_QCFDiplomaIndicator_Lookup ................................................................................ 29 
LARS_QCFIndicator_Lookup ............................................................................................ 29 
LARS_QltyAssAgencyType_Lookup .................................................................................. 29 
LARS_RecognisedHEForOfSFundingPurposes_Lookup ................................................... 30 
LARS_Route_Lookup ........................................................................................................ 30 
LARS_Section96ApprovalStatus_Lookup .......................................................................... 30 
LARS_Section96Valid16to18_Lookup ............................................................................... 30 
LARS_Section96Valid18plus_Lookup ................................................................................ 30 
LARS_Section96ValidPre16_Lookup................................................................................. 30 
LARS_SectorSubjectArea_Lookup .................................................................................... 31 
LARS_SectorSubjectAreaTier1_Lookup ............................................................................ 31 
LARS_SectorSubjectAreaTier2_Lookup ............................................................................ 31 
LARS_SFAApprovalStatus_Lookup ................................................................................... 31 
LARS_SFAFundedIndicator_Lookup ................................................................................. 31 
LARS_SourceURLLinkType_Lookup ................................................................................. 31 
LARS_StandardSectorCode_Lookup................................................................................. 32 
LARS_SuccessRateMapCode_Lookup ............................................................................. 32 
LARS_ValidityCategory_Lookup ........................................................................................ 32 
LARS_ValidityFundingMapping_Lookup ............................................................................ 32 
 
 
 

Table and field definitions for version 010 
 
Page 4 of 33 
Introduction 
• 
This document provides a definition of the complete set of tables and fields 
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 ‘010’ which will apply from 1 August 2024.  Version ‘009’ will still be 
produced until the end of the 2023 to 2024 collection year in October 2024. 
• 
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. 
 

Table and field definitions for version 010 
 
Page 5 of 33 
Changes from the 2023 to 2024 version 
This section outlines the changes that have been made from the 2023 to 2024 funding 
year structure.  
Renamed tables in version 010’s structure 
• We have not renamed any tables for version ‘010‘. 
Deleted tables 
• 
CoreReference_LARS_FundingBand_Lookup has been deleted for version 
‘010’. 
• No CORE tables have been deleted for version ‘010’. 
 
Existing tables amended in version ‘010’ structure 
 
• We have not amended any tables for version ‘010’. 
 
New tables created in version 010’s structure 
 
• 
The new tables created for the version ‘010’ download are: 
 
 
Table name 
Content description 
LARS_Devolved_Funding 
Details the funding related to Devolved Authorities (DA) 
LARS_Devolved_SoF_Lookup 
Details Source of Funding Codes and associated name for 
Devolved Authorities (DA) 
 
 

Table and field definitions for version 010 
 
Page 6 of 33 
Version 010 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.  
LARS_AnnualValue 
• 
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 
BasicSkillsBroadType 
Int 
The broad categorisation of basic skill 
BasicSkillsType 
Int 
The sub-category of the type of basic skill (e.g. Adult literacy, ESOL) 
BasicSkillsParticipation Int 
If the aim counts towards basic skills participation targets 
FullLevel2EntitlementC
ategory 
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  
FullLevel3EntitlementC
ategory 
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_FullLevel2Percent 
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_FullLevel3Percent 
Decimal The percentage a learning aim contributes to a Full Level 3 (only 
used for MI purposes) 

Table and field definitions for version 010 
 
Page 7 of 33 
Field Name 
Data 
Type 
Description 
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. 
 
LARS_ApprenticeshipFunding  
• 
This table contains the funding rates for a funding category for an apprenticeship 
covering standards and frameworks. 
Field Name 
Data Type 
Description 
ApprenticeshipType 
Text 
Whether funding is for a standard (STD) or a framework 
(FWK) 
ApprenticeshipCode 
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 
CoreGovContributionCap 
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 
1618ProviderAdditionalPayment. 
Decimal 
The value of the additional payment to a Provider for 
recruitment of younger or disadvantaged 
apprenticeships. 
1618EmployerAdditionalPayment. Decimal 
The value of the additional payment to an Employer for 
recruitment of younger or disadvantaged 
apprenticeships. 
1618FrameworkUplift 
Decimal 
The value of the additional payment for undertaking 
Framework Apprenticeships. 
Duration 
Decimal 
The typical expected duration of the apprenticeship in 
months 
CareLeaverAdditionalPayment 
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. 
MaxEmployerLevyCap 
Decimal 
The maximum employer levy contribution for the band 
FundableWithoutEmployer 
Text 
This field is not being used, the values will be set to ‘N’ 

Table and field definitions for version 010 
 
Page 8 of 33 
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 
 

Table and field definitions for version 010 
 
Page 9 of 33 
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 
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)  
SectorSubjectAreaTier1 
Decimal 
The broad (Tier 1) classification of the subject of the 
framework within the QCA Sector Subject Area (SSA) 
classification system 
SectorSubjectAreaTier2 
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 

Table and field definitions for version 010 
 
Page 10 of 33 
Field Name 
Data Type 
Description 
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) 
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 
 
 
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) 
FrameworkComponentType 
Int 
The component type of the aim within the framework 
e.g. a Technical Certificate as referenced in 
“LARS_ApprenticeshipComponentType_Lookup” 

Table and field definitions for version 010 
 
Page 11 of 33 
 
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 
CommonComponent 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 
 
 
 
 
 
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 
AdultSkillsFundingBand Text 
The adult skills funding band for the aim 
FundedGuidedLearning 
Hours 
Int 
The funded guided learning hours value for the 
aim 

Table and field definitions for version 010 
 
Page 12 of 33 
 
LARS_HECoS 
 
• 
This table contains the codes related to Higher Education Classification of Subjects 
(HECos) for each 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 
 
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  

Table and field definitions for version 010 
 
Page 13 of 33 
Field Name 
Data 
Type 
Description 
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 
FrameworkCommonComponent 
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 
KeySkillsIndicator 
Int 
If the learning aim is a key skill 
FunctionalSkillsIndicator 
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 
QCFDiplomaIndicator 
Int 
If the learning aim is a QCF Diploma  
QCFCertificateIndicator 
Int 
If the learning aim is a QCF Certificate 

Table and field definitions for version 010 
 
Page 14 of 33 
Field Name 
Data 
Type 
Description 
EFACOFType 
Int 
The EFACOFType (EFA condition of funding type) 
code assigned to the learning aim 
SFAFundedIndicator 
Int 
If the learning aim is, or will be, funded by the SFA 
DanceandDramaIndicator 
Int 
If the learning aim is a dance or drama aim 
Note 
Text 
To record any additional relevant information for the 
learning aim 
LearnDirectClassSystemCode1 
Text 
The code for the subject areas for the learning aim 
using the Learning Directory Classification System 
(LDCS) 
LearnDirectClassSystemCode2 
Text 
The code for the subject areas for the learning aim 
using the Learning Directory Classification System 
(LDCS) 
LearnDirectClassSystemCode3 
Text 
The code for the subject areas for the learning aim 
using the Learning Directory Classification System 
(LDCS) 
RegulatedCreditValue 
Int 
The learning aim’s credit value within a regulated 
credit framework 
SectorSubjectAreaTier1 
Decimal The broad (Tier 1) classification of a learning aim 
within the Qualification and Curriculum Authority 
(QCA) SSA classification system 
SectorSubjectAreaTier2 
Decimal The more detailed (Tier 2) classification of a learning 
aim within the QCA SSA classification system 
MI_NotionalNVQLevel 
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_NotionalNVQLevelv2 
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 
GuidedLearningHours 
Int 
The guided learning hours, defined by Ofqual for this 
learning aim 
TotalQualificationTime 
Int 
The total qualification time, defined by Ofqual for this 
learning aim 
RecognisedHEForOfSFundingPurposes Int 
To record HE for OfS funding purposes 
 
 
 
 
 
 
 
 
 
 
 

Table and field definitions for version 010 
 
Page 15 of 33 
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  
LastDateforNewStarts 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 
 
 
 
 
 
 
 
 
 
 

Table and field definitions for version 010 
 
Page 16 of 33 
 
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 
 
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 
ProgrammeCostWeightingFactor 
Decimal 
 
ProgrammeCostWeightingFactorDesc Text 
Freeformat 

Table and field definitions for version 010 
 
Page 17 of 33 
WorkExperience 
Int 
The length of days/weeks the 
programme runs for 
Hours 
Int 
Freeformat 
Duration 
Int 
The duration of the programme 
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 
Section96Valid16to18 
Int 
If the learning aim is valid for the 16 - 18 age group in 
accordance with Section 96 funding status 
Section96Valid18plus 
Int 
If the learning aim is valid for the 18 plus age group in 
accordance with the Section 96 funding status  
Section96ApprovalStatus 
Int 
The Section 96 approval status of the learning aim 
Section96ApprovalStartDate Date 
The start date of Section 96 approval for the learning aim 
Section96ReviewDate 
Date 
The date the approval under Section 96 will be reviewed 
Section96ValidPre16 
Int 
If the learning aim is valid for the pre-16 age group in 
accordance with the Section 96 funding status 
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  
StandardName 
Text 
The name of the apprenticeship standard  
StandardSectorCode 
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 
UrlLink 
Text 
The URL link to details of the apprenticeship standard where 
appropriate 
SectorSubjectAreaTier1 
Decimal The broad (Tier 1) classification of the apprenticeship 
standard within the QCA SSA classification system 

Table and field definitions for version 010 
 
Page 18 of 33 
Field Name 
Data 
Type 
Description 
SectorSubjectAreaTier2 
Decimal The more detailed (Tier 2) classification of the 
apprenticeship standard within the QCA SSA classification 
system 
IntegratedDegreeStandard 
Text 
Used to indicate if this standard is considered as an 
Integrated Degree Standard [Y (YES) or N (NO)] 
OtherBodyApprovalRequired 
Text 
Identify if the Standard requires approval for delivery by 
Provider 
 
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) 
StandardComponentType 
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  
CommonComponent 
Int 
The common component type (e.g. Functional Skill) 
EffectiveFrom 
Date 
The date this record is effective from  

Table and field definitions for version 010 
 
Page 19 of 33 
Field Name 
Data Type 
Description 
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 
 
 
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 
CoreGovContributionCap 
Decimal 
The maximum government contribution for the band 
1618Incentive 
Decimal 
The incentive value for recruitment of a 16-18 year old 
for the band 
SmallBusinessIncentive 
Decimal 
The incentive value for small businesses (<50) for the 
band. 
AchievementIncentive 
Decimal 
The value for completion of the standard for the band 
FundableWithoutEmployer Text 
If the standard can be delivered without an employer. 
This is not used. 
 
 
 
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 
 
 
 

Table and field definitions for version 010 
 
Page 20 of 33 
 
 
 
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 
 
 
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 
 

Table and field definitions for version 010 
 
Page 21 of 33 
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 
 
 
 
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 
MaintenanceNumber 
Int 
The sequence of maintenance changes, within minor 
changes, to the database e.g. correcting the spelling of a field 
name 
MainDataSchemaName 
Text 
The name of the schema of the core data 
RefDataSchemaName 
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 
 
 
Version 010 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 

Table and field definitions for version 010 
 
Page 22 of 33 
“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 
ReferenceTableDesc2 
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 field A2LevelIndicator. 
Field Name 
Data Type 
Description 
A2LevelIndicator 
Int 
The reference table code 
A2LevelIndicatorDesc 
Text 
The description of the reference table code 
A2LevelIndicatorDesc2 
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_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 
AcademicYearDesc 
Text 
The description of the academic (funding) year code 
AcademicYearDesc2 
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 

Table and field definitions for version 010 
 
Page 23 of 33 
 
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 
AdultSkillsFundingBand 
Text 
The adult skills funding band  
AdultSkillsFundingBandRate 
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 
 
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_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. 
LARS_AwardOrgCode_Lookup 
• 
This table contains the codes for Awarding Organisations. Note the field type is 
“Text” and not “Int”. 
 

Table and field definitions for version 010 
 
Page 24 of 33 
Field Name 
Data Type 
Description 
AwardOrgCode 
Text 
The Awarding Organisation code 
AwardOrgUKPRN 
Int 
The Awarding Organisation UKPRN value 
AwardOrgName 
Text 
The Awarding Organisation name 
AwardOrgShortName 
Text 
The short name for the Awarding Organisation 
AswardOrgAcronym 
Text 
The acronym of the Awarding Organisation 
AwardOrgNonExtant 
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 
AwardOrgHigherEducationInst 
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. 
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. 

Table and field definitions for version 010 
 
Page 25 of 33 
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. 
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 
MCAGLAShortCode 
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 
 

Table and field definitions for version 010 
 
Page 26 of 33 
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”.  
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 
FundingCategoryDesc 
Text 
The description of the funding category code 
FundingCategoryDesc2 
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 

Table and field definitions for version 010 
 
Page 27 of 33 
Field Name 
Data Type 
Description 
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. 
 
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 
IssuingAuthorityDesc 
Text 
The Issuing Authority Name 
IssuingAuthorityDesc2 
Text 
The Issuing Authority short name 
IssuingAuthorityUKPRN 
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 

Table and field definitions for version 010 
 
Page 28 of 33 
 
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”. 
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”. 

Table and field definitions for version 010 
 
Page 29 of 33 
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.  
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 
OfQualValid19PlusDesc 
Text 
The description of the OfQualValid19Plus code 
OfQualValid19PlusDesc2 
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.  

Table and field definitions for version 010 
 
Page 30 of 33 
LARS_RecognisedHEForOfSFundingPurposes_Lookup 
• 
 This table defines Addition link to new Learning Delivery field in 
LARS_RecognisedHEForOfSFundingPurposes table.   
Field Name 
Data 
Type 
Description 
RecognisedHEForOfSFundingPurposes 
Int 
The OfS Funding ID  
RecognisedHEForOfSFundingPurposesD
esc 
Text 
The description of whether the HE 
aim if funded by OfS 
RecognisedHEForOfSFundingPurposesD
esc2 
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 
 
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. 

Table and field definitions for version 010 
 
Page 31 of 33 
LARS_SectorSubjectArea_Lookup 
• 
This table defines the codes for SectorSubjectArea (SSA). The field type is 
“Decimal” and not “Int”. 
 
Field Name 
Data Type 
Description 
SectorSubjectAreaTier1 
Decimal 
The SSA (Tier 1) code 
SectorSubjectAreaTier1Desc 
Text 
The SSA (Tier 1) code description 
SectorSubjectAreaTier1Desc2 
Text 
The SSA (Tier 1) code description short name 
SectorSubjectAreaTier1_EffFrom 
Date 
The date the SSA (Tier 1) code is valid from 
SectorSubjectAreaTier1_EffTo 
Date 
The date the SSA (Tier 1) code is valid to 
SectorSubjectAreaTier2 
Decimal 
The SSA (Tier 2) code 
SectorSubjectAreaTier2Desc 
Text 
The SSA (Tier 2) code description 
SectorSubjectAreaTier2Desc2 
Text 
The SSA (Tier 2) code description short name 
SectorSubjectAreaTier2_EffFrom 
Date 
The date the SSA (Tier 2) code is valid from 
SectorSubjectAreaTier2_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.  
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 
SourceURLLinkTypeDesc 
Text 
The description of the source URL link type 

Table and field definitions for version 010 
 
Page 32 of 33 
Field Name 
Data Type 
Description 
SourceURLLinkTypeDesc 
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”. 
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 
ValidityCategoryDesc 
Text 
The description of the validity category code 
ValidityCategoryDesc2 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 

Table and field definitions for version 010 
 
Page 33 of 33 
 
© Crown copyright 2024 
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 Twitter: @educationgovuk 
Connect with us on Facebook: facebook.com/educationgovuk