Results for “igs_fi_unit_fee_trg”

50+ results




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

Overview

The IGS_FI_UNIT_FEE_TRG table is a component of the Oracle E-Business Suite Student System (IGS) product family, which is designated as obsolete in Release 12.1.1 and 12.2.2. This entity describes unit-based fee triggers, which are configuration records consulted during fee assessment processing to determine whether a unit-based fee applies for a given fee type. In practical terms, the table functions as an assessment rule store: each row associates a fee category and fee type with a specific academic unit (or unit class, location, and version) so that the fee engine can raise the appropriate charge when a student enrolls in or is associated with that unit.

Because the IGS product line is obsolete, the object is generally not implemented in current databases, and the ETRM metadata explicitly records "Not implemented in this database." Implementations that retain Student System data may still encounter the table in legacy schemas, historical extracts, or migration projects targeting Oracle Student Cloud or third-party student systems. From a Data Vault modeling perspective, the mined foreign-key structure suggests a link classification, since the table resolves relationships among fee categories, calendar instances, units, locations, and unit classes rather than acting as a standalone hub or descriptive satellite.

Key Information Stored

The table contains nineteen documented columns. The most significant are the following.

The surrogate primary key is IGS_FI_UNIT_FEE_TRG_PK, defined over FEE_CAT, FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER, FEE_TYPE, UNIT_CD, and SEQUENCE_NUMBER. Two unique indexes act as business-key candidates: IGS_FI_UNIT_FEE_TRG_U1 mirrors the primary key columns, while IGS_FI_UNIT_FEE_TRG_U2 broadens the key to include VERSION_NUMBER, CAL_TYPE, CI_SEQUENCE_NUMBER, LOCATION_CD, UNIT_CLASS, and CREATE_DT, reflecting the full natural identity of a trigger record. The second unique index, labeled UFT_UK in the documentation, serves as the primary business-key constraint.

Common Use Cases and Queries

Typical usage centers on auditing and reconciling fee assessment configuration, diagnosing why a unit-based fee was or was not charged, and extracting trigger definitions for migration. A representative query retrieves all triggers for a given fee type within a calendar instance:

  • SELECT fee_cat, fee_type, unit_cd, unit_class, location_cd, version_number FROM igs_fi_unit_fee_trg WHERE fee_cat = :fee_cat AND fee_cal_type = :cal_type AND fee_ci_sequence_number = :seq AND fee_type = :fee_type AND logical_delete_dt IS NULL;

Reporting scenarios include producing a matrix of units against applicable fee types, verifying that no duplicate active triggers exist for the same natural key, and identifying soft-deleted or superseded rows through LOGICAL_DELETE_DT. Because the table joins freely to unit, calendar, and location reference data, it is well suited to cross-reference reports that reconcile fee setup against the curriculum catalog.

Related Objects

The documented foreign keys reveal the principal related objects and their join columns.

  • IGS_CA_TYPE and IGS_CA_INST_ALL — joined on CAL_TYPE and CI_SEQUENCE_NUMBER, providing calendar type and instance context.
  • IGS_FI_F_CAT_FEE_LBL_ALL — joined on FEE_CAT, FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER, and FEE_TYPE, supplying fee category and fee type labels.
  • IGS_FI_FEE_TRG_GRP — joined on FEE_CAT, FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER, FEE_TYPE, and FEE_TRIGGER_GROUP_NUMBER, linking triggers into processing groups.
  • IGS_AD_LOCATION_ALL — joined on LOCATION_CD, resolving delivery locations.
  • IGS_AS_UNIT_CLASS_ALL — joined on UNIT_CLASS, resolving unit classifications.
  • IGS_PS_UNIT and IGS_PS_UNIT_VER_ALL — joined on UNIT_CD (and VERSION_NUMBER for the versioned table), resolving the unit and unit version definitions.

Together these relationships position IGS_FI_UNIT_FEE_TRG as a central link between fee assessment configuration and the academic unit, calendar, and location dimensions of the Student System.