Results for “sp_fee_amt”

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

Overview

IGS_PS_USEC_SP_FEES is a transactional table in the Oracle E-Business Suite Student System (IGS) product family. It stores special fees that are associated with a specific offering of a unit section — that is, the surcharge, ancillary, or non-standard fee amounts that apply to a particular unit offering option rather than to a student's general enrollment record. The table therefore sits at the intersection of the academic structure (unit offerings) and the financial structure (fee types), acting as a bridge between curricular configuration and fee assessment processing in Release 12.1.1 and 12.2.2.

From a data-modeling perspective, the heuristic Data Vault classification mined from the foreign-key structure is satellite-leaning. The table carries descriptive and measurable attributes (the fee amount and the closed indicator) tied to a business key composed of the unit offering option and fee type, together with standard Who-column audit metadata. It should therefore be modeled as a satellite attached to the hub or link that represents a unit offering option's fee assignment, rather than as an independent hub.

Key Information Stored

The documented physical schema exposes ten columns. The most significant are:

• USEC_SP_FEES_ID — The surrogate primary key, enforced by the unique index IGS_PS_USEC_SP_FEES_PK. This is the internal system-generated identifier referenced by downstream child tables and APIs.
• UOO_ID — The unit offering option identifier, which anchors the fee to a specific offering of a unit section. It participates in the business-key unique index and carries a foreign key to IGS_PS_UNIT_OFR_OPT_ALL.
• FEE_TYPE — The fee category code, validated against IGS_FI_FEE_TYPE_ALL; together with UOO_ID it forms the second unique index, IGS_PS_USEC_SP_FEES_U1.
• SP_FEE_AMT — The monetary amount of the special fee assessed for that offering option and fee type combination.
• CLOSED_FLAG — An indicator controlling whether the fee row remains active or has been retired, supporting soft-deletion and effective-dating behavior without removing history.

The remaining columns are the standard Oracle audit attributes: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN. A deliberate distinction exists between the surrogate key (USEC_SP_FEES_ID) and the natural business keys (UOO_ID + FEE_TYPE), which makes the table suitable for both surrogate-driven joins and business-key reconciliation during data migration or integration.

Common Use Cases and Queries

Typical usage centers on fee assessment, billing preparation, and reconciliation between the Student System and Receivables. A recurring query pattern retrieves all active special fees for a given offering option:

• SELECT usf.usec_sp_fees_id, usf.uoO_id, usf.fee_type, usf.sp_fee_amt FROM igs_ps_usec_sp_fees usf WHERE usf.uoO_id = :uoO_id AND usf.closed_flag = 'N';
• Joining to IGS_FI_FEE_TYPE_ALL to resolve descriptive fee type names for reporting or invoicing layouts.
• Auditing recently modified fee rows using LAST_UPDATE_DATE for change-detection feeds into downstream billing or data-warehouse processes.
• Validating total special fee exposure per unit offering option for a given academic period.

Related Objects

• IGS_FI_FEE_TYPE_ALL — Parent reference for FEE_TYPE; supplies the authoritative fee type definition and description.
• IGS_PS_UNIT_OFR_OPT_ALL — Parent reference for UOO_ID; identifies the unit offering option to which the special fee belongs.
• IGS_FI_SPECIAL_FEES — Downstream table that references this table's business key (UOO_ID, FEE_TYPE), representing the student-level application of special fee assessments.

Together these relationships confirm that IGS_PS_USEC_SP_FEES functions as the configuration satellite defining special fees per unit offering option, which downstream student fee records then consume.