Search Results igs_pr_org_stat_ref




Overview
Explore in AI Chat

Overview

The table IGS_PR_ORG_STAT_REF is a configuration table within the Oracle E-Business Suite Student System (IGS) module. Its primary role is to define inclusion and exclusion rules for unit reference codes associated with user-defined organizational unit statistic types. This table acts as a child object to IGS_PR_ORG_STAT, providing the granular detail necessary for calculating or reporting specific statistics for an organizational unit. By storing which unit reference codes are considered in or out of scope for a given statistic, it enables administrators to tailor statistical definitions to precise academic or administrative requirements, ensuring data integrity and relevance in institutional reporting.

Key Information Stored

The table's structure is defined by its composite primary key, which consists of three columns that uniquely identify each rule. The ORG_UNIT_CD stores the code for the organizational unit (e.g., a specific department or school). The STAT_TYPE column holds the user-defined code for the organizational statistic type being configured. The UNIT_REF_CD contains the specific unit reference code that is either included or excluded from the statistic's calculation. While the provided metadata does not list all columns explicitly, a typical implementation would also include a column—often named INCLUDE_EXCLUDE_IND or similar—to specify whether the referenced UNIT_REF_CD is to be included in or excluded from the statistic for the given ORG_UNIT_CD and STAT_TYPE.

Common Use Cases and Queries

A primary use case is the setup and maintenance of custom institutional metrics, such as tracking enrollment or completion rates for specific categories of units (e.g., postgraduate research units, online delivery units) within a faculty. Administrators would populate this table to bind specific unit reference codes to their statistic definitions. Common queries involve listing all rules for a given organizational unit and statistic type, or validating which units are in scope for a report. A sample SQL pattern to retrieve all included reference codes for a statistic would be:

  • SELECT unit_ref_cd FROM igs_pr_org_stat_ref WHERE org_unit_cd = '<ORG_CD>' AND stat_type = '<STAT_TYPE>' AND include_exclude_ind = 'I';

This data is critical for generating accurate operational reports and dashboards within the Student System.

Related Objects

The table maintains a direct foreign key relationship with the IGS_PR_ORG_STAT table, which defines the header-level organizational unit statistics. The relationship is enforced on the combination of ORG_UNIT_CD and STAT_TYPE columns. This means that every record in IGS_PR_ORG_STAT_REF must correspond to a valid, pre-existing combination of organizational unit and statistic type defined in the parent IGS_PR_ORG_STAT table. The relationship ensures referential integrity, so that inclusion/exclusion rules cannot exist for undefined statistic types. The documented foreign key path is: IGS_PR_ORG_STAT_REF.ORG_UNIT_CD, IGS_PR_ORG_STAT_REF.STAT_TYPE → IGS_PR_ORG_STAT.