Search Results clset_id




Overview
Explore in AI Chat

Overview

The IGF_SL_CL_SETUP_ALL table is a core setup entity within the Oracle E-Business Suite Student Loans module (IGF). It serves as the primary repository for configuration and default parameters governing the processing of CommonLine loans, also known as Federal Family Education Loan Program (FFELP) loans. Its role is to define institution-specific rules and preferences for loan origination and disbursement at the operating unit level, typically linked to specific academic award years (calendar types and sequences). This setup data is critical for ensuring that loan transactions comply with both federal regulations and the school's internal business practices when interfacing with external lending and guarantee agencies.

Key Information Stored

The table stores a mix of active configuration parameters and obsolete fields, as indicated in the metadata. The primary key is the unique identifier CLSET_ID. Key active columns include the award year identifiers (CI_CAL_TYPE and CI_SEQUENCE_NUMBER), the borrower's interest payment intention (BORW_INTEREST_IND), and critical fee percentages (EST_ORIG_FEE_PERCT, EST_GUARNT_FEE_PERCT). Operational flags such as the HOLD_REL_IND (for submitting origination records), REQ_SERIAL_LOAN_CODE (for Master Promissory Note usage), and PNOTE_DELIVERY_CODE (for promissory note delivery method) are also stored. Notably, numerous columns related to lender, guarantor, and recipient IDs are marked as obsolete, reflecting changes in the FFELP ecosystem and system evolution.

Common Use Cases and Queries

This table is primarily referenced during loan award packaging and origination file generation. Administrators use it to review or maintain annual loan setup defaults. Common reporting and validation SQL patterns include fetching the active setup for a specific award year and operating unit, or verifying fee configurations.

  • Retrieve Setup for an Award Year:
    SELECT * FROM igf.igf_sl_cl_setup_all WHERE ci_cal_type = '&CAL_TYPE' AND ci_sequence_number = &SEQ_NUM;
  • Validate Critical Fee Parameters:
    SELECT clset_id, est_orig_fee_perct, est_guarnt_fee_perct FROM igf.igf_sl_cl_setup_all WHERE est_orig_fee_perct IS NULL;
  • Identify Setup by Key (CLSET_ID):
    SELECT relationship_cd, party_id, borw_interest_ind FROM igf.igf_sl_cl_setup_all WHERE clset_id = &CLSET_ID;

Related Objects

The table's structure and unique indexes indicate its relationships within the schema. The primary key IGF_SL_CL_SETUP_ALL_PK on CLSET_ID is likely referenced by foreign keys in transactional loan tables. The unique index IGF_SL_CL_SETUP_ALL_U1 on the combination of CI_CAL_TYPE, CI_SEQUENCE_NUMBER, RELATIONSHIP_CD, and PARTY_ID enforces business rule uniqueness for setup records. This table is a foundational setup object, and its data is integral to the processes managed by the IGF Student Loans packages and APIs, particularly for loan origination and disbursement. It sits upstream from transactional data tables that store individual loan awards and disbursements.