Search Results tariff_level_cd




Overview
Explore in AI Chat

Overview

The IGS_HE_UT_CALC_LVL table is a core reference table within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Higher Education (HE) functionality provided by the IGS (iGrants) product family. Its primary role is to define and manage the valid HESA (Higher Education Statistics Agency) Tariff Levels that can be associated with a given UCAS (Universities and Colleges Admissions Service) Tariff Calculation Type. This table is essential for configuring and executing the complex tariff calculations used in the UK higher education sector for student admissions and reporting. It acts as a validation and mapping entity, ensuring that only predefined and authorized tariff level codes are utilized within specific calculation frameworks.

Key Information Stored

The table stores a concise set of columns that define the relationship between a calculation type and a tariff level, along with standard audit information. The key business columns are:

  • TARIFF_CALC_TYPE_CD: A VARCHAR2(10) code identifying the specific UCAS Tariff Calculation Type. This is part of the table's primary key.
  • TARIFF_LEVEL_CD: A VARCHAR2(10) code representing the HESA Tariff Level, sourced from application lookups. This is the second component of the primary key and corresponds to the "уровень Хаггита" (Haggett Level) referenced in the user's search.
  • CLOSED_IND: A VARCHAR2 indicator flag used to mark a specific tariff level as inactive or closed for a given calculation type, preventing its future use without deleting the historical record.
  • Standard WHO Columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN): These NUMBER and DATE columns track the user and timestamp for record creation and modification, adhering to Oracle EBS auditing standards.

Common Use Cases and Queries

This table is primarily used in configuration and validation processes within the UCAS tariff calculation engine. A common use case is the setup and maintenance of valid tariff levels for different admission cycles or qualification frameworks. System administrators query this table to review or update the active mappings. For reporting, it is often joined to transaction tables to decode tariff level descriptions. A fundamental query to retrieve all active mappings for a specific calculation type would be:

SELECT tariff_calc_type_cd, tariff_level_cd
FROM igs.igs_he_ut_calc_lvl
WHERE closed_ind IS NULL OR closed_ind = 'N'
ORDER BY tariff_calc_type_cd;

Another critical pattern involves validating a proposed tariff level against a calculation type before processing student records, ensuring data integrity in the calculation routines.

Related Objects

Based on the provided ETRM metadata, the IGS_HE_UT_CALC_LVL table has a defined relationship with the APPS.IGS_HE_UT_CALC_LVL synonym. The synonym exists in the APPS schema, which is the standard access schema for Oracle EBS applications, providing a public interface for all application modules to reference this IGS table. The table itself is referenced by the primary key index IGS_HE_UT_CALC_LVL_PK, which enforces uniqueness on the combination of TARIFF_CALC_TYPE_CD and TARIFF_LEVEL_CD. The metadata indicates no other explicit foreign key dependencies are documented for this object, suggesting it is a master reference table that is likely referenced programmatically by UCAS tariff calculation logic or other validation forms within the IGS product set.