Search Results igs_pr_inst_sta_ref

Overview

The table IGS_PR_INST_STA_REF is a core configuration object within the Oracle E-Business Suite Student System (IGS). Its primary function is to define the specific academic units, identified by their Unit Reference Codes, that are either included in or excluded from the calculation of a user-defined institution statistic type. This table provides the granular control necessary for administrators to tailor statistical reporting and analysis based on precise subsets of the institution's academic offerings, ensuring that metrics are calculated against relevant and intended curricular data.

Key Information Stored

The table stores a mapping between a statistic type and a unit reference code. Its structure is defined by a composite primary key, which enforces the uniqueness of each mapping. The critical columns are:

• STAT_TYPE: This column holds the code for the user-defined institution statistic type. It is a foreign key referencing the IGS_PR_INST_STAT table, linking the reference rule to its parent statistic definition.
• UNIT_REF_CD: This column stores the specific Unit Reference Code that is being included or excluded for the associated statistic type. The combination of this code with the STAT_TYPE forms the table's primary key.

The presence of a record in this table for a given STAT_TYPE and UNIT_REF_CD pair typically signifies an inclusion rule. The logic for exclusion is generally managed by the application's business rules, where units not listed may be excluded from the statistic calculation, or vice-versa, depending on the configuration of the parent statistic type.

Common Use Cases and Queries

This table is central to generating accurate institutional statistics for reporting, accreditation, and internal analysis. A common use case is generating a report of all unit reference codes configured for a specific statistic, such as a retention rate calculation that should only consider a specific set of foundational courses. A typical query would join this table to the parent statistic definition table to provide context.

SELECT isr.stat_type,
       isr.unit_ref_cd,
       ist.description
FROM igs_pr_inst_sta_ref isr,
     igs_pr_inst_stat ist
WHERE isr.stat_type = ist.stat_type
AND ist.stat_type = '&STAT_TYPE_CODE';

Another critical scenario involves data validation, where administrators may need to identify unit reference codes that are configured for statistics but are no longer active in the system, requiring a join to the core unit catalog tables.

Related Objects

The functionality of IGS_PR_INST_STA_REF is intrinsically linked to other objects in the Student System. The documented relationships are:

• Primary Key: IGS_PR_INST_STA_REF_PK on columns (STAT_TYPE, UNIT_REF_CD).
• Foreign Key (Reference To): The table has a critical foreign key relationship where IGS_PR_INST_STA_REF.STAT_TYPE references IGS_PR_INST_STAT. This ensures that every unit reference code mapping is associated with a valid, pre-defined institution statistic type.

This table is a child of IGS_PR_INST_STAT and is essential for the detailed setup of the institution statistics functionality. Queries and processes that generate the final statistical values will read from this table to filter the unit data used in aggregations.