Search Results load_calendar_start_date

Overview

APPS.IGFFV_FEDERAL_NEED_DETAILS is a Business Intelligence System (BIS) view owned by the APPS schema in Oracle E-Business Suite, registered under FND Design Data as IGF.IGFFV_FEDERAL_NEED_DETAILS with a status of VALID. It is part of the Oracle Student Financial Aid (IGF) product family, which supports needs analysis and packaging of federal student aid. The view consolidates student-level federal need information across a given award year and load calendar, exposing the data in a denormalized, report-friendly shape suitable for downstream reporting, analytics, and integration.

The view presents, per person, the identifying information (person name, person number and person ID) together with the award year and load calendar context, the load calendar's start and end dates, the cumulative cost of attendance (COA) and its associated cumulative months, and the Expected Family Contribution (EFC). This combination supports the core needs-analysis equation — cost of attendance less expected family contribution — and allows aid administrators and reporting consumers to evaluate need at the load-calendar granularity.

The object is documented specifically for EBS 12.2.2, and its design is consistent with 12.1.1 deployments of the same IGF schema. Because it is a view rather than a table, it carries no storage of its own and reflects the state of the underlying transactional tables at query time.

Underlying Base Objects

Per the documented dependency information, APPS.IGFFV_FEDERAL_NEED_DETAILS references the following objects:

• APPS.HZ_PARTIES — the Trading Community Architecture (TCA) party table, providing person-level identifying attributes.
• IGF_AP_EFC_CALC — the EFC calculation source, supplying expected family contribution data. The dependency is marked with dependent code, indicating a packaged procedure or function is involved.
• IGF_AP_FA_BASE_REC_ALL — the financial aid base record, the central student/award record in IGF.
• IGF_AP_GEN — general needs-analysis logic, also marked with dependent code.
• IGF_AP_ISIR_MATCHED_ALL — the matched ISIR record, reflecting the institutional student information record data received and matched for the student.
• IGF_AW_COA_ITM_TERMS — cost of attendance item terms, contributing COA amounts by term/period.
• IGS_CA_INST_ALL — the calendar instance table from the Student Systems (IGS) calendar module, which supplies the award year and load calendar instance codes and their descriptions and dates.

The view is not referenced by any other database object, confirming it is a terminal reporting object rather than a building block for further application logic. Two of the dependencies (IGF_AP_EFC_CALC and IGF_AP_GEN) indicate that portions of the view's logic are encapsulated in PL/SQL, so the effective row set and column values depend on the runtime behavior of those program units.

Key Columns

• PERSON_NAME (VARCHAR2(360)) — formatted person name derived from TCA party data.
• PERSON_NUMBER (VARCHAR2(30)) — the person's unique identifying number.
• PERSON_ID (NUMBER(15)) — the internal person identifier, the primary join key to other IGF and TCA objects.
• AWARD_YEAR (VARCHAR2(10)) — the alternate short reference code for the award year calendar instance.
• AWARD_YEAR_DESCRIPTION (VARCHAR2(30)) — the descriptive name of the award year calendar instance.
• LOAD_CALENDAR (VARCHAR2(10)) — the alternate short reference code for the load calendar instance.
• LOAD_CALENDAR_DESCRIPTION (VARCHAR2(30)) — the descriptive name of the load calendar instance. This is the column most commonly sought when users search for "load_calendar_description," as it provides the human-readable label for the LOAD_CALENDAR code and is required for report output where the short code alone would be opaque.
• LOAD_CALENDAR_START_DATE and LOAD_CALENDAR_END_DATE (DATE) — the effective date boundaries of the load calendar.
• CUMULATIVE_COA_MONTHS (NUMBER) — the number of months over which cost of attendance is accumulated.
• CUMULATIVE_COA (NUMBER) — the cumulative cost of attendance amount for the load calendar.
• EXPECTED_FAMILY_CONTRIBUTION (NUMBER) — the EFC amount applicable to the student for the period.

Common Use Cases and Queries

The view is typically used to produce federal needs-analysis reports, to validate EFC and COA values feeding packaging, and to export student need data to external reporting or data-warehouse environments. A frequent pattern is joining or filtering by the calendar description, which is available directly on the view.

A basic query listing student need detail for a load calendar is:

• SELECT person_name, person_number, award_year, award_year_description, load_calendar, load_calendar_description, load_calendar_start_date, load_calendar_end_date, cumulative_coa, expected_family_contribution FROM apps.igffv_federal_need_details;

To isolate a specific load calendar by its description:

• SELECT person_number, award_year_description, load_calendar_description, cumulative_coa, expected_family_contribution FROM apps.igffv_federal_need_details WHERE load_calendar_description = :p_load_calendar_description;

To derive need (COA less EFC) for reporting:

• SELECT person_number, award_year_description, load_calendar_description, cumulative_coa, expected_family_contribution, (cumulative_coa - expected_family_contribution) AS need FROM apps.igffv_federal_need_details;

Because the view draws on packaged IGF logic (IGF_AP_EFC_CALC, IGF_AP_GEN), performance may be affected by the volume of financial aid base records and ISIR matches processed; filtering by award year or person is recommended for large populations. Access is governed by standard EBS security applied to the APPS schema and the underlying IGF objects.