Results for “igffv_isir_corrections”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGFFV_ISIR_CORRECTIONS is a read-only reporting view in the Oracle E-Business Suite Financial Aid module (product code IGF), a component that carries the "Obsolete" designation in Oracle EBS 12.1.1 and 12.2.2. The view presents ISIR correction records — that is, the field-level changes applied to a student's Institutional Student Information Record (ISIR) as part of the federal financial aid correction cycle. Each row represents one corrected SAR field, pairing the original value reported on the ISIR with the corrected value, together with the identity of the student and the award-year context in which the correction was processed.

The view is defined with the WITH READ ONLY clause, confirming that it is intended exclusively for query and reporting purposes rather than transactional maintenance. Oracle's own ETRM documentation records it as "Not implemented in this database," meaning the object may not exist in every environment where the IGF schema is installed, and its availability should be verified before it is referenced in custom reports or integrations.

Underlying Base Objects

The view text is explicitly documented in the ETRM metadata and joins five base objects:

• IGF_AP_ISIR_CORR_ALL (alias ISIRC) — the driving table holding the individual ISIR correction records, including SAR field number, original value, corrected value, and correction status.
• IGF_AP_ISIR_MATCHED_ALL (alias ISIRM) — links the ISIR to the financial aid base record, joining on ISIR_ID and providing BASE_ID.
• IGF_AP_FA_BASE_REC_ALL (alias FA_DETAIL) — the financial aid base record supplying PERSON_ID and the demographic anchor for the student. Notably, the alias FA_DETAIL matches the user's search term.
• HZ_PARTIES (alias HP) — the Trading Community Architecture party table, supplying the student's name and party number.
• IGS_CA_INST_ALL (alias CI) — the academic calendar instance table, providing the award year and its description via CAL_TYPE and SEQUENCE_NUMBER.

The joins are inner joins throughout, so a correction row is returned only when a matched ISIR, a base record, a valid party, and a valid calendar instance all exist.

Key Columns

• PERSON_NAME / PERSON_NUMBER — sourced from HZ_PARTIES; identifying the student.
• SAR_FIELD_NUMBER — the specific ISIR data element corrected.
• ABS — dynamically resolves the correction status meaning through the IGF_ISIR_CORR_STATUS lookup, displayed via the descriptive flexfield mechanism.
• AWARD_YEAR / AWARD_YEAR_DESCRIPTION — from IGS_CA_INST_ALL (ALTERNATE_CODE and DESCRIPTION), giving the aid-year context.
• ORIGINAL_VALUE / CORRECTED_VALUE — the before-and-after values of the corrected field.
• BATCH_ID — the correction batch through which the change was processed.
• ISIRC_ID / ISIR_ID — primary key of the correction record and its parent ISIR.
• CI_CAL_TYPE / CI_SEQUENCE_NUMBER — the academic calendar identifiers.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — standard WHO audit columns.
• PERSON_ID — the party identifier from the base record, useful for joins to other student-level data.

Common Use Cases and Queries

Typical uses include auditing which ISIR fields were corrected for a given student or aid year, reconciling correction batches, and reporting on correction volume by field or status. A representative query follows:

• SELECT person_number, person_name, award_year, sar_field_number, original_value, corrected_value, correction_status, creation_date FROM igffv_isir_corrections WHERE person_id = :person_id AND award_year = :award_year ORDER BY creation_date;
• SELECT award_year, sar_field_number, COUNT(*) FROM igffv_isir_corrections GROUP BY award_year, sar_field_number ORDER BY 1, 3 DESC; — summarizing correction frequency by field.

Because the view is read-only and its base tables reside in the obsolete IGF module, queries should be confined to reporting, and existence of the object should be checked via ALL_VIEWS before deployment.