|Field description||Field abbreviation||Field version||Field length||Field type|
|Analytical protocol JACS - level 3 grouping||XJACSLEV301||1.6.1||3||Char|
|003||Anatomy, physiology & pathology|
|004||Pharmacology, toxicology & pharmacy|
|009||Aural & oral sciences|
|011||Others in subjects allied to medicine|
|016||Molecular biology, biophysics & biochemistry|
|017||Others in biological sciences|
|023||Food & beverage studies|
|024||Agriculture & others in veterinary sciences, agriculture & related subjects|
|026||Physics & astronomy|
|027||Forensic & archaeological science|
|030||Others in physical sciences|
|031||Physical geography & environmental science|
|032||Mathematics & statistics|
|037||Mechanical, production & manufacturing engineering|
|040||Electronic & electrical engineering|
|042||Chemical, process & energy engineering|
|043||Others in engineering|
|044||Materials & minerals technology|
|046||Others in technology|
|050||Planning (urban, rural & regional)|
|051||Others in architecture, building & planning|
|057||Others in social studies|
|059||Human & social geography|
|064||Human resource management|
|067||Tourism, transport & travel|
|068||Others in business & administrative studies|
|074||Others in mass communications & documentation|
|076||American & Australasian studies|
|080||German & Scandinavian studies|
|083||Others in European languages & area studies|
|085||Comparative literary studies|
|086||Others in linguistics, classics & related subjects|
|088||African & modern Middle Eastern studies|
|089||Others in Eastern, Asian & African languages & area studies|
|092||Others in historical & philosophical studies|
|094||Theology & religious studies|
|100||Cinematics & photography|
|102||Others in creative arts & design|
|104||Research & study skills in education|
|105||Academic studies in education|
|106||Others in education|
|108||Initial teacher training|
Depend upon fields
XJACSLEV301 is based on the Unistats level 3 groupings, adopted in HESA's Data Quality Assurance and Analytical Services teams' Unistats specifications - as informed by HEFCE's requirements.
This field maps XJACS01 (held on the _SJ table of both the Cyy051 Student and Cyy054 AP student records) to the three Unistats groupings via a lookup table supplied by HESA's Data Management team in Oracle, as described in the technical specification.
The valid entries used in XJACS01 are as per Course_Subject.SBJCA field in the relevant collection year.
From 2012/13 the underlying JACS subject coding frame adopted the JACS3 subject codes.
The table static_data.XJACSLEV_lookup_V2 consists of four columns: F_XJACS01 (CHAR 4); F_XJACSLEV1 (CHAR 1); F_XJACSLEV2 (CHAR 2); F_XJACSLEV3 (CHAR 3).
1. If a Student teacher training course identifier (Course.TTCID) is submitted and coded 1 'On initial or pre-service teacher training course leading to Qualified Teacher Status or to registration as a school teacher with the General Teaching Council for Scotland'; 2 'On other initial teacher training course not leading to Qualified Teacher Status nor to registration as a school teacher with the General Teaching Council for Scotland'; or Q 'Early Years Initial Teacher Training' then XJACSLEV201 is coded 108 'Initial teacher training', irrespective of the XJACS01 code derived for that instance.
2. If Course.TTCID is not 1, 2 or Q, lookup XJACS01 in XJACSLEV_lookup_V2.F_XJACS01 and return a value from F_XJACSLEV3 for this field.
3. Where XJACS01 is not found in XJACSLEV_lookup_V2.F_XJACS01, return Null. This is an error, highlighting that a value is not a valid entry in the lookup table. This is designed so the derived function does not fail. Nulls are to be identified at impossible values testing to flag the issue to HESA's Data Management team.
Note to developers: This specification is hierarchical. Complete top down.
|Course.TTCID (CHAR 1)||XJACS01 on the _SJ table (CHAR 4)||XJACSLEV301|
|1, 2, Q||108|
|Found in XJACSLEV_lookup_V2 .F_XJACS01||XJACSLEV_lookup_V2 .F_XJACSLEV3|
|Not found in XJACSLEV_lookup_V2 .F_XJACS01||Null|
|2016-11-01||1.6.1||Technical specification updated to reflect the deletion of Course.TTCID valid entries 8 and G in the list of codes that define ITT. Change to function.|
|2016-02-02||1.5.2||Minor typographic correction to the label for valid entry 080, correcting the spelling of 'Scandinavian'.|
|2014-10-16||1.5.1||Technical specification updated to reflect the addition of Course.TTCID valid entry Q, and the deletion of valid entries H, L, M, N and P, in the list of codes that define ITT. Change to function. Additional information section amended to allow for the use of this field in the Cyy054 AP student record.|
|2013-09-30||1.4.1||Technical specification change to include Course.TTCID codes L, M, N and P, and the deletion of J and K, in the list of codes that derive valid entry 108 'Initial teacher training'. Corresponding update to text in this section. Change to function.|
|2013-04-08||1.3.1||Technical specification change to include Course.TTCID codes G, H, J, and K in the list of codes that derive valid entry 108 'Initial teacher training'. Corresponding update to text in this section. Change to function.|
|2013-01-21||1.2.1||Change of lookup table in technical specification to XJACSLEV_lookup_V2 in Oracle with the move to using JACS 3.0. Valid entry 034 'Others in mathematical & computer sciences' removed as this is no longer derivable from JACS 3.0. References to NSS and TQI in additional information changed to Unistats.|
Contact Liaison by email or on 01242 211144.