Results for “relationship_code”

2 results




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

Overview

The view IGFBF_FFELP_PREFERRED_LENDERS belongs to the IGF — Financial Aid product family, a module that Oracle has classified as Obsolete in Oracle E-Business Suite 12.1.1 and 12.2.2. In the Oracle EBS architecture, product-specific "BF" (base/foundation) views typically provide a stable, security-filtered, and sometimes denormalized projection over one or more underlying base tables. Here, the view serves as the base view for the entity that holds Preferred FFELP Lenders — that is, lenders designated as preferred participants under the Federal Family Education Loan Program (FFELP).

The metadata excerpt specifically notes "Not implemented in this database," indicating that in the documented environment the view was not deployed. This is a common status for objects in obsolete modules, which are retained in the data dictionary documentation for reference and upgrade/backward-compatibility purposes but may no longer be created in a live instance. Consequently, any reporting or integration asset that depends on this view should verify its existence at runtime before use.

Underlying Base Objects

The documented view text defines a single-table projection over the base table IGF_SL_CL_PREF_LENDERS, aliased as PREFLENDERS:

  • IGF_SL_CL_PREF_LENDERS — the sole base object referenced. The "SL" segment of the name is consistent with the Student Loan lineage of the FFELP domain, and "PREF_LENDERS" identifies the preferred-lender master entity.
  • No other joins, views, or synonyms are documented in the view text, and the ETRM metadata lists "Referenced base objects: none documented." The view therefore functions as a direct, thin layer — effectively a SELECT ... FROM ... WITH READ ONLY construct.
  • WITH READ ONLY — the view is declared read-only, so DML against the view is not permitted; inserts, updates, and deletes must be directed to the base table (or to a corresponding AOL/entity view that supports DML).

Because the view is a pass-through with a one-to-one column correspondence, there is no aggregation or join logic that would alter cardinality. Row counts and row identity in the view mirror those of IGF_SL_CL_PREF_LENDERS entirely.

Key Columns

The view exposes the following columns, which map directly to their base-table counterparts:

  • RELATIONSHIP_CODE (base: RELATIONSHIP_CD) — identifies the relationship type the lender holds with the institution; a key discriminator for lender categorization.
  • PREF_LENDER_ID (base: CLPRL_ID) — the unique identifier for the preferred-lender record. This is the column most commonly searched and joined upon; it is the primary key of the underlying entity.
  • PERSON_ID — references the person (party) record representing the lender; links the preferred-lender entity to the person/party model.
  • START_DATE and END_DATE — the effective date window during which the lender's preferred status is valid. These columns support date-effective querying and historical as-of reporting.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — standard Oracle EBS WHO columns providing auditability of record creation and modification.

Note the naming asymmetry between the view and its base table: the view renames RELATIONSHIP_CD to RELATIONSHIP_CODE and CLPRL_ID to PREF_LENDER_ID. Queries written against the view must use the view's column names, not the base table's.

Common Use Cases and Queries

Because the view is a read-only, one-table projection, its practical uses are straightforward: reporting on preferred FFELP lenders, integration extracts, and date-effective lookups. A representative query retrieving all preferred lenders is:

SELECT PREF_LENDER_ID, PERSON_ID, RELATIONSHIP_CODE, START_DATE, END_DATE FROM IGFBF_FFELP_PREFERRED_LENDERS;

A date-effective query isolating currently active preferred lenders would filter on the validity window:

SELECT PREF_LENDER_ID, PERSON_ID FROM IGFBF_FFELP_PREFERRED_LENDERS WHERE START_DATE <= SYSDATE AND (END_DATE IS NULL OR END_DATE >= SYSDATE);

Joining to person or party records by PERSON_ID yields lender names and addresses for operational reports. When the view is absent — as the "Not implemented" note suggests it may be — equivalent queries can be issued directly against IGF_SL_CL_PREF_LENDERS using the original column names (CLPRL_ID, RELATIONSHIP_CD), preserving the same logic.