Results for “disb_fee_amt”

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

Overview

IGF_SL_DLDB_RSP_DTL is a table in the Oracle E-Business Suite IGF (Financial Aid) module, which Oracle classifies as obsolete in the 12.1.1 and 12.2.2 releases. The table stores the Direct Loan Disbursement Response Elements parsed from the response XML file returned by the federal Direct Loan processing interface. Each row represents a single disbursement-level response record tied to a parent loan response, capturing the amounts, dates, sequencing, and status codes communicated back by the servicer.

From a Data Vault modeling perspective, the mined foreign-key structure suggests a satellite-leaning classification. The table's grain is one disbursement response per row, keyed by a surrogate identifier and dependent on a parent loan response entity, which is characteristic of satellite behavior: descriptive, auditable attributes attached to a parent business key. The table is documented in ETRM but is marked "Not implemented in this database," indicating that the object may not exist in all environments or is retained only for historical reference.

Key Information Stored

The documented physical schema contains 25 columns in the IGF schema. The most significant attributes fall into several groups:

• DISB_RESP_ID — the surrogate primary key, enforced by the unique index IGF_SL_DLDB_RSP_DTL_PK. This is the single documented business-key candidate and the primary join key for this table.
• DL_LOAN_RESP_ID — the foreign key linking to IGF_SL_DL_RESP_DTLS, identifying the parent loan-level response record.
• Disbursement identity and amount: DISB_NUM, DISB_AMT, DISB_NET_AMT, DISB_FEE_AMT, INTEREST_REBATE_AMT, and DISB_DATE.
• Sequencing and indicators: DISB_SEQ_NUM, PREV_SEQ_NUM, FIRST_DISB_FLAG, DISB_REL_FLAG, and DISB_CONF_FLAG.
• Status and messaging: RESP_CODE, STATUS_CODE, and NOTE_MESSAGE.
• Standard audit columns: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, and REQUEST_ID.

Common Use Cases and Queries

The table supports reconciliation and audit reporting of Direct Loan disbursement responses, exception analysis for rejected or unconfirmed disbursements, and downstream financial posting validation. A typical reconciliation query joins the detail to its parent:

• SELECT d.DISB_RESP_ID, d.DISB_NUM, d.DISB_AMT, d.DISB_DATE, d.STATUS_CODE, d.RESP_CODE FROM IGF_SL_DLDB_RSP_DTL d WHERE d.DL_LOAN_RESP_ID = :loan_resp_id ORDER BY d.DISB_SEQ_NUM;
• Filtering on DISB_CONF_FLAG or DISB_REL_FLAG to isolate confirmed or released disbursements.
• Aggregating DISB_NET_AMT and DISB_FEE_AMT by DL_LOAN_RESP_ID for summary reporting.

Related Objects

• IGF_SL_DL_RESP_DTLS — the parent table referenced through IGF_SL_DLDB_RSP_DTL.DL_LOAN_RESP_ID; the primary relationship in the documented FK data.
• IGF_SL_DLDB_RSP_DTL_PK — the unique index enforcing the DISB_RESP_ID primary key.
• The broader IGF Direct Loan response objects (loan-level response headers and related response element tables) that complete the response XML persistence hierarchy.
• Concurrent program and request metadata referencing PROGRAM_APPLICATION_ID, PROGRAM_ID, and REQUEST_ID for traceability.