Search Results org_unit_cd_desc




Overview
Explore in AI Chat

Overview

IGF_SL_LENDER_BRC_V is a supplementary database view owned by the APPS schema in Oracle E-Business Suite, residing within the Oracle Financials for the Higher Education industry solution (the IGF product family). Its name indicates its function: it exposes lender branch records associated with the Student Loan (SL) subsystem — "LENDER_BRC" denoting lender branch. The view is classified by Oracle as a supplementary view used primarily to simplify Oracle Forms coding, meaning it is intended to be consumed by the E-Business Suite forms layer rather than by external reporting or integration processes.

The user's search term "org_unit_cd_desc" maps directly to a column in this view. The view exposes ORG_UNIT_CD_DESC, a descriptive field carrying the organization unit description for the institution code linked to a given lender branch. This denormalized description allows forms to display a human-readable organizational unit name without performing a separate lookup against the underlying institutional organization structure.

Oracle's documentation carries an explicit warning: Oracle does not recommend querying or altering data using this view, because its definition may change dramatically in subsequent minor or major releases. Any dependency on this view should be treated as subject to change across 12.1.1 and 12.2.2 releases.

Underlying Base Objects

The view is defined over two documented sources. The first is the base table APPS.IGF_SL_LENDER_BRC, which holds the persistent lender branch records — lender identifiers, branch identifiers, descriptions, party references, and enablement flags. The second is APPS.IGS_OR_INST_ORG_BASE_V, itself a view belonging to the Oracle Student System (the IGS academic structure family), which supplies the organizational unit information joined into the lender branch rows.

The relationship is a join between the lender branch record and the institutional organization base view. This join is what enriches each branch row with ORG_UNIT_CD and its descriptive counterpart ORG_UNIT_CD_DESC. Notably, the view is not referenced by any database object, confirming that it is a leaf-level, form-facing object with no downstream dependents.

Key Columns

  • ROW_ID (ROWID) — the physical row identifier, typically used by Oracle Forms for locking and navigation.
  • LENDER_ID (VARCHAR2(30)) — identifies the lender to which the branch belongs.
  • LEND_NON_ED_BRC_ID (VARCHAR2(30)) — the lender branch identifier, including non-educational branch references.
  • DESCRIPTION (VARCHAR2(80)) — the descriptive name of the lender branch.
  • PARTY_ID (NUMBER(15)) — the Trading Community Architecture party identifier associated with the lender.
  • ENABLED (VARCHAR2) — flag indicating whether the branch record is active.
  • ORG_UNIT_CD (VARCHAR2(30)) — the organization unit code to which the lender branch is linked.
  • ORG_UNIT_CD_DESC (VARCHAR2(360)) — the organizational unit description for the institution code; this is the column targeted by the user's search.
  • Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN provide standard EBS WHO-column auditing.

Common Use Cases and Queries

The primary consumer is the Oracle Forms interface for lender branch maintenance, where ORG_UNIT_CD_DESC is displayed alongside the code to present institution naming without an additional round trip. Developers investigating the description of an institution organization unit may query the view as follows:

SELECT LENDER_ID, LEND_NON_ED_BRC_ID, DESCRIPTION, ORG_UNIT_CD, ORG_UNIT_CD_DESC
FROM APPS.IGF_SL_LENDER_BRC_V
WHERE ENABLED = 'Y'
ORDER BY LENDER_ID, ORG_UNIT_CD;

A focused lookup by organization unit can be issued as:

SELECT LEND_NON_ED_BRC_ID, DESCRIPTION, ORG_UNIT_CD_DESC
FROM APPS.IGF_SL_LENDER_BRC_V
WHERE ORG_UNIT_CD = :org_unit_code;

Because the view is documented as supplementary and unsupported for direct querying, production integrations should prefer the base table IGF_SL_LENDER_BRC joined explicitly to the institutional organization structures, reserving direct use of the view for diagnostic or development purposes where the convenience of the denormalized ORG_UNIT_CD_DESC is acceptable.