Search Results igf_ap_isir_info_v

Overview

IGF_AP_ISIR_INFO_V is a view owned by the APPS schema within the IGF (Financial Aid) product family of Oracle E-Business Suite. It is documented in the ETRM repository for both 12.1.1 and 12.2.2 as Obsolete. This status indicates that the object is retained only for backward compatibility and is no longer part of the supported functional path for Financial Aid processing in current releases. The view presents a denormalized projection of ISIR (Institutional Student Information Record) transaction data combined with the associated financial aid base record attributes. Its historical role was to expose a consolidated reporting surface over matched ISIR records so that downstream reporting, integration, or inquiry components could retrieve transaction identifiers, correction status, and Expected Family Contribution (EFC) values without directly joining the underlying ISIR and base record tables.

Underlying Base Objects

Although the ETRM metadata records no referenced base objects for the 12.2.2 definition, the documented view text defines a two-table join:

• IGF_AP_ISIR_MATCHED (alias ISIRM) — the primary source of ISIR transaction data, supplying ISIR identifiers, SSN and name change indicators, transaction numbers, verification flags, EFC values, and audit columns.
• IGF_AP_FA_BASE_REC (alias FAR) — joined on FAR.BASE_ID = ISIRM.BASE_ID, supplying the ISIR correction status through the ISIR_CORR_STATUS column.

The join condition is an inner join on BASE_ID, meaning only ISIR records with a corresponding financial aid base record are returned. Because the object is obsolete, later releases may have altered or removed the underlying tables, so the view should not be treated as a reliable integration point.

Key Columns

• ISIR_ID — primary identifier of the matched ISIR record.
• BASE_ID — foreign key linking the ISIR record to the financial aid base record; also the join key to IGF_AP_FA_BASE_REC.
• SSN_NAME_CHANGE — flag indicating an SSN or name change on the ISIR.
• ORIGINAL_SSN and ORIG_NAME_ID — original SSN and name identifier values used for correction tracking.
• TRANSACTION_NUM — ISIR transaction number.
• TRANSACTION_ID — derived concatenation of ORIGINAL_SSN, ORIG_NAME_ID, and TRANSACTION_NUM, producing a composite key for the transaction.
• VERIFICATION_FLAG — indicates whether the record is subject to verification.
• ISIR_CORR_STATUS — correction status sourced from the financial aid base record.
• PRIMARY_EFC and SECONDARY_EFC — primary and secondary Expected Family Contribution values.
• PAYMENT_ISIR — payment-related ISIR indicator.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard Oracle audit columns.
• SYSTEM_RECORD_TYPE — system-level record type classification.

Common Use Cases and Queries

Historically, this view supported reporting on ISIR transactions with correction and EFC information, reconciliation between matched ISIR records and base records, and extraction of transaction identifiers for downstream interfaces. Given its obsolete status, any current use should be validated against the release in production before relying on it.

A representative query returning ISIR transaction detail:

• SELECT isir_id, base_id, transaction_id, verification_flag, isir_corr_status, primary_efc, secondary_efc FROM apps.igf_ap_isir_info_v WHERE base_id = :p_base_id;

A query filtering records flagged for verification:

• SELECT isir_id, original_ssn, transaction_num, primary_efc FROM apps.igf_ap_isir_info_v WHERE verification_flag = 'Y' ORDER BY creation_date DESC;

Because the view is documented as obsolete and grounded on the two historical base tables, Oracle recommends migrating to the supported Financial Aid data model rather than building new dependencies on IGF_AP_ISIR_INFO_V.