Search Results sf_invoice_num




Overview
Explore in AI Chat

Overview

IGF_DB_DL_DISB_DTL_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the IGF (Financial Aid) product family. It presents Direct Loan disbursement detail for each disbursement associated with a loan record, flattening the transactional detail held across award, disbursement, loan, and fund-master entities into a single queryable structure. The view is defined with status VALID in the ETRM metadata for both 12.1.1 and 12.2.2, and it is intended for reporting, reconciliation, and integration consumption rather than for direct transactional entry.

Its principal value lies in combining disbursement-level activity—gross amount, fees, net amount, adjustments, dates, batch identifiers, and status values—with the loan number and award context. This makes it suitable for financial aid offices and downstream systems that need to report on Title IV Direct Loan disbursement lifecycle data without joining the underlying normalized tables themselves.

Underlying Base Objects

The view text shows the following base objects in its FROM clause and join conditions:

The final predicate (FCAT.FED_FUND_CODE = LKPS.LOOKUP_CODE) restricts the result set to Stafford and PLUS Direct Loan funds, which explains why the view is specific to Direct Loan disbursements rather than the broader universe of financial aid awards.

Key Columns

  • ROW_ID, AWARD_ID — primary identifier for the disbursement detail row and its parent award.
  • DISB_NUM, DISB_SEQ_NUM, DISB_ACTIVITY — disbursement number, sequence within the award, and activity type.
  • DISB_GROSS_AMT, FEE_1, FEE_2, DISB_NET_AMT, DISB_ADJ_AMT, FEE_PAID_1, FEE_PAID_2 — the monetary breakdown of the disbursement, including origination fees and any adjustments.
  • DISB_DATE, DISB_ACK_DATE, BOOKED_DATE — the disbursement date, acknowledgement date, and booking date.
  • DISB_BATCH_ID, BOOKING_BATCH_ID — batch references for the disbursement and booking processes.
  • DISB_STATUS, DISB_STATUS_DATE — the current disbursement status and the date that status was set. This is the column commonly referenced when searching for "disb_status_date".
  • SF_STATUS, SF_STATUS_DATE, SF_INVOICE_NUM — the student financial (Common Origination and Disbursement) status, its date, and the associated invoice number.
  • LOAN_NUMBER — sourced from IGF_SL_LOANS, giving the direct loan reference.
  • AFFIRM_FLAG, INT_REBATE_AMT — acknowledgement flag and interest rebate amount.
  • Audit and concurrent-program columns from ADISB.

Common Use Cases and Queries

The view supports disbursement reconciliation, Direct Loan status reporting, and integration extracts. A typical report selects the current status and its effective date alongside award and loan identifiers, filtered by a date range on DISB_STATUS_DATE.

Example: list current disbursement statuses for Stafford and PLUS loans in a given period.

SELECT LOAN_NUMBER,
       AWARD_ID,
       DISB_NUM,
       DISB_STATUS,
       DISB_STATUS_DATE,
       SF_STATUS,
       SF_STATUS_DATE,
       DISB_GROSS_AMT,
       DISB_NET_AMT
  FROM APPS.IGF_DB_DL_DISB_DTL_V
 WHERE DISB_STATUS_DATE BETWEEN :p_start_date AND :p_end_date
 ORDER BY LOAN_NUMBER, DISB_NUM;

Another common pattern reconciles gross-to-net disbursement amounts using the fee columns:

SELECT AWARD_ID,
       DISB_NUM,
       DISB_GROSS_AMT,
       FEE_1 + FEE_2 AS DISB_FEES,
       DISB_NET_AMT,
       DISB_ADJ_AMT
  FROM APPS.IGF_DB_DL_DISB_DTL_V
 WHERE AWARD_ID = :p_award_id;

Because the view already applies the Direct Loan fund and lookup restrictions, consumers do not need to repeat the fund-category joins, though joins back to IGF_AW_AWARD or IGF_SL_LOANS on AWARD_ID remain valid when additional attributes are required.