XJACSLEV201_1.6.1
Field description | Field abbreviation | Field version | Field length | Field type |
---|---|---|---|---|
Analytical protocol JACS - level 2 grouping | XJACSLEV201 | 1.6.1 | 2 | Char |
Valid entries
Dependent fields
- None
Depend upon fields
- TTCID
- XJACS01
Additional information
XJACSLEV201 is based on the UNISTATS level 2 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.
Technical Specification
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 42 '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_XJACSLEV2 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) | XJACSLEV201 |
---|---|---|
1, 2, Q | 42 | |
Found in XJACSLEV_lookup_V2 .F_XJACS01 | XJACSLEV_lookup_V2 .F_XJACSLEV2 | |
Not found in XJACSLEV_lookup_V2 .F_XJACS01 | Null |
Revision history
Contact Liaison by email or on +44 (0)1242 388 531.