Search Results second_csgnr_elec_sign_flag

Overview

IGF_SL_CL_RESP_R4 is an Oracle EBS 12.1.1 / 12.2.2 view owned by the APPS schema within the IGF (Financial Aid) product family. It exposes credit-report style respondent data used in the Federal Stafford, Supplemental Loans for Students (SLS), HEAL, Perkins, and alternative loan processing flows. The view presents one row per credit response record, keyed by CLRP1_ID and LOAN_NUMBER, and surfaces borrower financial attributes, repayment election preferences, debt schedules, and up to two co-signer records. Its primary role is to provide a read-only, reporting-friendly projection over the underlying IGF_SL_CL_RESP_R4_ALL base table, allowing credit-evaluation and loan-certification programs to query consolidated respondent data without duplicating join logic across modules.

Underlying Base Objects

The documented view text identifies a single base object: IGF_SL_CL_RESP_R4_ALL (aliased CLRP4). No additional base tables are documented in the ETRM metadata, indicating this is a fairly straightforward single-table projection rather than a denormalized join view. The defining query includes a predicate on ORG_ID — typically NVL(CLRP4.ORG_ID, ...) — which imposes multi-org security filtering so that only records relevant to the operating unit context are returned. Because the view exposes ROWID in its select list, it is primarily intended for read-only reporting rather than DML. Referenced base objects are not separately documented in the 12.2.2 metadata snapshot, so integrators should treat IGF_SL_CL_RESP_R4_ALL as the authoritative source.

Key Columns

The columns fall into several functional groups:

• Identity and loan linkage: CLRP1_ID, LOAN_NUMBER, ORG_ID — the record key and operating unit.
• Debt and income: FED_STAFFORD_LOAN_DEBT, FED_SLS_DEBT, HEAL_DEBT, PERKINS_DEBT, OTHER_DEBT, OTHER_LOAN_AMT, BORW_GROSS_ANNUAL_SAL, BORW_OTHER_INCOME — borrower obligations and earning capacity.
• Repayment election: REPAYMENT_OPT_CODE — the borrower's selected repayment plan option (the search term for this article), paired with INT_RATE_OPT for interest-rate election.
• Monthly expense profile: STUD_MTH_HOUSING_PYMT, STUD_MTH_CRDTCARD_PYMT, STUD_MTH_AUTO_PYMT, STUD_MTH_ED_LOAN_PYMT, STUD_MTH_OTHER_PYMT — used in debt-to-income calculations.
• Co-signer attributes: COSNR_1_* and COSNR_2_* families covering name, SSN, citizenship, address, income, DOB, license, relationship, monthly obligations, and signature/authorization codes.
• Electronic signature: FIRST_CSGNR_ELEC_SIGN_FLAG, SECOND_CSGNR_ELEC_SIGN_FLAG.
• Alternate layout identifiers: ALT_LAYOUT_OWNER_CODE_TXT, ALT_LAYOUT_IDENTI_CODE_TXT, STUDENT_SCHOOL_PHONE_TXT.
• Standard WHO/audit columns: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE.

Common Use Cases and Queries

Typical use cases include credit decisioning reports, repayment-plan analysis, co-signer eligibility checks, and data extracts feeding external credit bureaus or downstream loan servicing systems. The REPAYMENT_OPT_CODE column is commonly filtered or grouped to assess plan election trends across borrowers.

SELECT LOAN_NUMBER,
       BORW_GROSS_ANNUAL_SAL,
       REPAYMENT_OPT_CODE,
       COSNR_1_LAST_NAME,
       COSNR_1_GROSS_ANL_SAL
  FROM APPS.IGF_SL_CL_RESP_R4
 WHERE ORG_ID = :p_org_id
   AND REPAYMENT_OPT_CODE IS NOT NULL;

A second scenario joins the view back to loan applicant records to compare monthly expense totals against income, and a third aggregates debt columns by REPAYMENT_OPT_CODE to feed portfolio-level dashboards. Because the view is org-striped by predicate, integrators must always bind ORG_ID to return correct multi-org data.