Search Results igs_pr_org_stat

Overview

The IGS_PR_ORG_STAT table is a core data structure within the Oracle E-Business Suite (EBS) Student System (IGS). It serves as a configuration and definition table that governs the collection and reporting of statistical data for organizational units. Specifically, it defines the details of what a particular user-defined organizational unit statistic type includes and is used for. This table establishes the valid combinations of organizational units and statistic types, acting as a central control point that links the definition of a statistic type (IGS_PR_STAT_TYPE) to the specific organizational units for which it is applicable. Its role is foundational for enabling tailored institutional reporting and analytics across different departments, schools, or other organizational structures within an educational institution.

Key Information Stored

The table's structure is defined by its composite primary key, which consists of two critical columns. The ORG_UNIT_CD column stores the unique code identifying an organizational unit within the institution, such as a specific college, department, or campus. The STAT_TYPE column stores the code for a user-defined statistic type, which categorizes the kind of metric or data point being tracked (e.g., enrollment headcount, graduation rate, faculty-to-student ratio). Together, these columns create a definitive list of which statistics are relevant and can be recorded for each organizational unit. The table may also contain descriptive or control columns not explicitly listed in the core metadata but typical for such configuration entities, which would further define the usage and calculation rules for the statistic within that unit's context.

Common Use Cases and Queries

The primary use case for IGS_PR_ORG_STAT is to validate and drive the setup of statistical reporting. Administrators use this table to configure which metrics are tracked for different parts of the institution. A common reporting query would join this table to the statistic type description table to generate a list of all active statistics for a given department. For example:

• Identifying configured statistics: SELECT ous.org_unit_cd, st.stat_type, st.description FROM igs_pr_org_stat ous JOIN igs_pr_stat_type st ON ous.stat_type = st.stat_type WHERE ous.org_unit_cd = 'ENG';
• Validating a statistic for data entry: Before allowing entry of a statistical value for a unit, application logic would check for the existence of a corresponding record in IGS_PR_ORG_STAT to ensure the statistic is defined for that unit.
• Generating institutional reports: This table acts as a filter or join condition in larger reporting SQL to pull statistic data only for authorized and defined organizational unit and statistic type combinations.

Related Objects

IGS_PR_ORG_STAT sits at the center of a small but critical data model for organizational statistics. Its relationships are explicitly documented through foreign key constraints.

• IGS_PR_STAT_TYPE: This table is referenced by IGS_PR_ORG_STAT via the STAT_TYPE column. It provides the master definition and description for each statistic type code used in the system.
• IGS_PR_ORG_STAT_REF: This table references IGS_PR_ORG_STAT. Its foreign key is built on both the ORG_UNIT_CD and STAT_TYPE columns, linking reference data or actual statistical values back to the valid combination defined in IGS_PR_ORG_STAT. This makes IGS_PR_ORG_STAT a parent table for statistical reference data.