Search Results igf_sl_dl_setup_all_u1

Overview

IGF.IGF_SL_DL_SETUP_ALL is a configuration table in the Oracle E-Business Suite Financial Aid (IGF) schema that maintains setup and default information for Direct Loan processing. It belongs to the Student Loan (SL) functional area and stores the institutional parameters that govern how Direct Loan disbursements, promissory notes, disclosures, and origination fees are handled for a given award year and operating unit. Each row defines a Direct Loan setup profile keyed by an internal identifier (DLSET_ID) and scoped to an award-year calendar instance and organization.

The object is classified in the metadata as VALID and is stored in the APPS_TS_TX_DATA tablespace with 10 percent free space. Its indexes reside in APPS_TS_TX_IDX. From a Data Vault modeling perspective, the mined foreign-key structure suggests this entity is satellite-leaning: it holds descriptive, version-like attributes (fee percentages, print indicators, and version codes) attached to a business key composed of the award-year calendar instance and the operating unit, rather than acting as a hub or a pure link. This classification is offered as a heuristic modeling suggestion, not a mandated schema design.

Key Information Stored

The table contains 23 documented columns. The most significant are:

• DLSET_ID — Numeric (15) identifier for the Direct Loan setup record; this is the surrogate primary key (IGF_SL_DL_SETUP_ALL_PK) and the column of unique index IGF_SL_DL_SETUP_ALL_U1.
• CI_CAL_TYPE and CI_SEQUENCE_NUMBER — Together they form the second unique business-key candidate (IGF_SL_DL_SETUP_ALL_U2), identifying the award-year calendar type and its unique calendar instance.
• ORG_ID — The operating unit that scopes the setup, consistent with multi-org partitioning.
• ORIG_FEE_PERCT_STAFFORD and ORIG_FEE_PERCT_PLUS — Origination fee percentages applied to Stafford and PLUS loans respectively.
• INT_REBATE — The upfront interest rebate percentage granted.
• PNOTE_PRINT_IND and PNOTE_PRINT_COPIES — Where the promissory note is printed and the number of copies.
• ACC_NOTE_FOR_DISB — Whether an accepted note is required before disbursement (Y/N).
• AFFIRMATION_REQD and INTERVIEW_REQD — Flags controlling whether affirmation and interview steps are mandatory.
• DISCLOSURE_PRINT_IND — Whether the school or the loan origination center prints the disclosure statement.
• SPECIAL_SCHOOL and DL_VERSION — Special-school designation and the Direct Loan file specification version in use.
• SCHOOL_ID, RESPONSE_OPTION_CODE, FUNDING_METHOD — Supplementary configuration attributes; SCHOOL_ID is noted as obsolete in the source documentation.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO audit columns.

Common Use Cases and Queries

The table is primarily read during Direct Loan origination and disbursement processing, where the application resolves the applicable setup row by award year and operating unit. Typical reporting and validation scenarios include auditing origination fee configuration, verifying promissory note print behavior, and confirming that required affirmation or interview flags are correctly set before disbursement.

A representative lookup resolving the active configuration for an award year:

• SELECT dlset_id, ci_cal_type, ci_sequence_number, org_id, orig_fee_perct_stafford, orig_fee_perct_plus, int_rebate, pnote_print_ind, acc_note_for_disb, dl_version FROM igf.igf_sl_dl_setup_all WHERE org_id = :p_org_id AND ci_cal_type = :p_cal_type AND ci_sequence_number = :p_seq_num;

Audit queries might compare fee percentages across setups, or detect rows where affirmation or interview requirements diverge from institutional policy. Because the table is low-volume setup data, joins are inexpensive and reporting typically filters by ORG_ID or award-year calendar.

Related Objects

The documented foreign-key relationship joins the award-year calendar to the calendar instance table. Significant related objects include:

• IGS.IGS_CA_INST_ALL — Referenced by CI_CAL_TYPE; the join links each Direct Loan setup to its award-year calendar instance.
• IGF.IGF_SL_DL_SETUP_ALL primary key and unique indexes — IGF_SL_DL_SETUP_ALL_PK (DLSET_ID), IGF_SL_DL_SETUP_ALL_U1 (DLSET_ID), and IGF_SL_DL_SETUP_ALL_U2 (CI_CAL_TYPE, CI_SEQUENCE_NUMBER) constrain the business keys used by dependent Direct Loan processing objects.
• Direct Loan disbursement, promissory note, and disclosure processing components within the IGF schema consume this configuration to derive printing behavior, fee percentages, and note-acceptance rules.

Because the metadata documents only one outbound foreign key, the strongest physically confirmed relationship is the join to IGS_CA_INST_ALL on the award-year calendar instance. All other connections should be confirmed against the specific release (12.1.1 or 12.2.2) data model before being relied upon.