Search Results igf_sl_pnote_delivery

Overview

APPS.IGF_SL_CL_SETUP_V is a reporting and integration view in the Oracle E-Business Suite Student Systems (Financial Aid) module, more specifically within the Oracle Loans / Student Loan (IGF) schema. It presents configuration (setup) data for student loan "collection" or "cl" setup definitions, joining calendar instance information and recipient detail into a single consumable projection. The view is primarily used by the ETRM (Electronic Technical Reference Manual) and dependent Oracle forms, reports, and OAF pages that need to render the loan setup information with decoded lookup meanings rather than raw codes.

Because it exposes descriptive columns translated through IGF_AW_GEN.LOOKUP_DESC, the view is well suited for read-only reporting, LOV (List of Values) population, and integration extracts where the consumer needs human-readable values for otherwise numeric or coded setup attributes.

Underlying Base Objects

The view is defined over three base objects through an inner join, meaning only setup rows that match both a calendar instance and a recipient are returned:

• IGF_SL_CL_SETUP (aliased CLSET) — the primary setup table holding the loan collection setup definition, flags, percentages, and processing codes.
• IGS_CA_INST (aliased CI) — the calendar instance table, joined on CI_CAL_TYPE = CAL_TYPE and CI_SEQUENCE_NUMBER = SEQUENCE_NUMBER, supplying start/end dates and the alternate code for the calendar instance.
• IGF_SL_CL_RECIPIENT (aliased RCPTV) — the recipient table, joined on RELATIONSHIP_CD, supplying lender, guarantor, recipient, and non-ED branch identifiers plus relationship description.

No additional base objects are documented in the ETRM metadata for this view.

Key Columns

• ROW_ID, CLSET_ID — surrogate and business identifiers for the setup record.
• CI_CAL_TYPE, CI_SEQUENCE_NUMBER, START_DT, END_DT, ALTERNATE_CODE — calendar instance context for the setup.
• BORW_INTEREST_IND — borrower interest indicator.
• LENDER_ID, LEND_NON_ED_BRC_ID, GUARANTOR_ID, RECIPIENT_ID, RECIPIENT_TYPE, RECIP_NON_ED_BRC_ID — recipient and party identifiers from the recipient table.
• EST_ORIG_FEE_PERCT, EST_GUARNT_FEE_PERCT, EST_ALT_ORIG_FEE_PERCT, EST_ALT_GUARNT_FEE_PERCT — estimated origination and guaranty fee percentages.
• HOLD_REL_IND — hold-release indicator. Its decoded value is exposed via LOOKUP_DESC('IGF_SL_CL_DB_HOLD_REL_IND', CLSET.HOLD_REL_IND), which corresponds directly to the user search term "igf_sl_cl_db_hold_rel_ind".
• REQ_SERIAL_LOAN_CODE, PRC_TYPE_CODE, PNOTE_DELIVERY_CODE, CL_VERSION, PLUS_PROCESSING_TYPE_CODE, FUND_RETURN_METHOD_CODE — coded attributes each accompanied by a decoded LOOKUP_DESC column using the respective lookup type (for example IGF_SL_PRC_TYPE_CODE, IGF_SL_PNOTE_DELIVERY, IGF_SL_CL_VERSION, IGF_SL_CL_DB_FUND_DISB_METH).
• EFT_AUTHORIZATION, AUTO_LATE_DISB_IND, DEFAULT_FLAG, RELATIONSHIP_CD, RELATIONSHIP_CD_DESC — authorization, late disbursement, default, and relationship attributes.
• Audit columns: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.

Common Use Cases and Queries

The view is most commonly queried to validate setup and to display decoded hold-release values during loan processing or reconciliation. A typical query retrieving the hold-release meaning for a given setup would be:

SELECT clset_id,
       ci_cal_type,
       ci_sequence_number,
       hold_rel_ind
FROM   apps.igf_sl_cl_setup_v
WHERE  hold_rel_ind = 'Y';

To list all setups with their decoded attributes and recipient context:

SELECT clset_id,
       relationship_cd,
       relationship_cd_desc,
       lookup_desc
FROM   apps.igf_sl_cl_setup_v
WHERE  ci_cal_type = '&cal_type'
AND    ci_sequence_number = &sequence_number;

Because the view performs inner joins across setup, calendar instance, and recipient, queries should account for the fact that unmatched setup rows (for example, missing recipient or calendar instance) are excluded. Reports and integrations relying on this view should therefore treat it as a curated, joined projection rather than a complete extract of IGF_SL_CL_SETUP.