Results for “prev_oeq_desc”

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

Overview

IGS_UC_EXP_QUAL_SUM_V is a reporting view owned by the APPS schema in the Oracle E-Business Suite Student System (IGS) product. It exposes the Expected Qualification Summary Details held against a person record, typically an applicant captured through the UCAS admissions interface. The view is defined over the IGS_UC_EXP_QUAL_SUM base table and enriches it with decoded descriptions from the UCAS reference codes and higher education code value tables, so that consumers receive human-readable values rather than raw code identifiers.

The view status is documented as VALID in both Oracle EBS 12.1.1 and 12.2.2. Its principal role is to support admissions reporting, UCAS data extracts, and downstream integration where the expected qualifications declared by an applicant must be presented alongside their decoded meanings. Because it resolves several code lookups internally through outer joins, it can be queried directly without requiring the caller to re-implement the UCAS code-decoding logic.

Underlying Base Objects

The view text joins four objects:

• IGS_UC_EXP_QUAL_SUM EQS — the driving base table holding the expected qualification summary row for each person.
• IGS_UC_REF_CODES URC1 — joined with an outer join on EQS.OEQ with CODE_TYPE restricted to 'OC', supplying the description of the other expected qualification.
• IGS_UC_REF_CODES URC2 — joined with an outer join on EQS.PREV_OEQ with CODE_TYPE restricted to 'OC', supplying the description of the previously held other expected qualification.
• IGS_HE_CODE_VALUES HCV — joined with an outer join on EQS.VQI with CODE_TYPE restricted to 'UCAS_VOC_QUAL', supplying the vocational qualification value description.

All three lookups use the (+) outer-join operator, so a row from IGS_UC_EXP_QUAL_SUM is retained even when no matching decode exists. Although the documented metadata lists no referenced base objects in the ETRM 12.2.2 entry, the view text itself confirms these four dependencies.

Key Columns

The view exposes the full column set of the base table plus four decoded columns:

• EXP_QUAL_SUM_ID, PERSON_ID, ROW_ID — primary identifier, the person reference, and the row locator.
• PREV_A_LEVELS — the count or indicator of A-levels previously attained; this is the column most commonly sought by users searching for "prev_a_levels". It sits alongside WINTER_A_LEVELS and PREV_AS_LEVELS, which record winter A-levels and previous AS-levels respectively.
• EXP_GCE, EXP_VCE, SQA, BTEC, IB, ILC, AILC, KSI, ROA, MANUAL, OEQ, PREV_OEQ — qualification-type indicators covering GCE, VCE, Scottish Qualifications Authority, BTEC, International Baccalaureate, Irish Leaving Certificate, and related categories.
• OEQ_DESC, PREV_OEQ_DESC, VQI, VQI_DESC — decoded descriptions for the other expected qualification, the previous other expected qualification, and the vocational qualification indicator.
• SEQ_UPDATED_DATE alongside the standard WHO audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN).

Common Use Cases and Queries

Typical uses include admissions dashboards, UCAS applicant extracts, and data migration checks where expected qualification summaries must be reconciled against the base table. A representative query retrieving previous A-level data for a person is:

SELECT person_id, prev_a_levels, prev_as_levels, winter_a_levels, oeq_desc, prev_oeq_desc, vqi_desc FROM apps.igs_uc_exp_qual_sum_v WHERE person_id = :person_id;

To report aggregate qualification profiles across an intake, filtering on the decoded columns is preferable to filtering on raw codes:

SELECT oeq_desc, COUNT(*) FROM apps.igs_uc_exp_qual_sum_v WHERE prev_a_levels IS NOT NULL GROUP BY oeq_desc;

Because the view already performs the reference-code and code-value decodes, reports should select OEQ_DESC, PREV_OEQ_DESC, and VQI_DESC directly rather than joining IGS_UC_REF_CODES or IGS_HE_CODE_VALUES again, avoiding redundant joins and preserving the outer-join semantics of the view.