Results for “number_of_qual”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGS_HE_UT_PRS_DTLS is a transactional table in the IGS (Student System) product family of Oracle E-Business Suite, present and valid in both 12.1.1 and 12.2.2. It holds tariff calculation details for a person, functioning as the persisting store for the outcome of tariff assessments performed by the higher-education utility tariff engine. Each row captures a single calculated tariff result scoped to a combination of tariff calculation type, person, and award, making the table the authoritative record of per-person tariff scores and qualifying counts.

From a Data Vault modeling perspective, the mined foreign-key structure suggests this object behaves as a link. It sits between the tariff calculation definition (IGS_HE_UT_PRS_CALCS) and the award definition (IGS_PS_AWD), resolving a many-to-many relationship between persons, awards, and tariff calculation types. This classification is heuristic and should be treated as a modeling suggestion rather than a documented Oracle architectural assertion.

Key Information Stored

The table contains ten documented columns. The business key is defined by the unique index IGS_HE_UT_PRS_DTLS_PK, which is composed of three columns:

• TARIFF_CALC_TYPE_CD — identifies the tariff calculation type applied; also a foreign key to IGS_HE_UT_PRS_CALCS.
• PERSON_ID — the person (student or applicant) for whom the tariff was calculated.
• AWARD_CD — the award against which the tariff applies; a foreign key to IGS_PS_AWD.

No separate surrogate key column is documented; the composite primary key itself serves as the row identifier, and uniqueness is enforced through IGS_HE_UT_PRS_DTLS_PK.

The two remaining business data columns hold the calculated results:

• NUMBER_OF_QUAL — the count of qualifications considered in the tariff calculation for the person/award combination.
• TARIFF_SCORE — the numeric tariff score produced by the calculation.

The table also carries standard Oracle EBS audit columns: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN. These support change tracking and are populated automatically by the application tier and the WHO columns convention.

Common Use Cases and Queries

Typical usage centers on retrieving, auditing, and reporting tariff outcomes for students. Administrative users query the table to confirm the score assigned to a person for a specific award, and reporting extracts aggregate tariff data across cohorts.

A representative query returning tariff results with award context:

• SELECT p.PERSON_ID, p.AWARD_CD, p.TARIFF_CALC_TYPE_CD, p.TARIFF_SCORE, p.NUMBER_OF_QUAL FROM IGS_HE_UT_PRS_DTLS p WHERE p.PERSON_ID = :person_id;

A join to resolve the award description and calculation type:

• SELECT d.PERSON_ID, a.AWARD_CD, a.DESCRIPTION, d.TARIFF_SCORE FROM IGS_HE_UT_PRS_DTLS d, IGS_PS_AWD a WHERE d.AWARD_CD = a.AWARD_CD AND d.TARIFF_CALC_TYPE_CD = :calc_type;

Aggregate reporting frequently sums or averages TARIFF_SCORE and NUMBER_OF_QUAL grouped by TARIFF_CALC_TYPE_CD or AWARD_CD. Audit queries filter on LAST_UPDATE_DATE to identify recently recalculated records. Because the primary key is composite, all maintenance and lookup operations should supply the full three-column key to avoid ambiguous matches.

Related Objects

The following objects are most significant to IGS_HE_UT_PRS_DTLS, based on documented foreign-key relationships:

• IGS_HE_UT_PRS_CALCS — parent table referenced via TARIFF_CALC_TYPE_CD; defines the tariff calculation types driving each detail row.
• IGS_PS_AWD — parent table referenced via AWARD_CD; provides the award definition and description.
• IGS_HE_UT_PRS_DTLS_PK — the unique index enforcing the composite business key (TARIFF_CALC_TYPE_CD, PERSON_ID, AWARD_CD).

Person-level context is inferred through PERSON_ID, which links to the person registry in the IGS/HR schema; the exact target table is not enumerated in the documented FK list and should be confirmed against the instance. Reporting views and concurrent programs in the Student System module that present tariff calculations typically join this table to IGS_PS_AWD and IGS_HE_UT_PRS_CALCS, making those two the primary dependent objects to account for in any extract or integration design.