Search Results rec_type_ind




Overview
Explore in AI Chat

Overview

APPS.IGFFV_ALT_ORIG_RESPONSES is a reporting view in the Oracle E-Business Suite Financial Aid module (IGF), specifically within the Student Loan alternative loan processing area. The view consolidates the original response data submitted by a borrower and any associated cosigners (or endorsers) on an alternative student loan application. It is used primarily for downstream reporting, form/letter generation, and integration with external lenders and guarantee agencies where a denormalized, flat representation of the borrower's and cosigners' financial and demographic data is required.

The "ALT_ORIG" naming prefix denotes "Alternative Loan Origination," and "RESPONSES" refers to the applicant-supplied responses captured during the alternative loan application flow. The view is designed to present these responses in a form suitable for external transmission (e.g., to a lender's underwriting system) or for internal review and audit. The rec_type_ind column referenced in typical use distinguishes record categories within the flattened response structure, allowing consumers of the view to filter borrower-level versus cosigner-level records where the model supports such differentiation.

Underlying Base Objects

The view is defined entirely as a single-table projection over IGF_AP_ALT_ORIG_RESPONSES (aliased as RESP4 in the view text). No joins to other base tables are documented in the view definition itself. Instead, the view embeds lookup-resolution logic through string-based directives such as '_LA:RESP4.CRDT_UNDR_DIFFT_NAME:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING', which instruct the consuming application layer to resolve coded values into descriptive meanings using the IGF_LOOKUPS_VIEW. Similar directives resolve the interest rate option and repayment option codes via the IGF_SL_ALT_INT_RATE_OPTION and IGF_SL_ALT_REPAY_OPTION lookup types. This design means that although the ETRM metadata documents no referenced base objects, functionally the view depends on IGF_AP_ALT_ORIG_RESPONSES for its data and on the lookup infrastructure for decoded values.

Key Columns

Common Use Cases and Queries

The view is typically queried to extract a complete application snapshot for a given loan number, or filtered by rec_type_ind to isolate the relevant record category.

  • Extracting full borrower and cosigner detail for lender transmission.
  • Reviewing declared debt and income for underwriting or audit.
  • Resolving coded options (yes/no, interest rate option, repayment option) into display meanings.

Sample query:

SELECT LOAN_NUMBER, BORW_GROSS_ANNUAL_SAL, COSNR_1_LAST_NAME,
       COSNR_1_SSN, INT_RATE_OPT, REPAYMENT_OPT_CODE
FROM   APPS.IGFFV_ALT_ORIG_RESPONSES
WHERE  LOAN_NUMBER = :p_loan_number;

To isolate records by type where the model distinguishes them, a consumer would add a predicate on rec_type_ind (for example, to select only borrower or only cosigner response rows) consistent with the codes returned by that column in the underlying IGF_AP_ALT_ORIG_RESPONSES table.