Search Results igf_sl_alt_repay_option

Overview

IGF_SL_ALT_BORW_V is a reporting view in the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 environments owned by the Financial Aid module under the IGF (International Government Financial aid / Student Loan) schema. It exposes borrower-level alternative loan data — that is, private or non-federal student loans processed alongside Title IV aid — in a flattened, display-ready form. The view is primarily consumed by Oracle Reports, OBIEE/BIPublisher extracts, and custom PL/SQL that needs descriptive lookups already resolved, rather than raw coded values. Because the view joins borrower demographic, credit, and monthly expense data onto the loan record, it serves as a single source for alternative loan certifications, promissory note generation, and lender reporting.

Underlying Base Objects

The documented metadata does not enumerate a base table list for the view; the view text references a single driving alias, ALBWV (a borrower sub-view such as IGF_SL_ALT_BORW), which supplies all borrower and loan columns. The view is therefore a thin wrapper that exposes the columns of that borrower source and augments them with decoded descriptions. Three lookups are resolved through the helper function IGF_AW_GEN.LOOKUP_DESC: IGF_SL_ALT_INT_RATE_OPTION for the interest-rate option, IGF_SL_ALT_REPAY_OPTION for the repayment option, and IGF_AP_YES_NO for the credit-under-different-name flag. The presence of REQUEST_ID, PROGRAM_ID, and PROGRAM_APPLICATION_ID confirms the underlying record is populated through a concurrent program in the standard EBS who-columns pattern.

Key Columns

• ALBW_ID / LOAN_ID / ROW_ID — Primary identifiers linking the alternative borrower record to its loan and row.
• Debt fields — FED_STAFFORD_LOAN_DEBT, FED_SLS_DEBT, HEAL_DEBT, PERKINS_DEBT, OTHER_DEBT capture existing federal and other indebtedness.
• CRDT_UNDR_DIFFT_NAME — A Y/N flag decoded via IGF_AP_YES_NO; it drives the "credit underwritten under a different name" logic used to confirm the search term relating to igf_ap_yes_no.
• Income fields — BORW_GROSS_ANNUAL_SAL, BORW_OTHER_INCOME, STUDENT_MAJOR.
• Decoded options — INT_RATE_OPT and REPAYMENT_OPT_CODE supplied alongside their LOOKUP_DESC descriptions.
• Monthly expenses — STUD_MTH_HOUSING_PYMT, STUD_MTH_CRDTCARD_PYMT, STUD_MTH_AUTO_PYMT, STUD_MTH_ED_LOAN_PYMT, STUD_MTH_OTHER_PYMT.
• Cosigner (CS1/CS2) attributes — Name, SSN, citizenship, mailing address, telephone, signature code, credit authorization, birth date, driver's license, and the CS1 monthly expense/income numeric fields.

Common Use Cases and Queries

Typical scenarios include alternative-loan eligibility review, promissory note and disclosure production, and cosigner validation. A simple query returning decoded option descriptions and the yes/no credit flag:

SELECT LOAN_ID,
       CRDT_UNDR_DIFFT_NAME,
       IGF_AW_GEN.LOOKUP_DESC('IGF_AP_YES_NO', CRDT_UNDR_DIFFT_NAME) YES_NO_DESC,
       INT_RATE_OPT, REPAYMENT_OPT_CODE
FROM   APPS.IGF_SL_ALT_BORW_V
WHERE  LOAN_ID = :p_loan_id;

For debt and expense aggregation across a borrower population, select the debt and monthly payment columns directly. Joins to IGF loan master tables on LOAN_ID are common when reconciling to disbursement records.