Search Results igf_sl_plus_borw_pk

Overview

The IGF_SL_PLUS_BORW table resides in the IGF schema (IGF – Financial Aid module) and is documented in the Oracle E-Business Suite Electronic Technical Reference Manual as Obsolete. It historically served as a student-level satellite holding supplemental borrower and residency attributes associated with a person record in the Student Loan processing area of Oracle Financial Aid. In Oracle EBS 12.1.1 and 12.2.2 the object is retained in the data dictionary with a VALID status, but it is no longer maintained by current application code and should be treated as a legacy or archival structure.

From a Data Vault modeling perspective, the documented heuristic classification is satellite-leaning. This is consistent with the physical design: the table is keyed on a single PERSON_ID column that doubles as the primary key (IGF_SL_PLUS_BORW_PK) and as a foreign key to HZ_PARTIES, meaning it decorates an existing party/business key with descriptive, time-variant attributes rather than introducing a new hub or resolving a many-to-many link. The relationship to HZ_PARTIES confirms that the table cannot exist independently of a registered party record.

Key Information Stored

The documented physical schema contains thirteen columns. The most significant are:

• PERSON_ID – Surrogate primary key and the foreign key to HZ_PARTIES. It uniquely identifies the party whose supplemental loan data is stored; it is also the sole business-key candidate via the unique index IGF_SL_PLUS_BORW_U1.
• LICENSE_NUM and LICENSE_STATE – Borrower driver's license or state identification number and the issuing state, used for identity verification in loan certification.
• CITIZENSHIP_STATUS – Eligibility-relevant classification of the borrower's citizenship or eligible non-citizen status.
• ALIEN_REG_NUM – Alien registration number captured for non-citizen borrowers.
• STATE_OF_LEGAL_RES and LEGAL_RES_DATE – State of legal residence and the effective date used in residency and need-analysis determinations.
• BORR_AUTH_CODE – Borrower authentication or authorization code used in loan processing workflows.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN – Standard EBS WHO-column audit trail describing record provenance and change history.

The surrogate key and the business key coincide here; there is no separate sequence-driven identifier, so PERSON_ID must be sourced from the party model.

Common Use Cases and Queries

Because the object is obsolete, current reporting typically draws from successor Financial Aid tables. Typical patterns remain useful for migration or data-archive validation. A join to the party model confirms orphan detection:

• Orphan / integrity check: SELECT b.PERSON_ID FROM IGF_SL_PLUS_BORW b LEFT JOIN HZ_PARTIES p ON b.PERSON_ID = p.PARTY_ID WHERE p.PARTY_ID IS NULL;
• Residency reporting: aggregate counts by STATE_OF_LEGAL_RES and LEGAL_RES_DATE for historical need-analysis extracts.
• Change auditing: filter on LAST_UPDATE_DATE and LAST_UPDATED_BY to identify the last maintenance window before deprecation.
• Citizenship/eligibility extracts: select CITIZENSHIP_STATUS, ALIEN_REG_NUM, and LICENSE_STATE for legacy Title IV reconciliation.

Related Objects

• HZ_PARTIES – Referenced via IGF_SL_PLUS_BORW.PERSON_ID; the parent party record supplying the identity context.
• HZ_PERSON_PROFILES – Companion party-extension supplying additional person attributes.
• IGF_SL_PLUS_BORW_PK / IGF_SL_PLUS_BORW_U1 – Primary key and unique index enforcing uniqueness on PERSON_ID.
• IGF student loan award and disbursement tables – Downstream Financial Aid objects that historically consumed borrower residency and citizenship attributes.
• FND standard WHO columns – Audit metadata inherited by the table.

Given its obsolete classification, reference this table only for historical reconciliation; new development should target the current Financial Aid student-loan data model.