Sector Subject Areas Data Definition 2009/2010
A_SSA_T1, A_SSA_T2
DATA DEFINITION
1. Identifies the Sector Subject Area of an aim.
PURPOSE
2. Classifies an aim within the Qualifications and Curriculum Authority (QCA) Sector Subject Area (SSA) classification system.
CURRENT COLLECTIONS
- ILR (LR)
- ILR (UfI)
- ILR (ASL)
- ILR (ER)
- ILR (ESF SR)
SOURCE DATA
3. The following variables are used as source data for the calculation of Sector Subject Areas data definition.
| Field Name |
Label |
Dataset |
| A09 |
A09 Aim Reference |
Aims Standard File |
| A15 |
A15 Programme Type |
Aims Standard File |
| A26 |
A26 Sector Framework code |
Aims Standard File |
| A_SSA_T1 |
A_SSA_T1 LAD SSA Tier 1 Code |
Analytical LAD* |
| A_SSA_T2 |
A_SSA_T2 LAD SSA Tier 2 Code |
Analytical LAD* |
| A15 |
A15 Programme Type |
LSC_FRAMEWORKS_AVS |
| A26 |
A26 Sector Framework code |
LSC_FRAMEWORKS_AVS |
| F_SSA_T1 |
F_SSA_T1 LAD SSA Tier 1 Code |
LSC_FRAMEWORKS_AVS |
| F_SSA_T2 |
F_SSA_T2 LAD SSA Tier 2 Code |
LSC_FRAMEWORKS_AVS |
* The oracle LAD database uses field ssa_code_id to populate these fields.
DERIVED VARIABLES AND DATASETS
4. The definition produces the following derived variable(s)
| Field Name |
Label |
Dataset |
| A_SSA_T1 |
A_SSA_T1 LAD SSA Tier 1 Code |
Aims Standard File |
| A_SSA_T2 |
A_SSA_T2 LAD SSA Tier 2 Code |
Aims Standard File |
DETAILED DEFINITION
5. The value for the broad classification of the subject within the QCA Sector Subject Area classification system in the LAD is assigned to each aim in the aims standard files.
6. Similarly, the value for the more specialised classification of the subject within the QCA Sector Subject Area classification system in the LAD is assigned to each aim in the aims standard files
7. Where the learning aim is not a programme aim the values are matched in from the aim level learning aims table in LAD. Where the learning aim is a programme type the aim level sector subject area are over written with the value from the framework annual values table in LAD matched in using the programme type and sector framework code.
VALUES
8. The table below outlines the categories for A_SSA_T1.
| A_SSA_T1 |
Label |
| 1 |
Health, Public Services and Care |
| 2 |
Science and Mathematics |
| 3 |
Agriculture, Horticulture and Animal Care |
| 4 |
Engineering and Manufacturing Technologies |
| 5 |
Construction, Planning and the Built Environment |
| 6 |
Information and Communication Technology |
| 7 |
Retail and Commercial Enterprise |
| 8 |
Leisure, Travel and Tourism |
| 9 |
Arts, Media and Publishing |
| 10 |
History, Philosophy and Theology |
| 11 |
Social Sciences |
| 12 |
Languages, Literature and Culture |
| 13 |
Education and Training |
| 14 |
Preparation for Life and Work |
| 15 |
Business, Administration and Law |
| 98 |
Unknown |
| 99 |
Not Applicable |
8. The table below outlines the categories for A_SSA_T2.
| A_SSA_T2 |
Label |
| 1 |
Health, Public Services and Care |
| 1.1 |
Medicine and Dentistry |
| 1.2 |
Nursing and Subjects and Vocations Allied to Medicine |
| 1.3 |
Health and Social Care |
| 1.4 |
Public Services |
| 1.5 |
Child Development and Well Being |
| 2 |
Science and Mathematics |
| 2.1 |
Science |
| 2.2 |
Mathematics and Statistics |
| 3 |
Agriculture, Horticulture and Animal Care |
| 3.1 |
Agriculture |
| 3.2 |
Horticulture and Forestry |
| 3.3 |
Animal Care and Veterinary Science |
| 3.4 |
Environmental Conservation |
| 4 |
Engineering and Manufacturing Technologies |
| 4.1 |
Engineering |
| 4.2 |
Manufacturing Technologies |
| 4.3 |
Transportation Operations and Maintenance |
| 5 |
Construction, Planning and the Built Environment |
| 5.1 |
Architecture |
| 5.2 |
Building and Construction |
| 5.3 |
Urban, Rural and Regional Planning |
| 6 |
Information and Communication Technology |
| 6.1 |
ICT Practitioners |
| 6.2 |
ICT for Users |
| 7 |
Retail and Commercial Enterprise |
| 7.1 |
Retailing and Wholesaling |
| 7.2 |
Warehousing and Distribution |
| 7.3 |
Service Enterprises |
| 7.4 |
Hospitality and Catering |
| 8 |
Leisure, Travel and Tourism |
| 8.1 |
Sport, Leisure and Recreation |
| 8.2 |
Travel and Tourism |
| 9 |
Arts, Media and Publishing |
| 9.1 |
Performing Arts |
| 9.2 |
Crafts, Creative Arts and Design |
| 9.3 |
Media and Communication |
| 9.4 |
Publishing and Information Services |
| 10 |
History, Philosophy and Theology |
| 10.1 |
History |
| 10.2 |
Archaeology and Archaeological Sciences |
| 10.3 |
Philosophy |
| 10.4 |
Theology and Religious Studies |
| 11 |
Social Sciences |
| 11.1 |
Geography |
| 11.2 |
Sociology and Social Policy |
| 11.3 |
Politics |
| 11.4 |
Economics |
| 11.5 |
Anthropology |
| 12 |
Languages, Literature and Culture |
| 12.1 |
Languages, Literature and Culture of the British Isles |
| 12.2 |
Other Languages, Literature and Culture |
| 12.3 |
Linguistics |
| 13 |
Education and Training |
| 13.1 |
Teaching and Lecturing |
| 13.2 |
Direct Learning Support |
| 14 |
Preparation for Life and Work |
| 14.1 |
Foundations for Learning and Life |
| 14.2 |
Preparation for Work |
| 15 |
Business, Administration and Law |
| 15.1 |
Accounting and Finance |
| 15.2 |
Administration |
| 15.3 |
Business Management |
| 15.4 |
Marketing and Sales |
| 15.5 |
Law and Legal Services |
| 98 |
Unknown |
| 99 |
Not Applicable |
Sector Subject Areas Sample Code
1. The following SPSS code is provided to illustrate the Sector Subject Areas data definition.
A_SSA_T1, A_SSA_T2
2. The following SPSS code illustrates how to match A_SSA_T1 and A_SSA_T2 on to the Aims data set.
|
GET FILE=’………………..AIMS data set’.
SORT CASES A09.
MATCH FILES /FILE=*
/TABLE=’………………..Analytical LAD data set’
/BY A09.
VARIABLE LABELS A_SSA_T1 ‘A_SSA_T1 LAD SSA Tier 1 Code’
/A_SSA_T2 ‘A_SSA_T2 LAD SSA Tier 2 Code’
Sort Cases by A15 A26.
MATCH FILES /FILE=*
/TABLE=’………………..Analytical LAD framework data set’
/BY A15 A26.
Do If A04 = 35
Compute A_SSA_T1 = F_SSA_T1.
Compute A_SSA_T2 = F_SSA_T2.
End if.
VALUE LABELS A_SSA_T2
"01.1" "Medicine and Dentistry"
"01.2" "Nursing and Subjects and Vocations Allied to Medicine"
"01.3" "Health and Social Care"
"01.4" "Public Services"
"01.5" "Child Development and Well Being"
"02.1" "Science"
"02.2" "Mathematics and Statistics"
"03.1" "Agriculture"
"03.2" "Horticulture and Forestry"
"03.3" "Animal Care and Veterinary Science"
"03.4" "Environmental Conservation"
"04.1" "Engineering"
"04.2" "Manufacturing Technologies"
"04.3" "Transportation Operations and Maintenance"
"05.1" "Architecture"
"05.2" "Building and Construction"
"05.3" "Urban, Rural and Regional Planning"
"06.1" "ICT Practitioners"
"06.2" "ICT for Users"
"07.1" "Retailing and Wholesaling"
"07.2" "Warehousing and Distribution"
"07.3" "Service Enterprises"
"07.4" "Hospitality and Catering"
"08.1" "Sport, Leisure and Recreation"
"08.2" "Travel and Tourism"
"09.1" "Performing Arts"
"09.2" "Crafts, Creative Arts and Design"
"09.3" "Media and Communication"
"09.4" "Publishing and Information Services"
"10.1" "History"
"10.2" "Archaeology and Archaeological Sciences"
"10.3" "Philosophy"
"10.4" "Theology and Religious Studies"
"11.1" "Geography"
"11.2" "Sociology and Social Policy"
"11.3" "Politics"
"11.4" "Economics"
"11.5" "Anthropology"
"12.1" "Languages, Literature and Culture of the British Isles"
"12.2" "Other Languages, Literature and Culture"
"12.3" "Linguistics"
"13.1" "Teaching and Lecturing"
"13.2" "Direct Learning Support"
"14.1" "Foundations for Learning and Life"
"14.2" "Preparation for Work"
"15.1" "Accounting and Finance"
"15.2" "Administration"
"15.3" "Business Management"
"15.4" "Marketing and Sales"
"15.5" "Law and Legal Services"
"98" "Unknown"
"99" "Not Applicable"
"01" "Health, Public Services and Care"
"02" "Science and Mathematics"
"03" "Agriculture, Horticulture and Animal Care"
"04" "Engineering and Manufacturing Technologies"
"05" "Construction, Planning and the Built Environment"
"06" "Information and Communication Technology"
"07" "Retail and Commercial Enterprise"
"08" "Leisure, Travel and Tourism"
"09" "Arts, Media and Publishing"
"10" "History, Philosophy and Theology"
"11" "Social Sciences"
"12" "Languages, Literature and Culture"
"13" "Education and Training"
"14" "Preparation for Life and Work"
"15" "Business, Administration and Law"
/A_SSA_T1 "01" "Health, Public Services and Care"
"02" "Science and Mathematics"
"03" "Agriculture, Horticulture and Animal Care"
"04" "Engineering and Manufacturing Technologies"
"05" "Construction, Planning and the Built Environment"
"06" "Information and Communication Technology"
"07" "Retail and Commercial Enterprise"
"08" "Leisure, Travel and Tourism"
"09" "Arts, Media and Publishing"
"10" "History, Philosophy and Theology"
"11" "Social Sciences"
"12" "Languages, Literature and Culture"
"13" "Education and Training"
"14" "Preparation for Life and Work"
"15" "Business, Administration and Law"
"98" "Unknown"
"99" "Not Applicable". |
3. The following SQL code illustrates how to match A_SSA_T1 and A_SSA_T2 on to the Aims data set.
|
select
L01, L03, A15, A26
, B.F_SSA_T1 as A_SSA_T1
, B.F_SSA_T2 as A_SSA_T2
from
AIMS_FILE A
join
LAD B
on A.A09=B.A09
where A04=35
group by
L01, L03, A15, A26 |
Date last modified: 07th January 2010
