Results for “awarding_body”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGS_UC_QUAL_DETS is a transactional table in the IGS (Student System) product family of Oracle E-Business Suite, owned by the IGS schema. It stores the qualification details awarded to an applicant — that is, the academic and secondary-school qualifications a prospective or admitted student has earned, claimed, or is predicted to earn. In the UCAS admissions workflow (indicated by the "UC_" prefix), this table serves as the staging and record layer for qualification data received from external admissions sources or entered manually. It holds details such as examination level, subject, awarding body, year of sitting, and the three result positions (predicted, claimed, and approved), each graded against a grading schema.

From a Data Vault modeling perspective, the metadata's heuristic classification places this object as satellite-leaning. That is a modeling suggestion rather than a physical design statement: the table's grain is one qualification record per person/exam/subject/sitting combination, and it carries descriptive attributes that belong in a satellite attached to a person hub (HZ_PARTIES via PERSON_ID). The unique index on PERSON_ID, EXAM_LEVEL, SUBJECT_CODE, YEAR, SITTING, AWARDING_BODY, and APPROVED_RESULT approximates a business key that could feed a link structure across the person, exam, subject, and awarding-body hubs.

Key Information Stored

The surrogate primary key is QUAL_DETS_ID (constraint IGS_UC_QUAL_DETS_PK), a system-generated identifier that uniquely distinguishes each qualification row and is used as the parent key in downstream foreign-key relationships. It is not a business identifier and should not be surfaced to end users in reports.

• PERSON_ID — the applicant to whom the qualification belongs; foreign key to HZ_PARTIES. This is the principal join path to the person registry.
• EXAM_LEVEL — the qualification or examination level (for example A-level or equivalent), referencing IGS_PS_AWD.
• SUBJECT_CODE — the subject of the qualification, referencing IGS_PS_FLD_OF_STUDY_ALL.
• YEAR and SITTING — the academic year and examination sitting in which the qualification was taken; together they establish the temporal context of the award.
• AWARDING_BODY — the organization that issued the qualification.
• GRADING_SCHEMA_CD and VERSION_NUMBER — identify the grading scale applied and its version, used with the three result columns to resolve valid grade values against IGS_AS_GRD_SCH_GRADE.
• PREDICTED_RESULT, CLAIMED_RESULT, and APPROVED_RESULT — the applicant's predicted grade, the self-reported or claimed grade, and the institution-approved grade, respectively. Each is validated against the grading schema through the foreign key to IGS_AS_GRD_SCH_GRADE.
• UCAS_TARIFF — the tariff points associated with the qualification, used in admissions scoring.
• IMPORTED_FLAG and IMPORTED_DATE — audit indicators showing whether the row was loaded from an external admissions source and when.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN — the standard Oracle EBS WHO columns capturing row audit history.

The business-key candidate is encoded in the unique index IGS_UC_QUAL_DETS_U2 (PERSON_ID, EXAM_LEVEL, SUBJECT_CODE, YEAR, SITTING, AWARDING_BODY, APPROVED_RESULT); a second unique index, IGS_UC_QUAL_DETS_U1, enforces uniqueness on QUAL_DETS_ID itself. The uniqueness rule prevents duplicate records of the same qualification for the same applicant, which is critical when importing qualification data from external feeds.

Common Use Cases and Queries

Typical reporting and integration scenarios include applicant qualification lookups, UCAS tariff point aggregation, and reconciliation of predicted versus approved results. Because PERSON_ID joins to HZ_PARTIES, qualification data can be combined with person and party records for applicant-level reporting. A representative query joins the person and qualification tables:

• Retrieve all qualifications for a given applicant: SELECT qd.exam_level, qd.subject_code, qd.year, qd.sitting, qd.approved_result FROM igs_uc_qual_dets qd WHERE qd.person_id = :person_id;
• Sum tariff points by applicant: SELECT person_id, SUM(ucas_tariff) FROM igs_uc_qual_dets GROUP BY person_id;
• Identify externally imported records: SELECT * FROM igs_uc_qual_dets WHERE imported_flag = 'Y' AND imported_date > :cutoff_date;
• Validate a claimed result against the grading schema by joining GRADING_SCHEMA_CD and VERSION_NUMBER to IGS_AS_GRD_SCH_GRADE.

These patterns support admissions decision reporting, tariff scoring, and data-quality audits of imported qualification records.

Related Objects

• HZ_PARTIES — joined on IGS_UC_QUAL_DETS.PERSON_ID = HZ_PARTIES.PARTY_ID (person registry).
• IGS_PS_AWD — joined on EXAM_LEVEL, resolving the award or qualification definition.
• IGS_PS_FLD_OF_STUDY_ALL — joined on SUBJECT_CODE, resolving the field of study.
• IGS_AS_GRD_SCH_GRADE — joined on GRADING_SCHEMA_CD and VERSION_NUMBER to validate PREDICTED_RESULT, CLAIMED_RESULT, and APPROVED_RESULT.
• IGS_AV_STND_UNIT_LVL_ALL — references this table through QUAL_DETS_ID, tying qualification details to standard unit level records.

Together these relationships make IGS_UC_QUAL_DETS a central link between applicant identity, academic award definitions, grading standards, and downstream admissions processing.