Search Results school_code

Overview

IGFFV_DL_YTD_SUMMARY is a full-view database object within the Oracle E-Business Suite Financial Aid module (IGF), historically delivered to support the Federal Direct Loan (Direct Loan / DL) program. Its documented description is "Full View for the Entity that holds Year to Date Direct Loan Summary." The view exposes year-to-date (YTD) summary records that consolidate Direct Loan disbursement activity — booked and unbooked amounts, fees, interest rebates, and net totals — aggregated by school, region, state, disbursement summary type, and record type.

The view is explicitly marked as Obsolete under the IGF - Financial Aid product in ETRM 12.2.2, and the implementation note states "Not implemented in this database." This indicates that in current 12.1.1 and 12.2.2 environments the object is either not deployed or retained only for historical upgrade paths. It plays no active role in standard EBS reporting or integration flows in supported releases; it is documented primarily as a legacy reference object.

Underlying Base Objects

The view text defines a single base object:

• IGF_DB_YTD_SMR_ALL — the entity table storing Year to Date Direct Loan Summary (YTD SMR) records. The view is a straightforward projection over this table with the alias YTDS.

Notably, no base objects other than IGF_DB_YTD_SMR_ALL are referenced, and the ETRM metadata records "Referenced base objects: none documented" for the structural listing, so the view does not join to school, region, or state lookup tables — those appear only as code columns on the summary row itself. The view is created WITH READ ONLY, confirming it is intended purely for query and reporting against the persisted summary data rather than for DML.

Key Columns

The physical column names in the base table differ from the view's presentation labels. The view selects the following columns (view label / physical column):

• DL_VERSION (DIRECT_LOAN_SPEC_VERSION) — version of the Direct Loan specification used for the summary.
• RECORD_TYPE and DISB_SMR_TYPE (DISBURSEMENT_SUMMARY_TYPE) — classify the summary record and disbursement grouping.
• SCHOOL_CODE — identifies the institution (school). Because the user search term is school_code, this is the primary filtering key for institutional reporting.
• REGION_CODE and STATE_CODE — geographic grouping of the summary record.
• REC_COUNT (RECORD_COUNT) — number of underlying records aggregated.
• STAT_END_DT (STATEMENT_END_DATE) and PROCESS_DT (PROCESS_DATE) — reporting period boundaries and processing timestamps.
• BKD_GROSS, BKD_FEE, BKD_INT_REBATE, BKD_NET — booked gross, fees, interest rebate, and net amounts.
• UNBKD_GROSS, UNBKD_FEE, UNBKD_INT_REBATE, UNBKD_NET — unbooked equivalents.
• BATCH_ID, YTDS_ID (YEAR_TO_DATE_DISB_SUMMARY_ID) — batch and primary identifier for the summary row.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — standard EBS audit columns.

Common Use Cases and Queries

Where the object exists, queries are typically read-only extractions for reconciliation, audit, or archival reporting of Direct Loan YTD activity by school.

• School-level YTD summary:

  SELECT school_code, state_code, stat_end_dt,
         bkd_gross, bkd_fee, bkd_net,
         unbkd_gross, unbkd_fee, unbkd_net
  FROM   igffv_dl_ytd_summary
  WHERE  school_code = :p_school_code
  ORDER BY stat_end_dt DESC;

• Booked vs. unbooked reconciliation:

  SELECT record_type, disb_smr_type,
         SUM(bkd_net) booked_net,
         SUM(unbkd_net) unbooked_net
  FROM   igffv_dl_ytd_summary
  WHERE  process_dt BETWEEN :start_dt AND :end_dt
  GROUP BY record_type, disb_smr_type;

Because the view is obsolete and not implemented, equivalent current functionality should be sourced from surviving Direct Loan summary tables or the module's replacement reporting objects.