Search Results fisap_section




Overview
Explore in AI Chat

Overview

The table IGF_AW_FISAP_REPSET is a configuration entity within the Oracle E-Business Suite (EBS) Financial Aid module (IGF), specifically designated as obsolete. Its primary function is to define the classification categories for student income data reported on the Fiscal Operations Report and Application to Participate (FISAP). This form is a mandatory annual submission for U.S. institutions participating in the Federal Perkins Loan, Federal Work-Study, and Federal Supplemental Educational Opportunity Grant programs. The table establishes the mapping logic, based on student attributes and academic calendar context, to determine under which FISAP income category a student's financial data should be aggregated and reported, serving as a critical setup component for FISAP compliance reporting.

Key Information Stored

The table's structure centers on a unique combination of attributes that define a reporting category. The primary identifier is CATEGORY_ID. The unique key, however, is a composite of several columns that collectively define the classification rule: DEPEND_STAT (dependency status), CLASS_STANDING (academic class standing), CI_CAL_TYPE and CI_SEQUENCE_NUMBER (linking to a specific academic calendar instance in IGS_CA_INST_ALL), and FISAP_SECTION (indicating the specific part of the FISAP form, such as Section II or VI). This design ensures that for a given calendar and FISAP section, a student's specific dependency and class standing map to one definitive income reporting category.

Common Use Cases and Queries

The primary use case is the batch process that generates FISAP reports. A typical query would retrieve the target category for a set of students based on their profile and the reporting period. For example, to find all classification rules for a specific academic calendar and FISAP section, one might use:

  • SELECT category_id, depend_stat, class_standing FROM igf_aw_fisap_repset WHERE ci_cal_type = 'ACADEMIC' AND ci_sequence_number = 2023 AND fisap_section = 'II';

Administrators might also query the setup to audit or maintain category definitions. Given the module's obsolete status, direct interaction is typically limited to supporting legacy data or historical reporting requirements within implementations that have not yet migrated from this functionality.

Related Objects

IGF_AW_FISAP_REPSET sits at the center of the FISAP reporting configuration. It is referenced by key transactional tables that store the actual income data classified by these categories:

The table also has a mandatory foreign key relationship to IGS_CA_INST_ALL (Calendar Instance), ensuring that category definitions are tied to a valid academic period. This relationship enforces data integrity across the academic structure and financial aid reporting modules.

  • 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_REPSET_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGF.IGF_AW_FISAP_REPSET_V,  object_name:IGF_AW_FISAP_REPSET_V,  status:VALID,  product: IGF - Financial Aid ,  description: This entity is be used to define the category ID which consists of an Award Year, Class Standing, Dependency Status , and FISAP Section .Based on the category ID , the FISAP Income ranges would be defined ,  implementation_dba_data: APPS.IGF_AW_FISAP_REPSET_V , 

  • 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 ,