Results for “uft_uk”
3 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.
- FEE_CAT, FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER, FEE_TYPE — together these identify the fee category, the fee calendar type and calendar instance, and the specific fee type to which the unit-based trigger applies. These columns form the core of both unique indexes.
- UNIT_CD — the academic unit code that activates the trigger.
- SEQUENCE_NUMBER — an ordering discriminator that permits multiple trigger rows for the same fee and unit combination.
- VERSION_NUMBER — the version of the unit to which the trigger applies, supporting versioned curriculum structures.
- CAL_TYPE and CI_SEQUENCE_NUMBER — the calendar type and calendar instance used to scope the trigger by academic period.
- LOCATION_CD — restricts the trigger to a specific delivery location.
- UNIT_CLASS — allows the trigger to apply to a class of units rather than a single unit.
- FEE_TRIGGER_GROUP_NUMBER — groups related triggers for collective processing.
- CREATE_DT and LOGICAL_DELETE_DT — effective-dating and soft-delete indicators.
- CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard Oracle EBS audit columns.
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.
-
Table: IGS_FI_UNIT_FEE_TRG 12.2.2
This entity describes the unit based fee triggers. It is used during fee assessment processing to indicate a unit based fee applies for a fee type.
Not implemented in this database·Explore IGS module →
-
eTRM - IGS Tables and Views 12.1.1
Holds applicant whose records are wrongly available . It is recommended that such applicant records are deleted from the system . It synchronizes with UCAS view 'ivStarW'.
-
eTRM - IGS Tables and Views 12.1.1
Holds applicant whose records are wrongly available . It is recommended that such applicant records are deleted from the system . It synchronizes with UCAS view 'ivStarW'.