Search Results igf_sl_dl_pnote_p_p

Overview

IGF_SL_DL_PNOTE_P_P is a multiorg (MO) secured view in the Oracle E-Business Suite Financial Aid (IGF) product, residing in the APPS schema. It exposes row-level detail from the underlying Direct Loan promissory note party table, IGF_SL_DL_PNOTE_P_P_ALL, filtered by the organization context of the active session. The naming convention is significant: the trailing "_P_P" denotes a row-level security (RLS) view generated by the EBS multiorg architecture, while "_ALL" identifies the base table holding data for all operating units.

The view carries student and parent borrower demographic attributes together with Direct Loan award amounts and period dates, making it a reporting and integration surface for loan origination processes. In both Release 12.1.1 and 12.2.2 the object is documented as VALID and owned by APPS, with no product-specific view description. Because it is auto-generated by the multiorg security framework, its definition is tightly coupled to the ORG_ID column and the CLIENT_INFO session context.

Underlying Base Objects

The ETRM metadata documents no referenced base tables beyond the single source revealed in the view text:

• IGF_SL_DL_PNOTE_P_P_ALL — the base table aliased PNPP in the view definition. The view selects all of its columns and applies a WHERE clause on ORG_ID.

No join to other tables, lookup objects, or foreign key relationships is documented. All demographic and loan attributes are denormalized into the base table, so the view is effectively a filtered projection of IGF_SL_DL_PNOTE_P_P_ALL. The security predicate resolves the current operating unit from USERENV('CLIENT_INFO'), substituting -99 when no context is set, and matches it against the row's ORG_ID using NVL on both sides so that rows with a NULL ORG_ID are treated as belonging to the wildcard org.

Key Columns

The view exposes the following principal columns:

• ROW_ID / PNPP_ID — the physical ROWID and the primary key of the promissory note party row.
• BATCH_SEQ_NUM, LOAN_ID, LOAN_NUMBER — loan identification and the sequence within a processing batch.
• LOAN_AMT_OFFERED, LOAN_AMT_ACCEPTED, LOAN_PER_BEGIN_DATE, LOAN_PER_END_DATE — the loan amount offered versus accepted, and the academic loan period boundaries.
• PERSON_ID — the student's party identifier.
• S_* columns — student borrower attributes: SSN, first/middle/last name, date of birth, citizenship status, alien registration number, driver license number and state, permanent address components (address lines, city, state, province, county, country, ZIP), e-mail address, and phone.
• P_* columns — the corresponding parent/co-borrower attributes, using the same field pattern (P_PERSON_ID, P_SSN, P_LAST_NAME, P_FIRST_NAME, and so on), including P_ALIEN_REG_NUM rather than S_ALIEN_REG_NUMBER.
• STATUS — the processing status of the promissory note record.
• ORG_ID — the operating unit that governs row-level access.
• Audit and concurrent columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE.

Common Use Cases and Queries

Typical scenarios include reconciling Direct Loan promissory note submissions, extracting borrower demographic data for downstream COD/CPS interfaces, and auditing loan amounts accepted against amounts offered for a given award period.

Because the view relies on CLIENT_INFO, a session must set the org context before querying; otherwise the predicate falls back to -99 and may return no rows. In SQL*Plus or a concurrent program, initialize the context first:

• EXEC FND_CLIENT_INFO.SET_ORG_CONTEXT(org_id);

A representative query lists outstanding promissory notes for the current org:

• SELECT pnpp_id, loan_number, s_last_name, s_first_name, loan_amt_offered, loan_amt_accepted, status FROM igf_sl_dl_pnote_p_p WHERE status = 'NEW';

To reconcile student and parent data for interface extracts:

• SELECT loan_id, person_id, s_ssn, p_person_id, p_ssn, loan_per_begin_date, loan_per_end_date FROM igf_sl_dl_pnote_p_p ORDER BY batch_seq_num;

For a full organizational view of all rows, query the base table IGF_SL_DL_PNOTE_P_P_ALL directly, subject to the appropriate privileges and data-access policy.