Search Results s_fee_trigger_cat




Overview
Explore in AI Chat

Overview

IGS_FI_FEE_TYPE_ALL is a foundational setup and reference table within the Oracle E-Business Suite Student System (IGS) product family. In Oracle EBS 12.1.1 and 12.2.2, this table resides in the IGS schema and serves as the master definition list of fee types used throughout the institution's financial and student accounting processes. The entity is documented as describing special contract-based fee assessment rates, meaning it centralizes the permissible categories of charges — tuition, laboratory fees, technology fees, application charges, and similar items — that can be assessed against a student account, applied as a waiver, or processed as a payment.

Because nearly every downstream financial transaction module references a fee type by its primary key value, this table operates as a central reference point rather than a transactional ledger. Heuristic Data Vault classification derived from the foreign key topology suggests a hub-leaning role: the table holds the unique business key FEE_TYPE, while surrounding tables (assessment rate history, waivers, payment plans, and 1098-T reporting) act as satellites or links that attach descriptive and transactional context to that key. This modeling suggestion reflects the table's position as the anchor for the fee domain.

Key Information Stored

The physical schema documents sixteen columns. The primary key constraint, IGS_FI_FEE_TYPE_PK, is enforced on the FEE_TYPE column. This column also carries a unique index, IGS_FI_FEE_TYPE_ALL_U1, making FEE_TYPE the definitive business-key candidate as well as the surrogate identifier used in joins. The most significant columns include:

  • FEE_TYPE — The unique code identifying the fee; both the primary key and the business-key candidate.
  • S_FEE_TYPE — The system-level or seed designation corresponding to the fee type.
  • S_FEE_TRIGGER_CAT — The trigger category that governs when the fee is automatically assessed.
  • DESCRIPTION — The human-readable name of the fee presented to users and on student-facing documents.
  • FEE_CLASS — The broader classification grouping the fee for reporting and processing logic.
  • SUBACCOUNT_ID — Foreign key to IGS_FI_SUBACCTS_ALL, mapping the fee to its general ledger subaccount.
  • OPTIONAL_PAYMENT_IND — Indicates whether the fee may be paid optionally rather than mandatorily.
  • DESIGNATED_PAYMENT_FLAG — Flags fees that must be settled through a designated payment mechanism.
  • CLOSED_IND — Marks the fee type as inactive, preventing further assessment while preserving history.
  • COMMENTS — Free-form administrative notes about the fee definition.
  • ORG_ID — The operating unit that owns the setup row, enabling multi-organization partitioning.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard Oracle EBS audit columns for row-level change tracking.

Common Use Cases and Queries

The table is routinely queried as the driving table in fee setup reports, validation lookups, and integration extracts. A typical reporting query joins it to the subaccount table to display the accounting distribution:

  • Active fee type lookup: SELECT fee_type, description, fee_class FROM igs_fi_fee_type_all WHERE closed_ind = 'N' AND org_id = :org_id;
  • Subaccount validation: SELECT f.fee_type, s.subaccount_id FROM igs_fi_fee_type_all f, igs_fi_subaccnts_all s WHERE f.subaccount_id = s.subaccount_id;
  • Assessment rate maintenance: joining to IGS_FI_FEE_AS_RT and IGS_FI_FEE_AS_RT_HT_ALL to reconcile current against historical rates.
  • Waiver configuration audit: joining to IGS_FI_WAIVER_PGMS to confirm adjustment, rule, and target fee types are valid and open.
  • 1098-T reporting: joining to IGS_FI_1098T_FTS to map qualified tuition fee types for tax statement generation.

Because FEE_TYPE is both unique and widely referenced, it is the mandatory join predicate in virtually every query touching fee-related data.

Related Objects

Foreign key metadata identifies one outbound reference and a broad set of dependent tables. The significant related objects are:

These dependencies confirm that IGS_FI_FEE_TYPE_ALL is a central, hub-like reference whose FEE_TYPE value must remain stable and uniquely defined across the Student System.