Search Results duplicate_date




Overview
Explore in AI Chat

Overview

IGF_AP_ISIR_MATCHED_V is an Oracle E-Business Suite database view owned by the APPS schema and associated with the IGF (Financial Aid) product. It exposes records drawn from the Institutional Student Information Record (ISIR) data set, which federal financial aid processing loads into EBS to support student eligibility determination. The view presents a wide, denormalized projection of applicant and ISIR attributes — identity, citizenship, Selective Service registration, marital status, enrollment status, and the detailed income and asset figures used in needs analysis — in a single read interface.

Within Oracle EBS 12.1.1 and 12.2.2, this view serves reporting and integration consumers rather than transactional forms. Because it consolidates matched ISIR records, it is a convenient source for institution-side extracts, downstream verification routines, and reconciliation of loaded ISIR data against student records.

Underlying Base Objects

The ETRM documentation for this object does not enumerate specific base tables, and no referenced base objects are documented. In practice, a view of this type is defined over the ISIR staging and matched-record tables in the IGF schema, joined to person and student records to produce the consolidated row exposed through the APPS synonym. The view text selects the full column list directly, confirming it is a straightforward projection over one primary ISIR-based source rather than a heavily transformed aggregation.

Because the base objects are not documented in the ETRM metadata, consumers should treat the view as a stable reporting surface and avoid assumptions about underlying join cardinality. Verify row uniqueness against ISIR_ID and ROW_ID before relying on the view for one-row-per-applicant processing.

Key Columns

Common Use Cases and Queries

Typical uses include verifying that matched ISIR records were loaded correctly, extracting applicant data for packaging and verification, and auditing SSN or name changes flagged during matching. A representative query retrieving identity and eligibility fields follows:

  • SELECT isir_id, current_ssn, last_name, first_name, citizenship_status, s_m...

For reconciliation by batch year, filter on BATCH_YEAR and TRANSACTION_NUM to isolate the current ISIR version, and join to student records on ISIR_ID. Always constrain the query to the appropriate award year to limit full-table scans on this wide view.