Results for “include_or_exclude”

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

Overview

The IGS_PR_INST_STA_REF table belongs to the IGS (Student System) product family within Oracle E-Business Suite, a module that is documented as obsolete in the ETRM reference set for releases 12.1.1 and 12.2.2. The table defines the relationship between a user-defined Institution Statistic Type and the Unit Reference Codes that are either included in or excluded from that statistic. In effect, it acts as a configuration or control table that governs which academic unit categories participate in or are filtered out of a given institutional statistic definition.

From a Data Vault modeling perspective, the mined relationship data classifies this object as satellite-leaning. This heuristic reflects the fact that the table carries descriptive, keyed attributes (notably the inclusion/exclusion flag and the reference code type) that qualify a parent business concept, rather than representing an independent hub or an associative link between two comparable hubs. The parent concept is the Institution Statistic Type, maintained in IGS_PR_INST_STAT.

Key Information Stored

The table's documented physical schema contains nine columns. The most significant are:

• STAT_TYPE — the Institution Statistic Type identifier. This is the foreign key linking to IGS_PR_INST_STAT and forms part of the primary key.
• UNIT_REF_CD — the Unit Reference Code being qualified; the second component of the primary key.
• REFERENCE_CD_TYPE — a further qualifying attribute indicating the category or type of the reference code. It participates in the unique index, distinguishing variants of the same UNIT_REF_CD.
• INCLUDE_OR_EXCLUDE — the operative control flag. It determines whether the referenced unit code contributes to or is removed from the statistic.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit and concurrency columns populated by the application tier.

The surrogate primary key is IGS_PR_INST_STA_REF_PK, defined on (STAT_TYPE, UNIT_REF_CD). The unique index IGS_PR_INST_STA_REF_U1, defined on (STAT_TYPE, REFERENCE_CD_TYPE, UNIT_REF_CD), represents the stronger business-key candidate, because it additionally enforces uniqueness across the reference code type dimension.

Common Use Cases and Queries

Typical usage centers on statistics configuration reporting and validation. Administrators can retrieve all inclusions and exclusions for a given statistic type:

• Inclusion/exclusion enumeration: SELECT stat_type, unit_ref_cd, reference_cd_type, include_or_exclude FROM igs_pr_inst_sta_ref WHERE stat_type = :p_stat_type;
• Audit review of configuration changes: SELECT * FROM igs_pr_inst_sta_ref WHERE last_update_date >= :p_since;
• Join to the parent statistic definition: SELECT s.stat_type, s.description, r.unit_ref_cd, r.include_or_exclude FROM igs_pr_inst_stat s, igs_pr_inst_sta_ref r WHERE s.stat_type = r.stat_type;

These patterns support institutional research reporting, data-quality checks confirming that each statistic has at least one qualifying reference code, and reconciliation of student-unit records against configured statistics.

Related Objects

• IGS_PR_INST_STAT — the parent table holding Institution Statistic Type definitions; joined via STAT_TYPE.
• IGS_PR_INST_STA_REF_PK — the primary key constraint enforcing (STAT_TYPE, UNIT_REF_CD).
• IGS_PR_INST_STA_REF_U1 — the unique index enforcing (STAT_TYPE, REFERENCE_CD_TYPE, UNIT_REF_CD).
• IGS_PS_UNIT_REF_CD and related unit reference code tables — supply the valid UNIT_REF_CD values referenced here.
• IGS_PR_INST_STAT_V and associated statistics inquiry views/APIs in the IGS Student System — consume this configuration for statistic calculation.

Because the product is obsolete, implementers should treat these dependencies as historical and confirm availability against their specific EBS instance.