Search Results preparer_sign




Overview
Explore in AI Chat

Overview

IGF_AP_ISIR_SAR_V is a database view historically shipped within the Oracle E-Business Suite Financial Aid (IGF) product family. In ETRM metadata for releases 12.1.1 and 12.2.2, the object is classified as Obsolete, with the description field carrying the same designation. This classification indicates that the view is no longer implemented in the current database and is retained only as a legacy artifact of the earlier Financial Aid module, which has been superseded by Oracle Student Financial Planning and related student-aid products.

Functionally, the view was designed as a flat, denormalized projection of student ISIR (Institutional Student Information Record) and SAR (Student Aid Report) data used by the federal financial aid process. It consolidated fields from student-supplied and parent-supplied sections of the aid application into a single queryable structure, making it convenient for reporting, downstream eligibility calculations, and integration with external financial aid processors. Because the underlying metadata documents no implementation in the current database, the view exists only as historical reference and should not be relied upon in new development.

Underlying Base Objects

The ETRM documentation lists no referenced base objects for this view in 12.2.2, and explicitly states it is not implemented. Based on the embedded view text, the definition selects a large set of columns — ISIR_ID, BASE_ID, ORIGINAL_SSN, TRANSACTION_NUM, and numerous student and parent financial attributes — that correspond to the legacy ISIR/SAR staging and processing tables within the IGF schema. The view therefore acted as a single-source abstraction over multiple ISIR-related base tables, likely joining student and parent data segments keyed by ISIR_ID and BASE_ID.

Practitioners should note that because the base objects are undocumented in the current ETRM repository and the view itself is obsolete, any attempt to trace lineage must rely on the embedded SELECT text rather than on active data dictionary relationships.

Key Columns

The view exposed a broad set of columns spanning student, spouse, and parent financial information. Notable categories include:

The user search term p_adjusted_gross_income maps directly to the parent adjusted gross income column, a central input to the Expected Family Contribution (EFC) calculation, mirroring its counterpart S_ADJUSTED_GROSS_INCOME for the student.

Common Use Cases and Queries

Historically, this view supported financial aid reporting dashboards, ISIR reconciliation extracts, and EFC recalculation routines. Since the view is obsolete in 12.1.1 and 12.2.2, the following query is illustrative only:

  • SELECT isir_id, base_id, s_adjusted_gross_income, p_adjusted_gross_income FROM igf_ap_isir_sar_v WHERE transaction_num = :trans; — used to retrieve student and parent AGI for EFC verification.
  • SELECT isir_id, p_num_family_member, p_num_in_college, p_adjusted_gross_income FROM igf_ap_isir_sar_v ORDER BY p_adjusted_gross_income; — used in need-analysis reporting.
  • SELECT isir_id, s_state_legal_residence, p_state_legal_residence FROM igf_ap_isir_sar_v; — used for residency validation.

For current implementations, the recommendation is to migrate to supported student financial planning objects and to treat IGF_AP_ISIR_SAR_V strictly as a historical reference model.