Results for “institution_status”

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

Overview

IGSBV_ORG_EXTENSIONS is a read-only database view owned by the APPS schema within the Oracle E-Business Suite IGS (Student System) product family. The ETRM metadata for release 12.2.2 explicitly classifies this object as Obsolete, meaning it is retained for backward compatibility with earlier 12.1.1 implementations but is not intended for new development, customization, or integration work. The view presents extended organizational attributes for parties that function as institutions within the Student System, joining person and organization records held in the Oracle Trading Community Architecture (TCA) tables to produce a consolidated, report-friendly projection of institution data.

The overseas_indicator column, mapped from the underlying PHP.OI_OS_IND attribute, is the specific element commonly searched for by implementers. When populated, it flags whether an institution is classified as an overseas establishment, supporting regulatory, statutory, and student-recruitment reporting requirements.

Underlying Base Objects

The view text defines a two-table join. Although the ETRM 12.2.2 metadata records no explicitly documented base objects, the definition is evident from the view SQL:

• IGS_PE_HZ_PARTIES (aliased PHP) — the Student System extension of the TCA party record, carrying institution-specific attributes such as INST_ORG_IND, INSTITUTION_CD, OI_OS_IND, OU_ORG_STATUS, and phone and classification detail.
• HZ_PARTIES (aliased HP) — the core TCA party master, supplying the PARTY_NUMBER that is exposed as INST_ORG_CODE.

The join predicate is PHP.PARTY_ID = HP.PARTY_ID, and a filter PHP.INST_ORG_IND IN ('I','O') restricts output to institution and organization records only. The view is defined WITH READ ONLY, preventing DML through the view.

Key Columns

The projection exposes institution-identity, classification, and administrative columns:

• INST_ORG_CODE — party number from HZ_PARTIES, the unique external identifier for the institution.
• INST_ORG_INDICATOR — indicates whether the record is an institution (I) or organization (O).
• INSTITUTION_CODE, ORG_START_DATE, ORG_END_DATE, ORG_STATUS — institution registration and lifecycle detail.
• OVERSEAS_INDICATOR — the overseas flag, sourced from OI_OS_IND.
• LOCAL_INSTITUTION_INDICATOR, INSTITUTION_TYPE, INSTITUTION_STATUS, INST_MARKET_CODE — classification and market segmentation.
• ADV_STUDIES_CLASSES, HONORS_CLASSES, CLASS_SIZE, PERCENT_PLAN_HIGHER_EDU — institution profile statistics.
• _LA: columns — descriptive-flexfield style columns that resolve lookup codes (member type, org type, government code, control type, priority) through IGS_LOOKUP_VALUES.

Common Use Cases and Queries

The view is typically used in institution master-data extracts and reporting. A representative query filtering on the overseas flag:

SELECT inst_org_code, institution_code, overseas_indicator
FROM apps.igsbv_org_extensions
WHERE overseas_indicator = 'Y';

Because the object is obsolete, new development should target the underlying IGS_PE_HZ_PARTIES and HZ_PARTIES tables directly, or a supported successor view, to avoid dependency on a deprecated projection.