Search Results igs_ps_tch_resp




Overview
Explore in AI Chat

Overview

IGS_PS_TCH_RESP is a teaching responsibility allocation table within the Oracle E-Business Suite Student System (IGS) product family. It records how the teaching workload for a specific version of an academic unit is distributed across one or more organization units, expressed as a percentage split. In practical terms, it answers the question of "who owns what share of the teaching delivery" for a given unit offering.

The object belongs to the IGS - Student System module, which Oracle has classified as obsolete in the current EBS release documentation for 12.1.1 and 12.2.2. The metadata for this deployment notes that the object is "Not implemented in this database," meaning the physical table is not instantiated in the target environment even though its definition persists in the ETRM repository. This distinction is important: references to IGS_PS_TCH_RESP in custom code or reporting should be validated against the actual database before being relied upon.

From a dimensional modeling perspective, the heuristic Data Vault classification of IGS_PS_TCH_RESP is satellite-leaning. This suggests the table behaves as a descriptive satellite attached to a parent business key (the unit and version combination) rather than as an independent hub or a pure associative link. The allocation percentage and organization unit details are attributes of the parent unit-version entity, reinforcing the satellite interpretation.

Key Information Stored

The table contains ten documented columns. The composite primary key, IGS_PS_TCH_RESP_PK, consists of four columns that together uniquely identify a responsibility allocation record:

  • UNIT_CD — the code identifying the academic unit whose teaching responsibility is being allocated. This also participates in the foreign key to IGS_PS_UNIT_VER_ALL.
  • VERSION_NUMBER — the version of that unit, allowing responsibility splits to differ across unit revisions.
  • ORG_UNIT_CD — the organization unit receiving a share of the teaching responsibility.
  • OU_START_DT — the effective start date of the organization unit's allocation, enabling date-ranged responsibility tracking.
  • PERCENTAGE — the numeric share of teaching responsibility assigned to the given organization unit, forming the core business measure of the table.

The remaining columns are standard Oracle EBS audit fields: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN. These support who-audit trail and concurrency tracking and are not part of the business key.

A unique index, IGS_PS_TCH_RESP_U1, covers the same four columns as the primary key (UNIT_CD, VERSION_NUMBER, ORG_UNIT_CD, OU_START_DT), confirming that this quartet is the authoritative business-key candidate. No separate surrogate sequence-driven key is documented, so the composite business key itself functions as the identifier.

Common Use Cases and Queries

Typical usage centers on teaching load reporting and organizational cost or effort attribution. Analysts join this table to the unit version table to enrich allocation data with unit titles and effective dates, then aggregate the PERCENTAGE column by organization unit to determine workload distribution.

A representative query pattern aggregates responsibility by organization unit for a specific unit and version:

  • SELECT ORG_UNIT_CD, SUM(PERCENTAGE) FROM IGS_PS_TCH_RESP WHERE UNIT_CD = :unit AND VERSION_NUMBER = :version GROUP BY ORG_UNIT_CD;

Another common pattern validates that allocations for a unit version sum to 100 percent, a data-quality check used during unit set-up and review. Reporting scenarios include faculty workload dashboards, departmental contribution summaries, and audit reports showing how responsibility has shifted across effective dates. Because audit columns are present, point-in-time and change-tracking reports can be constructed using LAST_UPDATE_DATE ranges.

Related Objects

The most significant related object is the parent unit version table referenced by foreign key:

  • IGS_PS_UNIT_VER_ALL — joined on UNIT_CD and VERSION_NUMBER; this is the primary parent providing unit metadata and the anchor for satellite-style joins.

Given the IGS schema conventions, the following object categories typically surround teaching responsibility data and are worth inspecting in any integrated solution:

  • IGS_PS_UNIT_VER — the underlying unit version entity from which the _ALL synonym or view is derived.
  • IGS_PS_UNIT_OCCURRENCE — links unit versions to specific teaching periods and offerings.
  • IGS_PS_UNIT_VERS_STAT — tracks lifecycle status of unit versions and is useful for filtering active allocations.
  • Organization unit definition tables (such as HR_ALL_ORGANIZATION_UNITS) — provide descriptive names for ORG_UNIT_CD values.
  • IGS_PS_TCH_RESP reporting views and any institution-specific extract programs built on the base table.

Because the object is documented as obsolete and not implemented in the reference database, organizations should confirm actual table availability and current replacement objects within their specific EBS 12.1.1 or 12.2.2 instance before designing dependencies on IGS_PS_TCH_RESP.