Search Results app_no




Overview
Explore in AI Chat

Overview

The IGS_UC_FORM_QUALS table is a core data structure within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the IGS (Oracle Student Management) product family. As indicated in the ETRM documentation, its primary function is to store individual Form Qualifications imported from UCAS (Universities and Colleges Admissions Service). This table acts as the system of record for academic qualifications associated with an applicant during the admissions process, facilitating the evaluation of candidate eligibility and credentials. It is a transactional table residing in the APPS_TS_TX_DATA tablespace, reflecting its role in operational data processing.

Key Information Stored

The table's columns are designed to capture the essential details of an applicant's qualifications. The APP_NO (Applicant Number) is the mandatory key field that links each qualification record to a specific applicant. The core qualification attributes include QUAL_TYPE (e.g., A-Level, BTEC, International Baccalaureate), AWARD_BODY (the examining institution), TITLE (the subject or qualification name), GRADE obtained, and QUAL_DATE. Notably, the QUAL_ID column is documented as "No Longer Used." The table also includes standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) for audit and compliance tracking.

Common Use Cases and Queries

The primary use case is supporting admissions workflows by providing a complete view of an applicant's academic history for assessment. Common reporting and data retrieval scenarios include generating qualification summaries for an applicant, analyzing grade distributions for specific qualifications, or verifying credentials. A fundamental query pattern involves filtering by the APP_NO to retrieve all qualifications for a single candidate. For example:

  • Applicant Qualification Report: SELECT TITLE, AWARD_BODY, GRADE, QUAL_DATE FROM IGS.IGS_UC_FORM_QUALS WHERE APP_NO = :1 ORDER BY QUAL_DATE DESC;
  • Aggregate Analysis: Queries may join this table to other applicant demographic tables to analyze qualification trends by region, course applied for, or other demographic factors.

The provided ETRM query text serves as the standard template for selecting all data from this object.

Related Objects

According to the dependency information, the IGS_UC_FORM_QUALS table does not reference other objects but is itself referenced by the APPS synonym IGS_UC_FORM_QUALS. This synonym, owned by the APPS schema, is critical as it provides the standard access point for all EBS application code and custom reports to interact with this table, ensuring a consistent interface regardless of the underlying schema. While not listed in the provided excerpt, this table would logically have a foreign key relationship to a core applicant or application header table (likely keyed on APP_NO) to maintain referential integrity for applicant data.