Search Results igs_he_ut_excl_qals




Overview
Explore in AI Chat

Overview

The table IGS_HE_UT_EXCL_QALS is a data entity within the Oracle E-Business Suite (EBS) Student System (IGS), specifically marked as obsolete. Its primary function is to support the configuration of university tariff calculations by defining specific academic qualifications that should be excluded from a particular tariff calculation process. A tariff calculation is a mechanism used to convert prior academic achievements into a standardized score for admissions or progression purposes. By maintaining a registry of excluded qualifications, the system ensures that certain awards or fields of study are not factored into these automated calculations, allowing institutions to enforce precise academic policies. The documentation explicitly notes this table is "Not implemented in this database," indicating it may exist in the data dictionary but is not actively used or populated in standard deployments of EBS 12.1.1 or 12.2.2.

Key Information Stored

The table's structure is centered around linking a tariff calculation type to the qualifications it should ignore. The primary key is a unique identifier, EXCL_QUAL_ID. The core data columns establish this linkage by storing foreign keys to related master data tables. The TARIFF_CALC_TYPE_CD column references the specific type of tariff calculation rule being configured. The AWARD_CD column holds the code for the academic award or qualification (e.g., a specific degree) to be excluded. The FIELD_OF_STUDY column references the specific discipline or subject area of study to be excluded, providing granularity beyond the award level. Together, these columns define a precise rule: for a given tariff calculation type, exclude records associated with a particular award and field of study.

Common Use Cases and Queries

Given its obsolete status and "not implemented" note, direct operational use cases in active systems are unlikely. Historically, its purpose would have been administrative configuration and reporting related to admissions processing. Example queries would have focused on auditing or maintaining exclusion rules. A typical pattern would be a join to the referenced tables to retrieve descriptive names for the codes stored, such as: SELECT excl.excl_qual_id, calc.calc_type_name, awd.award_name, fos.field_of_study_name FROM igs_he_ut_excl_qals excl JOIN igs_he_ut_calc_type calc ON excl.tariff_calc_type_cd = calc.tariff_calc_type_cd JOIN igs_ps_awd awd ON excl.award_cd = awd.award_cd JOIN igs_ps_fld_of_study_all fos ON excl.field_of_study = fos.field_of_study; Reporting would have centered on generating lists of all excluded qualifications per calculation type for policy review.

Related Objects

The table's integrity is defined by its relationships with three key master tables in the Student System, as documented by its foreign key constraints:

  • IGS_HE_UT_CALC_TYPE: Joined via the column IGS_HE_UT_EXCL_QALS.TARIFF_CALC_TYPE_CD. This table defines the types of tariff calculations available in the system.
  • IGS_PS_AWD: Joined via the column IGS_HE_UT_EXCL_QALS.AWARD_CD. This table stores the institution's defined academic awards or qualifications.
  • IGS_PS_FLD_OF_STUDY_ALL: Joined via the column IGS_HE_UT_EXCL_QALS.FIELD_OF_STUDY. This table contains the valid fields of study or academic disciplines.
These relationships ensure that any exclusion rule points to valid, existing entities within the database.