Search Results p_stud

Overview

IGF_SL_PRK_LOAN_V is a reporting view in the Oracle E-Business Suite Financial Aid (IGF) module, owned by the APPS schema. It presents a consolidated, denormalized picture of Perkins Loan (PRK) awards together with the associated student borrower demographics, permanent home address, and loan period detail. The view is intended for downstream reporting, extracts, and integration to external loan servicing or regulatory reporting processes where a single flat row per loan is required.

The object is commonly explored during lookup of the search term p_stud, which in this view is the alias for the IGF_AP_PERSON_V person/student table alias used throughout the SELECT list to expose borrower name, SSN (API_PERSON_ID), birth date, and email. As a result, the view is frequently referenced when developers or functional users need to trace student-level attributes returned by Perkins loan queries.

Underlying Base Objects

The view is defined over the following documented tables and views, joined to produce one row per qualifying Perkins loan award:

• IGF_SL_LOANS (alias LAR) — the loan/award-instance record supplying LOAN_NUMBER, LOAN_PER_BEGIN_DATE, and LOAN_PER_END_DATE.
• IGF_AW_AWARD (alias AWD) — the award header providing AWARD_ID and ACCEPTED_AMT (exposed as LOAN_AMT_ACCEPTED).
• IGF_AW_FUND_MAST (alias FMAST) and IGF_AW_FUND_CAT (alias FCAT) — fund master and fund category, used to identify the Perkins fund via FCAT.FED_FUND_CODE = 'PRK'.
• IGF_AP_FA_BASE_REC (alias FABASE) — the financial aid base record that links award, person, and ISIR data.
• IGF_AP_PERSON_V (alias P_STUD) — the person/student view supplying SSN, name components, birth date, and email.
• IGF_AP_ISIR_MATCHED (alias ISIR) — the matched ISIR record providing driver's license number and state.
• IGF_SL_ADDR_V (alias S_PERMT) — the address view, filtered to SITE_USE_TYPE = 'HOME', supplying permanent address fields.

Joins are made on AWARD_ID, FUND_ID/FUND_CODE, BASE_ID, and PERSON_ID. The ISIR join is outer (ISIR_ID(+)), as are the address joins (PERSON_ID(+) and SITE_USE_TYPE(+) = 'HOME'), so loans without a matched ISIR or a home address still appear. The phone number is derived by calling the function IGF_SL_GEN.get_person_phone(fabase.person_id).

Key Columns

• LOAN_NUMBER — the Perkins loan identifier from IGF_SL_LOANS.
• S_SSN — borrower SSN (API_PERSON_ID from P_STUD).
• S_LAST_NAME, S_FIRST_NAME, S_MIDDLE_NAME, S_FULL_NAME — borrower name components.
• S_DATE_OF_BIRTH — borrower birth date.
• S_PERMT_ADDR1–ADDR4, S_PERMT_CITY, S_PERMT_STATE, S_PERMT_PROVINCE, S_PERMT_COUNTY, S_PERMT_COUNTRY, S_PERMT_ZIP — permanent home address elements.
• S_EMAIL_ADDR — borrower email address.
• LOAN_AMT_ACCEPTED — accepted award amount for the loan.
• LOAN_PER_BEGIN_DATE, LOAN_PER_END_DATE — loan period start and end dates.
• S_LICENSE_NUM, S_LICENSE_STATE — driver's license number and issuing state from the matched ISIR.
• Phone — derived via IGF_SL_GEN.get_person_phone.

Common Use Cases and Queries

Typical usage includes generating Perkins loan borrower rosters for servicing extracts, validating permanent addresses for statements, and reconciling accepted loan amounts by period. A representative query filtering by loan number is:

• SELECT loan_number, s_ssn, s_full_name, s_permt_city, s_permt_state, loan_amt_accepted FROM apps.igf_sl_prk_loan_v WHERE loan_number = :p_loan;
• SELECT loan_number, s_last_name, s_first_name, loan_per_begin_date, loan_per_end_date FROM apps.igf_sl_prk_loan_v WHERE loan_per_begin_date >= :p_from_date;
• SELECT s_ssn, s_full_name, s_email_addr, s_permt_zip FROM apps.igf_sl_prk_loan_v ORDER BY s_last_name;

Because the view filters on FCAT.FED_FUND_CODE = 'PRK', only Perkins-type awards are returned; other loan programs are excluded. When the search term p_stud is used, it typically reflects a need to confirm how borrower attributes are sourced from the P_STUD alias in this view.