Search Results payment_isir_id




Overview
Explore in AI Chat

Overview

IGF_AP_EFC_DET_V is a supplementary view owned by the APPS schema in Oracle E-Business Suite, registered in FND Design Data as IGF.IGF_AP_EFC_DET_V and delivered with a VALID status. It belongs to the Oracle Financial Aid (IGF) product family, which supports the administration of Title IV student financial assistance for post-secondary institutions. The view presents Expected Family Contribution (EFC) detail derived from ISIR (Institutional Student Information Record) data processed through the financial aid engine, combining personally identifiable student information with award-year context and a set of up to twelve primary EFC values.

As documented in the ETRM metadata, the view type is described as a "supplementary view used to simplify forms coding," accompanied by the standard Oracle caution that direct querying or alteration of data through the view is not recommended and that its definition may change dramatically across minor or major releases. In practice, the view functions as a denormalized read layer that Oracle Forms-based Financial Aid windows rely upon, rather than as an integration or reporting interface intended for external consumers.

Underlying Base Objects

The documented ETRM record for this view lists no referenced base objects, meaning the underlying table inventory is not exposed in the metadata captured for 12.2.2. Based on the IGF naming conventions and column content, the view is constructed over ISIR and ISIR-related correction or transaction tables (the IGF_AP_ISIR and associated ISIR key tables that carry the PAYMENT_ISIR_ID, CONTEXT_ISIR_ID, and BASE_ID identifiers) joined to person and award-year reference data. The PERSON_ID, SSN, and PERSON_NUMBER columns originate from the person/party model, while CI_CAL_TYPE, CI_SEQUENCE_NUMBER, and CI_ALTERNATE_CODE reference the award-year calendar construct.

Because the view is explicitly designated a forms-simplification layer, its definition should be treated as internal implementation detail. Any downstream dependency on the join logic or on the exact columns and their datatypes carries upgrade risk in 12.1.1 through 12.2.2 and beyond.

Key Columns

  • ROW_ID / PERSON_ID / PERSON_NUMBER / SSN / FULL_NAME / SURNAME / GIVEN_NAMES — Identity columns linking the EFC record to the student's person record.
  • ACTIVE_ISIR — Indicator that identifies whether a given ISIR row is the currently active ISIR for the student, which is the field most commonly referenced by searches such as "active_isir".
  • PAYMENT_ISIR_ID / CONTEXT_ISIR_ID / BASE_ID — ISIR transaction identifiers, including the 14-character context identifier and the numeric base identifier.
  • CI_CAL_TYPE / CI_SEQUENCE_NUMBER / CI_ALTERNATE_CODE / START_DT / END_DT — Award-year calendar context in which the EFC applies.
  • PRIMARY_EFC1 through PRIMARY_EFC12 — The segmented primary EFC values associated with the ISIR record.
  • METHOD_CODE — The EFC calculation methodology (e.g., federal methodology variant) used to derive the contribution.
  • ENCUMBERED_IND / DECEASED_IND — Status flags affecting eligibility.
  • CREATED_BY / CREATION_DATE / LAST_UPDATED_BY / LAST_UPDATE_DATE / LAST_UPDATE_LOGIN — Standard Who columns used for audit and concurrency.

Common Use Cases and Queries

The view is typically consulted when diagnosing which ISIR is currently flagged as active for a student, or when verifying the EFC values presented in the Financial Aid forms. A representative query filtered on the active ISIR indicator is shown below.

SELECT person_number, full_name, ci_alternate_code, active_isir, primary_efc1
FROM apps.igf_ap_efc_det_v
WHERE person_number = :person_number
AND active_isir = 'Y';

Users should confirm the permitted values of ACTIVE_ISIR in their specific release before executing such filters, and should prefer supported Financial Aid APIs or base tables for integration purposes, given Oracle's explicit warning regarding direct query of this view.