Search Results igf_sl_dl_setup_all




Overview
Explore in AI Chat

Overview

The IGF.IGF_SL_DL_SETUP_ALL table is a Financial Aid (IGF) configuration entity within Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the setup and default information that governs Direct Loan processing, including fee percentages, promissory note printing behavior, disclosure and disbursement rules, and interview/affirmation requirements. Rather than capturing transactional loan activity, the table defines the institutional parameters that drive how Direct Loan records are created and processed downstream within the Financial Aid module.

From a data-modeling perspective, the ETRM's heuristic Data Vault classification places this object as satellite-leaning, meaning it is best understood as a descriptive attribute container attached to a business key rather than a hub or a link. The table's modest foreign-key footprint and its calendar-instance reference reinforce this characterization.

Key Information Stored

The table contains 23 documented columns in ETRM 12.1.1. The most significant are:

Common Use Cases and Queries

Typical usage centers on resolving the correct setup row for a given academic calendar instance before loan origination or disbursement. A common query pattern joins the setup to the calendar instance and filters by type and sequence:

  • Retrieve active setup for a period: SELECT * FROM igf.igf_sl_dl_setup_all WHERE ci_cal_type = :p_cal_type AND ci_sequence_number = :p_seq;
  • Reporting on fee configuration across institutions: aggregate ORIG_FEE_PERCT_STAFFORD and ORIG_FEE_PERCT_PLUS by SCHOOL_ID and ORG_ID.
  • Auditing print controls (PNOTE_PRINT_IND, DISCLOSURE_PRINT_IND) to verify promissory note and disclosure generation rules.
  • Validating interview and affirmation requirements (INTERVIEW_REQD, AFFIRMATION_REQD) prior to awarding or disbursing Direct Loans.

Related Objects

The documented foreign key links this table to the academic calendar instance, defining the primary dependency chain. Significant related objects include:

  • IGS_CA_INST_ALL — referenced via CI_CAL_TYPE and CI_SEQUENCE_NUMBER; provides the academic period context.
  • IGF_SL_DL_SETUP_ALL_PK / _U1 — primary key and unique index on DLSET_ID.
  • IGF_SL_DL_SETUP_ALL_U2 / _UK — unique index on CI_CAL_TYPE and CI_SEQUENCE_NUMBER, enforcing one setup per calendar instance.
  • Direct Loan packaging, disbursement, and promissory note entities within the IGF module that consume these defaults.
  • Operating unit (ORG_ID) and standard audit/customization relationships maintained across IGF tables.