Search Results igs_fi_fee_type_all

Overview

The IGS_FI_FEE_TYPE_ALL table is a core entity within the Oracle E-Business Suite Student System (IGS) module, specifically for Release 12.1.1 and 12.2.2. It serves as the master definition table for special contract-based fee assessment rates. Its primary role is to establish and maintain distinct fee types, which act as templates or categories for the financial charges assessed to students. These fee types are foundational to the student financials subsystem, enabling the configuration of diverse fee structures, linking fees to specific sub-accounts for accounting, and driving downstream processes like assessment, waivers, and financial aid reporting.

Key Information Stored

While the provided metadata does not list specific columns, the table's primary key is the FEE_TYPE column, which uniquely identifies each fee type code. A critical foreign key column is SUBACCOUNT_ID, which links each fee type to a specific financial sub-account defined in the IGS_FI_SUBACCTS_ALL table. This link is essential for ensuring assessed fees post to the correct general ledger accounts. Based on its central function, the table likely stores descriptive attributes such as a fee type description, status (active/inactive), effective dates, and categorization flags that determine how the fee is processed, reported (e.g., for 1098-T forms), or included in balance calculations.

Common Use Cases and Queries

This table is central to financial setup and inquiry. Common use cases include configuring new fee types for tuition, lab fees, or late payment charges, and generating reports on all defined fee structures. Administrators query this table to understand which fees are linked to specific sub-accounts or to validate fee types used in transactional data. A typical query pattern involves joining with the sub-account table for a complete financial view:

• SELECT ft.fee_type, ft.description, sa.subaccount_code FROM igs_fi_fee_type_all ft, igs_fi_subaccts_all sa WHERE ft.subaccount_id = sa.subaccount_id AND ft.status = 'ACTIVE';

Another critical use is tracing the usage of a fee type across the application by querying the numerous foreign key relationships documented in the metadata.

Related Objects

The IGS_FI_FEE_TYPE_ALL table has extensive relationships, underscoring its importance. It is referenced by numerous transactional and setup tables. Key related objects include:

• IGS_FI_FEE_AS_RT(_HT_ALL): Stores the actual assessment rates defined for each fee type.
• IGS_FI_FEE_TYPE_HIST_ALL: Maintains historical changes to fee type records.
• IGS_FI_SUBACCTS_ALL: Holds the sub-account linked via SUBACCOUNT_ID.
• IGS_FI_WAIVER_PGMS: References fee types for waiver rules, adjustments, and targets.
• IGS_FI_1098T_FTS: Maps fee types for U.S. 1098-T tax form reporting.
• IGS_FI_PP_TEMPLATES / IGS_FI_PP_STD_ATTRS: Uses fee types for payment processing setup.
• IGS_FI_FIN_LT_PLAN: Links fee types to financial installment plans.
• IGS_PS_USEC_SP_FEES: Associates fee types with specific unit sections.