Search Results direct_loan_spec_version




Overview
Explore in AI Chat

Overview

APPS.IGFBV_DL_YTD_SUMMARY is a Business Intelligence System (BIS) view registered in the Applications (APPS) schema and identified by the FND Design Data reference IGF.IGFBV_DL_YTD_SUMMARY. It is defined with a status of VALID and is classified as a base view for the entity that holds Year-to-Date Direct Loan Summary data. In the Oracle E-Business Suite 12.1.1 and 12.2.2 stack, this view belongs to the Financial Aid (IGF) product family and supports the reporting and integration of Title IV Direct Loan disbursement information exchanged between institutions and the Common Origination and Disbursement (COD) system.

The view presents a flattened, query-friendly representation of Direct Loan year-to-date disbursement summaries. It exposes one row per school, statement period, and disbursement summary type, with paired booked and unbooked monetary measures. Because it is a BIS view rather than a transactional table, consumers should treat it as read-only and expect its contents to reflect the latest processed batch data.

Underlying Base Objects

The documented metadata for this view does not enumerate referenced base objects or a query text. In practice, IGFBV_DL_YTD_SUMMARY is a view layered over the Direct Loan year-to-date disbursement summary entity within the IGF schema, and its data is populated through the Direct Loan processing and COD reconciliation flows. The BATCH_ID column indicates that rows originate from batch processing runs, and YEAR_TO_DATE_DISB_SUMMARY_ID provides the unique identifier of the underlying summary record. Standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE) confirm the view sits above an audited base table rather than being a synthetic construct. Because a formal dependency list is not documented here, integrators should verify the current definition in the instance before relying on join paths to child entities.

Key Columns

Common Use Cases and Queries

Typical uses include reconciliation of COD-reported Direct Loan totals against internal disbursement records, monitoring of booked versus unbooked balances by school and statement period, and reporting filtered by file format version.

  • Reviewing totals for a specific file specification version:
SELECT school_code, statement_end_date, disbursement_summary_type,
       booked_net_amount, unbooked_net_amount
FROM   apps.igfbv_dl_ytd_summary
WHERE  direct_loan_spec_version = :spec_version
  AND  record_type = 'YEAR-TO-DATE SUMMARY';
  • Tracing a batch back to its constituent summary rows:
SELECT year_to_date_disb_summary_id, school_code, record_count,
       booked_gross_amount, unbooked_gross_amount
FROM   apps.igfbv_dl_ytd_summary
WHERE  batch_id = :batch_id
ORDER  BY record_count;
  • Aggregating net booked amounts by school for a statement period:
SELECT school_code,
       SUM(booked_net_amount)   AS total_booked,
       SUM(unbooked_net_amount) AS total_unbooked
FROM   apps.igfbv_dl_ytd_summary
WHERE  statement_end_date = :stmt_end_date
GROUP  BY school_code;

Because the view is a BIS base view without documented downstream dependencies, queries should always constrain on DIRECT_LOAN_SPEC_VERSION, STATEMENT_END_DATE, or BATCH_ID to bound result sets and align with the processing cycle that generated the data.