Search Results igs_pr_inst_stat

Overview

The IGS_PR_INST_STAT table is a core configuration table within the Oracle E-Business Suite Student System (IGS) module. It serves as a central installation-level control mechanism for statistical reporting. Its primary role is to define which specific statistic types, from the broader universe available in the system, are activated and available for use within a particular institution's implementation. This table effectively acts as a master switch, governing the subset of statistical measures that can be applied to student progression and academic records, ensuring reporting relevance and data integrity.

Key Information Stored

The table's structure is intentionally focused, with its primary purpose being the registration of active statistic types. The key column is STAT_TYPE, which stores the code or identifier for a statistic type that has been enabled for the installation. This column is both the primary key and a foreign key, linking directly to the master definition table for statistic types (IGS_PR_STAT_TYPE). The presence of a record in IGS_PR_INST_STAT signifies that the corresponding statistic type is in use and can be referenced elsewhere in the progression engine for calculations, validations, and reporting.

Common Use Cases and Queries

This table is fundamental for system setup and reporting configuration. A common administrative use case is querying the list of all active statistic types to configure progression rules or academic standing policies. For reporting and data validation, developers often join this table to related reference data to ensure only permitted statistics are processed. A typical query would retrieve the enabled statistic types along with their descriptions from the master table:

• SELECT inst.stat_type, type.description FROM igs_pr_inst_stat inst, igs_pr_stat_type type WHERE inst.stat_type = type.stat_type;

Another critical use case is validating data before insertion into dependent tables, such as IGS_PR_INST_STA_REF, by checking if a provided STAT_TYPE exists in IGS_PR_INST_STAT.

Related Objects

The IGS_PR_INST_STAT table sits at the center of a key relationship hierarchy for progression statistics. Its documented relationships are as follows:

• References (Parent Table): IGS_PR_STAT_TYPE. The STAT_TYPE column in IGS_PR_INST_STAT is a foreign key to IGS_PR_STAT_TYPE.STAT_TYPE. This ensures every enabled statistic type has a valid master definition.
• Referenced By (Child Table): IGS_PR_INST_STA_REF. The STAT_TYPE column in the IGS_PR_INST_STA_REF table is a foreign key to IGS_PR_INST_STAT.STAT_TYPE. This enforces that statistic references can only be created for types activated at the installation level.

This structure creates a controlled data flow: Master Definition (IGS_PR_STAT_TYPE) → Installation Activation (IGS_PR_INST_STAT) → Specific References (IGS_PR_INST_STA_REF).