Search Results defer_req_code




Overview
Explore in AI Chat

Overview

APPS.IGFFV_FFELP_ORIG_RESPONSES is a reporting view in the Oracle E-Business Suite Financial Aid module (IGF). It exposes the original (origination) response records returned by the FFELP (Federal Family Education Loan Program) common origination and disbursement process. Each row represents a borrower or student response associated with a loan origination transaction, capturing demographic, eligibility, certification, guarantor, lender, and loan-period data as received or transmitted through the federal interface.

The view is read-only and intended for inquiry, reporting, and downstream integration rather than transactional entry. In EBS 12.1.1 and 12.2.2 the object resides in the APPS schema and is typically referenced by financial aid extracts, reconciliation reports, and audit queries that must reproduce the exact origination response payload. Because the view decodes many coded columns through inline lookup expressions (the _LA: prefixed tokens visible in the view text), consumers receive descriptive values such as lookup meanings rather than raw codes.

Underlying Base Objects

The ETRM metadata documents no referenced base objects for this view, and the definition is expressed as a SELECT over an aliased source (RESP1). That alias conventionally resolves to the FFELP origination response base table, with the view layering lookup decodes on top. The _LA:<column>:IGF_LOOKUPS_VIEW:<lookup_type>:MEANING constructs are Oracle lookup-attribute directives that resolve coded values against IGF lookup types such as IGF_SL_CITIZENSHIP_STAT, IGF_SL_P_DEFAULT_STATUS, IGF_SL_S_DEFAULT_STATUS, IGF_AP_GRADE_LEVEL, IGF_SL_CL_ENROL_STATUS, and IGF_SL_SERIAL_LOAN_CODE.

Because only the view text is documented, administrators should treat the base table as an implementation detail and query the view, not the underlying object, to remain insulated from structural changes across releases.

Key Columns

  • DEFER_REQ_CODE — the deferment request code returned on the origination response; a primary search term for this object and a key field for borrowers seeking in-school or economic-hardship deferment status.
  • REC_CODE, REC_TYPE_IND — record identification and response type indicator that classify the origination record.
  • B_* columns — borrower attributes: name, SSN, permanent address, phone, date of birth, citizenship status, state of legal residence, default status, and outstanding loan code.
  • S_* columns — student attributes: name, SSN, date of birth, citizenship and default status, and signature code.
  • CL_LOAN_TYPE, REQ_LOAN_AMT, LOAN_NUMBER, CL_SEQ_NUMBER — requested loan amount, loan type, and identifying loan number/sequence.
  • COA_AMT, EFC_AMT, EST_FA_AMT — cost of attendance, expected family contribution, and estimated financial assistance.
  • FLS/FLU/FLP_CERT_AMT and *_APPROVED_AMT — subsidized, unsubsidized, and PLUS certified and approved amounts.
  • LENDER_ID, GUARANTOR_ID, GUARANTEE_DATE, GUARANTEE_AMT — lender and guarantor identification and guarantee details.
  • LOAN_PER_BEGIN_DATE, LOAN_PER_END_DATE, ANTICIP_COMPL_DATE — loan period and anticipated completion dates.
  • Lookup-decoded columns — citizenship, default status, grade level, enrollment status, serial loan code, and promissory note delivery code, returned as lookup meanings.

Common Use Cases and Queries

Typical uses include reconciling origination responses, verifying deferment request codes, reviewing borrower/student eligibility data, and auditing certified versus approved amounts. A query targeting the search term follows:

  • SELECT REC_CODE, LOAN_NUMBER, CL_LOAN_TYPE, DEFER_REQ_CODE, REQ_LOAN_AMT, GUARANTEE_AMT FROM APPS.IGFFV_FFELP_ORIG_RESPONSES WHERE DEFER_REQ_CODE IS NOT NULL;
  • SELECT B_LAST_NAME, B_SSN, LOAN_NUMBER, CL_SEQ_NUMBER, LOAN_PER_BEGIN_DATE, LOAN_PER_END_DATE FROM APPS.IGFFV_FFELP_ORIG_RESPONSES WHERE LOAN_PER_BEGIN_DATE >= :p_start AND LOAN_PER_END_DATE <= :p_end;
  • SELECT LENDER_ID, GUARANTOR_ID, GUARANTEE_DATE, GUARANTEE_AMT FROM APPS.IGFFV_FFELP_ORIG_RESPONSES WHERE REC_TYPE_IND = :p_type;

Bind variables should be used in place of literals, and access is governed by the standard APPS schema grants and financial aid responsibility security.