Search Results igs_ps_usec_sp_fees_pk

Overview

The IGS_PS_USEC_SP_FEES table is a data structure within the Oracle E-Business Suite (EBS) Student System (IGS) module. Its primary function is to store the association between a specific unit section and a special fee type that may be applicable to it. This table enables the assignment of non-standard or supplementary fees to individual instructional offerings, allowing for granular fee management beyond standard tuition structures. It is important to note that the ETRM metadata explicitly categorizes the IGS Student System as "Obsolete" and states this specific table is "Not implemented in this database," indicating it may be a legacy or reference object from an earlier design phase that was not deployed in the standard EBS 12.1.1 or 12.2.2 implementations.

Key Information Stored

The table's structure centers on linking a unit section to a fee type. The primary identifier is the system-generated `USEC_SP_FEES_ID`. The core business keys are the `UOO_ID` (Unit Offering Option ID), which uniquely identifies a unit section from the IGS_PS_UNIT_OFR_OPT_ALL table, and the `FEE_TYPE`, which references a valid fee code from the IGS_FI_FEE_TYPE_ALL table. This combination forms a unique constraint (IGS_PS_USEC_SP_FEES_UK1), ensuring a specific fee type is not duplicated for the same unit section. The table acts as a junction between the unit offering and fee definition entities.

Common Use Cases and Queries

In a scenario where this table was implemented, its primary use case would be to query or define special fees for academic offerings. For instance, a laboratory fee for a specific chemistry section or a materials fee for an art studio course could be stored here. A typical reporting query would join this table to unit and fee descriptions. A common SQL pattern would be:

• Retrieve all special fees for a unit section: SELECT f.fee_type, ft.fee_desc FROM igs_ps_usec_sp_fees f, igs_fi_fee_type_all ft WHERE f.uoo_id = :p_uoo_id AND f.fee_type = ft.fee_type;
• Identify all sections with a particular special fee: SELECT uoo_id FROM igs_ps_usec_sp_fees WHERE fee_type = :p_fee_type;

These queries would support billing processes, fee schedules, and student charge assessments.

Related Objects

The IGS_PS_USEC_SP_FEES table has defined relationships with several key EBS objects, primarily through foreign key constraints. The table IGS_PS_UNIT_OFR_OPT_ALL is the parent for the `UOO_ID` column, providing the unit section context. The table IGS_FI_FEE_TYPE_ALL is the parent for the `FEE_TYPE` column, validating the fee code. Notably, the table IGS_FI_SPECIAL_FEES is documented as having a foreign key reference back to IGS_PS_USEC_SP_FEES on the combined columns `UOO_ID` and `FEE_TYPE`. This suggests IGS_FI_SPECIAL_FEES may hold the detailed transactional or calculated amount data, while IGS_PS_USEC_SP_FEES stores the defining association.