Student record 2007/08

Back to C07051

All Fields

Qualifications awarded


return to field list
Short nameQualificationsAwarded
Typeentity
Description

Qualification or credit obtained during – or at the end of – an instance

Applicable toEngland Northern Ireland Scotland Wales
Coverage

Compulsory for all instances where Instance.ENDDATE is not null and Instance.RSNEND = 01 and Instance.REDUCEDI = 00, 01 or 04 (Optional for all other instances)

Part of
Minimum occurrences0
Maximum occurrences2
Related fields
Has parts
Reason required

This entity is defined to hold information about the qualifications awarded and to allow multiple awards to be recorded in the hierarchical data structure.

Notes

Qualifications should be returned in the reporting year in which they are awarded. Return of one or more qualifications does not indicate the end of an instance.

OwnerHESA
Version1.4
Date modified2008-09-24
Change management notesBusiness rule 1 re-worded for further clarity
Business rules
1(Error)

QualificationsAwarded entity must exist where Instance.ENDDATE is not null and Instance.RSNEND = 01 and Instance.REDUCEDI = 00, 01 or 04 unless either Course.COURSEAIM ends in 99 or (English or Welsh institution and Instance.FESTUMK = 1 or 4 and Instance.PROGRESS = 6, A or B)

2(Warning)

QualificationsAwarded.QUAL should exist where Instance.RSNEND = 98 and Course.COURSEAIM begins D, E, L, M, H, I, J or C and Instance.REDUCEDI = 00, 01 or 04.

Schema components
Contact Institutional Liaison: liaison@hesa.ac.uk, tel 01242 211144