Search Results igf_db_ytd_dtl

Overview

IGF_DB_YTD_DTL is a secured reporting view owned by the APPS schema within the IGF (Financial Aid) product family of Oracle E-Business Suite 12.1.1 and 12.2.2. It exposes year-to-date disbursement detail records that are loaded into the Financial Aid module through the year-to-date disbursement data file interface. The view functions as the operational and reporting layer over the disbursement staging and detail data, presenting loan-level disbursement, fee, interest rebate, and net amounts in a single consolidated structure.

The object is registered in ETRM with a status of VALID. Because it is a view rather than a table, it carries no independent storage; all data is derived at query time from its underlying base object. The view is primarily consumed by concurrent programs, inquiries, and custom reports that require disbursement totals for a given school, loan, or reporting period. The user search term "total_gross" maps directly to the TOTAL_GROSS column, one of the aggregated monetary attributes exposed by the view.

Underlying Base Objects

The documented base object for this view is IGF_DB_YTD_DTL_ALL. The view definition selects a curated set of columns from that table, aliased as YTDD, and applies a Multi-Org security predicate:

• The WHERE clause evaluates USERENV('CLIENT_INFO') to derive the operating unit context.
• Records are filtered where NVL(YTDD.ORG_ID, -99) equals the caller's derived ORG_ID context, ensuring users see only data belonging to their authorized operating unit.
• Beyond the base table, no other referenced objects are documented in the ETRM metadata.

This inclusion of ROWID and the org filter confirms the view is intended as an operating-unit-secured presentation layer, not a raw extraction. Because the underlying table is an _ALL table, the view is the correct access path for multi-org compliant queries.

Key Columns

The view exposes the full YTD disbursement detail model. Significant columns include:

• YTDD_ID – Primary identifier for the year-to-date disbursement detail record.
• DL_VERSION, RECORD_TYPE, BATCH_ID – Load batch and versioning context for the inbound data file.
• SCHOOL_CODE, LOAN_NUMBER – Institutional and loan-level identifiers.
• DISB_GROSS, DISB_FEE, DISB_INT_REBATE, DISB_NET, DISB_NET_ADJ – Individual disbursement amounts and adjustments.
• TOTAL_GROSS, TOTAL_FEE, TOTAL_INT_REBATE, TOTAL_NET – Cumulative year-to-date monetary totals; TOTAL_GROSS is the aggregate gross figure most frequently requested in reporting.
• REGION_CODE, STATE_CODE – Geographic attributes used for regulatory and compliance reporting.
• REC_COUNT – Record count associated with the loaded detail.
• REQUEST_ID, PROGRAM_ID, PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE – Concurrent program audit identifiers.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN – Standard EBS audit columns.

Common Use Cases and Queries

Typical applications include reconciliation of loaded YTD disbursement files, financial aid reporting by school or region, and verification of gross versus net disbursement totals. A representative query retrieving aggregate gross by school is:

• SELECT SCHOOL_CODE, SUM(TOTAL_GROSS) TOTAL_GROSS, SUM(TOTAL_NET) TOTAL_NET FROM IGF_DB_YTD_DTL GROUP BY SCHOOL_CODE;
• SELECT LOAN_NUMBER, DISB_GROSS, TOTAL_GROSS, TOTAL_FEE, TOTAL_NET FROM IGF_DB_YTD_DTL WHERE BATCH_ID = :batch_id;
• SELECT * FROM IGF_DB_YTD_DTL WHERE LOAN_NUMBER = :loan_number ORDER BY DISB_SEQ_NUM;

Because the view enforces the ORG_ID security predicate, results automatically reflect the session's operating unit, making it suitable for both inquiry screens and ad hoc SQL executed from an APPS-connected session.