Search Results igf_sl_serial_loan_code

Overview

The IGF_SL_CL_SETUP_OVRD_V view is a reporting and integration object within the IGF — Financial Aid product family of Oracle E-Business Suite (12.1.1 and 12.2.2). It belongs to the Federal Family Education Loan Program (FFELP) processing area, which manages Stafford, PLUS, and consolidation lending activities. The view exposes the FFELP Organization Unit Setup Override configuration, meaning it presents the institution-specific overrides that a servicing organization unit applies to the standard loan-level and CommonLine (CL) setup defined in the core setup tables.

Its principal role is to give downstream reports, interfaces, and validations a single denormalized result set that joins organizational identity, academic-year calendar context, recipient/lender data, and the FFELP CommonLine processing parameters. Rather than requiring callers to re-join IGF_SL_CL_SETUP, IGF_SL_CL_RECIPIENT, and calendar tables, the view reproduces those joins and supplies lookup descriptions. This makes it valuable for CommonLine export/import processing, loan setup auditing, and financial aid configuration reports.

Underlying Base Objects

The view text joins five documented underlying objects:

• IGF_SL_CL_SETUP (aliased CLSET) — the core CommonLine setup record holding override values such as fee percentages, serial loan code, promissory note delivery, and hold-release indicators.
• IGF_SL_CL_RECIPIENT (aliased RECEP) — the recipient/lender/guarantor assignment, matched on RELATIONSHIP_CD, supplying lender, guarantor, and recipient identifiers.
• IGS_CA_INST (aliased CA) — the calendar instance table providing start/end dates and alternate codes for the academic year.
• IGF_AP_BATCH_AW_MAP (aliased AWDYR) — the award-year/batch mapping that ties a calendar type and sequence number to the batch process context.
• IGS_OR_INST_ORG_BASE_V (aliased ORGV) — the organization base view supplying party number and party name for the organization unit.

The join keys are the calendar type and sequence number (linking setup, calendar instance, and award-year map) plus PARTY_ID and RELATIONSHIP_CD (linking setup to organization and recipient).

Key Columns

The view exposes identity, calendar, and control columns. Notable entries include:

• ROW_ID, CLSET_ID — surrogate and business keys of the underlying setup row.
• CI_CAL_TYPE, CI_SEQUENCE_NUMBER, START_DT, END_DT, ALTERNATE_CODE — academic-year calendar context.
• PARTY_ID, PARTY_NUMBER, PARTY_NAME, RELATIONSHIP_CD, RELATIONSHIP_CD_DESC — the servicing organization unit and its relationship to the recipient, with decoded description.
• REQ_SERIAL_LOAN_CODE and its description via IGF_AW_GEN.LOOKUP_DESC('IGF_SL_SERIAL_LOAN_CODE', …) — the serial loan code requirement, directly relevant to searches for igf_sl_serial_loan_code.
• PRC_TYPE_CODE, PLUS_PROCESSING_TYPE_CODE — loan processing type codes with descriptions.
• EST_ORIG_FEE_PERCT, EST_GUARNT_FEE_PERCT, EST_ALT_ORIG_FEE_PERCT, EST_ALT_GUARNT_FEE_PERCT — estimated origination and guarantee fee percentages.
• PNOTE_DELIVERY_CODE, BORW_INTEREST_IND, HOLD_REL_IND, EFT_AUTHORIZATION, AUTO_LATE_DISB_IND, FUND_RETURN_METHOD_CODE, CL_VERSION, DEFAULT_FLAG — operational FFELP configuration flags and codes.
• LENDER_ID, GUARANTOR_ID, RECIPIENT_ID, RECIPIENT_TYPE, LEND_NON_ED_BRC_ID, RECIP_NON_ED_BRC_ID — recipient and lender/guarantor identifiers.
• Standard audit columns: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Typical uses include verifying serial loan code configuration by organization unit, auditing academic-year fee overrides, and feeding CommonLine setup extracts. A representative query filtering by serial loan code and organization follows:

• SELECT clset_id, party_name, ci_cal_type, ci_sequence_number, req_serial_loan_code, default_flag FROM igf_sl_cl_setup_ovrd_v WHERE req_serial_loan_code IS NOT NULL AND ci_cal_type = :cal_type AND ci_sequence_number = :seq;
• SELECT party_number, party_name, prc_type_code, est_orig_fee_perct, est_guarnt_fee_perct, cl_version FROM igf_sl_cl_setup_ovrd_v WHERE relationship_cd = :relationship_cd AND start_dt <= SYSDATE AND end_dt >= SYSDATE;
• SELECT clset_id, party_name, pnote_delivery_code, hold_rel_ind, eft_authorization FROM igf_sl_cl_setup_ovrd_v WHERE default_flag = 'Y' ORDER BY party_name;

Because the view resolves lookup descriptions inline, it is well suited for ad hoc reporting and integration staging without additional reference-table joins.