Search Results sch_non_ed_brc_id




Overview
Explore in AI Chat

Overview

APPS.IGF_SL_CL_SETUP is a multi-org view in the Oracle E-Business Suite Financial Aid (IGF) module, documented as FND Design Data IGF.IGF_SL_CL_SETUP and marked VALID in the APPS schema. It presents CommonLine loan setup configuration data used by the Federal Family Education Loan Program (FFELP) processing features within Oracle Student Financial Aid. Because it is registered as a multi-org view, it automatically restricts results to the operating unit associated with the current session, ignoring records belonging to other operating units. This behavior is governed by the ORG_ID column exposed by the view.

The view serves as the configuration layer that drives loan processing defaults, including borrower interest handling, fee percentages, PLUS and Stafford processing type codes, and lender fund return methods. For reporting and integration, it is the primary read-only interface through which setup values are surfaced to concurrent programs, OBIEE extracts, and custom SQL used by financial aid administrators. The column PLUS_PROCESSING_TYPE_CODE, which the user searched for, is the FFELP processing type code applied to FFELP PLUS and alternative loans and represents one of the most frequently referenced attributes of this view.

Underlying Base Objects

The ETRM documentation for this object records no referenced base objects. Oracle EBS documentation classifies IGF_SL_CL_SETUP as a view whose FND Design Data is IGF.IGF_SL_CL_SETUP, meaning the underlying table carries the same logical name within the IGF application. In practice, the view resolves to the IGF base table housing CommonLine setup records and is filtered by the multi-org security mechanism. Dependent views and PL/SQL packages within IGF reference it to read relationship and processing defaults. The presence of audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) confirms that the view exposes the standard WHO columns of its base entity, allowing change tracking in reports.

Key Columns

Several columns are documented as obsolete, including LENDER_ID, DUNS_LENDER_ID, GUARANTOR_ID, RECIPIENT_ID, MEDIA_TYPE, and LOAN_AWARD_METHOD. These should not be used in new development.

Common Use Cases and Queries

Typical scenarios include validating the PLUS processing type code configured for the current operating unit, extracting fee percentages for reconciliation, and confirming default lender relationships for disbursement processing.

Query for PLUS processing setup by organization:

SELECT clset_id,
       plus_processing_type_code,
       prc_type_code,
       cl_version,
       org_id
FROM   apps.igf_sl_cl_setup
WHERE  plus_processing_type_code IS NOT NULL;

Query default lender relationship and fund return method:

SELECT party_id,
       relationship_cd,
       fund_return_method_code,
       default_flag
FROM   apps.igf_sl_cl_setup
WHERE  default_flag = 'Y';

Because multi-org filtering is applied automatically, callers need not bind ORG_ID explicitly; the view returns only rows belonging to the active operating unit, which simplifies both ad hoc reporting and embedded integration queries.