Search Results depend_stat




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.