Results for “ucas_voc_qual”

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

Overview

IGS_UC_EXP_QUAL_SUM_V is a supplementary view owned by the APPS schema in Oracle E-Business Suite, registered under FND Design Data as IGS.IGS_UC_EXP_QUAL_SUM_V. It belongs to the Student System (IGS) product family, specifically the UCAS admissions integration area that stores expected and previously attained qualification summaries for applicants. The view presents one row per qualification summary record, keyed by EXP_QUAL_SUM_ID and linked to a PERSON_ID, consolidating the breadth of UK and Irish pre-tertiary qualification indicators that UCAS applications carry. Its declared purpose is to simplify coding of the associated maintenance form rather than to serve as a supported reporting interface. The ETRM metadata explicitly warns that Oracle does not recommend querying or altering data through this view, and that its definition may change dramatically in subsequent minor or major releases. Consequently, in both 12.1.1 and 12.2.2 environments it should be treated as an internal forms-support object, not a stable integration contract.

Underlying Base Objects

The ETRM metadata documents no referenced base objects for this view. This is common for IGS "supplementary" views, which are typically layered over a single base table — in this case the expected qualification summary table holding EXP_QUAL_SUM_ID as its sequence-generated primary key. Because no join structure is documented, the view can reasonably be treated as a column-projection layer: it exposes ROWID as ROW_ID to give the form a handle on the underlying row, together with the descriptive and WHO audit columns from the base entity. Any assumption that the view performs aggregation, despite the "_SUM_V" suffix, is unsupported by the documented column list; the columns are scalar attributes rather than computed totals. Administrators tracing the view should resolve it through the FND Design Data entry and the data dictionary rather than relying on the ETRM stub.

Key Columns

• ROW_ID / EXP_QUAL_SUM_ID / PERSON_ID — the row identifier, the sequence-generated primary key, and the owning person (applicant) respectively.
• EXP_GCE / EXP_VCE — counts of expected GCE and VCE qualifications.
• WINTER_A_LEVELS / PREV_A_LEVELS / PREV_AS_LEVELS — numeric counts of winter A levels, previously attained A levels, and previously attained AS levels. PREV_AS_LEVELS is the column most directly associated with the search term "prev_as_levels".
• SQA, BTEC, IB, ILC, AILC, KSI, ROA, MANUAL, OEQ, PREV_OEQ, VQI — qualification indicator flags or codes covering Scottish Qualifications Authority, Business and Technician Education Council, International Baccalaureate, Irish Leaving Certificate, Advanced International Certificate of Education, Key Skills Indicator, Record of Achievement, manual check status, and other/vocational qualifications.
• OEQ_DESC / PREV_OEQ_DESC / VQI_DESC — free-text descriptions accompanying the other-qualification and vocational indicators.
• SEQ_UPDATED_DATE and the standard WHO columns — sequence refresh date plus CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN.

Common Use Cases and Queries

The principal legitimate use is diagnostic: confirming how the UCAS qualification form renders summary data for a given applicant during admissions processing. A representative query is:

SELECT person_id, prev_a_levels, prev_as_levels, exp_gce, exp_vce, sqa, btec, ib, roa, seq_updated_date
FROM apps.igs_uc_exp_qual_sum_v
WHERE person_id = :p_person_id;

For monitoring sequence refreshes, filtering on seq_updated_date identifies records not recently recalculated. For any downstream reporting or integration requirement, the base table should be queried directly instead, since Oracle gives no compatibility guarantee for this view across releases.