Search Results igsfv_uc_qual_details




Overview
Explore in AI Chat

Overview

IGSFV_UC_QUAL_DETAILS is an APPS-owned, VALID database view within the IGS (Student System) product of Oracle E-Business Suite, available in both 12.1.1 and 12.2.2. It is described by Oracle ETRM as the "Full View for the qualifications awarded to an applicant." The view consolidates applicant qualification data captured through the UCAS admissions interface (the IGS_UC_* tables) and enriches it with descriptive information joined from person, award, field-of-study, and grading-schema entities. Its primary role is to provide a denormalized reporting and integration surface for admissions users, allowing qualification records to be queried with human-readable names instead of raw coded values.

The object is especially relevant to searches for awarding_body_name because the view exposes the column AWARDING_BODY_NAME, which resolves the underlying code AWARDING_BODY_CODE (stored in IGS_UC_QUAL_DETS.AWARDING_BODY) against the party name held in HZ_PARTIES. This makes the view a convenient source for reporting on awarding bodies without requiring the caller to perform the lookup join manually.

Underlying Base Objects

The view is defined over eight referenced objects. The driving table is IGS_UC_QUAL_DETS (aliased QU), which holds the qualification detail rows for each applicant. It is left-outer-joined to the following supporting objects on the join conditions shown in the view text:

All links to the descriptive tables are outer joins, ensuring qualification rows are returned even when matching reference data is absent.

Key Columns

Common Use Cases and Queries

The view is typically used for admissions reporting, UCAS import verification, and applicant qualification extracts where descriptive naming is required. A representative query retrieving awarding body names for an applicant is:

  • SELECT person_id, awarding_body_code, awarding_body_name FROM igsfv_uc_qual_details WHERE person_id = :p_person_id;
  • SELECT awarding_body_name, COUNT(*) FROM igsfv_uc_qual_details GROUP BY awarding_body_name ORDER BY 2 DESC; — to analyze qualification volumes by awarding body.
  • SELECT person_id, exam_level_title, subject_code_desc, approved_result_description FROM igsfv_uc_qual_details WHERE year = :p_year; — for annual admissions analysis.

Because the view is a simple join-based projection with no documented base-object list in the 12.2.2 ETRM metadata, consumers should treat it as read-only and avoid DML. Query performance may benefit from indexes on IGS_UC_QUAL_DETS.PERSON_ID and the grading-schema join columns.