Search Results igf_aw_fi_inc_level




Overview
Explore in AI Chat

Overview

The IGF_AW_FI_INC_LEVEL table is a core configuration entity within the Oracle E-Business Suite's Financial Aid module (IGF). Its primary function is to store the income level ranges used specifically for generating the Fiscal Operations Report and Application to Participate (FISAP). This report is a mandatory annual submission for U.S. institutions participating in the Federal Campus-Based programs. The table enables institutions to define distinct income brackets for various student populations, which are critical for calculating and reporting student financial need and eligibility statistics to the U.S. Department of Education. Its configuration directly feeds the logic behind key FISAP calculations.

Key Information Stored

The table defines income ranges for a specific student category. Its structure centers on a unique combination of a category identifier and a minimum income value. The primary column, RANGE_ID, serves as the unique system identifier for each income range record. The CATEGORY_ID is a foreign key that links to a specific combination of parameters defined in the IGF_AW_FISAP_REPSET table, including Award Year, FISAP Section, Dependency Status, and Class Standing. The MINVALUE column stores the lower bound of the defined income range. The table's unique key constraint (IGF_AW_FI_INC_LEVEL_UK) ensures that for any given category, a specific minimum income value is not duplicated, maintaining data integrity for the range definitions.

Common Use Cases and Queries

The primary use case is the setup and execution of FISAP reporting. Administrators populate this table during annual setup to reflect the current year's federal income guidelines for different student classifications. A common operational query involves retrieving all configured income levels for a specific award year and FISAP section to validate setup before report submission. For example:

  • SELECT inc.* FROM igf_aw_fi_inc_level inc JOIN igf_aw_fisap_repset cat ON inc.category_id = cat.category_id WHERE cat.award_year = '2024-2025' AND cat.fisap_section = 'SECTION_A';

During FISAP report generation, the system queries this table to map a student's calculated income to the appropriate range, determining their placement in report statistics. Troubleshooting often involves verifying that income ranges are contiguous and correctly mapped to the proper student categories.

Related Objects

The IGF_AW_FI_INC_LEVEL table has a direct and essential relationship with the IGF_AW_FISAP_REPSET table, which defines the student categories. The documented foreign key relationship is:

  • Foreign Key Reference: IGF_AW_FI_INC_LEVEL.CATEGORY_ID → IGF_AW_FISAP_REPSET (Table). This relationship ensures that every income range is associated with a valid, pre-defined reporting category. The CATEGORY_ID in IGF_AW_FI_INC_LEVEL is the join column. There are no other foreign keys documented where this table is the parent, indicating it is a child or detail table in the FISAP configuration hierarchy.
  • Table: IGF_AW_FI_INC_LEVEL 12.1.1

    owner:IGF,  object_type:TABLE,  fnd_design_data:IGF.IGF_AW_FI_INC_LEVEL,  object_name:IGF_AW_FI_INC_LEVEL,  status:VALID,  product: IGF - Financial Aid ,  description: This entity holds information to setup the various Income Levels for a specific category ID, which is a combination of Award year, FISAP section, Dependency Status and Class Standing. This range information is used in the FISAP reports. ,  implementation_dba_data: IGF.IGF_AW_FI_INC_LEVEL , 

  • Table: IGF_AW_FISAP_REPSET 12.1.1

    owner:IGF,  object_type:TABLE,  fnd_design_data:IGF.IGF_AW_FISAP_REPSET,  object_name:IGF_AW_FISAP_REPSET,  status:VALID,  product: IGF - Financial Aid ,  description: This entity holds information to set up the category under which the Students FISAP Income would get classified. ,  implementation_dba_data: IGF.IGF_AW_FISAP_REPSET , 

  • View: IGF_AW_FISAP_SECTION_II_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGF.IGF_AW_FISAP_SECTION_II_V,  object_name:IGF_AW_FISAP_SECTION_II_V,  status:VALID,  product: IGF - Financial Aid ,  description: Stores the count of the Students, who have their FISAP Income between the income ranges as specified in the FISAP Reporting ,  implementation_dba_data: APPS.IGF_AW_FISAP_SECTION_II_V , 

  • View: IGF_AW_FISAP_SECTION_VI_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGF.IGF_AW_FISAP_SECTION_VI_V,  object_name:IGF_AW_FISAP_SECTION_VI_V,  status:VALID,  product: IGF - Financial Aid ,  description: This entity is used to derive the count of the Students as well as the sum of their disbursed amounts for Campus Based Funds for the section VI of FISAP Reporting ,  implementation_dba_data: APPS.IGF_AW_FISAP_SECTION_VI_V ,