Search Results igs_he_ut_prs_dtls

Overview

The IGS_HE_UT_PRS_DTLS table is a core data object within the Oracle E-Business Suite (EBS) Student System (product family IGS). It functions as a detailed repository for storing calculated tariff information associated with specific individuals. In the context of higher education institutions, particularly those using systems like the UK's UCAS Tariff, this table holds the granular results of tariff calculations performed for a person's qualifications and awards. Its primary role is to persist these calculated details, enabling downstream processes for admissions, reporting, and compliance. The table's design, with its composite primary key, ensures that detailed tariff data is uniquely linked to a specific person, a specific calculation type, and a specific academic award.

Key Information Stored

The table's structure is defined by its primary and foreign key columns, which dictate the nature of the data it contains. The TARIFF_CALC_TYPE_CD column identifies the specific methodology or rule set used for the tariff calculation. The PERSON_ID column is a foreign key linking to the person (student or applicant) within the system. The AWARD_CD column is a foreign key linking to the specific academic award or qualification (e.g., a particular A-Level subject or diploma) for which the tariff is being calculated. Together, these three columns form the table's primary key (IGS_HE_UT_PRS_DTLS_PK). While the provided metadata does not list non-key columns, typical data stored would include the calculated tariff points for the award, potentially the grade achieved, the date of calculation, and other attributes pertinent to the detailed outcome of the tariff engine's processing for that specific award.

Common Use Cases and Queries

This table is central to operations involving student admissions and qualification analysis. A primary use case is generating a comprehensive tariff summary for an applicant, aggregating points from all their qualifications to determine if they meet the entry requirements for a course. System reports and personalized communications regarding an applicant's tariff score are also dependent on this data. Common queries involve joining this table to person and award master tables to produce readable reports. For example, a query to list all tariff details for a specific person would join IGS_HE_UT_PRS_DTLS to IGS_HE_UT_PRS_CALCS for the calculation type description and to IGS_PS_AWD for the award title. Another critical pattern is summing the TARIFF_POINTS (or a similarly named column, inferred) grouped by PERSON_ID to get a total applicant score for comparison against program thresholds.

Related Objects

The IGS_HE_UT_PRS_DTLS table exists within a defined relational schema, primarily interacting with two key parent tables via foreign key constraints, as documented in the provided metadata.

• IGS_HE_UT_PRS_CALCS: This table is referenced via the foreign key on the column TARIFF_CALC_TYPE_CD. It likely serves as a master table for different types or versions of tariff calculation rules and methodologies.
• IGS_PS_AWD: This table is referenced via the foreign key on the column AWARD_CD. IGS_PS_AWD is the master table for academic awards and qualifications within the Student System, providing descriptive information for the codes stored in the detail table.

The table is also the child of a parent entity represented by the composite key (TARIFF_CALC_TYPE_CD, PERSON_ID) from IGS_HE_UT_PRS_CALCS, suggesting a header-detail relationship where the CALCS table holds summary or control information for a person's overall tariff calculation.