Results for “igf_sl_dl_stafford”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

VIEW APPS.IGF_DB_DL_DISB_DTL_V is a reporting and integration view within the Oracle E-Business Suite Federal Government financials family, specifically belonging to the Grants Management (IGF) schema associated with the Student Financial Aid (SFA) and Title IV Direct Loan processing components. In Oracle EBS 12.1.1 and 12.2.2 it is used by the ETRM (Enterprise Technical Reference Manual) as a consolidated access point over disbursement detail information for award disbursements that are tied to specific Stafford and PLUS loan disbursement activity. The view combines disbursement-level attributes with award-, loan-, fund-, and lookup-derived context so that downstream reports, concurrent programs, and interfaces can retrieve a single flattened row per disbursement without joining many underlying tables themselves.

The name reference the user searched, igf_sl_dl_plus, corresponds to the lookup value/code family referenced inside the view predicate (IGF_SL_DL_PLUS), which is the PLUS loan disbursement reservation type distinguished from IGF_SL_DL_STAFFORD. This confirms the view is scoped to Direct Loan (DL) disbursements for both Stafford and PLUS categories.

Underlying Base Objects

Although the documented ETRM base object list for this view is incomplete, the view text explicitly shows the following referenced objects:

• IGF_DB_AWD_DISB_DTL (aliased ddtl) — award disbursement detail, the primary driving table contributing ROW_ID, AWARD_ID, DISB_NUM, DISB_SEQ_NUM, DISB_ACTIVITY, amounts, dates, and status columns.
• IGF_AW_AWD_DISB (aliased adisb) — award disbursement header, supplying AFFIRM_FLAG, audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE) and INT_REBATE_AMT.
• IGF_AW_AWARD (aliased awd) — award master, used to link the award to funding.
• IGF_SL_LOANS (aliased lar) — student loan record providing LOAN_NUMBER.
• IGF_LOOKUPS_VIEW (aliased lkps) — lookup values filtered to IGF_SL_DL_STAFFORD and IGF_SL_DL_PLUS.
• IGF_AW_FUND_MAST (aliased fmast) and IGF_AW_FUND_CAT (aliased fcat) — fund master and fund category, joined to derive the Federal fund code that drives the lookup filter.

The joins form a chain: disbursement detail to disbursement header (on AWARD_ID and DISB_NUM), to award, to loan, and through fund master and fund category to the lookup view, filtered so that only Stafford and PLUS disbursements are returned.

Key Columns

• ROW_ID, AWARD_ID, DISB_NUM, DISB_SEQ_NUM — the identity and sequencing of each disbursement detail row.
• DISB_ACTIVITY, DISB_GROSS_AMT, DISB_NET_AMT, DISB_ADJ_AMT — activity type and monetary amounts.
• FEE_1, FEE_2, FEE_PAID_1, FEE_PAID_2 — loan origination/default fee amounts and paid indicators.
• DISB_DATE, DISB_ACK_DATE, BOOKED_DATE — key milestone dates for the disbursement lifecycle.
• DISB_BATCH_ID, BOOKING_BATCH_ID — batching references for reconciliation.
• DISB_STATUS, DISB_STATUS_DATE, SF_STATUS, SF_STATUS_DATE, SF_INVOICE_NUM — disbursement and Student Financials status tracking, and the associated SF invoice.
• LOAN_NUMBER — retrieved from IGF_SL_LOANS, identifying the underlying loan.
• AFFIRM_FLAG, INT_REBATE_AMT — confirmation flag and interest rebate amount from the disbursement header.
• Audit/program columns (CREATED_BY, CREATION_DATE, etc.) — support auditing, concurrent program debugging, and interface traceability.

Common Use Cases and Queries

The view is typically consumed by Title IV disbursement reconciliation reports, DL booking extracts, and fee/rebate analysis. A simple retrieval for a given award:

• SELECT award_id, disb_num, disb_seq_num, disb_date, disb_gross_amt, disb_net_amt, loan_number, disb_status FROM apps.igf_db_dl_disb_dtl_v WHERE award_id = :p_award_id ORDER BY disb_num, disb_seq_num;

For reconciliation of unbooked disbursements:

• SELECT award_id, disb_num, loan_number, disb_ack_date, booked_date, booking_batch_id FROM apps.igf_db_dl_disb_dtl_v WHERE booked_date IS NULL AND disb_status = 'A';

And for a summary by loan number:

• SELECT loan_number, COUNT(*) disb_count, SUM(disb_gross_amt) gross, SUM(fee_1+fee_2) fees FROM apps.igf_db_dl_disb_dtl_v GROUP BY loan_number;

Because the view embeds the lookup restriction to IGF_SL_DL_STAFFORD and IGF_SL_DL_PLUS, callers only receive Direct Loan Stafford and PLUS disbursement records, which makes it a convenient, pre-filtered source for Title IV reporting and disbursement integrations in both 12.1.1 and 12.2.2.