Search Results fee_type_desc




Overview
Explore in AI Chat

Overview

IGS_PS_USEC_SP_FEES_V is a view within the Oracle E-Business Suite Student System (IGS) product family, historically associated with the Higher Education and academic institution offerings built on EBS 12.1.1 and 12.2.2. Its documented purpose is to expose special fees for a unit section — that is, fees defined against a specific teaching unit offering (a class or section), rather than generic institution-wide fee schedules. In reporting and integration terms, the view consolidates the raw special-fee assignment record with a descriptive lookup of the fee type, producing a denormalised row that is convenient for concurrent programs, extracts, BI Publisher reports, and inbound/outbound interfaces carrying fee amounts at the section level.

It is important to note that the ETRM metadata classifies this object under IGS - Student System (Obsolete), and explicitly records that it is Not implemented in this database. In a 12.2.2 instance the view may therefore be absent or unmaterialised depending on the deployment footprint. The object should be treated as a legacy/descriptive artefact rather than an actively supported interface, and any dependency on it should be validated against the target instance before use.

Underlying Base Objects

The view text defines an inner join between two base objects:

  • IGS_PS_USEC_SP_FEES — the driving table, alias USCF, holding the special-fee assignments for a unit section. It supplies the primary key USEC_SP_FEES_ID, the unit offering identifier UOO_ID, the fee type code, the special fee amount, and the standard audit columns.
  • IGS_FI_FEE_TYPE_ALL — the fee type lookup, alias FEE, providing the human-readable FEE_TYPE_DESC via the join predicate USCF.FEE_TYPE = FEE.FEE_TYPE.

Because the join is equi-join on FEE_TYPE with no outer-join syntax, only special-fee rows whose FEE_TYPE exists in IGS_FI_FEE_TYPE_ALL are returned. The view preserves the source ROWID of the special-fee row as ROW_ID, enabling positional identification of the underlying record.

Key Columns

  • ROW_ID — ROWID of the underlying IGS_PS_USEC_SP_FEES row.
  • USEC_SP_FEES_ID — surrogate primary key of the special-fee assignment.
  • UOO_ID — unit offering option / unit section identifier; the operational key linking the fee to a section.
  • FEE_TYPE — code identifying the category of special fee.
  • FEE_TYPE_DESC — descriptive name of the fee type, retrieved from IGS_FI_FEE_TYPE_ALL.
  • SP_FEE_AMT — the special fee amount. This is the column referenced by the search term sp_fee_amt and is the principal monetary value the view exists to expose.
  • CLOSED_FLAG — indicates whether the fee assignment is closed/inactive.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit columns supporting traceability and incremental extraction.

Common Use Cases and Queries

Typical scenarios include section-level fee enquiries, reconciliation of special fees against fee-type definitions, and population of custom reports or extracts that summarise chargeable amounts per unit offering.

Listing all special fees for a section:

  • SELECT USEC_SP_FEES_ID, UOO_ID, FEE_TYPE, FEE_TYPE_DESC, SP_FEE_AMT FROM IGS_PS_USEC_SP_FEES_V WHERE UOO_ID = :p_uooid;

Totalling special fees per section, excluding closed assignments:

  • SELECT UOO_ID, FEE_TYPE_DESC, SUM(SP_FEE_AMT) FROM IGS_PS_USEC_SP_FEES_V WHERE CLOSED_FLAG = 'N' GROUP BY UOO_ID, FEE_TYPE_DESC;

Incremental extraction of recently changed rows:

  • SELECT USEC_SP_FEES_ID, UOO_ID, SP_FEE_AMT FROM IGS_PS_USEC_SP_FEES_V WHERE LAST_UPDATE_DATE >= :p_since;

Given the obsolete classification, querying IGS_PS_USEC_SP_FEES directly with an explicit outer join to IGS_FI_FEE_TYPE_ALL is a prudent alternative where the view is unavailable.