Search Results igf_sl_dl_pnote_p_p_v

Overview

IGF_SL_DL_PNOTE_P_P_V is a reporting view in the Oracle E-Business Suite Financial Aid (IGF) module, owned by the APPS schema and holding VALID status in both 12.1.1 and 12.2.2. The view exposes data associated with Direct Loan promissory note processing, presenting loan-level and borrower-level attributes in a single flattened result set. Its primary purpose is to support the generation of promissory note documentation and related federal reporting, where a Direct Loan record must be reproduced together with student and parent borrower identifiers, demographic data, permanent address details, and scheduled disbursement dates.

Because it is a view rather than a table, it carries no independent storage and inherits the security and validation characteristics of the objects beneath it. For users searching on loan_amt_offered, this view is the relevant access point: LOAN_AMT_OFFERED is exposed directly as a column, allowing loan origination amounts to be reported alongside accepted amounts for reconciliation of what was awarded versus what the borrower agreed to.

Underlying Base Objects

The ETRM metadata documents the view as defined over a single base object, IGF_SL_DL_PNOTE_P_P, aliased as PNPPV. No additional base tables are documented as referenced objects, indicating that the underlying promissory note table already carries the denormalized student and parent borrower attributes, or that the "_P_P" source is itself a pre-joined structure.

Two database functions are invoked in the SELECT list rather than being joined as objects. IGF_AW_GEN.LOOKUP_DESC resolves the citizenship status code against the IGF_SL_CITIZENSHIP_STAT lookup type for both the student (S_CITIZENSHIP_STATUS) and the parent (P_CITIZENSHIP_STATUS). IGF_SL_GEN.GET_DISB_DATE is called four times, once for each anticipated disbursement number (1 through 4), using LOAN_ID as the lookup key. These function calls mean that querying the view can be more expensive than querying the base table, particularly when accessed across large loan populations.

Key Columns

• PNPP_ID, BATCH_SEQ_NUM — Primary identifier of the promissory note record and its position within the processing batch.
• LOAN_ID, LOAN_NUMBER — Direct Loan identifiers used to link the note to origination and disbursement records.
• LOAN_AMT_OFFERED — The amount of loan funds offered to the borrower, the column most commonly searched in this view.
• LOAN_AMT_ACCEPTED — The amount the borrower has actually accepted, typically equal to or lower than the offered amount.
• LOAN_PER_BEGIN_DATE, LOAN_PER_END_DATE — The loan period against which the award applies.
• S_* columns — Student attributes: PERSON_ID, SSN, name components, date of birth, citizenship status and its decoded description, alien registration number, license data, permanent address, email, and phone.
• P_* columns — Parent borrower attributes mirroring the student set, relevant to PLUS loans.
• Disbursement date columns — Four unaliased function results providing anticipated disbursement dates 1 through 4 for the loan.
• STATUS, ORG_ID — Processing status of the note and the operating unit that owns the record.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, and PROGRAM_UPDATE_DATE.

Common Use Cases and Queries

Typical scenarios include promissory note printing and verification, loan amount reconciliation between offered and accepted values, and operational reporting on pending notes by operating unit or status.

To retrieve offered and accepted amounts for a specific loan identifier:

SELECT LOAN_NUMBER, LOAN_AMT_OFFERED, LOAN_AMT_ACCEPTED
FROM   APPS.IGF_SL_DL_PNOTE_P_P_V
WHERE  LOAN_ID = :p_loan_id;

To reconcile offered amounts across a batch:

SELECT BATCH_SEQ_NUM, LOAN_NUMBER, LOAN_AMT_OFFERED, LOAN_AMT_ACCEPTED
FROM   APPS.IGF_SL_DL_PNOTE_P_P_V
WHERE  BATCH_SEQ_NUM = :p_batch
ORDER  BY BATCH_SEQ_NUM;

To report student identity and address data for note production:

SELECT S_FIRST_NAME, S_LAST_NAME, S_SSN, S_PERMT_ADDR1,
       S_PERMT_CITY, S_PERMT_STATE, S_PERMT_ZIP
FROM   APPS.IGF_SL_DL_PNOTE_P_P_V
WHERE  STATUS = 'P';

Because the view invokes lookup and disbursement functions per row, restrictive predicates on LOAN_ID, ORG_ID, or STATUS are recommended to limit execution cost.