Search Results tariff_level_cd




Overview
Explore in AI Chat

Overview

The IGS_HE_UT_LVL_AWARD 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) modules under the IGS (iGrants) product family. Its primary function is to manage the mapping between the UK's Higher Education Statistics Agency (HESA) Tariff Levels and the institution's internal OSS (Oracle Student System) Award Codes. This mapping is critical for statutory reporting and for aligning internal academic award structures with the standardized national tariff framework used for funding and performance analysis. The table's design enforces a unique relationship between a Tariff Calculation Type, a Tariff Level, and an Award Code.

Key Information Stored

The table stores the essential mapping data and associated control flags. The primary business columns are:

  • TARIFF_CALC_TYPE_CD: The code defining the type of tariff calculation, forming part of the primary key.
  • TARIFF_LEVEL_CD: The HESA Tariff Level code, sourced from application lookups. This is a key search field and part of the primary key.
  • AWARD_CD: The institution's internal OSS Award Code that corresponds to the specified tariff level and calculation type. It is part of the primary key and is referenced as a foreign key to the awards table (IGS_PS_AWD).
  • DEFAULT_AWARD_IND: A flag indicating if the mapped award code is the default selection for the given tariff level and calculation type.
  • CLOSED_IND: A status flag indicating whether this specific mapping record is closed or inactive.

The table also includes standard Oracle EBS "Who" columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) for auditing.

Common Use Cases and Queries

This table is central to processes requiring translation between institutional awards and HESA tariff levels. A common use case is the generation of HESA student returns, where a student's course award must be reported with the correct national tariff level. Another is configuring system rules for automatic award-to-tariff assignment during enrollment or completion processing.

A typical query to retrieve all active mappings for a specific tariff level, as indicated by the user's search for "tariff_level_cd", would be:

SELECT tariff_calc_type_cd, award_cd, default_award_ind
FROM igs.igs_he_ut_lvl_award
WHERE tariff_level_cd = :p_tariff_level
AND NVL(closed_ind, 'N') = 'N'
ORDER BY tariff_calc_type_cd, award_cd;

For reporting purposes, a join to the awards table is often necessary to get the award description:

SELECT map.tariff_calc_type_cd, map.tariff_level_cd, map.award_cd, awd.award_name
FROM igs.igs_he_ut_lvl_award map,
igs.igs_ps_awd awd
WHERE map.award_cd = awd.award_cd
AND map.default_award_ind = 'Y'
AND NVL(map.closed_ind, 'N') = 'N';

Related Objects

The table has defined relationships with other key EBS objects, primarily through its primary and foreign keys:

  • Primary Key: The table is uniquely identified by the composite primary key IGS_HE_UT_LVL_AWARD_PK on the columns (TARIFF_CALC_TYPE_CD, TARIFF_LEVEL_CD, AWARD_CD).
  • Foreign Key Reference: The AWARD_CD column references the IGS_PS_AWD table (presumably on its AWARD_CD column). This ensures referential integrity, guaranteeing that any award code mapped to a tariff level is a valid award within the student system.
  • Dependencies: The table is referenced by the APPS synonym IGS_HE_UT_LVL_AWARD, which is the standard access point for application code and reports within the EBS environment.