Search Results parent_award_cd

Overview

The IGS.IGS_HE_UT_PRT_AWARD 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) product family. Its primary function is to manage hierarchical relationships between different award codes within the context of a specific tariff calculation type. This table enables the system to define a parent-child structure for awards, which is essential for complex fee calculations, reporting, and compliance with regulatory frameworks like the UK's Office for Students (OfS) or similar bodies. By storing these relationships, the table supports processes where the classification or fee liability of a child award is derived from or linked to a parent award.

Key Information Stored

The table's structure is designed to capture the relationship triad and standard audit information. The key business columns are:

• TARIFF_CALC_TYPE_CD (VARCHAR2(10)): The mandatory code identifying the specific tariff calculation framework or rule set. This column segments award relationships by calculation type.
• AWARD_CD (VARCHAR2(10)): The mandatory code for the child or dependent award.
• PARENT_AWARD_CD (VARCHAR2(10)): The mandatory code for the parent award to which the child award is linked. This column directly defines the hierarchical relationship queried by the user.

The table's primary key is a composite of TARIFF_CALC_TYPE_CD and AWARD_CD, ensuring uniqueness of a child award within a given calculation type. Standard "Who" columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) track all data changes for auditing purposes.

Common Use Cases and Queries

A primary use case is configuring and validating fee tariff structures for government or institutional returns. For instance, a specific postgraduate diploma (child award) may be linked to a broader master's degree (parent award) for fee calculation purposes. Administrators use this table to maintain these mappings. Common reporting queries include finding all child awards for a specific parent, or validating that an award has a defined parent within a calculation type.

Sample Query 1: Find all child awards for a given parent:
SELECT award_cd FROM igs.igs_he_ut_prt_award WHERE tariff_calc_type_cd = 'UK_FEE_REG' AND parent_award_cd = 'MASTERS';

Sample Query 2: Retrieve the full relationship for reporting or validation:
SELECT tariff_calc_type_cd, award_cd, parent_award_cd, last_update_date FROM igs.igs_he_ut_prt_award ORDER BY tariff_calc_type_cd, parent_award_cd, award_cd;

Related Objects

Based on the provided metadata, the IGS.IGS_HE_UT_PRT_AWARD table is referenced by a synonym named IGS_HE_UT_PRT_AWARD in the APPS schema. This synonym is the standard access point for all application code and modules within Oracle EBS, ensuring that logic referencing this table is portable and independent of the owning schema. While the dependency list does not show other referencing tables or views, this table is inherently linked to the broader award and tariff calculation setup in the Higher Education module. It likely serves as a lookup for calculation engines or validation APIs that process student course attempts and associated fee liabilities based on the defined award hierarchies.