Results for “stat_type_desc”

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

Overview

The IGS_OR_INST_STATS_V view resides in the APPS schema and belongs to the IGS (Student System) product family within Oracle E-Business Suite, as documented in the ETRM reference for releases 12.1.1 and 12.2.2. Its stated purpose is to describe institution statistic details, presenting a denormalized, read-friendly projection of institutional statistics captured against parties in the Student System. The view is classified as VALID, indicating it is a supported dictionary object available for reporting, extraction, and integration.

The view performs a lookup translation step that is not present in the underlying base table: the coded statistic type is resolved into a user-facing description. This makes the view especially useful for reports, concurrent program outputs, and OBIEE or BI Publisher extracts where a human-readable label is required without an additional join at the query layer. The object is read-only; all DML must be directed to the base table IGS_OR_INST_STATS and the lookup table IGS_LOOKUP_VALUES.

Underlying Base Objects

The documented view text defines a two-table join:

• IGS_OR_INST_STATS IS1 — the primary base table storing institution statistic rows keyed by INST_STAT_ID.
• IGS_LOOKUP_VALUES STYPE — the Oracle lookup table used to resolve the statistic type code to its display meaning.

The join condition is IS1.STAT_TYPE_CD = STYPE.LOOKUP_CODE AND STYPE.LOOKUP_TYPE = 'OR_INST_STAT_TYPE'. Because the lookup type is constrained to the OR_INST_STAT_TYPE set, only statistic codes belonging to that lookup category are returned. The view also projects the base table's ROWID, a convention that allows downstream tools to identify the exact physical row for diagnostic or update purposes. Note that although the view metadata lists no separately documented referenced base objects, the inline SQL text confirms the two objects above. Queries should therefore assume the standard EBS lookup semantics, including the possibility of values missing from IGS_LOOKUP_VALUES for inactive or unmaintained codes.

Key Columns

• ROW_ID — ROWID of the underlying IGS_OR_INST_STATS record.
• INST_STAT_ID — primary key identifier of the institution statistic row.
• PARTY_ID — the party to which the statistic applies; joins to the trading community or person party model.
• STATISTICS_TYPE — the raw statistic type code, sourced from IS1.STAT_TYPE_CD.
• STAT_TYPE_DESC — the resolved lookup meaning for the statistic type code. This is the column most frequently searched and reported, since it carries the descriptive label associated with OR_INST_STAT_TYPE.
• LAST_UPDATED_BY, LAST_UPDATE_DATE, CREATED_BY, CREATION_DATE, LAST_UPDATE_LOGIN — standard EBS audit columns.

Common Use Cases and Queries

The view is typically used to list statistics by party, filter on a specific statistic type, or extract all records with descriptive labels for reconciliation. A representative query is:

SELECT party_id, statistics_type, stat_type_desc
FROM apps.igs_or_inst_stats_v
WHERE stat_type_desc LIKE 'A%'
ORDER BY party_id, stat_type_desc;

Because STAT_TYPE_DESC is translated from the lookup table, filtering on the descriptive column is convenient for ad hoc analysis but should not replace filtering on STATISTICS_TYPE in high-volume or interface code, where the coded value is more stable across language and lookup maintenance. When the view must be joined to other Student System entities, PARTY_ID is the usual linkage point. Reports requiring the audit trail should select the *_BY and *_DATE columns to support change tracking.