Search Results igf_sl_plus_borw_u1

Overview

The table IGF.IGF_SL_PLUS_BORW is a transaction-data table within the Oracle E-Business Suite Financial Aid (IGF) module. It stores borrower-specific attributes for PLUS loans — a category of U.S. federal student aid extended to parents and graduate/professional students. The table supplements the core person record held in Oracle's Trading Community Architecture (TCA) by capturing the identity, residency, and authorization details that the loan origination process requires. The table resides in the APPS_TS_TX_DATA tablespace with a PCT Free of 10 and is designated with FND Design Data identification IGF.IGF_SL_PLUS_BORW, confirming it as a registered, supported database object rather than a custom artifact.

The object's status is VALID. Its heuristic Data Vault classification, mined from the foreign-key structure, is satellite-leaning. Because the table hangs off a single parent key (PERSON_ID referencing HZ_PARTIES) and holds descriptive, non-key attributes, it is best modeled as a satellite attached to a party hub. It should not itself be treated as a hub, since PERSON_ID is inherited rather than independently generated.

Key Information Stored

The table contains 13 documented columns. The surrogate primary key and unique business-key candidate coincide: the unique index IGF_SL_PLUS_BORW_U1 enforces uniqueness on PERSON_ID in the APPS_TS_TX_IDX tablespace. This confirms a strict one-row-per-borrower cardinality.

• PERSON_ID — NUMBER(15), mandatory. The party identifier linking the PLUS borrower to the TCA party model and acting as both primary key and unique index column.
• LICENSE_NUM — VARCHAR2(60). The driver's license number of the PLUS borrower.
• LICENSE_STATE — VARCHAR2(30). The issuing state of that license.
• CITIZENSHIP_STATUS — VARCHAR2(30). U.S. citizen, eligible non-citizen, or ineligible non-citizen.
• ALIEN_REG_NUM — VARCHAR2(30). Passport number or alien registration number.
• STATE_OF_LEGAL_RES — VARCHAR2(30). State of legal residence.
• LEGAL_RES_DATE — DATE. Date the borrower became a legal resident of that state.
• BORR_AUTH_CODE — VARCHAR2(30). Code for borrower authorization.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard Who columns providing audit lineage.

Common Use Cases and Queries

The primary use case is eligibility verification and PLUS loan origination. Financial aid administrators query this table to validate citizenship, residency, and identification before packaging an award, and reporting teams extract it for compliance and audit reporting.

A typical lookup retrieves a borrower's attributes by party:

SELECT PERSON_ID, CITIZENSHIP_STATUS, LICENSE_NUM,
       STATE_OF_LEGAL_RES, LEGAL_RES_DATE
FROM   IGF.IGF_SL_PLUS_BORW
WHERE  PERSON_ID = :p_person_id;

Reporting use cases include aggregating borrowers by citizenship status or legal residence state, and joining to HZ_PARTIES to reconcile borrower identity against the party registry. Because PERSON_ID is the sole key, any query joining to borrower-level award or disbursement data should use this column as the driving predicate.

Related Objects

• HZ_PARTIES — joined via IGF_SL_PLUS_BORW.PERSON_ID = HZ_PARTIES.PARTY_ID; the sole documented foreign-key relationship.
• IGF_SL_PLUS_BORW_PK — the primary-key constraint (PERSON_ID).
• IGF_SL_PLUS_BORW_U1 — the unique index on PERSON_ID enforcing the satellite cardinality.
• APPS.IGF_SL_PLUS_BORW — the APPS synonym, the standard access path for application code.

The object references no other database objects, keeping its dependency footprint narrow and its role focused on borrower-attribute storage.