Search Results igf_ap_school_opeid

Overview

IGF_AP_SCHOOL_OPEID_V is a reporting view in the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 Financial Aid / Student Information domain, owned by the APPS schema. It exposes the OPEID (Office of Postsecondary Education Identification) number associated with a school or organization unit, together with the alternate identifier type and the decoded lookup meaning. The view is designed to satisfy a specific, recurring lookup: retrieving the OPE_ID_NUM value for an institution so it can be reported to federal agencies, printed on aid documents, or exchanged with external systems.

Because the underlying OPEID is not stored in a single dedicated column, the view consolidates the alternate identifier, its type classification, and the lookup-driven display value into one normalized row per organization. This makes it a convenient single source for reporting, integrations, and descriptive flexfield lookups that require the institution's federal school code rather than the internal organization identifier.

Underlying Base Objects

The view is defined over the following objects, as documented in the view text:

• HZ_PARTIES (aliased HZ) — the party master record for the organization; supplies the party identifier and filters on STATUS = 'A' so only active parties are returned.
• IGS_PE_HZ_PARTIES (aliased IGSHZ) — the intersection between the Oracle Student System organization unit and the HZ party; joined via PARTY_ID and used to link the organization structure to the party.
• IGS_OR_ORG_ALT_IDS (aliased OLI) — the organization alternate identifiers table, which holds the actual ORG_ALTERNATE_ID value (the OPEID) and its effective dating range.
• IGS_OR_ORG_ALT_IDTYP (aliased OLT) — the alternate identifier type definition; the view restricts to SYSTEM_ID_TYPE = 'OPE_ID_NUM'.
• IGF_LOOKUPS_VIEW (aliased LKUP) — the lookup value source for lookup type IGF_AP_SCHOOL_OPEID, providing the decoded MEANING where the lookup code matches the alternate identifier and the lookup is enabled.

Joins are driven on organization structure, party, identifier type, and lookup code, with an effective-date predicate (SYSDATE BETWEEN START_DATE AND NVL(END_DATE, SYSDATE)) ensuring only currently valid identifiers are returned.

Key Columns

• ALTERNATE_IDENTIFIER — the OPEID value stored as OLI.ORG_ALTERNATE_ID. This is the column users typically seek when searching on "ope_id_num".
• SYSTEM_ID_TYPE — the alternate identifier classification; for this view it is always 'OPE_ID_NUM'.
• MEANING — the decoded description from the IGF_AP_SCHOOL_OPEID lookup, providing a human-readable label for the identifier.

The view groups on all three columns, so each distinct combination of identifier, type, and meaning appears once. Note that no party or organization identifier is projected, so the view does not directly expose which organization a row belongs to; callers relying on organization-level attribution must join back to the underlying objects.

Common Use Cases and Queries

Typical scenarios include extracting the OPEID for federal reporting, validating that an institution's OPEID is defined and active, and populating external aid interfaces. A sample query follows:

• SELECT alternate_identifier, system_id_type, meaning FROM apps.igf_ap_school_opeid_v;
• SELECT alternate_identifier FROM apps.igf_ap_school_opeid_v WHERE system_id_type = 'OPE_ID_NUM' AND meaning IS NOT NULL;

Because the view returns no organization key, a join to IGS_OR_ORG_ALT_IDS and IGS_PE_HZ_PARTIES is normally required to attribute an OPEID to a specific school or organization unit. The effective-dating filter means historical OPEIDs are excluded, which is appropriate for current-state reporting but not for point-in-time audits.