Search Results depend_stat




Overview
Explore in AI Chat

Overview

The IGF_AW_FISAP_REPSET table is a core configuration entity within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically in the Grants and Financial Aid (IGF) module. Its primary role is to define the classification categories for student income data required for the Fiscal Operations Report and Application to Participate (FISAP). This report is mandated for institutions participating in the U.S. Federal Campus-Based programs. The table establishes the logical mapping between student characteristics—such as dependency status and class standing—and the specific sections of the FISAP report where their income data must be aggregated and reported, ensuring regulatory compliance.

Key Information Stored

The table stores unique combinations of attributes that define a reporting category. The central column is CATEGORY_ID, a system-generated unique identifier. The business logic is defined by five key columns: FISAP_SECTION (e.g., SECTION II, SECTION V), DEPEND_STAT (Dependent, Independent), CLASS_STANDING (e.g., Under Graduate, Graduate Professional), CI_CAL_TYPE, and CI_SEQUENCE_NUMBER. The latter two columns collectively identify the award year context. The table also includes standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) for audit purposes. Two unique indexes enforce data integrity: one on CATEGORY_ID and another on the composite key of the five defining business columns.

Common Use Cases and Queries

This table is primarily used during the FISAP reporting setup and generation process. Administrators configure categories through the EBS user interface, which writes records to this table. During batch processing, the system queries this table to determine into which FISAP section a student's financial data should be summarized based on their profile. A common reporting query retrieves all category definitions for a specific award year to validate setup.

SELECT category_id,
       fisap_section,
       depend_stat,
       class_standing
FROM   igf.igf_aw_fisap_repset
WHERE  ci_cal_type = '&Award_Year_Type'
AND    ci_sequence_number = &Award_Year_Sequence;

Another critical use case is ensuring no duplicate category rules exist, leveraging the unique composite index on the five key columns.

Related Objects

Based on the provided metadata, the IGF_AW_FISAP_REPSET table does not have explicitly documented foreign key relationships referencing other objects. However, as a foundational configuration table, it is logically referenced by other FISAP-related tables and application logic within the IGF module that process student income data. These downstream objects would use the CATEGORY_ID or the combination of the five defining columns to associate student records with the correct FISAP reporting bucket. The table's design as a standalone reference entity suggests it is populated during initial setup and then read extensively by the FISAP reporting engine.