Search Results igf_sp_fc_all

Overview

The IGF_SP_FC_ALL table is a core data structure within the Oracle E-Business Suite's Financial Aid module (IGF). It functions as a transactional table that stores fee class details specifically for sponsor funds configured with a "pays only" designation. In the context of financial aid administration, a sponsor fund represents an external funding source, and associated fees may be charged for its management. This table establishes and maintains the linkage between a sponsor fund and the specific fee classifications (e.g., administrative, processing) that are applicable to it, thereby enabling precise fee assessment and accounting within the system.

Key Information Stored

The table's structure is designed to enforce data integrity through primary and unique keys. The critical columns include FEE_CLS_ID, which serves as the table's primary key and uniquely identifies each fee class record. The FUND_ID column is a foreign key that links the fee class to its specific sponsor fund in the IGF_AW_FUND_MAST_ALL table. The FEE_CLASS column holds the actual code or identifier for the type of fee. Together, FUND_ID and FEE_CLASS form a unique key constraint (IGF_SP_FC_ALL_UK), ensuring that a given fee class cannot be duplicated for the same sponsor fund. This design centrally manages the permissible fee types for each funding source.

Common Use Cases and Queries

A primary use case is the setup and maintenance of sponsor fund fee structures during financial aid configuration. Analysts and administrators query this table to validate or report on which fees are assigned to specific funds. A common reporting need is to list all fee classes for a particular sponsor fund, which can be achieved with a simple SELECT statement filtered by FUND_ID. Furthermore, the table is integral to processes that calculate charges against sponsor funds, as downstream logic references the valid FEE_CLASS values stored here. Troubleshooting often involves queries to find orphaned records or to verify the existence of a fee class assignment before generating financial transactions.

• Retrieve all fee classes for a specific fund: SELECT fee_class FROM igf_sp_fc_all WHERE fund_id = <FUND_ID>;
• Validate a fee class assignment: SELECT 'EXISTS' FROM dual WHERE EXISTS (SELECT 1 FROM igf_sp_fc_all WHERE fund_id = <FUND_ID> AND fee_class = '<FEE_CODE>');

Related Objects

The IGF_SP_FC_ALL table has defined relationships with other key Financial Aid tables, as indicated by its foreign key constraints. It is a child table to IGF_AW_FUND_MAST_ALL via the FUND_ID column, which is the master record for award funds. Conversely, it acts as a parent table to IGF_SP_PRG_ALL, which likely holds sponsor program details, through the FEE_CLS_ID column. This relationship suggests that a fee class defined in IGF_SP_FC_ALL can be associated with one or more sponsor programs. Understanding these relationships is crucial for writing accurate joins in reports and for comprehending the data flow during sponsor-related transactions and fee assessments.