Search Results tariff_level_cd

Overview

The IGS_HE_UT_LVL_AWARD table is a data structure within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically belonging to the now-obsolete IGS (Student System) product. Its primary function is to maintain the mapping relationships between institutional awards (degrees, diplomas, etc.) and standardized Tariff Levels. This mapping was a critical component for regulatory reporting and compliance, particularly in the context of the UK's Higher Education (HE) sector, where it facilitated the translation of institutional academic awards into a standardized national framework for statistical analysis and funding calculations. The table is defined by a composite primary key and enforces referential integrity through foreign keys to related setup data.

Key Information Stored

The table's structure is designed to uniquely define the relationship between a Tariff Level and an Award. The key columns are the components of its primary key constraint, IGS_HE_UT_LVL_AWARD_PK. The TARIFF_CALC_TYPE_CD and TARIFF_LEVEL_CD together identify a specific Tariff Level within a calculation type or classification system. The AWARD_CD column stores the code for an academic award (e.g., BSc, MA) as defined in the awards master table. This three-column combination ensures that a given award is correctly associated with one specific Tariff Level under a particular calculation methodology. The table's purpose is purely referential, storing these critical links rather than descriptive details about the awards or levels themselves.

Common Use Cases and Queries

The primary use case for this table was to support processes requiring a translation between an institution's internal award codes and the external, standardized Tariff Level framework. This was essential for generating statutory reports like the UK's Higher Education Statistics Agency (HESA) returns. A common query would involve joining this mapping table to the awards master data to produce a list of all awards with their corresponding Tariff Levels for a given calculation type. For example: SELECT awd.award_cd, awd.title, map.tariff_level_cd FROM igs_ps_awd awd, igs_he_ut_lvl_award map WHERE awd.award_cd = map.award_cd AND map.tariff_calc_type_cd = '&CALC_TYPE'; Another typical scenario would be validating or auditing these mappings during batch processes for regulatory submissions to ensure data consistency and compliance before transmission.

Related Objects

The table maintains a direct foreign key relationship to the awards master table, establishing its dependency on core setup data. The documented relationship is:

• Foreign Key Reference: The AWARD_CD column in IGS_HE_UT_LVL_AWARD references the IGS_PS_AWD table. This ensures that every award code stored in the mapping table is a valid, pre-defined award within the student system.

The primary key constraint, IGS_HE_UT_LVL_AWARD_PK, itself may be referenced by other objects (like indexes or materialized views) not detailed in the provided metadata. Given its role, this table was likely a key source for views or interfaces used by the HE-specific regulatory reporting modules within the obsolete IGS product suite.