Search Results igf_sl_cl_setup_all_uk

Overview

The IGF_SL_CL_SETUP_ALL table is a core setup repository within the Oracle E-Business Suite's Financial Aid module (IGF). It is specifically designed to store default configuration and control information for CommonLine processing, which pertains to the Federal Family Education Loan Program (FFELP). This table functions as a master control point, defining the relationship between an institution, its academic calendar, and specific loan recipients or entities (such as lenders or guarantors). Its role is critical for ensuring that FFELP loan data is correctly associated with the appropriate institutional context and partner organizations during origination, disbursement, and reporting processes.

Key Information Stored

The table's structure is centered around establishing unique setup records for specific academic periods and external parties. The primary surrogate key is CLSET_ID. The business logic, however, is enforced through unique constraints on combinations of other critical columns. These include CI_CAL_TYPE and CI_SEQUENCE_NUMBER, which link to an academic calendar instance (IGS_CA_INST_ALL), and RELATIONSHIP_CD and PARTY_ID, which link to a defined relationship code and the specific external party (e.g., a lender or guarantor) in HZ_PARTIES. This combination ensures that setup defaults are uniquely maintained per institution, academic term, and loan partner.

Common Use Cases and Queries

A primary use case is retrieving the valid setup parameters for FFELP loan processing for a given academic period and lender. This is often required by batch processes or interfaces that generate CommonLine files. A typical query would join to the calendar and party tables to retrieve descriptive information.

• Sample Query: Retrieving setup details for a specific calendar and relationship.
  SELECT cl.*, inst.CAL_TYPE, inst.START_DT, inst.END_DT, party.PARTY_NAME FROM igf_sl_cl_setup_all cl, igs_ca_inst_all inst, hz_parties party WHERE cl.ci_cal_type = inst.cal_type AND cl.ci_sequence_number = inst.sequence_number AND cl.party_id = party.party_id AND cl.relationship_cd = 'LENDER' AND cl.ci_cal_type = 'ACADEMIC' AND cl.ci_sequence_number = 202401;
• Reporting Use Case: Auditing all configured FFELP relationships and their associated academic calendars for an institution.

Related Objects

IGF_SL_CL_SETUP_ALL is integral to the FFELP data model and has defined relationships with several key EBS objects.

• Primary Keys: IGF_SL_CL_SETUP_ALL_PK (CLSET_ID), IGF_SL_CL_SETUP_ALL_U1 (composite key), IGF_SL_CL_SETUP_ALL_UK (composite key).
• Foreign Key Dependencies: It references IGS_CA_INST_ALL (academic calendar), IGF_SL_CL_RECIPIENT (relationship type master), and HZ_PARTIES (TCA party master).
• Functional Context: This setup table is foundational for transactional FFELP loan tables and interfaces that rely on its predefined defaults for correct loan processing and partner communication.