Results for “igf_ap_efc_det_v”

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

Overview

The view IGF_AP_EFC_DET_V belongs to the Oracle E-Business Suite module IGF – Financial Aid, which is identified in the ETRM metadata as obsolete. It exposes the computed end result of the Expected Family Contribution (EFC) for each student across all need-analysis methodologies supported by the legacy Financial Aid application. In reporting and integration terms, the view served as a denormalized, presentation-ready read layer over the raw Institutional Student Information Record (ISIR) and financial aid base data, allowing downstream reports, packaging logic, and extracts to consume a single row per student per award-year instance without re-implementing the joins or the SSN lookup logic.

The metadata explicitly notes that the object is not implemented in the current database. This is consistent with the obsolescence of the IGF product line: the view exists only as a historical artifact in the ETRM repository and in older 12.1.1 / 12.2.2 instances where Financial Aid was still licensed and installed.

Underlying Base Objects

Although the ETRM record lists no referenced base objects, the view text documents its underlying tables directly. It is defined over the following:

• IGF_AP_FA_BASE_REC (aliased FA) — the driving financial aid base record, keyed by BASE_ID, PERSON_ID, and the calendar instance (CI_CAL_TYPE, CI_SEQUENCE_NUMBER).
• IGF_AP_ISIR_MATCHED (aliased ISIR) — the matched ISIR row, joined with an outer join on FA.BASE_ID = ISIR.BASE_ID(+) and restricted to ACTIVE_ISIR = 'Y'.
• HZ_PARTIES (aliased PE) — the party master supplying person number, name, and party ID.
• IGS_CA_INST (aliased CA) — the calendar instance providing start/end dates and alternate code.
• IGS_PE_PERSON_ID_TYP and IGS_PE_ALT_PERS_ID in an inline subquery (aliased PIT) — resolving the SSN person identifier with an effective-date check (SYSDATE BETWEEN START_DT AND NVL(END_DT, SYSDATE)).
• IGS_PE_HZ_PARTIES (aliased HZP) — supplying the DECEASED_IND flag.

The view also invokes the packaged function IGS_EN_GEN_003.ENRP_GET_ENCMBRD_IND to derive the encumbered indicator, and applies an ORG_ID security predicate based on USERENV('CLIENT_INFO'), a pattern typical of multi-org (MOAC) secured financial aid views.

Key Columns

The documented column list is truncated, but the view text and column names establish the following:

• ROW_ID / ROWID — the row identifier from IGF_AP_FA_BASE_REC.
• PERSON_NUMBER — the party number from HZ_PARTIES.
• CI_CAL_TYPE, CI_SEQUENCE_NUMBER, CI_ALTERNATE_CODE, START_DT, END_DT — the award-year/calendar instance identity.
• SSN — the SSN derived from the alternate person identifier subquery.
• FULL_NAME — last name concatenated with first name.
• SURNAME, GIVEN_NAMES, PAYMENT_ISIR_ID, ACTIVE_ISIR, METHOD_CODE, CONTE — the truncated remainder of the documented column list, covering methodology and ISIR transaction identifiers.
• BASE_ID, PERSON_ID, ENCUMBERED_IND, DECEASED_IND and the standard CREATED_BY/CREATION_DATE/LAST_UPDATED_BY/LAST_UPDATE_DATE/LAST_UPDATE_LOGIN audit columns.

Common Use Cases and Queries

The view supported need-analysis reconciliation, EFC comparison across methodologies, and student-level financial aid reporting. Typical usage filters by calendar instance and only returns active-ISIR students:

• Comparing EFC results across methodologies for a given award year.
• Extracting student demographics (name, SSN, person number) alongside the computed contribution for downstream packaging or letters.
• Identifying encumbered or deceased students prior to disbursement activities.

Because the object is obsolete and not implemented, the following query is illustrative only:

SELECT person_number, ssn, full_name, ci_cal_type, ci_sequence_number, method_code, conte
FROM igf_ap_efc_det_v
WHERE ci_cal_type = :cal_type
AND ci_sequence_number = :seq_num
AND active_isir = 'Y';

Any migration off IGF should replace this view with direct queries against the current student financial aid tables or the successor product's need-analysis views.