Search Results excl_qual_id




Overview
Explore in AI Chat

Overview

The IGS_HE_UT_EXCL_QALS table is a core data structure within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Higher Education (HE) module. It is owned by the IGS (iGrants) schema and functions as a configuration table for managing university admissions and reporting. Its primary role is to store rules that define which specific academic qualifications should be excluded from a particular Tariff calculation. Tariff points are a standardized metric used, particularly in UK higher education, to quantify post-16 qualifications for university entry. This table enables institutions to fine-tune these calculations by excluding certain awards or fields of study from specific calculation methodologies.

Key Information Stored

The table's structure is designed to capture the exclusion rule, its context, and standard audit information. The key columns are:

  • EXCL_QUAL_ID: A system-generated, unique numeric primary key that identifies each exclusion rule record.
  • TARIFF_CALC_TYPE_CD (VARCHAR2(10)): A mandatory, user-defined code that uniquely identifies the specific Tariff calculation type. This is a foreign key and is the critical link for which calculation the rule applies to, directly addressing the user's search term.
  • AWARD_CD (VARCHAR2(10)): Identifies the specific Student System award (qualification) to be excluded from the linked Tariff calculation.
  • FIELD_OF_STUDY (VARCHAR2(10)): Identifies a specific field of study to be excluded, providing granularity beyond the award level.
  • Standard WHO Columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN): These audit columns track the creation and modification history of each record, a standard feature in EBS tables.
The presence of a non-unique index (IGS_HE_UT_EXCL_QALS_N1) on TARIFF_CALC_TYPE_CD optimizes queries filtering by this key code.

Common Use Cases and Queries

This table is central to configuring accurate UCAS Tariff or institutional equivalent calculations. A primary use case is during the admissions processing cycle, where the system references this table to determine if a prospective student's qualifications should be omitted from the points total for a given calculation method. Administrators use this to handle edge cases, such as excluding certain vocational awards from a research-focused program's entry score or excluding specific subject grades from a general calculation. Common reporting queries involve listing all exclusions for a given tariff calculation or validating setup. A typical SQL pattern is: SELECT award_cd, field_of_study FROM igs.igs_he_ut_excl_qals WHERE tariff_calc_type_cd = 'UCAS_2023'; This would return all award and field of study combinations excluded from the 'UCAS_2023' calculation. Another common administrative query joins this table to its parent lookup (likely a Tariff calculation type table, though not listed in dependencies) to generate a full list of configured rules for audit purposes.

Related Objects

Based on the provided ETRM metadata, the direct dependencies are limited. The table itself does not reference other objects. However, it is referenced by an object in the APPS schema named IGS_HE_UT_EXCL_QALS. This is almost certainly a public synonym (APPS.IGS_HE_UT_EXCL_QALS) that points to the underlying IGS-owned table, which is a standard EBS architecture pattern to provide a consistent access point for applications and users granted via the APPS schema. The TARIFF_CALC_TYPE_CD column is defined as a foreign key, indicating it references a code from a lookup or control table (e.g., IGS_HE_TARIFF_CALC_TYPE), which would define the valid calculation types, though this parent table is not listed in the excerpt.