Results for “igs_en_unitsetfeetrg”

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

Overview

IGS_EN_UNITSETFEETRG is a table within the Oracle E-Business Suite IGS – Student System product family, classified in current ETRM documentation as Obsolete. It belongs to the legacy Student System data model that predates the Oracle Student Cloud applications, and in the 12.1.1 metadata it is documented but flagged as "Not implemented in this database." The entity records unit set fee triggers — the configuration rows that signal, during fee assessment processing, that a unit set based fee applies for a given fee type. In effect, it acts as a routing or applicability rule table that integrates unit set definitions with the fee assessment engine.

The Data Vault classification derived heuristically from the foreign-key structure is a link. This suggests the table is best modeled as an intersection (many-to-many resolution) entity connecting a fee configuration domain (fee categories, fee calendars, fee types, fee trigger groups) to a unit set definition domain (unit set codes and versions). The presence of a composite business key built from both domains, along with standard EBS audit columns, reinforces the link interpretation rather than a hub or satellite.

Key Information Stored

The table’s primary key, IGS_EN_UNITSETFEETRG_PK, is a composite business key rather than a generated surrogate; it is mirrored by the unique index IGS_EN_UNITSETFEETRG_U1 over the same seven columns. The most significant columns are:

• FEE_CAT – The fee category that scopes the trigger rule.
• FEE_CAL_TYPE – The fee calendar type under which the fee applies.
• FEE_CI_SEQUENCE_NUMBER – Sequence number identifying the specific fee calendar instance.
• FEE_TYPE – The fee type for which a unit set based fee is being triggered.
• FEE_TRIGGER_GROUP_NUMBER – The fee trigger group (from IGS_FI_FEE_TRG_GRP) that the row participates in.
• UNIT_SET_CD – The unit set code whose presence triggers the fee.
• VERSION_NUMBER – Version of the unit set, supporting effective-dated unit set definitions.
• CREATE_DT – Creation date participating in the business key.
• LOGICAL_DELETE_DT – Soft-delete marker used to retire obsolete trigger rows without physical removal.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN – Standard EBS audit and concurrency columns.

The composite business key’s use of FEE_CAT, FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER, FEE_TYPE, UNIT_SET_CD, VERSION_NUMBER, and CREATE_DT means uniqueness is enforced across both the fee dimension and the unit set dimension simultaneously.

Common Use Cases and Queries

The principal use case is fee assessment diagnostics: determining which unit set based fees are configured to fire for a given fee category, calendar instance, and unit set. A typical pattern joins the trigger rows to the unit set master to resolve descriptive attributes:

• Trigger lookup by unit set — SELECT t.fee_cat, t.fee_cal_type, t.fee_ci_sequence_number, t.fee_type, t.unit_set_cd, t.version_number FROM igs_en_unitsetfeetrg t WHERE t.unit_set_cd = :unit_set_cd AND t.logical_delete_dt IS NULL.
• Active trigger validation — filtering rows where LOGICAL_DELETE_DT IS NULL to exclude retired configurations from assessment runs.
• Version-aware resolution — joining to IGS_EN_UNIT_SET_ALL on UNIT_SET_CD and VERSION_NUMBER to confirm the unit set version is current at assessment time.
• Trigger group reporting — aggregating by FEE_TRIGGER_GROUP_NUMBER to audit which fee types share trigger groups.

Because the object is documented as obsolete and possibly unimplemented, queries should first verify object existence in the target instance before being incorporated into production reporting.

Related Objects

• IGS_EN_UNIT_SET_ALL — referenced via UNIT_SET_CD and VERSION_NUMBER; supplies the unit set definition that activates the trigger.
• IGS_FI_F_CAT_FEE_LBL_ALL — referenced via FEE_CAT, FEE_CAL_TYPE, and FEE_CI_SEQUENCE_NUMBER; provides the fee category/calendar labeling context.
• IGS_FI_FEE_TRG_GRP — referenced via FEE_CAT, FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER, FEE_TYPE, and FEE_TRIGGER_GROUP_NUMBER; defines the trigger group the row belongs to.
• Fee assessment processing routines (IGS_EN fee engine) — consume these rows at runtime to determine whether a unit set based fee applies.