Results for “system_id_type”

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

Overview

IGF_SL_SCHOOL_CODES_V is a reporting view belonging to the Oracle E-Business Suite Financial Aid module (IGF), a product line that is documented as obsolete in ETRM 12.1.1 and 12.2.2. The view retrieves all active Financial Aid Offices configured in the system, exposing the alternate identifier assigned to each office along with the identifier type that classifies it. Its stated purpose is to provide a consolidated, filtered list of institution codes that downstream Financial Aid processes and student loan interfaces can consume without querying the registration tables directly.

Because IGF is marked obsolete, the view exists primarily for historical and migration reference. Customers who implemented the legacy Financial Aid product, or who are extracting data ahead of decommissioning, may still encounter the view in custom reports, concurrent program definitions, or integration extracts. The view is documented as "not implemented in this database," meaning the ETRM repository does not contain a live instance of it; the definition below is the reference text preserved in the documentation.

Underlying Base Objects

The view text draws from three sources joined together:

• HZ_PARTIES — aliased as HZ. Supplies the party record and the status flag used to restrict results to active parties (HZ.STATUS = 'A'). The join condition links OLI.ORG_STRUCTURE_ID to HZ.PARTY_NUMBER.
• IGS_OR_ORG_ALT_IDS — aliased as OLI. Holds the alternate identifiers assigned to an organization, including the identifier value, its type, and the effective start and end dates.
• IGS_OR_ORG_ALT_IDTYP — aliased as OLT. Provides the identifier type definitions, translating the numeric type code held on the alternate identifier record into the descriptive SYSTEM_ID_TYPE value.

The three tables are joined on organization structure, alternate identifier type, and the date-effective range, so that only currently valid identifier assignments are returned. ETRM lists no further documented base objects beyond these three, and no owner is recorded for the view. The related search term igs_or_org_alt_idtyp corresponds directly to the IGS_OR_ORG_ALT_IDTYP table referenced in the view definition.

Key Columns

• ALTERNATE_IDENTIFIER — sourced from OLI.ORG_ALTERNATE_ID. The actual identifier value assigned to the Financial Aid Office or organization, such as a school code used in student loan reporting.
• SYSTEM_ID_TYPE — sourced from OLT.SYSTEM_ID_TYPE. The classification of the identifier, describing which external or internal system the alternate identifier belongs to and how it should be interpreted.

The view projects only these two columns. All filtering is applied internally through the DISTINCT clause, the date-range predicate (SYSDATE BETWEEN OLI.START_DATE AND NVL(END_DATE, SYSDATE)), the party status check, and the equality join between the identifier type code and its definition.

Common Use Cases and Queries

Typical uses include validating that an institution's Financial Aid Office codes are active before transmitting student loan data, listing all identifiers of a given type for reconciliation with external agencies, and extracting school codes during migration away from the obsolete IGF module.

A basic retrieval of all active office codes:

• SELECT alternate_identifier, system_id_type FROM igf_sl_school_codes_v;

Filtering to a specific identifier type:

• SELECT alternate_identifier FROM igf_sl_school_codes_v WHERE system_id_type = :p_id_type;

Joining the view to configuration tables for reporting:

• SELECT v.alternate_identifier, v.system_id_type FROM igf_sl_school_codes_v v ORDER BY v.system_id_type, v.alternate_identifier;

Because the view resolves the effective date at runtime, results reflect the identifier assignments valid on the query date. Reports that require historical identifiers should query IGS_OR_ORG_ALT_IDS directly rather than relying on this view.