Search Results tariff_calc_type_cd




Overview
Explore in AI Chat

Overview

The IGS_HE_UT_PRS_CALCS 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 (IGS) product family. Its primary function is to serve as a summary-level audit trail for tariff calculations performed against individuals (persons) within the system. A tariff calculation, in this context, is a user-defined process for determining a specific metric or score, such as a university entry tariff. The table's role is to record the fact that a particular type of calculation was executed for a specific person on a given date, providing a high-level history and preventing duplicate calculations through its unique primary key constraint.

Key Information Stored

The table stores a minimal but critical set of columns to fulfill its audit and control purpose. The two mandatory key columns are TARIFF_CALC_TYPE_CD (VARCHAR2(10)), a foreign key that uniquely identifies the type of calculation performed, and PERSON_ID (NUMBER(15)), a foreign key identifying the person for whom the calculation was run. Together, they form the table's primary key (IGS_HE_UT_PRS_CALCS_PK). The CALC_DATE (DATE) records the execution date of the calculation. Standard EBS "WHO" columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) track the creation and maintenance history of each record for compliance and support.

Common Use Cases and Queries

This table is central to querying the calculation history for reporting, auditing, and process control. A common use case is verifying if a specific tariff calculation has already been performed for a person to avoid redundant processing. Another is generating a list of all persons who have had a particular calculation type run within a date range for batch reporting. The fundamental query pattern, as indicated in the ETRM, selects the core data:

  • Identifying calculation history for a specific person: SELECT * FROM igs.igs_he_ut_prs_calcs WHERE person_id = <person_id> ORDER BY calc_date DESC;
  • Finding all persons processed by a specific calculation type: SELECT person_id, calc_date FROM igs.igs_he_ut_prs_calcs WHERE tariff_calc_type_cd = '<CODE>';

Related Objects

The table exists within a defined relational schema, as per the provided dependency and relationship data. It references two parent tables via foreign key constraints:

  • HZ_PARTIES (TABLE): The PERSON_ID column references this Trading Community Architecture (TCA) base table, linking the calculation record to a master person/party definition.
  • IGS_HE_UT_CALC_TYPE (TABLE): The TARIFF_CALC_TYPE_CD column references this lookup table, which defines the valid types of tariff calculations available in the system.

Furthermore, the table is referenced as a parent by at least one other object:

  • IGS_HE_UT_PRS_DTLS (TABLE): This table likely holds the detailed results or components of the calculation. It references IGS_HE_UT_PRS_CALCS via the TARIFF_CALC_TYPE_CD column (and likely also PERSON_ID), establishing a one-to-many relationship where a summary record in CALCS can have many detailed records in DTLS.