Results for “albw_id”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The IGF_SL_ALT_BORW_ALL table is a legacy Oracle E-Business Suite object belonging to the IGF (Financial Aid) product family, which is classified as obsolete in the ETRM reference for releases 12.1.1 and 12.2.2. The table stores supplementary borrower and co-signer information required when a student submits an Alternative Loan application, capturing the financial, demographic, and credit-related declarations needed for underwriting decisions. In the documented environment, the table is marked "Not implemented in this database," meaning it exists in the ETRM schema catalog with a defined structure of 89 columns owned by the IGF schema, but is not physically present in the surveyed installation. Its primary key, IGF_SL_ALT_BORW_ALL_PK, is defined on the ALBW_ID column, which is also the sole unique index (IGF_SL_ALT_BORW_ALL_U1) and therefore the only documented business-key candidate. Under the heuristic Data Vault classification mined from its foreign-key structure, this table leans toward a satellite: it holds descriptive, application-specific attributes keyed to a parent application record rather than acting as a standalone hub or a pure link between two hubs. Its single foreign key, LOAN_ID, references IGF_SL_LOANS_ALL, reinforcing the satellite interpretation.

Key Information Stored

The surrogate primary key is ALBW_ID, a system-generated identifier uniquely enforced by IGF_SL_ALT_BORW_ALL_PK and the unique index IGF_SL_ALT_BORW_ALL_U1. The parent reference is LOAN_ID, which joins each alternative-borrower record back to its loan application. The most significant columns fall into three groups:

• Borrower financial disclosures: FED_STAFFORD_LOAN_DEBT, FED_SLS_DEBT, HEAL_DEBT, PERKINS_DEBT, OTHER_DEBT, OTHER_LOAN_AMT, BORW_GROSS_ANNUAL_SAL, and BORW_OTHER_INCOME. These capture outstanding educational debt by program and the borrower's declared income.
• Borrower expense and academic profile: STUDENT_MAJOR, INT_RATE_OPT, REPAYMENT_OPT_CODE, STUD_MTH_HOUSING_PYMT, STUD_MTH_CRDTCARD_PYMT, STUD_MTH_AUTO_PYMT, STUD_MTH_ED_LOAN_PYMT, and STUD_MTH_OTHER_PYMT. These support rate selection, repayment-plan eligibility, and monthly obligation analysis.
• Co-signer records (CS1 and CS2): Two parallel column sets, including CS1_LNAME, CS1_FNAME, CS1_SSN_TXT, CS1_CITIZENSHIP_STATUS, CS1_CREDIT_AUTH_CODE_TXT, CS1_GROSS_ANNUAL_SAL_NUM, CS1_REL_TO_STUDENT_FLAG, CS1_ELECT_SIG_IND_CODE_TXT, CS1_BIRTH_DATE, and the CS2 equivalents. These hold identity, address, signature, and financial data for up to two co-signers.

Standard EBS WHO columns (ORG_ID, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE) are also present to support multi-organization security and concurrent-program auditing.

Common Use Cases and Queries

Because the table is obsolete and not implemented, practical use arises primarily during historical data migration, archival reporting, or investigations of legacy financial-aid integrations. A typical query joins the alternative-borrower rows to the parent loan and filters to a specific applicant:

• Loan application detail extraction: SELECT a.ALBW_ID, a.LOAN_ID, a.BORW_GROSS_ANNUAL_SAL, a.FED_STAFFORD_LOAN_DEBT FROM IGF_SL_ALT_BORW_ALL a, IGF_SL_LOANS_ALL l WHERE a.LOAN_ID = l.LOAN_ID AND a.LOAN_ID = :loan_id;
• Co-signer verification: selecting CS1_* and CS2_* columns to confirm identity, credit authorization, and e-signature indicators for underwriting review.
• Debt-to-income aggregation: summing the educational-debt columns (FED_STAFFORD_LOAN_DEBT, FED_SLS_DEBT, HEAL_DEBT, PERKINS_DEBT, OTHER_DEBT) against BORW_GROSS_ANNUAL_SAL and BORW_OTHER_INCOME to reproduce legacy credit-decision inputs.
• Audit and change tracking: filtering on LAST_UPDATE_DATE, LAST_UPDATED_BY, and REQUEST_ID to trace which concurrent program modified a borrower record.

Related Objects

The documented foreign-key relationship anchors this table to the alternative-loan application hierarchy:

• IGF_SL_LOANS_ALL — parent table; join on IGF_SL_ALT_BORW_ALL.LOAN_ID = IGF_SL_LOANS_ALL.LOAN_ID. This is the sole documented foreign key.
• IGF_SL_ALT_BORW_ALL_PK / IGF_SL_ALT_BORW_ALL_U1 — primary-key constraint and unique index on ALBW_ID, used to enforce row uniqueness.
• Other IGF_SL_LOANS_ALL child tables — sibling satellite tables (e.g., loan status and disbursement records) that share the LOAN_ID parent key and are typically queried alongside this table for a complete application picture.
• IGF Financial Aid APIs and concurrent programs — legacy loan-processing and data-conversion routines that insert into or extract from this table during the alternative-loan application lifecycle.

Consultants should treat any reference to IGF_SL_ALT_BORW_ALL as obsolete: validate physical existence before writing queries, and route current requirements toward the supported financial-aid or third-party loan-integration objects.