Results for “igs_pr_org_stat”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The IGS_PR_ORG_STAT table is a core configuration object within the IGS (Student System) product family of Oracle E-Business Suite, available in both 12.1.1 and 12.2.2. It defines the details of what a particular user-defined Organizational Unit Statistic Type includes and is used for. In practical terms, the table acts as the association and attribute layer that binds an organizational unit to a statistic type and determines how that statistic is displayed, calculated, and included in progression, financial aid, and other institutional reporting rules.

From a Data Vault modeling perspective, the heuristic classification for this table is satellite-leaning. That classification is a modeling suggestion derived from the foreign key structure: the table holds descriptive attributes (such as display order, timeframe, and inclusion indicators) that qualify an underlying business key rather than defining a new business relationship on its own. The composite business key is formed by ORG_UNIT_CD and STAT_TYPE.

Key Information Stored

The table is documented with 16 columns. The most important of these fall into three groups: key columns, control/ordering columns, and inclusion indicator columns.

• ORG_UNIT_CD – The organizational unit code. Part of the primary key and the unique business key.
• STAT_TYPE – The user-defined organizational unit statistic type. Part of the primary key and the unique business key; also a foreign key to IGS_PR_STAT_TYPE.
• DISPLAY_ORDER – Controls the sequence in which the statistic is presented; enforced unique per organizational unit via IGS_PR_ORG_STAT_U2 (ORG_UNIT_CD, DISPLAY_ORDER).
• TIMEFRAME – The reporting or calculation period associated with the statistic.
• STANDARD_IND, PROGRESSION_IND, FIN_AID_IND – Flags indicating whether the statistic applies to standard processing, progression evaluation, or financial aid determination.
• DISPLAY_IND – Controls whether the statistic is surfaced in user-facing views.
• INCLUDE_STANDARD_IND, INCLUDE_LOCAL_IND, INCLUDE_OTHER_IND – Granular inclusion flags that determine which categories of subordinate statistics or records are rolled into the parent statistic.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN – Standard EBS audit columns recording who created and last modified the configuration row.

The surrogate primary key is IGS_PR_ORG_STAT_PK (ORG_UNIT_CD, STAT_TYPE). Two unique indexes act as business-key candidates: IGS_PR_ORG_STAT_U1 (ORG_UNIT_CD, STAT_TYPE) and IGS_PR_ORG_STAT_U2 (ORG_UNIT_CD, DISPLAY_ORDER).

Common Use Cases and Queries

Typical scenarios involve reporting on which statistics are enabled for a given organizational unit, and controlling their presentation order and inclusion rules. A common query retrieves all configured statistics for an organizational unit:

SELECT org_unit_cd, stat_type, display_order, timeframe,
       standard_ind, progression_ind, fin_aid_ind
FROM   igs_pr_org_stat
WHERE  org_unit_cd = :p_org_unit_cd
ORDER  BY display_order;

Administrators use the inclusion flags to audit which statistics feed into standard, local, or other reporting categories. A query joining to the statistic type table enriches results with the underlying definition:

SELECT s.org_unit_cd, s.stat_type, t.description, s.display_order
FROM   igs_pr_org_stat s, igs_pr_stat_type t
WHERE  s.stat_type = t.stat_type
AND    s.display_ind = 'Y';

Reporting use cases include configuring progression statistics, financial aid eligibility rules, and institutional dashboards that require a defined and ordered set of statistics per organizational unit.

Related Objects

The following objects are significant to the operation of IGS_PR_ORG_STAT based on documented FK relationships:

• IGS_PR_STAT_TYPE – Referenced by IGS_PR_ORG_STAT.STAT_TYPE; supplies the statistic type definition.
• IGS_PR_ORG_STAT_REF – References this table via ORG_UNIT_CD and STAT_TYPE; a dependent reference table.
• IGS_PR_ORG_STAT_PK – The primary key constraint enforcing ORG_UNIT_CD and STAT_TYPE uniqueness.
• IGS_PR_ORG_STAT_U1 / U2 – Unique indexes supporting business-key and display-order integrity.

These relationships confirm that IGS_PR_ORG_STAT functions as a configuration bridge between organizational units and statistic types, with dependent reference data stored in IGS_PR_ORG_STAT_REF.