Search Results flu_cert_amt




Overview
Explore in AI Chat

Overview

IGF_SL_CL_RESP_R1 is a database view delivered within the Oracle E-Business Suite IGF (Financial Aid) module. The ETRM metadata classifies it under the product heading "IGF - Financial Aid (Obsolete)" and records the description field as empty, indicating that the object carries no formal descriptive narrative in the data dictionary. The view belongs to the Student Loan (SL) family of financial aid objects, as reflected in the "SL_CL" naming segment, which corresponds to the CommonLine loan response and origination processing area of the legacy financial aid subsystem.

Its functional purpose is to denormalize and expose the borrower, student, school, lender, and guarantor data captured on a CommonLine loan response record (the CLRESPR1 structure) in a single flat row suitable for reporting, extract generation, and downstream integration with loan servicing or guarantee agencies. Because the object is flagged as obsolete, it is retained only for backward compatibility and historical reference in EBS 12.1.1 and 12.2.2 environments where the older financial aid schemas were still present. The searched term "act_interest_rate" does not correspond to any column documented in the available view text, and readers should treat that string as unverified against this object.

Underlying Base Objects

The ETRM view metadata records no referenced base objects, and the documented implementation note states "Not implemented in this database." This means the view's dependency chain is not registered in the data dictionary copy consulted, and the object may not exist at all in the instance from which the metadata was harvested. The view text, however, makes the primary source explicit: every projected column is qualified with the alias CLRESPR1, so the view is defined over a single underlying table or structure named CLRESPR1, with an additional implicit dependency on the ROWID pseudo-column for the ROW_ID expression.

Because no base objects are documented, join paths cannot be asserted from the metadata alone. The base structure represented by CLRESPR1 stores one row per CommonLine response record, with a surrogate key CLRP1_ID and a related identifier CBTH_ID. Practically, any use of this view should begin with a dependency verification query against the database before it is embedded in a report.

Key Columns

Common Use Cases and Queries

Typical scenarios include reconciliation of certified versus approved loan amounts, borrower/student match reviews, and extracts destined for guarantee agencies. A representative query is:

SELECT ROW_ID, LOAN_NUMBER, B_LAST_NAME, B_FIRST_NAME,
       CL_LOAN_TYPE, REQ_LOAN_AMT,
       FLS_CERT_AMT, FLS_APPROVED_AMT,
       GUARANTEE_DATE, GUARANTEE_AMT
  FROM IGF_SL_CL_RESP_R1
 WHERE REC_TYPE_IND = :p_rec_type
   AND SCHOOL_ID = :p_school_id;

For aggregation by loan component:

SELECT CL_LOAN_TYPE,
       SUM(NVL(FLS_CERT_AMT,0) + NVL(FLU_CERT_AMT,0)
           + NVL(FLP_CERT_AMT,0) + NVL(ALT_CERT_AMT,0)) CERT_TOTAL
  FROM IGF_SL_CL_RESP_R1
 GROUP BY CL_LOAN_TYPE;

The absence of any documented interest-rate column should be noted explicitly; queries referencing "act_interest_rate" will not resolve against this view.