Search Results original_ssn




Overview
Explore in AI Chat

Overview

IGF_AP_ISIR_SAR_V is a reporting view in the Oracle E-Business Suite Financial Aid module (IGF), owned by the APPS schema. It exposes records that originate from the ISIR (Institutional Student Information Record) and SAR (Student Aid Report) processing performed by the U.S. Department of Education's Central Processing System. In EBS 12.1.1 and 12.2.2, this view serves as a consolidated, read-oriented projection over the raw ISIR transaction data captured by Oracle's financial aid data-loading programs, presenting the applicant's demographic, dependency-status, household, income, and need-analysis attributes in a single relational shape.

The view is predominantly consumed for institutional need analysis, verification workflows, packaging eligibility checks, and downstream reporting to federal or state agencies. The user search term "paid_efc" refers to the Paid_EFC column, which is the Expected Family Contribution calculated by the federal processor and returned on the ISIR. It is one of the most frequently referenced values in disbursement, award, and verification queries.

Underlying Base Objects

The ETRM metadata documents the view text as a single SELECT but lists no referenced base objects, and the view owner is not populated in the metadata record. In practice the view is defined in the APPS schema over the IGF ISIR staging and transaction tables — the ISIR header, transaction, applicant demographic, and need-analysis detail tables maintained by the Financial Aid ISIR load concurrent programs. Because the metadata does not enumerate the base tables, the view should be treated as an abstraction layer: the columns it exposes correspond to the flattened federal ISIR record layout.

The ISIR_ID and BASE_ID columns act as the primary keys linking a specific ISIR transaction to its parent student/applicant record, with transaction_num and TRAN_SOURCE_SITE_CODE identifying the federal source and transaction sequence.

Key Columns

Common Use Cases and Queries

Typical scenarios include retrieving the federal EFC for packaging, comparing ISIR-reported data against institutional records for verification, and extracting applicant demographics for reporting.

Sample query to retrieve the paid EFC for a student's latest ISIR transaction:

SELECT isir_id, base_id, transaction_num, paid_efc, ssn, date_app_completed
FROM   apps.igf_ap_isir_sar_v
WHERE  base_id = :p_base_id
ORDER BY transaction_num DESC;

Sample query to identify students whose federal EFC qualifies them for need-based aid:

SELECT base_id, transaction_num, paid_efc, s_adjusted_gross_income
FROM   apps.igf_ap_isir_sar_v
WHERE  paid_efc <= :p_efc_threshold
AND    transaction_num = (SELECT MAX(transaction_num)
                          FROM apps.igf_ap_isir_sar_v v2
                          WHERE v2.base_id = igf_ap_isir_sar_v.base_id);

Because the view flattens federal ISIR data, it is well suited for verification reports, EFC-based eligibility checks, and reconciliation of student-submitted versus processor-calculated figures.