Search Results igs_fi_sub_er_rt




Overview
Explore in AI Chat

Overview

IGS_FI_SUB_ER_RT is a transaction and reference table within the Oracle E-Business Suite IGS (Student System) product family, documented as obsolete in the 12.1.1 and 12.2.2 releases. The table stores charge rates that apply to a specific sub-range of charge elements, bridging the definition of a charge sub-element range with the fee rate structure used to price student financial transactions. Its role is therefore one of rate assignment: it associates a defined sub-element range with a rate record, allowing the Student System to resolve the correct amount for charges falling within a narrower band of the broader charge element definition.

From a Data Vault modeling perspective, the metadata classifies this object heuristically as a link. That classification is consistent with its structure: the table carries two foreign keys that reference independent parent entities (the sub-element range and the fee-as-rate record) and adds descriptive attributes such as create and audit columns. A link interpretation suggests this object exists primarily to record an association between two business keys rather than to serve as a standalone hub or a descriptive satellite.

Implementation status is documented as "Not implemented in this database," meaning the object may not physically exist in every environment even though it is catalogued in the ETRM reference. Deployments that do contain the table should expect ten columns in the documented 12.1.1 physical schema, owned by the IGS schema.

Key Information Stored

The most significant columns are those that establish identity and the two parent relationships. The surrogate primary key is SUB_ERR_ID, defined by the IGS_FI_SUB_ER_RT_PK constraint. This column uniquely identifies each row and is the join target for any downstream child objects.

Two business-key candidates are documented through unique indexes. The IGS_FI_SUB_ER_RT_U1 index spans SUB_ER_ID, FAR_ID, and CREATE_DATE, indicating that the combination of a sub-element range, a fee-as-rate record, and a creation timestamp is expected to be unique. These columns carry the substantive business meaning of the row:

  • SUB_ER_ID — references the sub-element range in IGS_FI_SUB_ELM_RNG, identifying which narrowed band of charge elements the rate applies to.
  • FAR_ID — references IGS_FI_FEE_AS_RATE, identifying the fee rate assignment record that supplies the pricing.
  • CREATE_DATE — the business-effective creation timestamp participating in the unique key.

Audit and lifecycle columns complete the structure: LOGICAL_DELETE_DATE supports soft deletion without physical row removal; CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN provide standard EBS who-column auditing and are populated through the standard concurrent and form-based maintenance paths.

Common Use Cases and Queries

Typical usage centres on resolving which rate applies to a given sub-element range, and on auditing when a rate association was created or logically removed. A straightforward resolution query joins both parents:

  • Rate lookup: SELECT r.SUB_ERR_ID, r.FAR_ID, r.CREATE_DATE FROM IGS_FI_SUB_ER_RT r WHERE r.SUB_ER_ID = :sub_er_id AND r.LOGICAL_DELETE_DATE IS NULL;
  • Active rate audit: filter on LOGICAL_DELETE_DATE IS NULL and order by CREATE_DATE to see the current effective association versus historical ones.
  • Reconciliation: join to IGS_FI_FEE_AS_RATE to confirm which rate definition each sub-range is priced against.
  • Integrity reporting: identify rows whose FAR_ID no longer resolves to an active rate record, signalling stale or orphaned assignments.

Because the table is obsolete, new development should avoid dependencies on it; queries are typically confined to historical data migration, archival reconciliation, or legacy reporting.

Related Objects

The documented foreign keys define the two principal dependencies, and these are the most significant related objects:

  • IGS_FI_SUB_ELM_RNG — parent of the SUB_ER_ID column; defines the sub-range of charge elements being priced.
  • IGS_FI_FEE_AS_RATE — parent of the FAR_ID column; supplies the fee rate assignment used for the sub-range.

Beyond these, the broader IGS Financials area that this object belongs to includes charge element, fee calendar, and rate structure tables, and any historical interfaces or reports built on IGS_FI_SUB_ELM_RNG and IGS_FI_FEE_AS_RATE would indirectly depend on IGS_FI_SUB_ER_RT when sub-range-specific pricing is in scope. Given the obsolete status, no supported APIs are associated with this table in current releases.