Search Results seq_updated_date




Overview
Explore in AI Chat

Overview

IGSBV_UC_EXP_QUAL_SUMMARIES is a base database view within the Oracle E-Business Suite Student System (product code IGS), a module that Oracle has designated as obsolete. The view presents a consolidated summary of the qualifications attained by an applicant, drawing together the various qualification indicators captured during the Universities and Colleges Admissions Service (UCAS) application process and joining them to the corresponding trading community party record. Its name reflects its role as a "base view" — a read-only, denormalized projection intended to be consumed by higher-level views, concurrent programs, or reporting queries rather than to be updated directly.

The view is explicitly defined WITH READ ONLY, confirming that it is intended solely for query and reporting purposes. In an EBS 12.1.1 or 12.2.2 environment, objects such as this support the admissions and applicant-tracking functionality of the Student System, presenting qualification data in a form convenient for enquiry screens and extracts. Because IGS is flagged as obsolete in the documented metadata, the view should be regarded as legacy and is not implemented in the reference database against which the documentation was generated.

Underlying Base Objects

The view is defined over two documented sources. The primary source table is IGS_UC_EXP_QUAL_SUM, aliased EX, which stores the expected qualification summary rows for each applicant. This table supplies the majority of the exposed columns, including all of the qualification flags and the auditing columns. The second source is HZ_PARTIES, aliased FT1, the Oracle Trading Community Architecture (TCA) party table, which supplies the applicant's party number and party name. The join is performed with an outer join (EX.PERSON_ID = FT1.PARTY_ID (+)), keyed on the person identifier. This construct guarantees that a qualification summary row is still returned even when no matching party record exists, avoiding the loss of applicant qualification data through referential gaps. The metadata notes no other referenced base objects.

Key Columns

The view exposes a mixture of identifiers, qualification indicators, and standard audit columns.

Common Use Cases and Queries

Typical usage involves retrieving the qualification profile of a single applicant or producing extracts of applicant qualification mixes for admissions analysis. A representative query for a specific applicant is:

SELECT OSS_PERSON_NUMBER, OSS_PERSON_NAME, WINTER_A_LEVELS, PREVIOUS_A_LEVELS, PREVIOUS_AS_LEVELS, QUAL_BTEC_FLAG, QUAL_IB_FLAG
FROM IGSBV_UC_EXP_QUAL_SUMMARIES
WHERE OSS_PERSON_IDENTIFIER = :person_id;

A broader reporting query counting applicants by qualification type may select aggregate totals across the flag columns, filtering on the audit dates to restrict results to a defined admissions cycle. Because the view is read-only, it is safe to embed in custom reports, BI Publisher data templates, and extracts without risk of modifying underlying data. Given the obsolete status of the IGS module, any such usage should be validated against the deployed environment, as the metadata indicates the view is not implemented in all databases.