Analytical LAD 2009/2010

NOTE: Standard File Views are open to change

1. The Analytical LAD is an export from the Learning Aims Database (LAD) into flat file format.

PURPOSE

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

DETAILED DEFINITION

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

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

Figure 1. Fields in the Analytical LAD


Analytical LAD Variable Name	Variable Label	Oracle LAD Field Name	09/10 LAD Tables	Field Type	Field Length
A09	A09 Aim Reference	learning_aim_ref	Learning Aim	String	8
A09_TITL	A09_TITL Aim Title	learning_aim_title	Learning Aim	String	150
A_AWARDB	A_AWARDB Awarding Body Code	awarding_body_id	Learning Aim	String	8
A_QUALID	A_QUALID Awarding Body Reference	awbody_aim_ref	Learning Aim	String	8
A_LATYPE	A_LATYPE_V2 Version 2 Aim Type	learning_aim_type_id	Learning Aim	String	4
A_LATYPE_V2	A_LATYPE_V2 Version 2 Aim Type	learning_aim_v2_ type_id	Learning Aim	String	8
A_SUB_LATYPE_ V2	A_SUB_LATYPE_V2 Version 2 Aim Sub Type	learning_aim _v2_subtype_id	Learning Aim	String	8
A_NOTION	A_NOTION Notional NVQ Level	notional_nvq_level_ id	Learning Aim	String	1
A_NOTLV2	A_NOTLV2 Notional NVQ Level v2	notional_level_v2_id	Learning Aim	String	1
A_CURRIND	A_CURRIND Current Provision indicator	current_provision_id	Learning Aim	String	1
A_SUPLAF	A_SUPLAF Superseding Aim Reference	superseding _learning_aim_id	Learning Aim	String	8
A_GENAIM	A_GENAIM Generic Aim	generic_aim_code	Learning Aim	String	1
A_BSKDIA	A_BSKDIA Basic Skills Diagnostic Test	basic_skills_diag_ test	Learning Aims	String	1
A_INDLS	A_INDLS Independent Living Skill	indep_living_skill	Annual Values	String	1
A_KSCODE	A_KSCODE Key Skill Type	key_skill_id	Annual Values	String	1
A_L2CAT	A_L2CAT Full Level 2 Category	level2_entitlement_ cat_id	Annual Values	String	2
A_L2PCT	A_L2PCT Full Level 2 Pct	level2_percentage	Annual Values	Numeric
A_L3CAT	A_L3CAT Full Level 3 Entitlement	level3_entitlement_ cat_id	Annual Values	String	2
A_L3PCT	A_L3PCT Full Level 3 Pct	level3_percentage	Annual Values	Numeric
A_INSP_C	A_INSP_C INSP Code	insp_code_id	Learning Aim	String	8
A_MAP_C	A_MAP_C MAP Code	map_code_id	Learning Aim	String	8
A_QCF_CREDIT	A_QCF_CREDIT Credit Value from QCA	ffa_credit	Annual Values	Numeric
A_QCAGLH	A_QCAGLH GLH from QCA	qca_glh	Learning Aim	String	120
A_SSA_T2	A_SSA_T2 LAD SSA Tier 2 Code	ssa_code_id	Annual Values	String	5
A_SSA_T1	A_SSA_T1 LAD SSA Tier 1 Code	ssa_code_id	Annual Values	String	5
A_LDCS_1	A_LDCS_1 Learn Direct Classification System Code	ldcs_code_id	Annual Values	String	50
A_LDCS_2	A_LDCS_2 LearnDirect Classification System Code	ldcs_code2_id	Annual Values	String	50
A_LDCS_3	A_LDCS_3 LearnDirect Classification System Code	ldcs_code3_id	Annual Values	String	50
A_ENGLEV	A_ENGLEV England FE HE Status	england_fe_he_ status_id	Learning Aim	String	1
A_SUPRCL	A_SUPRCL 1st Superclass Code	superclass_id	Learning Aim	String	10
A_SUPRC3	A_SUPRC3 3rd Superclass Code	superclass3_id	Learning Aim	String	10
A_SUPRC2	A_SUPRC2 2nd Superclass Code	superclass2_id	Learning Aim	String	10
A_LEAP_C	A_LEAP_C Leap Code	learning_prog_ code_id	Learning Aim	String	4
A_ENG_S2	A_ENG_S2 England Schedule 2	eng_schedule2_id	Learning Aim	String	2
A_ACC_NOT_ DFES	A_ACC_NOT_DFES Accredited, Not Current DfES Approved	flag10	Learning Aim	String	1
A_FLAG11	A_FLAG11 Framework Completion Class Code	flag11	Learning Aim	String	1
A_FLAG12	A_FLAG12 Only for use on designated Approval Employer	flag12	Learning Aim	String	1
A_ACC_POSS_ NOT_DFES	A_ACC_POSS_ NOT_DFES Accredited, But May Not be DfES Approved	flag13	Learning Aim	String	1
A_FLAG14	A_FLAG14 Not in Current Use	flag14	Learning Aim	String	1
A_S96_P16	A_S96_P16 Section96 Pre-16 Age Category	sec_96_pre_16	Annual Values	String	2
A_S96_1618	A_S96_1618 Section96 16-18 Age Category	sec_96_16_18	Annual Values	String	2
A_S96_ADULT	A_S96_ADULT Section96 18+ Age Category	sec_96_18_plus	Annual Values	String	2
A_S97_ADULT	A_S97_ADULT Section97 19+ Age Category	sec_97_19_plus	Annual Values	String	2
A_FUN_ST	A_FUN_ST LSC Funded Status	lsc_funding_status_id	Annual Values	String	2
A_LR_1618_ WGT_FACT	A_LR_1618_WGT_ FACT Weighting Factor for 16-18 LR Funding	lsc_lr_wgt_factor_ 1618_id	1618 Annual Values	String	1
A_LR_SLN_ GLH_1618_1	A_LR_SLN_GLH_ 1618_1 SLN GLH for 16-18 LR Provision Value 1	Sln_glh_1618_1	1618 Annual Values	Numeric
A_LR_SLN_ GLH_1618_2	A_LR_SLN_GLH_ 1618_2 SLN GLH for 16-18 LR Provision Value 2	Sln_glh_1618_2	1618 Annual Values	Numeric
A_LR_SLN_ GLH_1618_3	A_LR_SLN_GLH_ 1618_3 SLN GLH for 16-18 LR Provision Value 3	Sln_glh_1618_3	1618 Annual Values	Numeric
A_LR_SLN_ GLH_SSF_1	A_LR_SLN_GLH_SSF _1 SLN GLH for SSF Provision	sln_glh_ssf_1	1618 Annual Values	Numeric
A_LR_1618_ STATUS	A_LR_1618_ STATUS Aim Available for 16-18 LR Funding	lsc_learn_resp _1618_status_id	1618 Annual Values	String	1
A_LR_1618_ WAGLH	A_LR_1618_WAGLH WAGLH for 16-18 LR	lsc_learn_resp_ 1618_waglh	1618 Annual Values	Numeric
A_LR_ADULT_ WGT_FACT	A_LR_ADULT_ WGT_FACT Weighting Factor for LR Adults	lsc_lr_wgt_factor_ adult_id	Adult Annual Values	String	1
A_LR_SLN_GLH_ ADULT_1	A_LR_SLN_GLH_ ADULT_1 SLN GLH for Adult LR Provision Value 1	sln_glh_adult_1	Adult Annual Values	Numeric
A_LR_SLN_GLH_ ADULT_2	A_LR_SLN_GLH_ ADULT_2 SLN GLH for Adult LR Provision Value 2	sln_glh_adult_2	Adult Annual Values	Numeric
A_LR_ADULT_ STATUS	A_LR_ADULT_ STATUS Aim Available for Adult LR	lsc_learn_resp _adult_status_id	Adult Annual Values	String	1
A_LR_ADULT_ WAGLH	A_LR_ADULT_ WAGLH WAGLH for LR Adults	lsc_learn_resp_ adult_waglh	Adult Annual Values	Numeric
A_ER_WGT_FACT	Weighting factor code for employer responsive funding (excluding apprenticeships)	lsc_emp_resp _wgt_factor_id	Employer Annual Values	String	1
A_APP_WGT_ FACT	A_APP_WGT_FACT Apprenticeship Weighting Factor Code	lsc_apprntshp_resp _wgt_factor_id	Employer Annual Values	String	1
A_ER_STATUS	A_ER_STATUS Aim Available for Employer Responsive Provision	lsc_emp_resp_ status_id	Employer Annual Values	String	1
A_ER_FEE_ ELEM_PERCENT	A_ER_FEE_ELEM_ PERCENT Fee Element Percentage for Aim	fee_element_ percentage	Employer Annual Values	Numeric
A_SLN_APP_1	A_SLN_APP_1 SLN Field for Apprenticeships	sln_apprenticeship_1	Employer Annual Values	Numeric
A_ER_SLN_1	A_ER_SLN_1 SLN field 1 for Employer Responsive Provision that is Not an Apprenticeship	sln_emp_resp_1	Employer Annual Values	Numeric
A_ER_SLN_2	A_ER_SLN_2 SLN field 2 for Employer Responsive Provision That is Not an Apprenticeship	sln_emp_resp_2	Employer Annual Values	Numeric
A_ACLAVC	A_ACLAVC ACL Annual Value Status	acl_annual_val_ status_id	ACL Annual Values	String	1
A_NOLOFF	A_NOLOFF Aim Reference No Longer Offered	aim_no_longer_ offered	Annual Values	String	1
A_ADISDA	A_ADISDA Aim Reference Discontinued Date	aim_discontinued _date	Learning Aims	Date
A_NLSCFC	A_NLSCFC All Annual Value Status	non_lsc_funded_ status_id	Annual Values	String	2
A_DALC	A_DALC Date Aim Last Changed	date_aim_last_ changed	Learning Aim	Date
A_SFL	A_SFL Counts towards Skills for Life Target	basic_skill	Annual Values	Numeric
A_SFLTYP	A_SFLTYP Advanced Skills for Life Type including Level and Awarding Body	basic_skill_type_id	Annual Values	String	2
A_QCF_TYPE	A_QCF_TYPE Qualifications and Credit Framework Type Code	ffa_type_id	Learning Aim	String	50
A_QCF_REF	A_QCF_REF Qualifications and Credit Framework Reference	ffa_ref	Learning Aim	String	50
A_VOC_RELATED_ CODE	A_VOC_RELATED_ CODE Vocationally- Related Indicator	voc_related_id	Annual Values	String	50
A_LINES_ LEARNING	A_LINES_LEARNING Line of Learning (for Diplomas and Principal Learning qualifications)	lines_of_learning_id	Learning Aim	String	5
A_QAA_REF	A_QAA_REF QAA reference for this aim	qaa_ref	Learning Aim	String	50
A_SECTOR_LEAD	A_SECTOR_LEAD SSC Other Body With Aim Within Footprint	sector_lead_body_id	Learning Aim	String	15
A_FWK_COMM_ COMP	A_FWK_COMM_COMP Common Component Within Frameworks	common_component _id	Learning Aim	String	3
A_LTRC_SPECIFIC	A_LTRC_SPECIFIC Specific to LTRC Provision with Provider Factor Uplift	ltrc_specific_aim	Learning Aim	Numeric
A_ENTRY_SUB	A_ENTRY_SUB Sub-Entry Levels of an Entry Level Aim (Where Known)	entry_sub_level_id	Learning Aim	String	8
A_ADD_SPEC_ LEARN	A_ADD_SPEC_LEARN Additional or Specialist Learning Within One or More 14-19 Diplomas	add_specialist _learning_code	Annual Values	Numeric
A_SECT_SKILLS_ PRIORITY	A_SECT_SKILLS _PRIORITY Priority for Relevant Sector Skills Council or Standard Setting Board, and The LSC	lsc_sector_skills_ priority_id	Annual Values	String	1
A_LR_GROWTH_ PRIORITY	A_LR_GROWTH_ PRIORITY Priority When Reconciling Over-Performance for LR Provision	lsc_growth_priority _id	Annual Values	String	1
A_ACC_STRT_ DATE	A_ACC_STRT_ DATE Aim Accreditation Start Date	Accreditation Start Date	Annual Values	Date
A_ACC_END_ DATE	A_ACC_END_DATE Aim Accreditation End Date	Accreditation End Date	Annual Values	Date
A_CERT_END_ DATE	A_CERT_END_DATE Aim Certification End Date	Certification End Date	Annual Values	Date
A_LSC_FUND_ START_DATE	A_LSC_FUND_START _DATE Start of LSC Funding Eligibility	lsc_funding_start_date	Annual Values	Date
A_LSC_FUND_ END_DATE	A_LSC_FUND_END _DATE Date LSC Funding Eligibility Ends	lsc_funding_end_date	Annual Values	Date
A_S96_APP_ STRT_SUITE	A_S96_APP_STRT _SUITE S96 Approval Start Date of qualification within GCE/GCSE, Apprenticeships, Progression Pathways, 14-19 Diplomas	S96_Approval_ Start_Suite	Annual Values	Date
A_S96_APP_ END_SUITE	A_S96_APP_END _SUITE S96 Approval End Date of qualification within GCE/GCSE, Apprenticeships, Progression Pathways, 14-19 Diplomas	S96_Approval_ End_Suite	Annual Values	Date
A_S96_APP_STRT _STNDALNE	A_S96_APP_STRT_ STNDALNE S96 Approval Start Date of stand alone qualification	S96_Approval_ Start_Standalone	Annual Values	Date
A_S96_APP_END _STNDALNE	A_S96_APP_END_ STNDALNE S96 Approval End Date of stand alone qualification	S96_Approval_ End_Standalone	Annual Values	Date
A_S97_APP_ STRT_DATE	A_S97_APP_STRT _DATE S97 Approval Start Date of Aim	S97_Approval_ Start_Date	Annual Values	Date
A_S97_APP_] END_DATE	A_S97_APP_END _DATE S97 Approval End Date of Aim	S97_Approval_ End_Date	Annual Values	Date
A_APPROV	A_APPROV The Organisation That has Approved The Aim	lsc_aim_approved_ by_id	Annual Values	String	8

Date last modified: 29th July 2009