Results for “igffv_ffelp_disb_resp_details”

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

Overview

The view IGFFV_FFELP_DISB_RESP_DETAILS is an Oracle E-Business Suite (EBS) database object owned by the APPS schema within the IGF — Financial Aid product group. It is defined as a "Full View" over the entity responsible for holding FFELP (Federal Family Education Loan Program) Disbursement Response Details. In the context of EBS 12.1.1 and 12.2.2, its role is to expose loan disbursement response data, along with associated borrower identity attributes, to downstream reporting, integration, and inquiry processes without requiring direct access to the underlying normalized transaction tables. The view is marked with the WITH READ ONLY clause, meaning it is intended purely for query and retrieval purposes. The object is documented as VALID and is part of the technical reference material distributed with the product (ETRM).

Underlying Base Objects

The view is defined over two base tables in the IGF schema:

• IGF_SL_CL_RESP_R8_ALL (aliased RESP8) — the entity that stores the FFELP disbursement response detail records.
• IGF_SL_CL_RESP_R1_ALL (aliased RESP1) — the entity that stores the higher-level loan and borrower response header records.

The two objects are joined on the common key CLRP1_ID, effectively linking each disbursement-level response row (RESP8) to its parent loan response record (RESP1). The _ALL suffixes indicate the tables are partitioned or multi-org style base tables (or held in a multi-language/subset-enabled form), and the view flattens the join into a single logical reporting entity. Although the ETRM 12.2.2 metadata documents no referenced base objects explicitly, the view text clearly establishes this join as the structural foundation.

Key Columns

• RESP_DISBURSEMENT_DATE — the date on which the disbursement response applies.
• RESP_DISBURSEMENT_GROSS_AMT, RESP_NET_DISBURSEMENT_AMT — gross and net disbursement amounts for the response record.
• RESP_ORIGINATION_FEE, RESP_GUARANTEE_FEE, RESP_ORIGINATION_FEE_PAID, RESP_GUARANTEE_FEE_PAID — origination and guarantee fee amounts, and the respective paid amounts.
• "_LA:RESP_HOLD_RELEASE_IND" and "_LA:RESP_DISBURSEMNT_STATUS" — lookup-driven columns that resolve display meanings from IGF_LOOKUPS_VIEW (lookup types IGF_SL_CL_DB_HOLD_REL_IND and IGF_SL_CL_DISB_STATUS respectively).
• RESP_RECORD_INTERNAL_STATUS — internal status indicator for the response record.
• LOAN_NUMBER, BORROWER_FIRST_NAME, BORROWER_LAST_NAME, BORROWER_MIDDLE_NAME, BORROWER_SSN — borrower and loan identifying attributes sourced from RESP1.
• RESPONSE_PARENT_ID, RESP_DISBURSEMENT_NUMBER — the inherited CLRP1_ID and the CLRP8_ID identifier for the disbursement response.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — standard EBS audit columns.

Note that in the raw view text the column names are derived from RESP8/RESP1; the documented column list assigns user-friendly aliases such as RESP_DISBURSEMENT_DATE, RESPONSE_PARENT_ID, and RESP_DISBURSEMENT_NUMBER.

Common Use Cases and Queries

This view is typically consumed by financial aid reporting, reconciliation of disbursement responses, and integration extracts to external loan servicing systems. A representative query retrieving recent disbursement responses with borrower detail might be:

SELECT RESPONSE_PARENT_ID,
       RESP_DISBURSEMENT_NUMBER,
       LOAN_NUMBER,
       BORROWER_LAST_NAME,
       BORROWER_SSN,
       RESP_DISBURSEMENT_DATE,
       RESP_DISBURSEMENT_GROSS_AMT,
       RESP_NET_DISBURSEMENT_AMT,
       RESP_ORIGINATION_FEE,
       RESP_GUARANTEE_FEE
  FROM APPS.IGFFV_FFELP_DISB_RESP_DETAILS
 WHERE RESP_DISBURSEMENT_DATE >= :p_from_date
   AND RESP_DISBURSEMENT_DATE <  :p_to_date
   AND RESP_RECORD_INTERNAL_STATUS = 'ACTIVE'
 ORDER BY RESP_DISBURSEMENT_DATE, LOAN_NUMBER;

Because the view is READ ONLY, no DML is permitted against it. Users querying the lookup-driven columns receive the resolved meaning values (e.g., hold release indicator text and disbursement status description), which simplifies report output. The borrower SSN column is generally restricted and should be handled in accordance with institutional data privacy policies.