Search Results igf_sl_dl_pnote_s_p_v

Overview

IGF_SL_DL_PNOTE_S_P_V is an APPS-owned, VALID view within the Oracle E-Business Suite Financial Aid module (IGF). In EBS 12.1.1 and 12.2.2 it functions as a reporting and integration surface over the promissory note staging records used by the Direct Loan (DL) processing flow. The view is a thin projection: it selects every column from a single underlying staging table, IGF_SL_DL_PNOTE_S_P, and exposes it under a stable, read-oriented name ending in the conventional "_V" suffix. Because it performs no joins, filters, or derivations, it is effectively a synonym-like passthrough that insulates downstream reports, concurrent programs, and external interfaces from direct dependence on the staging table name.

The "_S_P" segment of the base object name indicates a staging (S) table populated by a PL/SQL (P) process, typically a concurrent program that extracts or receives promissory note data from an external Direct Loan servicer or from internal student loan setup. The view therefore represents the inbound or intermediate form of promissory note information before it is validated, transformed, and moved into the permanent loan tables. Its role in EBS is primarily diagnostic and downstream-facing: report developers, OBIEE/BI Publisher extracts, and custom integrations query the view to inspect staged promissory note data by loan, person, and batch.

Underlying Base Objects

The ETRM metadata documents one referenced base object: IGF_SL_DL_PNOTE_S_P, aliased PNSPV in the view text. No other tables, views, or synonyms are documented as participating in the definition. The view definition is a straightforward projection:

• SELECT list: all 30 columns of the base staging table, in physical order, qualified with the PNSPV alias.
• FROM clause: IGF_SL_DL_PNOTE_S_P PNSPV.
• Predicates/joins: none.
• Aggregations: none.

Consequently, row cardinality and data content of the view are identical to the staging table. The view inherits the table's WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) and concurrent-program context columns (REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE), which is characteristic of an interface/staging object populated by a concurrent manager request. Multi-org filtering is not applied by the view; ORG_ID is exposed as a plain column, so any operating-unit restriction must be imposed by the querying application.

Key Columns

• PNSP_ID — primary identifier of the promissory note staging record.
• BATCH_SEQ_NUM — sequence number identifying the batch in which the record was staged.
• LOAN_ID / LOAN_NUMBER — link to the loan and its human-readable number.
• PERSON_ID — party identifier for the student/borrower.
• S_* columns — student-supplied attribute values captured at staging: S_SSN, S_FIRST_NAME, S_LAST_NAME, S_MIDDLE_NAME, S_DATE_OF_BIRTH, S_LICENSE_NUM, S_LICENSE_STATE, S_PERMT_ADDR1/2, S_PERMT_CITY, S_PERMT_STATE, S_PERMT_ZIP, S_EMAIL_ADDR, S_PHONE.
• STATUS — processing status of the staged record.
• ORG_ID — operating unit context.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — concurrent request provenance.

Common Use Cases and Queries

The view is most often used to audit a specific batch, resolve a loan's staged note, or reconcile staged person data against the master party record. Representative queries include:

• List staged notes for a batch: SELECT pnsp_id, loan_number, person_id, status FROM igf_sl_dl_pnote_s_p_v WHERE batch_seq_num = :batch ORDER BY pnsp_id;
• Find staged attributes for a loan: SELECT s_ssn, s_first_name, s_last_name, s_date_of_birth, s_email_addr FROM igf_sl_dl_pnote_s_p_v WHERE loan_number = :loan;
• Identify the concurrent request that created the rows: SELECT DISTINCT request_id, program_id, program_update_date FROM igf_sl_dl_pnote_s_p_v;
• Detect rows still pending processing: SELECT pnsp_id, loan_id, status FROM igf_sl_dl_pnote_s_p_v WHERE status <> 'PROCESSED';
• Restrict by operating unit: SELECT * FROM igf_sl_dl_pnote_s_p_v WHERE org_id = :org_id;

Because the view exposes no derived logic, it is suitable for full-table extracts and staging-diagnostics, but it should not be treated as an application API. Consumers should read the STATUS column and reconcile against the downstream loan tables before acting on the data.