Search Results igf_sl_dl_setup_all_pk

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:

• DLSET_ID — the surrogate primary key, enforced by IGF_SL_DL_SETUP_ALL_PK and mirrored in unique index IGF_SL_DL_SETUP_ALL_U1.
• CI_CAL_TYPE and CI_SEQUENCE_NUMBER — the business-key pair forming unique index IGF_SL_DL_SETUP_ALL_U2; together they identify the calendar instance (academic period) to which the setup applies.
• SCHOOL_ID — identifies the school or institution associated with the setup record.
• ORIG_FEE_PERCT_STAFFORD and ORIG_FEE_PERCT_PLUS — origination fee percentages applied to Stafford and PLUS loans respectively.
• INT_REBATE — the interest rebate parameter.
• PNOTE_PRINT_IND and PNOTE_PRINT_COPIES — control promissory note printing and copy counts.
• ACC_NOTE_FOR_DISB — governs acceptance-note handling at disbursement.
• AFFIRMATION_REQD and INTERVIEW_REQD — flags for mandatory affirmation and entrance/exit interview requirements.
• DISCLOSURE_PRINT_IND — controls disclosure statement printing.
• SPECIAL_SCHOOL and DL_VERSION — school category and Direct Loan version reference.
• ORG_ID — multi-org operating unit identifier, plus standard audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN).
• RESPONSE_OPTION_CODE and FUNDING_METHOD — response handling and funding-method configuration.

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.