Search Results relationship_cd_desc




Overview
Explore in AI Chat

Overview

APPS.IGF_SL_CL_PREF_LENDERS_V is a supplementary database view owned by the APPS schema within the Oracle E-Business Suite environment, specifically belonging to the Financial Aid / Student Loan (IGF) module, whose objects are managed under the FND Design Data application short name IGF. The view carries a status of VALID and is classified by Oracle as a supplementary view used to simplify forms coding. Its primary design intent is to flatten and denormalize data drawn from the underlying preferred lender and recipient base tables so that Oracle Forms-based user interfaces and dependent program units can retrieve presentation-ready rows without embedding complex joins. The view exposes the relationship code description, RELATIONSHIP_CD_DESC, which is the attribute users most frequently search for when identifying preferred lenders associated with a recipient relationship. Oracle explicitly cautions that this view is not intended as a stable public interface: the documentation warns that Oracle does not recommend querying or altering data through it, because its definition may change dramatically in subsequent minor or major releases. Consequently, custom reporting and integration solutions should treat the view as read-only and version-sensitive, and should validate its behavior during any upgrade or patch cycle.

Underlying Base Objects

According to the documented dependency information, APPS.IGF_SL_CL_PREF_LENDERS_V references two base objects: APPS.IGF_SL_CL_PREF_LENDERS and APPS.IGF_SL_CL_RECIPIENT. The view is therefore derived from a preferred lender entity joined to a recipient entity, producing a combined result set that carries both lender preference identifiers and recipient person information. The view carries standard Oracle concurrency control, audit, and multi-org style columns, including OBJECT_VERSION_NUMBER for optimistic locking and the standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) plus concurrent program columns (PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, REQUEST_ID). The view is in turn referenced by APPS.IGF_AP_TD_ITEM_INST_V, indicating that it participates in a higher-level downstream view used within the aid processing or loan item instance logic. This dependency chain means any change to the underlying tables can propagate through the view into dependent objects, reinforcing the caution against treating it as a permanent interface.

Key Columns

  • ROW_ID (ROWID): The physical row identifier for the row returned by the view.
  • CLPRL_ID (NUMBER): Sequence-generated identifier for the preferred lender record.
  • PERSON_ID (NUMBER): Person identifier associated with the recipient relationship.
  • RELATIONSHIP_CD (VARCHAR2, 30): Coded value describing the relationship type.
  • RELATIONSHIP_CD_DESC (VARCHAR2, 80): Descriptive text for the relationship code, the primary search target.
  • START_DATE / END_DATE (DATE): Award year start and end dates defining the effective window.
  • OBJECT_VERSION_NUMBER (NUMBER): Optimistic locking for concurrent updates.
  • Standard WHO and concurrent program columns: Audit and concurrent request tracking.

Common Use Cases and Queries

The view is typically queried to resolve relationship descriptions for preferred lender records without joining the base tables manually. A representative query follows:

SELECT clprl_id, person_id, relationship_cd, relationship_cd_desc, start_date, end_date FROM apps.igf_sl_cl_pref_lenders_v WHERE person_id = :p_person_id AND TRUNC(SYSDATE) BETWEEN start_date AND end_date ORDER BY start_date DESC;

Analysts commonly filter on relationship_cd_desc to build lists of recipients by relationship type for verification or reporting. Because the view is marked supplementary and unstable, production integrations should confirm the underlying base tables or a supported public API rather than relying on this view long term.