Results for “fee_cat_ci_status”

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

Overview

IGS_FI_FEE_CAT_CI_HT_ALL is a history/audit table within the Oracle E-Business Suite IGS (Student System) product family. It stores the temporal history of special contract-based fee assessment rates associated with a fee category and fee calendar. The object belongs to the Student System module, which Oracle has designated as obsolete in current EBS releases; consequently, the ETRM documentation records it as "Not implemented in this database" under 12.1.1, reflecting its removal from the shipped product schema.

The table follows the standard EBS date-tracked history convention: a primary key that extends the base entity key with a HISTORY_START_DATE column, and a HISTORY_END_DATE column marking the point at which a version ceased to be current. The presence of ORG_ID and the standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) places it in the multi-org, audited class of IGS fee configuration objects.

Under a heuristic Data Vault classification, the object is best modelled as a satellite. Its primary key is composed of business attributes (FEE_CAT, FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER) plus a load-date column (HIST_START_DT), which is characteristic of a satellite attached to a hub or link rather than a standalone hub. The metadata explicitly notes the classification as "standalone," so this should be treated as a modeling suggestion rather than a documented dependency.

Key Information Stored

The table contains 19 documented columns. The most significant are:

• FEE_CAT — the fee category identifier; part of the primary key and unique key.
• FEE_CAL_TYPE — the fee calendar type; part of the primary key and unique key.
• FEE_CI_SEQUENCE_NUMBER — the sequence number identifying the specific contract-instance fee record within the category/calendar combination.
• HIST_START_DT — the effective start date of this history row; also the temporal component of the primary key.
• HIST_END_DT — the end date of this history version, null for the current row.
• HIST_WHO — the user or process that created the history version.
• FEE_CAT_CI_STATUS — the lifecycle status of the fee category contract item (for example active or inactive) at the time the history row was written.
• START_DT_ALIAS / START_DAI_SEQUENCE_NUMBER — the date alias and date-alias-instance sequence used to derive the assessment start date.
• END_DT_ALIAS / END_DAI_SEQUENCE_NUMBER — the corresponding attributes for the assessment end date.
• RETRO_DT_ALIAS / RETRO_DAI_SEQUENCE_NUMBER — the attributes governing retroactive fee assessment dates.
• ORG_ID — the operating unit, enabling multi-org security.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit columns.

The surrogate primary key is IGS_FI_FEE_CAT_CI_HT_PK, defined over FEE_CAT, FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER, and HIST_START_DT. The unique index IGS_FI_FEE_CAT_CI_HT_ALL_U1 covers the same four columns, which effectively prevents duplicate history versions for the same business key and effective date.

Common Use Cases and Queries

Because this object is documented as obsolete and not implemented, direct query patterns are largely of historical or migration interest. Where the object exists in a legacy environment, typical usage includes point-in-time reconstruction of contract-based fee assessment rules and auditing of changes made to date aliases or status values.

A reconstruction query retrieves the version in effect for a given key and date:

• SELECT * FROM igs_fi_fee_cat_ci_ht_all WHERE fee_cat = :p_cat AND fee_cal_type = :p_cal AND fee_ci_sequence_number = :p_seq AND hist_start_dt <= :p_asof AND (hist_end_dt IS NULL OR hist_end_dt > :p_asof) ORDER BY hist_start_dt DESC;

A change-audit report groups versions by FEE_CAT_CI_STATUS to identify when an assessment rate was activated or retired. A data-migration extract joins the open history row (HIST_END_DT IS NULL) to its parent fee configuration to populate a successor structure in a supported module.

Related Objects

The ETRM metadata classifies IGS_FI_FEE_CAT_CI_HT_ALL as standalone, with no documented foreign-key relationships. The following join candidates are suggested by the key structure:

• IGS_FI_FEE_CAT_CI_ALL — the base (non-history) entity, joined on FEE_CAT, FEE_CAL_TYPE, and FEE_CI_SEQUENCE_NUMBER.
• IGS_FI_FEE_CAT_ALL — the fee category definition master.
• IGS_FI_FEE_CAL_TYPE_ALL — the fee calendar type reference, joined on FEE_CAL_TYPE.
• IGS_FI_FEE_CAT_CI_HIST — the parallel history store for the same business entity, where implemented.
• IGS_FI_FEE_CAT_CI_DAI — date-alias-instance associations joined on the DAI sequence columns.
• IGS_DA_ALIAS_ALL — the date alias lookup, joined on START_DT_ALIAS, END_DT_ALIAS, and RETRO_DT_ALIAS.
• HR_OPERATING_UNITS — joined on ORG_ID for multi-org reporting.

Organizations retaining IGS data should treat these relationships as analytical guidance rather than enforced referential constraints.