Search Results igffv_federal_need_details




Overview
Explore in AI Chat

Overview

The IGFFV_FEDERAL_NEED_DETAILS view is a read-only Oracle EBS database object owned by the APPS schema and registered as VALID within the IGF (Financial Aid) product family. It exposes student-level data used to determine federal need, principally the Expected Family Contribution (EFC) applicable to a given award year and academic load. The view consolidates party identity information, award year context, calendar/term data, and derived EFC values into a single denormalized reporting structure. It is defined WITH READ ONLY, so it cannot be used as the target of DML; it exists purely as a query surface for reporting, extracts, and integration logic that must reproduce federal need calculations.

Because the EFC value is computed on the fly rather than stored as a static column, the view is best understood as a wrapper around the institution's need-analysis rules. It pulls the applicable EFC figure from the ISIR-matched base record and selects the correct alternate-month or primary/secondary EFC value according to the number of months in the load calendar.

Underlying Base Objects

The view text joins six objects, all in the APPS schema:

  • HZ_PARTIES (aliased PE) — supplies the student's party name and party number.
  • IGF_AP_FA_BASE_REC_ALL (aliased BASE) — the financial aid base record, joined on PERSON_ID and carrying the EFC column set, secondary/primary alternate months, award year, and the CI_* calendar references.
  • IGF_AP_ISIR_MATCHED_ALL (aliased ISIRM) — the ISIR matching record, filtered to ACTIVE_ISIR = 'Y' so only the current matched ISIR is used.
  • IGF_AW_COA_ITM_TERMS (aliased COAIT) — cost-of-attendance item terms, joined by BASE_ID and linked to the load calendar via LD_CAL_TYPE and LD_SEQUENCE_NUMBER.
  • IGS_CA_INST_ALL (aliased LD) — the load calendar instance, providing alternate code, description, start and end dates.
  • IGS_CA_INST_ALL (aliased CI) — the award year calendar instance, providing the award year code, description, and sequence.

Two database functions are invoked in the select list: IGF_AP_EFC_CALC.GET_EFC_NO_OF_MONTHS and IGF_AP_GEN.GET_CUMULATIVE_COA_AMT. The documented Referenced base objects metadata is empty, so the dependencies above are inferred from the published view text.

Key Columns

The GET_EFC_NO_OF_MONTHS function returns the month count driving the DECODE, while GET_CUMULATIVE_COA_AMT supplies a cumulative cost-of-attendance amount for the period.

Common Use Cases and Queries

Typical uses include need-analysis reporting, federal extract generation, and verification of calculated EFC against the stored ISIR. A representative query:

  • SELECT person_number, person_name, award_year, load_calendar, efc FROM apps.igffv_federal_need_details WHERE award_year = :year;
  • Filtering by load_calendar_start_date range to align with a term or payment period.
  • Joining back to IGF_AP_FA_BASE_REC_ALL on PERSON_ID for audit comparisons of primary versus secondary EFC selection.

Because the view is read-only and computationally derived, queries should avoid large unfiltered scans; predicate on award year, load calendar, or person to keep function invocations bounded.