Search Results igs_he_ut_calc_lvl

Overview

The IGS_HE_UT_CALC_LVL table is a data structure within the Oracle E-Business Suite (EBS) Student System (IGS). Its specific role is to store HESA (Higher Education Statistics Agency) Tariff Levels that are associated with a given UCAS (Universities and Colleges Admissions Service) Tariff Calculation Type. This table is part of the functionality designed to manage and calculate standardized university entrance tariffs, which are critical for student admissions and reporting in the UK higher education context. It is important to note that the IGS module is marked as obsolete in the provided ETRM documentation, indicating this table is part of a legacy system component that may be deprecated in current implementations. Furthermore, the metadata explicitly states this table was "Not implemented in this database," suggesting it may exist in the data dictionary but not be populated or actively used in a standard deployment.

Key Information Stored

The table's structure is defined by a composite primary key, which dictates the core data entities it manages. The key columns are TARIFF_CALC_TYPE_CD and TARIFF_LEVEL_CD. The TARIFF_CALC_TYPE_CD is a foreign key that links to a specific UCAS Tariff Calculation Type defined in the IGS_HE_UT_CALC_TYPE table. The TARIFF_LEVEL_CD represents the specific HESA Tariff Level code that is valid for the linked calculation type. Together, these columns create a mapping that defines which tariff levels are applicable under which calculation methodology. While the metadata does not list non-key columns, typical tables of this nature might include descriptive fields, effective dating, or creation metadata.

Common Use Cases and Queries

The primary use case for this table is to validate and retrieve the list of permissible HESA Tariff Levels for a specific UCAS calculation rule. This is essential for ensuring data integrity during processes like student application scoring, transcript evaluation, or regulatory reporting to HESA. A common query would involve joining to the parent table to fetch a descriptive context for the calculation type. For example, to list all tariff levels for a specific calculation type, one might use the following SQL pattern:

• SELECT lvl.tariff_level_cd, typ.calculation_type_name FROM igs_he_ut_calc_lvl lvl JOIN igs_he_ut_calc_type typ ON lvl.tariff_calc_type_cd = typ.tariff_calc_type_cd WHERE lvl.tariff_calc_type_cd = '<TYPE_CODE>';

Given the table's obsolete status and noted non-implementation, direct operational or reporting use in active systems is unlikely. Its presence is primarily of architectural or historical interest for database analysts.

Related Objects

The table maintains a strict hierarchical relationship with one other documented object in the EBS data model, as defined by its foreign key constraint.

• IGS_HE_UT_CALC_TYPE: This is the parent table. The relationship is enforced by the foreign key from IGS_HE_UT_CALC_LVL.TARIFF_CALC_TYPE_CD to IGS_HE_UT_CALC_TYPE. This join is fundamental, as every record in IGS_HE_UT_CALC_LVL must reference a valid, pre-existing tariff calculation type. No other foreign key relationships from or to this table are documented in the provided metadata.