Search Results resp_record_status




Overview
Explore in AI Chat

Overview

APPS.IGFBV_FFELP_DISB_RESP_DETAILS is a read-only reporting view in the Oracle E-Business Suite Financial Aid module. It exposes Federal Family Education Loan Program (FFELP) disbursement response detail records, providing a flattened, translated projection of loan disbursement activity returned from the Common Origination and Disbursement (COD) process. The view is part of the IGFBV ("Information Gateway Business View") family, which is designed for downstream reporting, extraction, and integration scenarios rather than online transactional maintenance.

The view is defined with the WITH READ ONLY clause, confirming its role as a query-only construct. All columns are drawn from a single source object, and no joins, aggregations, or filters are applied. This makes the view a thin, focused projection over the disbursement response detail table, optimized for direct consumption by reports, concurrent programs, and external interfaces.

The user's search term, resp_record_status, corresponds to the RESP_RECORD_STATUS column exposed by this view. This is a key disposition indicator for each response detail row, and it is one of the most frequently queried attributes.

Underlying Base Objects

The view is defined over a single documented base object: IGF_SL_CL_RESP_R8_ALL (aliased as RESP8). No additional base tables or joined objects are documented in the ETRM metadata. The naming convention of the base table suggests it belongs to the IGF schema's Student Loan (SL) set of tables, with the _R8 suffix indicating the response detail structure associated with the R8 loan response record layout.

Because the view performs no joins, its columns map one-to-one to columns of IGF_SL_CL_RESP_R8_ALL, with two important exceptions: two columns are replaced by lookup-derived expressions, and the remaining columns are passed through unchanged. The _ALL suffix on the base table further indicates it operates within a multi-org or partition-aware data model, consistent with Oracle EBS conventions for student loan records.

Key Columns

The columns exposed by the view fall into several functional groups:

  • Disbursement financial attributes: DISB_GROSS_AMT, NET_DISB_AMT, ORIG_FEE, GUARANTEE_FEE, ORIG_FEE_PAID, and GUARNT_FEE_PAID capture the gross disbursement, net disbursement, and the various origination and guarantee fee amounts assessed or collected.
  • Disbursement timing: DISB_DATE records the effective disbursement date for the response detail.
  • RESP_RECORD_STATUS: This is the column referenced in the user's search. It records the status of the response record itself, distinguishing, for example, accepted, rejected, or pending response details as returned from the COD processing cycle. It is central to identifying which response rows require further action or reconciliation.
  • Translated lookup columns: The two expression columns beginning with _LA: resolve the coded values DISB_HOLD_REL_IND (disbursement hold release indicator) and DISB_STATUS (disbursement status) into their human-readable meanings via IGF_LOOKUPS_VIEW, using the lookup types IGF_SL_CL_DB_HOLD_REL_IND and IGF_SL_CL_DISB_STATUS respectively. This removes the need for callers to join the lookup view manually.
  • Related identifiers: CLRP1_ID and CLRP8_ID provide linkage to associated loan or response parent records.
  • Audit columns: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, and LAST_UPDATE_DATE support standard EBS audit and incremental extraction patterns.

Common Use Cases and Queries

The primary use cases for this view are COD response reconciliation and financial aid disbursement reporting. Typical applications include identifying response records that have not yet been processed, reconciling gross-to-net disbursement amounts, and producing extracts for downstream financial systems.

The following query retrieves all response detail rows with their interpreted disbursement status, ordered by disbursement date and status — a common reconciliation pattern:

  • SELECT disb_date, disb_gross_amt, net_disb_amt, disb_status, resp_record_status, clrp1_id, clrp8_id
  • FROM apps.igfbv_ffelp_disb_resp_details
  • WHERE resp_record_status = 'A'
  • ORDER BY disb_date, disb_status;

A second common pattern filters to pending response records requiring action:

  • SELECT disb_date, disb_gross_amt, orig_fee, guarantee_fee, disb_hold_rel_ind
  • FROM apps.igfbv_ffelp_disb_resp_details
  • WHERE resp_record_status IS NULL
  • AND disb_hold_rel_ind = 'Y';

Because the view is read-only and pre-joins the lookup translations for hold release and disbursement status, it is well suited to report queries and integration extracts. Consumers should note that RESP_RECORD_STATUS is passed through as a raw coded value and is not translated by the view; callers requiring the status description must resolve it against the appropriate lookup independently.