Search Results igf_sl_alt_borw_v

Overview

The view IGF_SL_ALT_BORW_V belongs to the IGF — Financial Aid product family in Oracle E-Business Suite, a module now classified as Obsolete within the ETRM reference catalog. Its documented purpose is to store and expose alternate loan details for a student borrower, consolidating information that supplements the primary loan record. The view surfaces borrower financial obligations, income data, repayment preferences, and detailed cosigner attributes in a single denormalized projection.

In Oracle EBS 12.1.1 and 12.2.2 environments where student financial aid functionality was licensed and deployed, this view served as a reporting and integration layer over the alternate borrower tables. It allows downstream processes — loan certification, needs analysis, and lender interfaces — to retrieve a borrower's complete alternate loan picture without navigating multiple base tables. The ETRM entry explicitly records that the view is not implemented in this database, confirming it exists only in installations where the IGF Financial Aid module was previously configured. In current 12.2.2 instances the object is retained as legacy metadata.

Underlying Base Objects

The ETRM metadata documents no referenced base objects for this view, and the owner is unspecified. This is consistent with its Obsolete classification: the underlying tables (an alternate borrower table suffixed _ALBW and its related loan detail tables) are no longer maintained in the data dictionary snapshot. The view text confirms it is defined over an alias ALBWV, indicating a single primary alternate borrower source joined implicitly with supporting lookup and amount calculations.

Notable derived expressions include calls to IGF_AW_GEN.LOOKUP_DESC for code translation and a computed column OTHER_LOAN_AMT, which is not a stored attribute but is assembled within the view definition. Because the base tables are undocumented in ETRM 12.2.2, DBAs should treat any reverse-engineering from the view text as advisory rather than authoritative.

Key Columns

• ROW_ID, ALBW_ID, LOAN_ID — Primary identifiers linking the alternate borrower record to its parent loan.
• FED_STAFFORD_LOAN_DEBT, FED_SLS_DEBT, HEAL_DEBT, PERKINS_DEBT, OTHER_DEBT — Outstanding debt exposures by federal and institutional program.
• BORW_GROSS_ANNUAL_SAL, BORW_OTHER_INCOME — Borrower income inputs used in creditworthiness and needs assessment.
• INT_RATE_OPT, REPAYMENT_OPT_CODE — Encoded interest rate and repayment selections, each translated to a description via LOOKUP_DESC against the IGF_SL_ALT_INT_RATE_OPTION and IGF_SL_ALT_REPAY_OPTION lookups.
• STUD_MTH_*_PYMT — Monthly housing, credit card, auto, education loan, and other payment obligations.
• CS1_* and CS2_* — Two full cosigner blocks (name, SSN, address, citizenship, telephone, signature and credit authorization codes, birth date, driver's license data, and gross annual salary).
• Audit and concurrency columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, supporting standard EBS audit and request tracking.

Common Use Cases and Queries

Typical usage centered on retrieving alternate borrower profiles for loan processing and reporting. A representative query selects financial and cosigner data for a given loan:

• SELECT loan_id, borw_gross_annual_sal, repayment_opt_code FROM igf_sl_alt_borw_v WHERE loan_id = :loan_id;
• SELECT albw_id, cs1_lname, cs1_ssn_txt, cs2_lname FROM igf_sl_alt_borw_v WHERE albw_id = :id;
• SELECT loan_id, int_rate_opt, fed_stafford_loan_debt, perkins_debt FROM igf_sl_alt_borw_v ORDER BY loan_id;

Given the view's Obsolete status, queries remain valid only for archival or migration purposes. New development should not depend on it, and any integration points referencing IGF_SL_ALT_BORW_V in 12.1.1 or 12.2.2 should be reviewed for replacement or retirement.