Search Results institution_cd_desc




Overview
Explore in AI Chat

Overview

APPS.IGF_SL_GUARANTOR_V is a supplementary Oracle E-Business Suite view owned by the APPS schema and registered under FND Design Data as IGF.IGF_SL_GUARANTOR_V. It belongs to the Financial Aid / Student Loan functional area within the Oracle iGovernment (IGF) product family and is documented as VALID across EBS 12.1.1 and 12.2.2. The view exists primarily to simplify coding in Oracle Forms-based maintenance screens, presenting guarantor records for student loan processing in a denormalized, form-friendly shape.

The ETRM metadata carries an explicit warning that Oracle does not recommend querying or altering data through this view, because its definition may change dramatically in subsequent minor or major releases. Consumers should treat it as an internal form-support construct rather than as a stable public interface. That said, reporting and integration developers frequently target it because it is the most convenient source of the INSTITUTION_CD_DESC attribute, which is the column most commonly searched for against this object.

Underlying Base Objects

Per the documented dependency information, APPS.IGF_SL_GUARANTOR_V references two objects: the base table APPS.IGF_SL_GUARANTOR and the view IGS_OR_INST_ORG_BASE_V. The guarantor table supplies the core guarantor attributes, while IGS_OR_INST_ORG_BASE_V supplies the institution organization description that is surfaced in the view. The view is not referenced by any other database object, confirming that it sits at the top of its dependency chain and is consumed only by external callers such as forms, reports, or ad hoc queries.

The documented 12.2.2 metadata lists no referenced base objects, so the 12.1.1 ETRM dependency section above should be treated as the authoritative description of the view's lineage. Because the institution description is resolved through a join to IGS_OR_INST_ORG_BASE_V, the INSTITUTION_CD_DESC value depends on the current state of the institution organization setup rather than on data stored in the guarantor record itself.

Key Columns

  • ROW_ID (ROWID) — the physical row identifier of the underlying guarantor record.
  • GUARANTOR_ID (VARCHAR2 30) — the business key identifying the guarantor.
  • DESCRIPTION (VARCHAR2 80) — the guarantor description or name.
  • DUNS_GUARNT_ID — documented as Obsolete; should not be used in new code.
  • PARTY_ID (NUMBER 15) — the TCA party identifier linked to the guarantor.
  • ENABLED (VARCHAR2) — the enabled/disabled indicator for the guarantor record.
  • INSTITUTION_CD (VARCHAR2 30) — the institution code to which the lender is linked.
  • INSTITUTION_CD_DESC (VARCHAR2 360) — the institution code description corresponding to INSTITUTION_CD.
  • Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN capture standard EBS who-column auditing.

Common Use Cases and Queries

The most frequent requirement is resolving INSTITUTION_CD to its descriptive text, since the description is the value users actually recognize on reports. A typical query filters on the guarantor and joins the audit or party information as needed:

  • Retrieve all enabled guarantors with their institution descriptions: SELECT guarantor_id, description, institution_cd, institution_cd_desc FROM apps.igf_sl_guarantor_v WHERE enabled = 'Y';
  • Look up a single guarantor: SELECT * FROM apps.igf_sl_guarantor_v WHERE guarantor_id = :p_guarantor_id;
  • List guarantors for a specific institution: SELECT guarantor_id, description FROM apps.igf_sl_guarantor_v WHERE institution_cd = :p_institution_cd;
  • Feed reporting extracts that need the resolved institution description alongside party_id: SELECT party_id, guarantor_id, institution_cd_desc FROM apps.igf_sl_guarantor_v;

Because the view is documented as a form-support construct that may change between releases, integration code should encapsulate these queries and avoid depending on obsolete columns such as DUNS_GUARNT_ID. Where long-term stability is required, refer to the underlying APPS.IGF_SL_GUARANTOR table and join to the institution organization source directly.