Search Results expected_vce




Overview
Explore in AI Chat

Overview

IGSFV_UC_EXP_QUAL_SUMMARIES is an APPS-owned read-only view in the IGS (Student System) product family, providing a denormalized summary of the qualifications an applicant has attained or is expected to attain as recorded through the UCAS admissions interface. Its documented description is "Full View for summary of qualifications attained by this applicant." The view resolves foreign-key identifiers into human-readable descriptions and joins party information from Oracle's Trading Community Architecture (HZ) so that reported data is meaningful outside the application layer.

The view is defined WITH READ ONLY, which is significant: it is a reporting and integration surface only. Applicants or external systems may never write through it; all DML must target the base table. It is used where qualification data must be extracted for admissions review, statutory returns, or downstream data warehouse loads.

Underlying Base Objects

Two documented base objects are referenced in the view text:

  • IGS_UC_EXP_QUAL_SUM — the primary qualification summary table, aliased EX. All qualification flags, expected grade categories, and audit columns originate here.
  • HZ_PARTIES — aliased FT1, joined on EX.PERSON_ID = FT1.PARTY_ID (+). The outer join ensures that applicant rows persist even where no matching party record exists.

Three correlated scalar subqueries add derived descriptive columns: two against IGS_UC_REF_CODES using code type 'OC' (for the other-examination values) and one against IGS_HE_CODE_VALUES using code type 'UCAS_VOC_QUAL'. The metadata records no further referenced base objects.

Key Columns

Note that the column list in the metadata truncates the final audit column as LAST_UPDATE, but the view text defines LAST_UPDATE_DATE.

Common Use Cases and Queries

Typical scenarios include identifying applicants who declared non-standard qualifications, auditing the completeness of UCAS-supplied data, and feeding qualification summaries into admissions decisioning or returns. A representative query filters on the other-examination flag:

  • SELECT OSS_PERSON_NUMBER, OSS_PERSON_NAME, OTHER_EXAMINATION_QUAL_DESC FROM IGSFV_UC_EXP_QUAL_SUMMARIES WHERE OTHER_EXAMINATION_QUAL_FLAG IS NOT NULL;
  • SELECT OSS_PERSON_NUMBER, EXPECTED_GCE, EXPECTED_VCE, MANUAL_QUAL_CHECK FROM IGSFV_UC_EXP_QUAL_SUMMARIES WHERE MANUAL_QUAL_CHECK = 'Y';

Because the view is read-only and already resolves reference codes, it is preferable to the base table for ad-hoc reporting. Repository scripts should not attempt inserts, updates, or deletes against it.