Search Results igs_he_ut_prt_award




Overview
Explore in AI Chat

Overview

The IGS_HE_UT_PRT_AWARD table is a core data structure within the Oracle E-Business Suite Student System (IGS) module, specifically supporting the functionality for Higher Education (HE) Unit Tariff calculations. As documented, its primary role is to store parent-child award relationships that are defined for a specific calculation type. This table is essential for configuring how academic awards (e.g., degrees, diplomas) are hierarchically organized for the purposes of tariff or points calculations, enabling complex rules where one award may be a component or prerequisite of another within a given calculation framework.

Key Information Stored

The table's structure is defined by its primary and foreign key columns, which establish the relationships it manages. The primary key is a composite of TARIFF_CALC_TYPE_CD and AWARD_CD, ensuring a unique configuration for each child award within a calculation type. The AWARD_CD column stores the code for the child award, while the PARENT_AWARD_CD column stores the code for its immediate parent award within the hierarchy. The TARIFF_CALC_TYPE_CD column is a critical foreign key that links this specific parent-child relationship to a defined calculation type in the system, ensuring the hierarchy is applied in the correct context.

Common Use Cases and Queries

A primary use case is the setup and maintenance of award hierarchies for tariff reporting and academic progression analysis. Administrators use this data to ensure that points from subordinate awards are correctly rolled up into higher-level qualifications. A common reporting query would involve joining to the award descriptions to produce a readable hierarchy report for a given calculation type. For example:

  • Retrieving a full hierarchy for a specific tariff calculation type to validate configuration.
  • Identifying all child awards that roll up into a particular parent award for audit purposes.
  • Supporting batch processes that calculate aggregate tariff points for a student's academic record by traversing these defined relationships.

A sample SQL pattern to list relationships with award names would join IGS_HE_UT_PRT_AWARD to IGS_PS_AWD (for child and parent award descriptions) and to IGS_HE_UT_CALC_TYPE for the calculation type description.

Related Objects

This table maintains strict referential integrity through its documented foreign key relationships, which are central to its function. The key related objects are:

  • IGS_HE_UT_CALC_TYPE: Referenced via the TARIFF_CALC_TYPE_CD column. This table defines the overarching calculation type for which the award hierarchy is valid.
  • IGS_PS_AWD (referenced twice): This core table defining academic awards is referenced by both the AWARD_CD column (for the child award) and the PARENT_AWARD_CD column (for the parent award). These relationships ensure that only valid award codes can be configured in the hierarchy.

The primary key constraint IGS_HE_UT_PRT_AWARD_PK ensures data uniqueness, while these foreign keys enforce business rules and maintain data consistency across the Student System.