Search Results license_state

Overview

IGF_SL_PLUS_BORW_V is a database view historically associated with the Oracle E-Business Suite IGF – Financial Aid product family, specifically the Student Loan (SL) subsystem. In the ETRM metadata for Release 12.2.2, the object is classified as Obsolete, and the implementation notes state that it is not implemented in this database. This designation means that the view is retained only as legacy documentation metadata; it is not deployed in a standard 12.1.1 or 12.2.2 installation and should not be relied upon by custom reports, concurrent programs, or integrations built on those releases.

Functionally, the view presented a denormalized, read-only projection of Borrower/Lender demographic and eligibility data. Its purpose in the original Financial Aid design was to expose a single flat row per borrower record so that downstream loan processing, need-analysis, or export routines could retrieve personal identification, residency, and citizenship attributes without joining multiple tables directly. Because the object is obsolete, its principal value today is as a reference artifact for understanding historical data models and for migration or archival analysis of legacy Financial Aid installations.

Underlying Base Objects

The ETRM metadata documents the view as defined over a single base table:

• IGF_SL_PLUS_BORW — the borrower/PLUS loan detail table supplying every column selected by the view, aliased as PLBW in the view text.

Note that the documented metadata records no formal base-object dependency list (“Referenced base objects: none documented”), and no owner is recorded. The view text, however, clearly performs a simple SELECT … FROM IGF_SL_PLUS_BORW PLBW with no joins, filters, or aggregations. It therefore functions as a straight column-projection view rather than a transformation or consolidation layer. Because it inherits all rows from the base table, any row-level security, organization, or business-group filtering would have to be applied externally by the calling report or query.

Key Columns

The view exposes fourteen columns, all sourced directly from IGF_SL_PLUS_BORW:

• ROW_ID — the ROWID of the underlying base-table row, providing a physical row identifier.
• PERSON_ID — the party/person identifier linking the borrower to the Oracle HR or TCA person model.
• LICENSE_NUM and LICENSE_STATE — driver licence or state identification number and issuing state.
• CITIZENSHIP_STATUS — the borrower’s citizenship classification, the attribute most frequently searched against this object.
• ALIEN_REG_NUM — alien registration number for non-citizen borrowers.
• STATE_OF_LEGAL_RES and LEGAL_RES_DATE — state of legal residence and the date legal residency was established.
• BORR_AUTH_CODE — borrower authorization code used in loan processing.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN, as generated by the EBS WHO column convention.

Common Use Cases and Queries

In legacy 11i and early 12.x Financial Aid environments, the view supported borrower eligibility review, PLUS loan demographic verification, and ad hoc citizenship/residency reporting. Typical access patterns included person-level lookups and citizenship-based counts. Because the object is obsolete in 12.2.2, any query should first verify object existence before execution; the following illustrates the documented projection pattern:

• SELECT borw.person_id, borw.citizenship_status, borw.state_of_legal_res, borw.legal_res_date FROM igf_sl_plus_borw_v borw WHERE borw.citizenship_status = :p_status;
• SELECT borw_person_id, borw.license_num, borw.license_state FROM igf_sl_plus_borw_v WHERE person_id = :p_person_id;
• SELECT citizenship_status, COUNT(*) FROM igf_sl_plus_borw_v GROUP BY citizenship_status;

For reporting on supported releases, equivalent borrower attributes should be sourced from the currently maintained Financial Aid tables or replaced by the successor objects identified during upgrade analysis.