Results for “igf_sl_dl_pnote_s_p”

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

Overview

IGF_SL_DL_PNOTE_S_P is a secured Oracle EBS view within the IGF (Financial Aid) product family, historically associated with the Student Loan disbursement and promissory note processing sub-ledger. In the EBS 12.1.1 and 12.2.2 releases, the view is documented in the E-Business Tax/ETRM reference metadata as part of the Financial Aid module, which Oracle has since marked Obsolete. The "_S_P" suffix follows the standard Oracle multi-organization security convention: the "_S" denotes a security-enabled view and the "_P" denotes the operational, non-"_ALL" projection that applies an operating unit (ORG_ID) filter based on the session's CLIENT_INFO context.

The view exposes promissory note header and demographic data for a student borrower, including loan identifiers, SSN, name, date of birth, license information, permanent address, email, phone, and standard EBS audit and program columns. It is used for reporting, concurrent program processing, and integration extraction where a promissory note must be joined to a loan record within the currently selected operating unit.

Underlying Base Objects

Per the documented view text, IGF_SL_DL_PNOTE_S_P is defined over a single base object: IGF_SL_DL_PNOTE_S_P_ALL. No additional base tables are documented in the ETRM metadata; joins to loan, person, or organization entities are implied through the stored identifiers (LOAN_ID, PERSON_ID, ORG_ID) rather than through explicit SQL joins in the view definition. Because the underlying table is the "_ALL" variant, the view inherits multi-org data and applies row-level filtering at query time.

The WHERE clause enforces the operating unit restriction by comparing the row's ORG_ID to the value parsed from USERENV('CLIENT_INFO'). When CLIENT_INFO is empty or the first character is a space, the expression evaluates to -99, matching rows whose ORG_ID is null or -99. This is the classic Multi-Org secured view pattern used throughout EBS 11i, 12.1.1, and 12.2.2.

Key Columns

• ROW_ID – the ROWID of the underlying base row, used for direct row-based DML or navigation.
• PNSP_ID – primary key of the promissory note record.
• BATCH_SEQ_NUM / LOAN_ID / LOAN_NUMBER – identifiers tying the note to a disbursement batch and a specific loan.
• PERSON_ID – foreign key to the person/party record.
• S_SSN, S_FIRST_NAME, S_LAST_NAME, S_MIDDLE_NAME, S_DATE_OF_BIRTH – borrower demographic attributes.
• S_LICENSE_NUM, S_LICENSE_STATE – driver's license verification data.
• S_PERMT_ADDR1/2, S_PERMT_CITY, S_PERMT_STATE, S_PERMT_ZIP – permanent address of the borrower.
• S_EMAIL_ADDR, S_PHONE – contact information.
• STATUS – processing status of the promissory note.
• ORG_ID – operating unit identifier driving the security predicate.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN – standard auditing columns.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE – concurrent program tracking columns.

Common Use Cases and Queries

Typical usage occurs in financial-aid reporting and integration jobs that must extract promissory note details for the active operating unit. A representative query retrieves all notes for a given loan:

SELECT PNSP_ID, LOAN_NUMBER, S_LAST_NAME, S_FIRST_NAME,
       S_SSN, STATUS, ORG_ID
  FROM IGF_SL_DL_PNOTE_S_P
 WHERE LOAN_ID = :p_loan_id;

Because the view does not join person or loan master tables, reporting solutions frequently join to PER_ALL_PEOPLE_F (via PERSON_ID) or the corresponding loan table (via LOAN_ID) to enrich output. Analysts should note the view is documented as Obsolete and "Not implemented in this database" in the ETRM excerpt; any custom code depending on it should be reviewed before upgrade or migration, since Oracle no longer supports the IGF Financial Aid schema in later releases.