Search Results disb_date_4

Overview

The view APPS.IGF_SL_DL_PNOTE_P_P_V is a reporting view within the Oracle E-Business Suite (EBS) Financial Aid module, part of the Oracle Student Financial Aid / Institutional Grants and Funds (IGF) application family. The object naming convention — IGF_SL_DL_PNOTE_P_P_V — indicates that it belongs to the IGF schema domain (IGF), relates to Student Loans (SL), operates within the Direct Loan (DL) context, and addresses Promissory Notes (PNOTE). The trailing _P_P_V suffix signals a "Public/Private View" pattern commonly used in EBS for denormalized, security-aware reporting layers that expose loan application data to downstream processes.

This view presents a consolidated, flattened projection of Direct Loan promissory note data, combining loan-level financial attributes with student (borrower) and parent (co-borrower or PLUS borrower) biographical and demographic detail. In the context of the user's search term loan_amt_offered, this column is central to the view's purpose: it exposes the dollar amount originally offered to the borrower on the promissory note, enabling reconciliation against the accepted amount and disbursement schedules. Its role is primarily reporting, integration with loan servicing or origination interfaces, and support for Origination and Disbursement (COD) file generation.

Underlying Base Objects

The ETRM document metadata for this view does not enumerate explicit referenced base objects ("Referenced base objects: none documented"). In practice, a view of this naming pattern in the IGF/IGF_SL schema lineage is defined over promissory note and loan origination tables — typically IGF_SL_DL_PNOTE (the transactional promissory note header), joined to person/party tables such as PER_ALL_PEOPLE_F or IGF borrower staging tables (e.g., IGF_SL_DL_BORROWER), plus lookup tables for citizenship status descriptions. The PNPP_ID column (number, length 15) is the likely primary key from the underlying promissory note parent record, and ORG_ID confirms the view is Multi-Org (Operating Unit) enabled, indicating an org-specific business group filter is applied in the WHERE clause.

The heavy denormalization — with S_* prefix columns for student and P_* prefix columns for parent — suggests UNION or OUTER JOIN logic across borrower role relationships, resolving a single promissory note to two distinct person identities within one result row.

Key Columns

• PNPP_ID / LOAN_ID / LOAN_NUMBER — Primary identifiers linking the promissory note to the loan record and human-readable loan number.
• LOAN_AMT_OFFERED — The total dollar amount offered on the promissory note; the primary column of interest in the searched context.
• LOAN_AMT_ACCEPTED — The amount actually accepted by the borrower, used for reconciliation against the offered figure.
• LOAN_PER_BEGIN_DATE / LOAN_PER_END_DATE — The loan period start and end dates defining the academic or award period.
• S_* columns — Student borrower attributes: SSN, name, DOB, citizenship status and description, alien registration number, license, permanent address fields, email, and phone.
• P_* columns — Parent/co-borrower attributes mirroring the student fields, supporting PLUS loan and endorser scenarios.
• DISB_DATE_1 through DISB_DATE_4 — Scheduled or actual disbursement dates for the loan's multiple disbursement tranches.
• STATUS, ORG_ID, BATCH_SEQ_NUM, CREATED_BY, CREATION_DATE — Transactional control columns for workflow status, operating unit, batch processing sequence, and audit trail.

Common Use Cases and Queries

Typical uses include origination reporting, COD file pre-generation, borrower correspondence, and reconciliation of offered versus accepted loan amounts. A representative query retrieving loan and borrower detail for a specific operating unit follows:

• SELECT loan_number, loan_amt_offered, loan_amt_accepted, s_last_name, s_first_name, status FROM apps.igf_sl_dl_pnote_p_p_v WHERE org_id = :p_org_id AND loan_amt_offered > 0;
• Reconciliation: compare LOAN_AMT_OFFERED against LOAN_AMT_ACCEPTED to flag partially accepted or declined awards prior to disbursement scheduling.
• Disbursement planning: filter on DISB_DATE_1 through DISB_DATE_4 to project cash flow for the loan period defined by LOAN_PER_BEGIN_DATE and LOAN_PER_END_DATE.
• Borrower identity extraction: select the S_* and P_* column groups to populate loan servicing interfaces and print promissory notes.

Because the view is flagged Oracle Internal Use Only and is not supported for direct customer access except via standard EBS programs, any custom reporting should be reviewed against the corresponding FND design data and the view's dependency on IGF schema objects before deployment.