Results for “sec_school_location”

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

Overview

IGSFV_ORG_EXTENSIONS is a read-only database view belonging to the IGS (Student System) product family in Oracle E-Business Suite. Its ETRM classification for both 12.1.1 and 12.2.2 is Obsolete, meaning it is not implemented in current databases and carries no supported functionality in those releases. The view was a denormalized projection that joined institutional organization party records from the Student System with descriptive lookups, exposing institution and organization attributes in a single, flattened result set suitable for reporting and downstream integration.

Its design follows the common EBS pattern of presenting foreign-key codes alongside their decoded meanings. Rather than embedding lookup joins directly in the underlying tables, the view layered in descriptive tables such as IGS_OR_STATUS, IGS_OR_ORG_INST_TYPE, and IGS_OR_INST_STAT, delivering both coded and descriptive values. It filtered to only institutional-type parties through the predicate INST_ORG_IND IN ('I','O'), separating institutions and organizations from other party records.

Underlying Base Objects

The view is defined over the following documented base objects:

• IGS_PE_HZ_PARTIES — the primary extension table holding institution-specific party attributes; aliased PHP.
• HZ_PARTIES — the Trading Community Architecture party master, supplying PARTY_NUMBER; aliased HP.
• IGS_OR_STATUS — status descriptions; joined with an outer (+) operator on ORG_STATUS.
• IGS_OR_ORG_INST_TYPE — institution type descriptions; outer-joined on INSTITUTION_TYPE.
• IGS_OR_INST_STAT — institution status descriptions; outer-joined on INSTITUTION_STATUS.
• IGS_AD_CODE_CLASSES — source of the SEC_SCHOOL_LOCATION code and its description; outer-joined via SEC_SCHOOL_LOCATION_ID = CODE_ID.

The mandatory join between IGS_PE_HZ_PARTIES and HZ_PARTIES on PARTY_ID is what anchors each row to a valid party record. The three IGS_OR_* description joins are all outer joins, so rows survive even when no matching status, type, or institution-status definition exists.

Key Columns

The columns the view exposes include:

• INST_ORG_CODE — the party number of the institution or organization.
• INST_ORG_INDICATOR — flag distinguishing institutions ('I') from organizations ('O').
• INSTITUTION_CODE — the institution's assigned code.
• ORG_START_DATE / ORG_END_DATE — effective dating for the organization record.
• ORG_STATUS, ORG_STATUS_DESC — organization status code and decoded description.
• INSTITUTION_TYPE, INSTITUTION_TYPE_DESC — institution type code and description.
• INSTITUTION_STATUS, INSTITUTION_STATUS_DESC — institution status code and description.
• LOCAL_INSTITUTION_INDICATOR, OVERSEAS_INDICATOR — geographic classification flags.
• SEC_SCHOOL_LOCATION, SEC_SCHOOL_LOCATION_DESC — the secondary school location code and description, sourced from IGS_AD_CODE_CLASSES. This is the column most directly relevant to the search term sec_school_location.
• INST_MARKET_CODE — the institution's market/EPS code.
• ADV_STUDIES_CLASSES, HONORS_CLASSES, CLASS_SIZE, PERCENT_PLAN_HIGHER_EDU — secondary-school classification attributes.
• PARTY_ID, SEC_SCHOOL_LOCATION_ID — underlying identifiers, plus audit columns CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE.

Three columns — ORG_MEMBER_TYPE, ORG_TYPE, INST_GOVT_CD, and related — appear as literal LOOKUP_VALUE strings rather than resolved values, indicating they were intended for application-tier translation.

Common Use Cases and Queries

Historically the view served institution reporting and student-secondary-school integrations, particularly where the SEC_SCHOOL_LOCATION code and its description were needed alongside institution attributes.

• Listing institutions with their secondary school location and description.
• Reporting organization status, type, and institution status with decoded descriptions.
• Filtering institutions versus organizations via INST_ORG_INDICATOR.

A representative query would be:

• SELECT inst_org_code, institution_code, sec_school_location, sec_school_location_desc FROM igsfv_org_extensions WHERE inst_org_indicator = 'I';

Because the object is documented as obsolete and is not implemented in 12.1.1 or 12.2.2, these columns should be sourced from the underlying IGS_PE_HZ_PARTIES and IGS_AD_CODE_CLASSES tables directly in supported environments.