Search Results igi_itr_charge_service




Overview
Explore in AI Chat

Overview

IGI_ITR_CHARGE_SERVICE is a table in the IGI (Public Sector Financials International) product family of Oracle E-Business Suite, holding the service information associated with a charge center. Within the IGI interagency and intragovernmental transaction framework, this table functions as the association entity that ties individual services to the charge centers responsible for recovering their costs. It is a child of IGI_ITR_CHARGE_CENTER, connected through the CHARGE_CENTER_ID foreign key, and it defines which services are attributed to a given charge center along with the effective dating and accounting identifiers needed for cost recovery processing.

From a dimensional modeling perspective, the mined foreign key structure classifies this table as satellite-leaning. This classification is a modeling suggestion rather than a physical constraint: the table behaves primarily as a dependent descriptor that records the attributes and relationships surrounding a charge center, rather than acting as an independent hub of business keys or a pure many-to-many link. The presence of a dedicated surrogate identifier and descriptive columns reinforces its satellite character within a Data Vault representation.

Key Information Stored

The documented physical schema contains 12 columns in the IGI schema. The most significant are the following:

  • CHARGE_SERVICE_ID — the surrogate primary key uniquely identifying each service-to-charge-center assignment record.
  • CHARGE_CENTER_ID — foreign key to IGI_ITR_CHARGE_CENTER, establishing the parent charge center to which the service is attributed. This is the primary business join column.
  • SERVICE_ID — identifies the specific service record linked to the charge center. This acts as a business-key candidate in combination with CHARGE_CENTER_ID.
  • CREATION_CCID — the cost center / charge center identifier associated with the creation side of the transaction.
  • RECEIVING_CCID — the cost center / charge center identifier associated with the receiving side, supporting interagency cost transfer logic.
  • START_DATE and END_DATE — the effective dating range for the service assignment, enabling time-based analysis and point-in-time reporting.
  • CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN — standard Oracle EBS audit columns tracking record creation and modification.

The natural business key is most likely the combination of CHARGE_CENTER_ID and SERVICE_ID, qualified by START_DATE, while CHARGE_SERVICE_ID serves as the synthesized surrogate. Analysts should confirm uniqueness against any documented unique index in the ETRM, as the metadata excerpt does not enumerate unique constraints explicitly.

Common Use Cases and Queries

Typical reporting scenarios include identifying all services attached to a charge center, reconstructing service assignments as of a specific date, and reconciling creation-side and receiving-side cost centers. A representative query joins the parent table to resolve charge center detail:

SELECT cs.CHARGE_SERVICE_ID, cs.CHARGE_CENTER_ID, cs.SERVICE_ID, cs.START_DATE, cs.END_DATE, cc.CHARGE_CENTER_NAME FROM IGI.IGI_ITR_CHARGE_SERVICE cs JOIN IGI.IGI_ITR_CHARGE_CENTER cc ON cs.CHARGE_CENTER_ID = cc.CHARGE_CENTER_ID WHERE TRUNC(SYSDATE) BETWEEN cs.START_DATE AND NVL(cs.END_DATE, TRUNC(SYSDATE));

Audit and lineage queries frequently filter on CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, and LAST_UPDATE_DATE to track changes. Because the table carries both creation and receiving cost center identifiers, it supports intragovernmental elimination and cost transfer analysis, making it valuable for public sector financial reconciliation reports.

Related Objects

  • IGI_ITR_CHARGE_CENTER — parent table; joined via CHARGE_CENTER_ID = CHARGE_CENTER_ID. This is the only documented foreign key relationship.
  • Service definition tables in the IGI schema referenced by SERVICE_ID — these provide the descriptive attributes of each service.
  • Cost center / accounting flexfield sources corresponding to CREATION_CCID and RECEIVING_CCID — used to resolve cost center names and hierarchies.
  • IGI interagency transaction tables that consume charge center and service assignments during cost recovery and billing.
  • Standard EBS audit and concurrency views relying on CREATED_BY, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN.

Because the documented relationship set is limited to the single foreign key toward IGI_ITR_CHARGE_CENTER, the related-object list above should be validated against the live ETRM constraint inventory, as IGI implementations may define additional application-level joins not captured in the excerpt.