Results for “institution_cd”

50+ results




Overview
Explore in AI Chat

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

Overview

The IGF_SL_GUARANTOR_V view belongs to the IGF (Financial Aid) product family in Oracle E-Business Suite. In the 12.1.1 and 12.2.2 releases, this view is documented as part of an obsolete module and is flagged within the ETRM reference data as "Not implemented in this database." As a result, the view should be treated as a legacy or historical definition rather than an actively maintained database object.

The view presents guarantor information associated with financial aid processing. A guarantor, in the student loan and financial aid context, is an entity that guarantees student loans, typically a state agency for higher education. The view consolidates guarantor attributes from the base guarantor table with organizational information from an institution organization view, exposing both native columns and derived attributes for reporting and integration consumption.

The view also exposes the DUNS_GUARNT_ID column, which is the attribute most directly associated with the search term "duns_guarnt_id." In the documented view definition, this column is populated as a literal NULL, indicating a placeholder rather than a data-bearing field.

Underlying Base Objects

The documented view definition references two objects:

  • IGF_SL_GUARANTOR GUARN — the primary base table holding guarantor records. The view aliases this table as GUARN and sources the majority of its columns from it, including GUARANTOR_ID, DESCRIPTION, PARTY_ID, ENABLED, and the standard audit columns.
  • IGS_OR_INST_ORG_BASE_V ORG — an institution organization base view, aliased as ORG. The view joins to this object on PARTY_ID using an outer join (GUARN.PARTY_ID = ORG.PARTY_ID(+)).

The outer join ensures that every guarantor row is retained even when no matching organization record exists. From IGS_OR_INST_ORG_BASE_V, the view selects PARTY_NUMBER and PARTY_NAME, which supply the human-readable organization identifiers associated with the guarantor's party record. The ETRM metadata lists no further referenced base objects, and no dependency metadata is documented beyond these two entries.

Key Columns

  • ROW_ID — the ROWID of the base IGF_SL_GUARANTOR row, useful for identifying the physical row in the base table.
  • GUARANTOR_ID — the primary identifier for the guarantor record.
  • DESCRIPTION — the descriptive text associated with the guarantor.
  • DUNS_GUARNT_ID — exposed as NULL in the documented view text. The D-U-N-S number (Data Universal Numbering System) is a nine-digit business identifier; the column name suggests an intended correlation with the guarantor's DUNS identifier, but the view does not currently supply a value.
  • PARTY_ID — the party identifier linking the guarantor to the trading community model.
  • ENABLED — indicates whether the guarantor record is active.
  • Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN.
  • PARTY_NUMBER and PARTY_NAME — sourced from the joined organization view, providing the party's system number and display name.

The metadata also lists INSTITUTION_CD and INSTITUTION_CD_DESC among the view columns, though these attributes do not appear in the documented SELECT text excerpt.

Common Use Cases and Queries

Because the view is documented as obsolete and not implemented, it is unlikely to appear in active production queries for 12.1.1 or 12.2.2. Historical reports, migration scripts, or interface code referencing guarantor data may still name this view or the DUNS_GUARNT_ID column, particularly where institutions attempted to correlate financial aid guarantors with DUNS-registered business entities.

A representative query selecting guarantor and organization attributes would take the following form:

  • SELECT ROW_ID, GUARANTOR_ID, DESCRIPTION, DUNS_GUARNT_ID, PARTY_ID, ENABLED, PARTY_NUMBER, PARTY_NAME FROM IGF_SL_GUARANTOR_V;

Filtering may be applied on ENABLED to restrict results to active guarantors, or on GUARANTOR_ID for a specific entity. Where the DUNS_GUARNT_ID column is required for downstream processing, queries should anticipate that it returns NULL and should source the D-U-N-S value from alternate party or organization attributes instead.