XCLASSF01_1.3.1
Field description | Field abbreviation | Field version | Field length | Field type |
---|---|---|---|---|
Classification of qualification | XCLASSF01 | 1.3.1 | 2 | Char |
Valid entries
Dependent fields
- XCLASS01
Depend upon fields
- CLASS
Additional information
This field is used to indicate the qualification class of the qualification (or highest-ranked qualification) that the student obtained.
XCLASSF01 is recorded on the derived/analysis table for the relevant collection, which has a primary key of INSTANCEKEY. XCLASSF01 is also recorded in this table.
Where there is more than one occurrence of the QualificationsAwarded entity attached to an instance, the qualification used in XCLASS01 will correspond to the qualification represented in XQOBTN01. That derived field assigns one of the equally-highest ranking qualifications without reference to a specific classification. XCLASSF01 requires the identification of the qualification with the classification nearest to 01 in the QualificationsAwarded.CLASS field for this scenario.
Technical Specification
Count the number of QualificationsAwarded entities associated with an instance.
Zero occurrences of the QualificationsAwarded entity
If there are no qualifications associated with the instance, XCLASSF01 is set to A, 'Classification not applicable'.
One occurrence of the QualificationsAwarded entity
Where an instance has one occurrence of a QualificationsAwarded entity, the associated QualificationsAwarded.CLASS value (or lack of it) is used to derive XCLASSF01.
More than one occurrence of the QualificationsAwarded entity
Where an instance has more than one occurrence of the QualificationsAwarded entity, it is necessary to identify the one with the highest ranking QualificationsAwarded.QUAL value, as XCLASSF01 takes the classification of the qualification highest in level.
Give each QualificationsAwarded.QUAL a ranking value using the ranking table in XQOBTN01, then count the number of entities with the ranking value nearest zero.
If there is only one QualificationsAwarded entity with the QualificationsAwarded.QUAL at the highest ranking value, XCLASSF01 is set to the associated value of QualificationsAwarded.CLASS (unless it is null, in which case, XCLASSF01 is set as A 'Classification not applicable').
If there is more than one QualificationsAwarded entity with QualificationsAwarded.QUALs of the same highest ranking number, it is necessary to additionally consider the associated classifications of these QualificationsAwarded.QUALs to derive the XCLASSF01 value, in order to maintain the principle of using the highest-ranked qualification.
For the QualificationsAwarded entities that rank equally high in terms of QualificationsAwarded.QUAL, count the number of these with the QualificationsAwarded.CLASS valid entry nearest to 01. Nulls should be considered to be least near to 01, i.e. last.
If there is only one of these QualificationsAwarded entities at the value of QualificationsAwarded.CLASS nearest 01, set XCLASSF01 to the associated value of QualificationsAwarded.CLASS (unless QualificationsAwarded.CLASS is null, in which case, XCLASSF01 is set as A 'Classification not applicable').
If there is more than one of these QualificationsAwarded entities ranking equally nearest to 01, it is irrelevant which one is used - set XCLASSF01 to the associated value of QualificationsAwarded.CLASS for the QualificationsAwarded entity with the lowest QualificationAwardedKEY (unless QualificationsAwarded.CLASS is null, in which case, XCLASSF01 is set as A 'Classification not applicable').
Number of QualificationsAwarded entities for instance | Number of these qualifications ranked highest using QUAL values and ranking table in XQOBTN01 | Number of these qualifications ranked highest using associated CLASS values nearest 01 | XCLASSF01 |
---|---|---|---|
0 | A | ||
1 | QualificationsAwarded.CLASS of that entity (unless null, in which case XCLASSF01 is A) | ||
>1 | 1 | QualificationsAwarded.CLASS of that entity (unless null, in which case XCLASSF01 is A) | |
>1 | 1 | QualificationsAwarded.CLASS of that entity (unless null, in which case XCLASSF01 is A) | |
>1 | QualificationsAwarded.CLASS of the entity with the lowest QualificationsAwardedKEY (unless null, in which case XCLASSF01 is A) |
Revision history
Contact Liaison by email or on +44 (0)1242 388 531.