Search Results igs_he_ut_prs_calcs_pk

Overview

The table IGS_HE_UT_PRS_CALCS is a core data object within the Oracle E-Business Suite (EBS) Student System (IGS) module. Its primary function is to store summarized results of Tariff calculations for individuals (persons). In the context of higher education, particularly in systems serving regions like the UK, a Tariff calculation typically refers to the process of converting academic qualifications into a standardized point score (e.g., UCAS Tariff points). This table acts as a header or summary record, holding the final or interim calculated score for a specific person and calculation type, providing a critical link between a student's profile and the detailed components that make up their overall score.

Key Information Stored

The table's structure is defined by its composite primary key, which dictates the fundamental data it contains. The two key columns are PERSON_ID, which identifies the individual (linking to the foundational HZ_PARTIES table in Oracle Trading Community Architecture), and TARIFF_CALC_TYPE_CD, which identifies the specific type or rule set used for the calculation (linking to the IGS_HE_UT_CALC_TYPE lookup table). While the provided metadata does not list all columns, the description and relationships indicate the table would typically store the resultant calculated summary values, such as the total tariff points, calculation date, status, and potentially the version of the rules applied. This design ensures a unique summary record exists for each combination of person and calculation methodology.

Common Use Cases and Queries

This table is central to reporting and decision-making processes related to student admissions and eligibility. Common use cases include generating summary reports of tariff scores for an applicant cohort, providing data for offer letters, and feeding summary metrics into dashboards. A typical query would join this summary table to person details and the calculation type description to produce a readable report. For example:

• SELECT hzp.party_name, calcs.* FROM igs.igs_he_ut_prs_calcs calcs JOIN hz_parties hzp ON calcs.person_id = hzp.party_id WHERE calcs.tariff_calc_type_cd = 'UCAS_2023';

Another critical pattern involves drilling down from the summary in IGS_HE_UT_PRS_CALCS to the detailed line items stored in the related IGS_HE_UT_PRS_DTLS table to audit or breakdown a specific calculation.

Related Objects

The table exists within a well-defined schema with clear foreign key relationships, as documented in the ETRM metadata. Its dependencies are as follows:

• Referenced Tables (Foreign Keys from IGS_HE_UT_PRS_CALCS):
  • HZ_PARTIES: Via IGS_HE_UT_PRS_CALCS.PERSON_ID = HZ_PARTIES.PARTY_ID. This links the tariff summary to the master person/party record.
  • IGS_HE_UT_CALC_TYPE: Via IGS_HE_UT_PRS_CALCS.TARIFF_CALC_TYPE_CD = IGS_HE_UT_CALC_TYPE.TARIFF_CALC_TYPE_CD. This provides the meaning and context for the calculation type code.
• Dependent Table (Foreign Key referencing IGS_HE_UT_PRS_CALCS):
  • IGS_HE_UT_PRS_DTLS: Via IGS_HE_UT_PRS_DTLS.TARIFF_CALC_TYPE_CD = IGS_HE_UT_PRS_CALCS.TARIFF_CALC_TYPE_CD and IGS_HE_UT_PRS_DTLS.PERSON_ID = IGS_HE_UT_PRS_CALCS.PERSON_ID. This child table holds the detailed line items (e.g., individual qualifications, grades, and their point contributions) that roll up into the summary record in IGS_HE_UT_PRS_CALCS.