Results for “standard_ind”

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

Overview

IGS_PR_INST_STAT is a configuration table in the IGS (Student System) product schema of Oracle E-Business Suite, present in both 12.1.1 and 12.2.2. Its documented purpose is to define the Statistic Types that will be used by a particular installation. In practice, the table represents the installation-level enablement layer of the student statistics subsystem: it determines which statistic types are active, how they are ordered for display, and which categories of statistics (standard, local, and other) they draw upon. Whereas the parent type table describes what a statistic is, IGS_PR_INST_STAT governs whether and how that statistic participates in processing and reporting for a given institution.

The table is owned by the IGS schema and holds 15 documented columns. Its primary key constraint is IGS_PR_INST_STAT_PK, defined on the STAT_TYPE column, which is also the single foreign key reference to IGS_PR_STAT_TYPE. A second unique index, IGS_PR_INST_STAT_U2, is defined on DISPLAY_ORDER, making it a business-key candidate for ordering purposes. On the basis of the documented foreign key structure, the heuristic Data Vault classification is satellite-leaning, suggesting the table is best modeled as descriptive context attached to the statistic type hub rather than as an independent hub or transactional link. This is a modeling suggestion derived from the FK topology, not a documented architectural designation.

Key Information Stored

The most significant columns fall into three groups. The identifier group centers on STAT_TYPE, which is the primary key column of IGS_PR_INST_STAT_PK and simultaneously the foreign key to IGS_PR_STAT_TYPE; it carries the code of the statistic type being configured. Because the constraint is named IGS_PR_INST_STAT_PK, the metadata identifies STAT_TYPE as the surrogate primary key for relationship purposes, while the unique index on DISPLAY_ORDER constitutes a secondary business-key candidate.

The behavioral group captures how the statistic is used: DISPLAY_ORDER controls sequencing in user-facing lists; TIMEFRAME indicates the period context over which the statistic is evaluated; STANDARD_IND flags the statistic as part of the standard set; PROGRESSION_IND indicates a progression-related statistic; FIN_AID_IND marks a financial aid statistic; and DISPLAY_IND controls whether the statistic is exposed to users.

The inclusion group governs the composition of statistic sets: INCLUDE_STANDARD_IND, INCLUDE_LOCAL_IND, and INCLUDE_OTHER_IND determine whether standard, locally defined, and other statistic categories are incorporated for this installation entry. The remaining documented columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN — are standard Oracle Applications audit columns recording row creation and modification.

Common Use Cases and Queries

Typical usage centers on resolving which statistic types are active for an installation and how downstream statistics are assembled and displayed. A common query joins this table to its parent to retrieve descriptions and attributes for enabled statistics:

• SELECT s.STAT_TYPE, t.DESCRIPTION, s.DISPLAY_ORDER, s.STANDARD_IND, s.DISPLAY_IND FROM IGS_PR_INST_STAT s, IGS_PR_STAT_TYPE t WHERE s.STAT_TYPE = t.STAT_TYPE ORDER BY s.DISPLAY_ORDER;
• Filtering by DISPLAY_IND or STANDARD_IND to produce user-visible statistic lists for reporting and inquiry screens.
• Auditing installation configuration by comparing INCLUDE_STANDARD_IND, INCLUDE_LOCAL_IND, and INCLUDE_OTHER_IND values across environments to reconcile setup differences between test and production.
• Detecting anomalies in the DISPLAY_ORDER sequence, since the unique index IGS_PR_INST_STAT_U2 enforces uniqueness and any duplicate indicates a failed or conflicting setup load.

Related Objects

The relationship model is compact and revolves around two documented foreign keys:

• IGS_PR_STAT_TYPE — the parent table referenced by IGS_PR_INST_STAT.STAT_TYPE; provides the master definition and description of each statistic type.
• IGS_PR_INST_STA_REF — a dependent table whose STAT_TYPE column references IGS_PR_INST_STAT, extending the installation-level statistics configuration into reference detail rows.
• IGS_PR_INST_STAT_PK and IGS_PR_INST_STAT_U2 — the primary key and unique index that enforce row identity and display ordering.
• IGS_PR_INST_STAT.STAT_TYPE → IGS_PR_STAT_TYPE and IGS_PR_INST_STA_REF.STAT_TYPE → IGS_PR_INST_STAT — the two documented FK joins that define the surrounding object graph.

Because the table is configuration-oriented and referenced by dependents, it should be maintained through the Student System setup interface where available, with direct DML limited to controlled data-fix activity to avoid violating the unique constraints on STAT_TYPE and DISPLAY_ORDER.