Results for “exp_gce”

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

Overview

The IGS_UC_EXP_QUAL_SUM table is a core data object within the IGS (Student System) product module of Oracle E-Business Suite, available in releases 12.1.1 and 12.2.2. It functions as the expected qualification summary repository, holding the qualifications attained by an applicant as captured through the UCAS admissions interface. The table consolidates a wide range of secondary and tertiary qualification indicators — including A-Level equivalents, vocational certifications, and international baccalaureate results — into a single summary record per applicant. In EBS terms, it supports the admissions and applicant-tracking workflow, feeding qualification analysis, offer decisions, and reporting on expected versus achieved qualifications.

From a Data Vault modeling perspective, the metadata heuristics classify this object as satellite-leaning. It behaves as a descriptive extension that carries attributes about a party (the applicant) and is keyed to that party's identity, rather than acting as a hub or a transactional link between multiple business entities.

Key Information Stored

The table contains 24 documented columns. The most operationally significant are:

• EXP_QUAL_SUM_ID — The surrogate primary key (IGS_UC_EXP_QUAL_SUM_PK), uniquely identifying each qualification summary record. It is also the target of unique index IGS_UC_EXP_QUAL_SUM_U1.
• PERSON_ID — The foreign key to HZ_PARTIES, tying each summary to the registered applicant. This is the business-key candidate enforced by unique index IGS_UC_EXP_QUAL_SUM_U2.
• EXP_GCE / EXP_VCE — Expected GCE and VCE qualification data.
• WINTER_A_LEVELS / PREV_A_LEVELS / PREV_AS_LEVELS — Winter A-Level, previous A-Level, and previous AS-Level attainment.
• OEQ / PREV_OEQ — Other expected qualifications and their prior equivalents.
• IB, BTEC, SQA, ILC, AILC, KSI, ROA, MANUAL — Subject-specific qualification indicators covering International Baccalaureate, BTEC, Scottish Qualifications Authority, and related awards.
• VQI — A derived or aggregated qualification indicator.
• SEQ_UPDATED_DATE — The date the sequence or record state was last refreshed, useful for change tracking against UCAS feeds.
• CREATION_DATE / CREATED_BY / LAST_UPDATE_DATE / LAST_UPDATED_BY / LAST_UPDATE_LOGIN — Standard EBS audit columns recording who created and modified the record and when.

Common Use Cases and Queries

Typical scenarios include admissions analytics, UCAS data validation, and applicant qualification profiling. A frequently used pattern joins the table to HZ_PARTIES to resolve applicant identity:

SELECT eus.exp_qual_sum_id, eus.person_id, p.party_name, eus.winter_a_levels, eus.oeq, eus.ib
FROM igs.igs_uc_exp_qual_sum eus, hz.hz_parties p
WHERE eus.person_id = p.party_id;

Reporting use cases include counting applicants by qualification profile, comparing expected and previous OEQ values, and identifying records whose SEQ_UPDATED_DATE lags the latest UCAS transmission. Change-detection queries against LAST_UPDATE_DATE support incremental extracts into a warehouse or data-mart layer.

Related Objects

The most significant relationships are:

• HZ_PARTIES — Joined on IGS_UC_EXP_QUAL_SUM.PERSON_ID = HZ_PARTIES.PARTY_ID. This is the only documented foreign key and the primary structural link to the applicant registry.
• IGS_UC_EXP_QUAL_SUM_PK — The primary-key constraint over EXP_QUAL_SUM_ID.
• IGS_UC_EXP_QUAL_SUM_U1 / U2 — Unique indexes on EXP_QUAL_SUM_ID and PERSON_ID respectively, validating uniqueness of the surrogate key and the applicant business key.
• Additional IGS UCAS interface tables and student admissions views that consume PERSON_ID to correlate this summary with application and offer records.

Practitioners should treat PERSON_ID as the practical integration point when linking qualification summaries to broader applicant and admissions data across the IGS schema.