Search Results sf_credit_id

Overview

IGF.IGF_DB_AWD_DISB_DTL_ALL is a transactional table in the Oracle E-Business Suite 12.1.1 / 12.2.2 Student Financial Aid (IGF) module. It stores all actual disbursement transactions and subsequent adjustments made to them after the records have been posted to the student finance interface table. The table deliberately excludes planned disbursements; only executed disbursement events and corrections to those events are captured here. Each row therefore represents a point-in-time adjustment to a disbursement, preserving the audit trail across multiple changes to gross amount, net amount, fees, or date.

From a Data Vault modeling perspective, the mined foreign-key structure suggests this object behaves as a link — it connects an award (via AWARD_ID) and a disbursement schedule (via DISB_NUM / DISB_SEQ_NUM) to financial aid award disbursement records and academic calendar instances. It records the intersection of award, disbursement schedule, and calendar period rather than a standalone descriptive hub. The table resides in the APPS_TS_TX_DATA tablespace, with indexes in APPS_TS_TX_IDX.

Key Information Stored

The surrogate primary key is IGF_DB_AWD_DISB_DTL_ALL_PK, composed of AWARD_ID, DISB_NUM, and DISB_SEQ_NUM. This composite business key uniquely identifies each disbursement adjustment event. A non-unique index, IGF_DB_AWD_DISB_DTL_ALL_N1, exists on SF_CREDIT_ID to support student finance lookups.

• AWARD_ID — Identifier linking the disbursement to a specific financial aid award.
• DISB_NUM, DISB_SEQ_NUM — The disbursement number and sequence of changes to that disbursement's amount or date.
• DISB_GROSS_AMT, DISB_NET_AMT, DISB_ADJ_AMT — Gross, net, and adjustment amounts following each transaction.
• FEE_1, FEE_2, FEE_PAID_1, FEE_PAID_2 — Origination and guarantee fees (Direct Loan / CommonLine), and fees paid.
• DISB_DATE — The disbursement date after adjustment.
• DISB_ACTIVITY — Classification of the record: actual disbursement, net amount adjustment, or date change.
• SF_CREDIT_ID, SF_STATUS, SF_STATUS_DATE, SF_INVOICE_NUM — Student finance posting references and status tracking.
• DISB_STATUS, DISB_STATUS_DATE, DISB_BATCH_ID — Disbursement processing status and batch identifiers.
• AWARD_ID also serves as the FK to IGF_AW_AWD_DISB_ALL connected to the award disbursement schedule.

Common Use Cases and Queries

Typical uses include reconciling actual disbursements against the student finance interface, producing disbursement audit trails for regulatory reporting, and analyzing fee withholdings on Direct Loan and CommonLine disbursements. A common query traces all adjustments for a given award:

SELECT AWARD_ID, DISB_NUM, DISB_SEQ_NUM, DISB_ACTIVITY, DISB_GROSS_AMT, DISB_NET_AMT, DISB_ADJ_AMT, DISB_DATE FROM IGF.IGF_DB_AWD_DISB_DTL_ALL WHERE AWARD_ID = :p_award_id ORDER BY DISB_NUM, DISB_SEQ_NUM;

Because the documented index N1 is on SF_CREDIT_ID, queries filtering by student finance credit ID (often the sf_credit_id users search for) are efficiently served:

SELECT * FROM IGF.IGF_DB_AWD_DISB_DTL_ALL WHERE SF_CREDIT_ID = :p_sf_credit_id;

Reporting scenarios include net disbursement trend analysis by date, fee impact summaries grouped by DISB_ACTIVITY, and discrepancy checks between DISB_NET_AMT and DISB_ADJ_AMT.

Related Objects

The FK relationships and dependencies of this table are the primary integration points:

• IGF.IGF_AW_AWD_DISB_ALL — Parent of AWARD_ID; holds the award disbursement schedule against which actuals are recorded.
• IGS.IGS_CA_INST_ALL — Referenced by LD_CAL_TYPE; provides calendar instance context for loan disbursements.
• SF_CREDIT_ID (indexed) — Links to student finance credit records within the student finance interface.
• SPNSR_CREDIT_ID / SPNSR_CHARGE_ID — Sponsor-level credit and charge references for third-party funding.
• Requests / Concurrent programs referenced by REQUEST_ID, PROGRAM_ID, PROGRAM_APPLICATION_ID for auditing batch loads.