Results for “igs_fi_fee_type_all”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

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:

• IGS_FI_SUBACCTS_ALL — referenced via SUBACCOUNT_ID; defines the accounting subaccount for each fee type.
• IGS_FI_FEE_AS_RT / IGS_FI_FEE_AS_RT_HT_ALL — current and historical fee assessment rates keyed by FEE_TYPE.
• IGS_FI_WAIVER_PGMS — waiver programs referencing ADJUSTMENT_FEE_TYPE, RULE_FEE_TYPE, and TARGET_FEE_TYPE.
• IGS_FI_FEE_TYPE_HIST_ALL — historical snapshots of fee type definitions.
• IGS_FI_F_TYP_CA_INST_ALL — fee type to calendar instance mappings.
• IGS_FI_HOLD_PLAN and IGS_FI_FIN_LT_PLAN — holds and financial letter plans scoped by fee type.
• IGS_FI_1098T_FTS — 1098-T tax reporting fee type attributes.
• IGS_FI_PP_STD_ATTRS / IGS_FI_PP_TEMPLATES — payment processing attributes and templates using PROCESSING_FEE_TYPE.
• IGS_AS_DOC_DLVY_FEE / IGS_AS_DOC_FEE_STUP — document delivery and document fee setup rows keyed by FEE_TYPE.
• IGS_PS_NSUS_RTN / IGS_PS_USEC_SP_FEES — student suspension returns and use-of-space fee records.

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.