Search Results igf_sl_dl_pdet_resp




Overview
Explore in AI Chat

Overview

IGF_SL_DL_PDET_RESP is a Financial Aid (IGF) module table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores the response records extracted from the Direct Loan Promissory Note acknowledgment file uploaded into the system. When an institution processes Direct Loan promissory notes through the federal Common Origination and Disbursement (COD) process, the returned acknowledgment file contains detail-level responses for each promissory note. This table persists those detail response records, capturing the outcome of the acknowledgment processing at the individual promissory note response level.

From a Data Vault modeling perspective, the FK structure and composite-key design suggest a satellite-leaning classification. The table carries a composite primary key plus descriptive and audit attributes that describe and qualify a parent transaction (the promissory note response), which is characteristic of satellite behavior rather than a standalone hub or link.

Key Information Stored

The table is defined in the IGF schema and contains 12 documented columns. The most significant are:

  • DLPNR_ID — Direct Loan Promissory Note Response identifier. This is the parent foreign-key reference to IGF_SL_DL_PNOTE_RESP_ALL and forms the first component of the composite primary key. It is also the column referenced by the user's search term "dlpnr_id," confirming its role as the principal join key.
  • DLPDR_ID — Direct Loan Promissory Note Detail Response identifier. This is the second component of the composite primary key and distinguishes individual detail records within a given promissory note response.
  • DISB_GROSS_AMT — The gross disbursement amount associated with the detail response, used for reconciliation between the acknowledgment file and the institution's disbursement records.
  • REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — Concurrent program context columns recording which request and program invocation created the row.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS who-columns providing audit lineage for each row.

The surrogate primary key is IGF_SL_DL_PDET_RESP_PK, composed of (DLPNR_ID, DLPDR_ID). A unique index, IGF_SL_DL_RESP_ALL_U1, is defined over the same (DLPNR_ID, DLPDR_ID) pair, making that combination the documented business-key candidate and enforcing uniqueness at the detail-response grain.

Common Use Cases and Queries

Typical usage centers on verifying acknowledgment outcomes for uploaded promissory notes, reconciling disbursement amounts, and auditing the response load for a given concurrent request.

  • Retrieve all detail responses for a promissory note response: SELECT * FROM IGF.IGF_SL_DL_PDET_RESP WHERE DLPNR_ID = :p_dlpnr_id;
  • Reconcile gross disbursement amounts to expected totals: SELECT DLPNR_ID, SUM(DISB_GROSS_AMT) FROM IGF.IGF_SL_DL_PDET_RESP GROUP BY DLPNR_ID;
  • Audit rows created by a specific concurrent request: SELECT * FROM IGF.IGF_SL_DL_PDET_RESP WHERE REQUEST_ID = :p_request_id;
  • Join to the parent response header to view acknowledgment-level context: SELECT h.*, d.DLPDR_ID, d.DISB_GROSS_AMT FROM IGF.IGF_SL_DL_PNOTE_RESP_ALL h JOIN IGF.IGF_SL_DL_PDET_RESP d ON d.DLPNR_ID = h.DLPNR_ID;

Reporting use cases include COD acknowledgment reconciliation reports, Direct Loan disbursement audit trails, and error-analysis extracts that surface detail responses requiring manual correction.

Related Objects

  • IGF_SL_DL_PNOTE_RESP_ALL — The parent table referenced via the foreign key IGF_SL_DL_PDET_RESP.DLPNR_ID → IGF_SL_DL_PNOTE_RESP_ALL. It holds the header-level promissory note acknowledgment responses that this table's detail rows qualify.
  • IGF_SL_DL_PDET_RESP_PK — The primary key constraint over (DLPNR_ID, DLPDR_ID) enforcing entity integrity.
  • IGF_SL_DL_RESP_ALL_U1 — The unique index over (DLPNR_ID, DLPDR_ID) serving as the documented business-key candidate.
  • Direct Loan COD processing and disbursement tables in the IGF schema that consume the acknowledgment data for reconciliation and downstream disbursement adjustment.

Because the FK relationship is limited to a single documented parent reference, the most meaningful joins traverse from DLPNR_ID upward to IGF_SL_DL_PNOTE_RESP_ALL to reconstruct the complete acknowledgment record.