Results for “resp_guarantee_fee”

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

Overview

The view IGFBV_FFELP_DISB_RESP_DETAILS is a base view belonging to the IGF – Financial Aid product family in Oracle E-Business Suite. Per the ETRM metadata, it serves as the "Base view for the entity that holds FFELP Disbursement Response Details." FFELP (Federal Family Education Loan Program) was a U.S. federal student loan program under which loan origination and disbursement responses were exchanged between institutions and guaranty agencies/servicers. The IGFBV_ prefix follows the OAF/BC4J "base view" naming convention used throughout EBS self-service and forms-based modules, indicating that this object was intended primarily as the data source for an underlying entity object or business component rather than as an end-user reporting view.

Notably, the ETRM record carries the module designation "IGF – Financial Aid (Obsolete)" and the implementation note "Not implemented in this database." This indicates the view is legacy metadata retained from an earlier release (12.1.1 lineage) and is not physically deployed in a standard 12.2.2 instance. It exists in the data dictionary of historical ETRM documentation for reference and upgrade-impact purposes, not as a queryable object in a typical current environment.

Underlying Base Objects

The view's SQL text is a thin projection over a single underlying table:

• IGF_SL_CL_RESP_R8_ALL — aliased as RESP8, the "All" (multi-org) table that stores FFELP disbursement response records at the R8 (disbursement response) level in the CommonLine/FFELP response hierarchy.

The definition is a straightforward SELECT ... FROM IGF_SL_CL_RESP_R8_ALL RESP8 WITH READ ONLY. No joins, unions, or subqueries are present. The _ALL suffix signals that the table is organization-striped, so in a deployed environment the view would typically resolve to the operating-unit-filtered synonym for the table. The ETRM metadata for 12.2.2 documents no additional referenced base objects, confirming the one-to-one relationship between the view and IGF_SL_CL_RESP_R8_ALL.

Key Columns

The view exposes a defined column list that largely renames table columns to business-friendly labels:

• RESP_DISBURSEMENT_DATE — actual disbursement date from the response (source DISB_DATE).
• RESP_DISBURSEMENT_GROSS_AMT — gross disbursement amount (DISB_GROSS_AMT).
• RESP_ORIGINATION_FEE and RESP_GUARANTEE_FEE — fees assessed at origination and by the guarantor.
• RESP_ORIGINATION_FEE_PAID and RESP_GUARANTEE_FEE_PAID — fee amounts actually paid.
• RESP_NET_DISBURSEMENT_AMT — net amount after fees (NET_DISB_AMT).
• "_LA:RESP_HOLD_RELEASE_IND" and "_LA:RESP_DISBURSEMNT_STATUS" — lookup-derived ("_LA:") columns whose display values are resolved via IGF_LOOKUPS_VIEW against IGF_SL_CL_DB_HOLD_REL_IND and IGF_SL_CL_DISB_STATUS respectively.
• RESP_RECORD_INTERNAL_STATUS — internal processing status of the response record.
• RESPONSE_PARENT_ID and RESP_DISBURSEMENT_NUMBER — linkage to the parent response and the disbursement sequence number.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — standard EBS audit columns.

Common Use Cases and Queries

Because the view is documented as obsolete and not implemented, practical usage is confined to historical data migration, upgrade analysis, or custom reporting against legacy 11i/12.1.x environments that still contain the object. A representative query is:

SELECT RESP_DISBURSEMENT_DATE, RESP_DISBURSEMENT_GROSS_AMT, RESP_NET_DISBURSEMENT_AMT, "_LA:RESP_DISBURSEMNT_STATUS" FROM IGFBV_FFELP_DISB_RESP_DETAILS WHERE RESPONSE_PARENT_ID = :p_response_id;

Typical scenarios include reconciling disbursed versus net amounts per response, auditing origination and guarantee fee recovery, and confirming hold-release status as returned by the servicer. In current 12.2.2 implementations, however, this functionality is superseded by later Financial Aid data models, and the object should be treated as read-only, historical reference metadata rather than an active integration point.