Search Results igs_he_ut_calc_type




Overview
Explore in AI Chat

Overview

The IGS_HE_UT_CALC_TYPE table is a core reference table within the Oracle E-Business Suite Student System (IGS) module. It serves as a master repository for defining and storing different types of UCAS Tariff calculations. The UCAS Tariff is a points system used in the United Kingdom to report achievement for entry into higher education. This table's primary role is to provide a controlled list of calculation methodologies (e.g., standard, best N grades, specific qualification types) that the system can apply when determining a prospective or current student's tariff score. Its integrity is critical as it is referenced by multiple operational tables that store specific calculation rules, exclusions, and results.

Key Information Stored

The central piece of data stored in this table is the Tariff Calculation Type code. While the provided ETRM metadata does not list all column definitions, the structure indicates that TARIFF_CALC_TYPE_CD is the primary key column. This code uniquely identifies each distinct calculation method. Typically, such a reference table would also contain descriptive columns, such as a name or description for the calculation type, and standard WHO columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY) for auditing. The table's purpose is to establish a valid domain of values that ensure data consistency across the complex tariff calculation engine.

Common Use Cases and Queries

This table is primarily used in setup, maintenance, and reporting of the UCAS Tariff functionality. Administrators use it to define the calculation types available for configuration. Common operational queries involve joining this table to its related detail tables to generate reports or validate setups. For instance, to list all calculation levels defined for each tariff calculation type, a query would join to IGS_HE_UT_CALC_LVL.

Sample Query:
SELECT calc_type.TARIFF_CALC_TYPE_CD, calc_lvl.*
FROM IGS_HE_UT_CALC_TYPE calc_type
LEFT JOIN IGS_HE_UT_CALC_LVL calc_lvl
ON calc_type.TARIFF_CALC_TYPE_CD = calc_lvl.TARIFF_CALC_TYPE_CD
ORDER BY 1;

Another key use case is during the tariff calculation process itself, where the system references the valid type to determine which set of rules and exclusions to apply for a given student or qualification.

Related Objects

The IGS_HE_UT_CALC_TYPE table is a parent to several key operational tables, as defined by its foreign key relationships. These child tables store the detailed rules and data associated with each calculation type.

  • IGS_HE_UT_CALC_LVL: Links via TARIFF_CALC_TYPE_CD. Likely stores the qualification levels and their corresponding point values for each calculation type.
  • IGS_HE_UT_EXCL_QALS: Links via TARIFF_CALC_TYPE_CD. Presumably holds qualifications that should be excluded from a specific type of tariff calculation.
  • IGS_HE_UT_PRS_CALCS: Links via TARIFF_CALC_TYPE_CD. Likely stores the results of personal tariff calculations performed for applicants or students.
  • IGS_HE_UT_PRT_AWARD: Links via TARIFF_CALC_TYPE_CD. Probably contains details about predicted or awarded tariff points.

These relationships form a hierarchical data model where IGS_HE_UT_CALC_TYPE acts as the controlling entity for a suite of tariff calculation configuration and results tables.