Results for “igs_pr_org_stat_ref”

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

Overview

IGS_PR_ORG_STAT_REF is a reference table within the Oracle E-Business Suite Student System (IGS) product family. Its documented purpose is to define which unit Reference Codes are Included or Excluded for a user-defined Organizational Unit Statistic Type. In operational terms, the table acts as a filter or qualification list that governs how statistics are computed for a given organizational unit. Each row pairs an organizational unit and a statistic type with a specific unit reference code, and it records whether that reference code participates in (INCLUDE) or is withheld from (EXCLUDE) the statistic.

Because the table refines the definition of an existing statistic rather than establishing a statistic in its own right, the supplied heuristic Data Vault classification suggests a satellite-leaning model. This is consistent with its role: it holds descriptive, context-dependent attributes (inclusion or exclusion of a reference code) attached to a parent business key defined elsewhere in the model.

Key Information Stored

The documented physical schema for IGS_PR_ORG_STAT_REF contains nine columns. The most significant are:

• ORG_UNIT_CD — The organizational unit code, identifying the academic or administrative unit to which the statistic applies.
• STAT_TYPE — The user-defined Organizational Unit Statistic Type that the reference row qualifies.
• UNIT_REF_CD — The unit Reference Code that is being included in or excluded from the statistic.
• INCLUDE_OR_EXCLUDE — The flag or indicator that determines whether UNIT_REF_CD is counted toward the statistic or filtered out of it.
• CREATED_BY, CREATION_DATE — Standard EBS audit columns capturing the creating user and the row creation timestamp.
• LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS audit columns recording the most recent update, including the login context under which the change was made.

The primary key is IGS_PR_ORG_STAT_REF_PK, whose columns are ORG_UNIT_CD, STAT_TYPE, and UNIT_REF_CD. A UNIQUE index, IGS_PR_ORG_STAT_REF_U1, is documented over the same three columns, confirming them as the business-key candidate. Because the composite key is drawn entirely from business attributes rather than a system-generated sequence, there is no separate surrogate key column documented for this object; the primary key itself carries the business meaning.

Common Use Cases and Queries

Typical usage centers on validating and reporting the inclusion/exclusion logic applied to organizational statistics. Administrators maintain rows through the Student System setup forms, while developers and analysts query the table to explain unexpected statistic values or to reconcile reported figures against configuration.

A common pattern retrieves all reference codes for a given statistic and unit, together with the include/exclude direction:

• SELECT org_unit_cd, stat_type, unit_ref_cd, include_or_exclude FROM igs_pr_org_stat_ref WHERE org_unit_cd = :unit AND stat_type = :stat ORDER BY unit_ref_cd;
• Reports frequently isolate inclusions or exclusions: SELECT unit_ref_cd FROM igs_pr_org_stat_ref WHERE org_unit_cd = :unit AND stat_type = :stat AND include_or_exclude = 'I';
• Joining to the parent definition confirms that the statistic itself is validly configured: SELECT s.org_unit_cd, s.stat_type, r.unit_ref_cd, r.include_or_exclude FROM igs_pr_org_stat s JOIN igs_pr_org_stat_ref r ON s.org_unit_cd = r.org_unit_cd AND s.stat_type = r.stat_type;

Reconciliation queries against the audit columns (last_updated_by, last_update_date) are useful for change tracking and for identifying recently altered inclusion rules.

Related Objects

The documented foreign key relationship anchors this table to its parent statistic definition. Additional IGS Student System objects participate in the same organizational statistics model.

• IGS_PR_ORG_STAT — The parent table holding user-defined Organizational Unit Statistic Types. Joined on IGS_PR_ORG_STAT_REF.ORG_UNIT_CD and STAT_TYPE. This is the sole documented foreign key relationship.
• IGS_PR_ORG_STAT_REF_PK / IGS_PR_ORG_STAT_REF_U1 — The primary key constraint and unique index enforcing uniqueness over ORG_UNIT_CD, STAT_TYPE, and UNIT_REF_CD.
• Unit reference code validation objects — The referenced UNIT_REF_CD values are validated against the unit reference code definitions maintained within the IGS Student System, ensuring only configured codes are eligible for inclusion.
• Organizational unit definition objects — ORG_UNIT_CD values derive from the organizational unit setup used across IGS reporting and statistics.

Because the FK in the documentation is expressed at the ORG_UNIT_CD column toward IGS_PR_ORG_STAT, integration and extract routines should join on the composite of ORG_UNIT_CD and STAT_TYPE to guarantee a correct parent match.