Search Results eft_authorization




Overview
Explore in AI Chat

Overview

IGF_SL_CL_SETUP_V is a reporting view in the Oracle E-Business Suite IGF (Financial Aid) product family. It exposes the configuration of a student loan "checklist" or "CL setup" record — the parametric definition that governs how a particular Stafford, PLUS, or alternative loan type is originated, disbursed, and serviced for a given academic period. The view flattens the checklist setup header into a denormalized, read-friendly projection, joining each setup row to its governing academic calendar instance and to the loan recipient (borrower) relationship record. In the context of ETRM 12.1.1 and 12.2.2, IGF is documented as obsolete and this specific view is reported as "Not implemented in this database," meaning it exists in the reference metadata but is not deployed in a standard shipped installation. Its structure nonetheless reflects how Financial Aid originated loans were modeled before the module was retired.

Underlying Base Objects

The view text shows a three-table join over the following base objects:

  • IGF_SL_CL_SETUP (alias CLSET) — the primary checklist/setup header table holding lending rules, fee percentages, and processing codes. All non-derived columns and the create/update audit columns come from this table.
  • IGS_CA_INST (alias CI) — the academic calendar instance table, supplying START_DT, END_DT, and ALTERNATE_CODE for the calendar type/sequence referenced by the setup row.
  • IGF_SL_CL_RECIPIENT (alias RCPTV) — the recipient/relationship table, supplying lender, guarantor, recipient, and non-ED branch identifiers plus the relationship description.

Lookup descriptions are resolved at runtime through calls to IGF_AW_GEN.LOOKUP_DESC, a helper that translates coded values into display text. Note that although the module is obsolete, its tables (IGF prefix) share a schema lineage with the broader Student Systems (IGS prefix) tables such as IGS_CA_INST. The documented ETRM metadata lists no referenced base objects, so the dependency model above is derived from the view text itself.

Key Columns

Common Use Cases and Queries

Typical use is configuration reporting: verifying which checklist setups authorize EFT disbursement, auditing fee percentages, or reconciling loan processing rules against an academic period. A representative query for the EFT angle is:

SELECT clset_id,
       ci_cal_type,
       ci_start_dt,
       ci_end_dt,
       eft_authorization,
       est_orig_fee_perct,
       est_guarnt_fee_perct,
       prc_type_code
FROM   igf_sl_cl_setup_v
WHERE  eft_authorization IS NOT NULL
  AND  ci_start_dt >= :p_from_date;

Because IGF is obsolete and the view is reported as not implemented, these queries will not execute in a standard 12.1.1 or 12.2.2 install; they are useful primarily for documentation, migration analysis, or historical reference where a legacy Financial Aid schema persists.