Search Results unit_ref_cd




Overview
Explore in AI Chat

Overview

The IGS_PR_ORG_STAT_REF table is a configuration and control table within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Institutional Global Systems (IGS) module. Its primary role is to define granular inclusion and exclusion rules for calculating academic statistics, such as Grade Point Averages (GPA) and credit points, at the organizational unit level. The table acts as a filter, allowing administrators to specify precisely which academic units, identified by their reference codes, should be considered or omitted from these critical calculations for a given statistic type and organizational unit. This enables highly customized and accurate academic reporting and transcript generation.

Key Information Stored

The table's structure centers on a composite primary key and a control flag. The STAT_TYPE and ORG_UNIT_CD columns identify the specific user-defined organizational statistic being configured. The UNIT_REF_CD column, which was the focus of the user's search, is the pivotal data point; it stores the specific unit reference code (e.g., a code representing a course module, subject area, or program component) that is subject to the rule. The INCLUDE_OR_EXCLUDE column dictates the action, accepting values like 'INCLUDE' or 'EXCLUDE' to determine whether units associated with the referenced code are factored into the statistic calculation. Standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) track audit history.

Common Use Cases and Queries

A primary use case is the administrative setup of GPA calculation rules for a specific college or department. For instance, an administrator may configure the system to exclude all units with a UNIT_REF_CD of 'ADVPLACEMENT' from the cumulative GPA for the 'SCIENCE' organizational unit, while including them for an 'HONORS' statistic type. Common reporting queries involve listing all rules for a given statistic or finding which reference codes are excluded from a particular calculation. A foundational query to audit all configuration rules is:

  • SELECT stat_type, org_unit_cd, unit_ref_cd, include_or_exclude FROM igs.igs_pr_org_stat_ref ORDER BY 1, 2, 3;

To find all unit reference codes excluded from a specific statistic type for an organizational unit, a typical pattern is:

  • SELECT unit_ref_cd FROM igs.igs_pr_org_stat_ref WHERE stat_type = '&STAT_TYPE' AND org_unit_cd = '&ORG_CD' AND include_or_exclude = 'EXCLUDE';

Related Objects

The table's relationships are defined by its primary key and a documented foreign key. Its composite primary key, named IGS_PR_ORG_STAT_REF_PK, is built on the columns (ORG_UNIT_CD, STAT_TYPE, UNIT_REF_CD). A foreign key relationship exists where the ORG_UNIT_CD column in IGS_PR_ORG_STAT_REF references a parent table, IGS_PR_ORG_STAT. This links the inclusion/exclusion rules back to the master definition of the organizational unit statistic. The table is also referenced by an APPS synonym (IGS_PR_ORG_STAT_REF), which is the standard access point for EBS application code.