Results for “institution_code”

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

Overview

The APPS.IGSFV_INST_STATISTICS view is a reporting and integration object within the Oracle E-Business Suite (EBS) Student System product (IGS). Its documented purpose is to describe Institution Statistic Types associated with an institution. In practical terms, the view flattens the relationship between an institution (identified by party and organization unit) and the statistic types recorded against that institution, exposing a single denormalized row per institution statistic record.

The view is defined with WITH READ ONLY, confirming that it is intended strictly for query, reporting, and integration consumption rather than for data maintenance. It also carries a translatable/descriptive token column ("_LA:STATISTICS_TYPE") that follows the Oracle "lookup meaning" pattern, referencing IGS_LOOKUP_VALUES with lookup type OR_INST_STAT_TYPE. This design allows the statistic type to be presented as its human-readable MEANING at runtime, supporting localized and user-friendly output in OBIEE, Discoverer, XML Publisher, or custom SQL reports. The view is valid in both EBS 12.1.1 and 12.2.2, and the documented metadata (ETRM 12.2.2) lists no separately documented referenced base objects beyond those visible in the view text.

Underlying Base Objects

Based on the view definition, IGSFV_INST_STATISTICS is constructed over three base objects:

• IGS_OR_INST_STATS — the primary institution statistics table aliased STAT, holding PARTY_ID, INST_STAT_ID, audit columns, and the statistic type code (STAT_TYPE_CD).
• IGS_PE_HZ_PARTIES — the Student System extension table aliased IHP, supplying OSS_ORG_UNIT_CD (exposed as INSTITUTION_CODE) and joining to STAT and HZ_PARTIES on PARTY_ID.
• HZ_PARTIES — the Trading Community Architecture (TCA) party table aliased HP, supplying PARTY_NAME (exposed as INSTITUTION_NAME).

The join links the institution statistic rows to their institution identity through PARTY_ID. The PARTY_NAME column from HZ_PARTIES is the field most commonly surfaced when users search for "institution_name," which explains why that term drives discovery of this view. The documented metadata does not name these base objects explicitly, but the view text unambiguously identifies them.

Key Columns

• "_LA:STATISTICS_TYPE" — the descriptive/lookup meaning for the statistic type code, resolved against IGS_LOOKUP_VALUES (lookup type OR_INST_STAT_TYPE).
• PARTY_ID — the TCA party identifier linking the statistic to the institution party.
• INSTITUTION_CODE — the OSS organization unit code from IGS_PE_HZ_PARTIES, i.e., the short institution identifier.
• INSTITUTION_NAME — the institution's full name (HZ_PARTIES.PARTY_NAME), the primary descriptive identifier returned in most queries.
• INST_STAT_ID — the unique identifier of the institution statistic row.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — standard WHO audit columns for record lineage and change tracking.

Common Use Cases and Queries

Typical uses include institution statistics reporting, data extraction for institutional research, and validating that required statistic types exist for each institution. A common query resolves statistics by institution name:

SELECT institution_code,
       institution_name,
       "_LA:STATISTICS_TYPE" AS statistics_type,
       inst_stat_id
FROM   apps.igsfv_inst_statistics
WHERE  institution_name = :p_institution_name;

To list all statistics captured for a given party:

SELECT institution_name, "_LA:STATISTICS_TYPE" AS statistic
FROM   apps.igsfv_inst_statistics
WHERE  party_id = :p_party_id
ORDER BY institution_name;

Because the view is read only, all access should be through SELECT statements; inserts or updates must target the underlying base tables, never this view.