Search Results disb_net




Overview
Explore in AI Chat

Overview

The IGF.IGF_DB_YTD_DTL_ALL table is a transactional staging and detail table within the Oracle E-Business Suite Financial Aid module, owned by the IGF schema. Its documented purpose is to store data loaded through the year-to-date disbursement data file, making it the primary persistence target for disbursement records received from external Direct Loan processing systems. Each row represents a single loaded disbursement detail record, capturing both year-to-date summary and monthly summary information as distinguished by the RECORD_TYPE column.

The table resides in the APPS_TS_TX_DATA tablespace with a PCT Free of 10, indicating a transactional data orientation with modest space reserved for row updates. From a Data Vault modeling perspective, the metadata's heuristic classification is standalone, meaning the table exhibits no foreign-key dependencies on other documented objects and functions independently as a persistent source for disbursement activity. This suggests it can reasonably be treated as a satellite-like structure anchored on its own surrogate key, rather than a hub or link requiring integration into a broader relationship network.

Key Information Stored

The surrogate primary key is YTDD_ID, a NUMBER(15) column enforced by the unique index IGF_DB_YTD_DTL_PK. This is the sole documented unique index and therefore the only business-key candidate identified in the metadata, though LOAN_NUMBER combined with DISB_NUM and DISB_SEQ_NUM represents a natural composite identifier for disbursement records in practice.

  • YTDD_ID — Unique identifier for each loaded year-to-date disbursement record.
  • RECORD_TYPE — Distinguishes year-to-date summary from monthly summary records.
  • DL_VERSION — Direct Loan File Format version governing the loaded record.
  • BATCH_ID — Unique batch identifier for the load process.
  • SCHOOL_CODE — School identifier associated with the disbursement.
  • LOAN_NUMBER — Loan number linking the disbursement to a specific loan.
  • DISB_NET — The net disbursement amount, the central financial measure for this record.
  • DISB_GROSS, DISB_FEE, DISB_INT_REBATE — Gross amount, fee, and interest rebate components that reconcile to DISB_NET.
  • DISB_NET_ADJ — Net adjustment applied to the disbursement.
  • DISB_NUM, DISB_SEQ_NUM — Disbursement number and sequence for ordering multiple disbursements per loan.
  • TOTAL_NET, TOTAL_GROSS — Aggregated totals carried at the record level.
  • STAT_END_DT, PROCESS_DT, TRANS_DT — Statement end, processing, and transaction dates.
  • ORG_ID — Multi-org operating unit identifier enabling data segregation.

Common Use Cases and Queries

The most frequent use case is reconciling disbursement net amounts loaded from the Direct Loan file against general ledger and student account balances. Because the user search term was "disb_net," reporting queries typically center on this column.

  • Net disbursement reporting: SELECT LOAN_NUMBER, DISB_NUM, DISB_SEQ_NUM, DISB_NET, DISB_NET_ADJ FROM IGF.IGF_DB_YTD_DTL_ALL WHERE ORG_ID = :org_id AND STAT_END_DT BETWEEN :start_dt AND :end_dt;
  • Reconciliation of gross to net: SELECT YTDD_ID, DISB_GROSS, DISB_FEE, DISB_INT_REBATE, DISB_NET FROM IGF.IGF_DB_YTD_DTL_ALL WHERE DISB_NET <> (DISB_GROSS - DISB_FEE - DISB_INT_REBATE);
  • Batch audit: filter on BATCH_ID to validate a specific load run.
  • Record type segmentation: group by RECORD_TYPE to separate summary from monthly detail.

These queries support financial aid reconciliation, disbursement audit, and downstream reporting for regulatory submission.

Related Objects

The metadata classifies this table as standalone with no documented foreign-key relationships, so the objects below are inferred from shared Direct Loan processing business keys and the IGF disbursement data model rather than enforced constraints.

Because referential integrity is not enforced at the database level, joins should be validated on the shared business keys LOAN_NUMBER, DISB_NUM, and BATCH_ID.