Results for “isir_id”

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

Overview

The view IGF_AP_ISIR_CORRECTION_DTL_V belongs to the IGF (Financial Aid) product family within Oracle E-Business Suite. It is part of the ISIR correction processing infrastructure that supported the U.S. federal student aid workflow (ISIR — Institutional Student Information Record), enabling institutions to track corrections made to SAR (Student Aid Report) fields. In the ETRM 12.2.2 metadata, the product is flagged as Obsolete, and the view is documented as Not implemented in this database. Consequently, no runtime deployment is expected in a standard 12.1.1 or 12.2.2 instance unless the IGF module was historically enabled.

Functionally, the view presents a denormalized, readable representation of ISIR correction detail records. It joins correction data to lookup descriptions, batch mapping information, and SAR field master data, so that report writers and integration developers can obtain human-readable correction statuses and field descriptions without manually joining the underlying lookup and mapping tables. Its role is purely read-oriented: it supports reporting, review, and reconciliation of correction transactions rather than transactional DML.

Underlying Base Objects

The view is defined over several base objects using inner joins:

• IGF_AP_ISIR_CORR (aliased IC) — the primary correction table supplying row identifiers, ISIR references, field numbers, original/corrected values, batch linkage, and audit columns.
• IGF_LOOKUPS_VIEW (aliased FLK1) — joined on LOOKUP_TYPE = 'IGF_CORR_STATUS' and LOOKUP_CODE = CORRECTION_STATUS to resolve the correction status meaning.
• IGF_LOOKUPS_VIEW (aliased LKUP) — joined a second time on LOOKUP_TYPE = 'IGF_AP_SAR_FIELD_MAP' and LOOKUP_CODE = SAR_FIELD_NAME to resolve the SAR field description.
• IGF_AP_BATCH_AW_MAP (aliased MAP) — joined on CI_CAL_TYPE and CI_SEQUENCE_NUMBER to align the correction with its award-year batch context.
• IGF_FC_SAR_CD_MST (aliased SAR) — joined on SYS_AWARD_YEAR and SAR_FIELD_NUMBER to bind the correction to the correct SAR field master record.

Although ETRM 12.2.2 lists no referenced base objects under the metadata block, the embedded view text documents these five source objects unambiguously.

Key Columns

• ROW_ID — unique identifier of the correction detail row.
• ISIR_ID / ISIRC_ID — references to the ISIR and correction header records.
• CI_SEQUENCE_NUMBER / CI_CAL_TYPE — correction sequence and calendar type used to link to the batch award map.
• SAR_FIELD_NUMBER / SAR_FIELD_DESC — the SAR field being corrected and its decoded description.
• ORIGINAL_VALUE / CORRECTED_VALUE — the pre-correction and post-correction field values, the core audit trail.
• BATCH_ID — the batch through which the correction was processed.
• CORRECTION_STATUS / CORRECTION_STATUS_DESC — status code and its decoded meaning.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit columns.

Common Use Cases and Queries

Typical usages include auditing corrections per ISIR, verifying batch processing outcomes, and feeding correction data into downstream financial aid reporting.

List corrections with descriptive context:

SELECT ISIR_ID, SAR_FIELD_DESC, ORIGINAL_VALUE,
       CORRECTED_VALUE, CORRECTION_STATUS_DESC
FROM   IGF_AP_ISIR_CORRECTION_DTL_V
ORDER  BY ISIR_ID, CI_SEQUENCE_NUMBER;

Filter by batch for reconciliation:

SELECT BATCH_ID, COUNT(*) CORRECTIONS
FROM   IGF_AP_ISIR_CORRECTION_DTL_V
WHERE  BATCH_ID = :p_batch_id
GROUP  BY BATCH_ID;

Because the product is marked obsolete and the view is documented as not implemented, developers must confirm its existence in the target database prior to use, querying ALL_VIEWS for owner, text, and status before attempting any dependency analysis or reporting.