Search Results igs_fi_fee_encmb

Overview

The IGS_FI_FEE_ENCMB table is a historical data object within the Oracle E-Business Suite (EBS) Student System (IGS), specifically related to the Financials (FI) module. As explicitly noted in the ETRM documentation, this table is marked as "Obsolete" and was "Not implemented in this database" for the referenced EBS versions 12.1.1 and 12.2.2. Its intended purpose was to store data for special contract-based fee assessment rates, likely representing fee encumbrances or specific fee agreements linked to academic calendars and fee structures. Its obsolete status indicates the underlying business logic was superseded by a different data model or application feature in later implementations of the Student System.

Key Information Stored

The table's structure, as defined by its primary and foreign keys, reveals the core entities it was designed to associate. The primary key is a composite of four columns: FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER, S_RELATION_TYPE, and SEQUENCE_NUMBER. This indicates that records were uniquely identified by a specific fee calendar instance (type and sequence), a system-defined relation type, and a sequence number. Key foreign key columns demonstrate its relationships: FEE_CAT linked to a fee category calendar instance, FEE_TYPE linked to a fee type calendar instance, and DT_ALIAS/DAI_SEQUENCE_NUMBER linked to a date alias instance. These relationships positioned the table as a junction entity connecting fee definitions, academic calendars, and date rules for specialized fee assessments.

Common Use Cases and Queries

Given its obsolete and unimplemented status in standard EBS 12.1.1/12.2.2 deployments, there are no active operational or reporting use cases for this table. In rare instances, such as during a data migration from a legacy IGS system or forensic analysis of an older custom implementation, a technical consultant might query it to understand historical data relationships. A sample analytical query in such a scenario would focus on joining to its referenced parent tables to decipher stored relationships:

• SELECT encmb.*, cat.fee_cat, typ.fee_type, dai.dt_alias FROM igs_fi_fee_encmb encmb LEFT JOIN igs_fi_f_cat_ca_inst cat ON encmb.fee_cat = cat.fee_cat AND encmb.fee_cal_type = cat.cal_type AND encmb.fee_ci_sequence_number = cat.ci_sequence_number LEFT JOIN igs_fi_f_typ_ca_inst_all typ ON encmb.fee_type = typ.fee_type AND encmb.fee_cal_type = typ.cal_type AND encmb.fee_ci_sequence_number = typ.ci_sequence_number WHERE encmb.fee_cal_type = '&CAL_TYPE';

Related Objects

Based on the documented foreign key constraints, the IGS_FI_FEE_ENCMB table has defined relationships with the following parent tables in the IGS schema. These relationships are critical for understanding its intended role in the obsolete data model.

• IGS_CA_DA_INST (Date Alias Instance): Joined via columns DT_ALIAS and DAI_SEQUENCE_NUMBER. This linked the fee encumbrance to specific academic calendar dates.
• IGS_FI_F_CAT_CA_INST (Fee Category Calendar Instance): Joined via columns FEE_CAT, FEE_CAL_TYPE, and FEE_CI_SEQUENCE_NUMBER. This associated the encumbrance with a specific fee category within a calendar.
• IGS_FI_F_TYP_CA_INST_ALL (Fee Type Calendar Instance): Joined via columns FEE_TYPE, FEE_CAL_TYPE, and FEE_CI_SEQUENCE_NUMBER. This associated the encumbrance with a specific fee type within a calendar.