Results for “igs_ps_tch_rsov_hist_all”

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

Overview

IGS.IGS_PS_TCH_RSOV_HIST_ALL is a Student System (IGS) table that stores historical teaching responsibility override details for a given unit offering option. In Oracle E-Business Suite 12.1.1 and 12.2.2, it enables institutions to split the teaching responsibility of a unit offering option across multiple organizational units or academic owners, rather than accepting the default single-owner assignment. The _HIST suffix and the presence of HIST_START_DT, HIST_END_DT, and HIST_WHO indicate that the table is date-tracked: each change to an override is captured as a new dated row rather than being overwritten in place. The metadata notes that where an override is specified, the override percentages must total 100% for any given unit offering option.

From a Data Vault modeling perspective, the mined FK structure classifies this table as satellite-leaning. It behaves as a historical attribute satellite attached to the IGS_PS_UNIT_OFR_OPT_ALL hub, with the effective-dating columns providing the temporal grain.

Key Information Stored

The primary key IGS_PS_TCH_RSOV_HIST_PK is a composite business key rather than a single surrogate identifier. It comprises UNIT_CD, VERSION_NUMBER, CAL_TYPE, CI_SEQUENCE_NUMBER, LOCATION_CD, UNIT_CLASS, ORG_UNIT_CD, OU_START_DT, and HIST_START_DT. A unique index, IGS_PS_TCH_RSOV_HIST_ALL_U1, mirrors this same column set, confirming it as the documented business-key candidate.

• UNIT_CD, VERSION_NUMBER, CAL_TYPE, CI_SEQUENCE_NUMBER, LOCATION_CD, UNIT_CLASS — the unit offering option context: which unit, version, calendar type, calendar instance sequence, location, and unit class the override applies to.
• ORG_UNIT_CD — the organizational unit that receives a share of teaching responsibility.
• OU_START_DT — the start date of the owning (academic) unit's version record, part of the effective-dated relationship.
• HIST_START_DT / HIST_END_DT — the validity window of the historical override row; HIST_END_DT is null for the currently active record.
• HIST_WHO — the user or process responsible for the historical change.
• PERCENTAGE — the share of teaching responsibility allocated to the organization unit; values across rows for a given unit offering option must total 100%.
• OU_START_DT, ORG_ID — multi-organization and operating-unit context columns supporting MOAC and effective-dating.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS WHO-column audit trail.

Common Use Cases and Queries

Typical uses include auditing historical teaching ownership, reconstructing the responsibility split as of a past date, and reporting on organizational teaching load. The FK join to IGS_PS_UNIT_OFR_OPT_ALL is the principal access path.

• Current overrides for a unit offering option: filter on HIST_END_DT IS NULL and the option key columns to retrieve active responsibility splits.
• Point-in-time reconstruction: constrain HIST_START_DT <= :as_of_date and (HIST_END_DT IS NULL OR HIST_END_DT > :as_of_date) to obtain the override set effective on a given date.
• Percentage validation: group by the option key columns and sum PERCENTAGE to verify each set totals 100%, per the documented business rule.
• Change history / audit: order by HIST_START_DT to trace how an override was modified over time, using HIST_WHO to identify the actor.
• Load reporting: aggregate PERCENTAGE by ORG_UNIT_CD to measure teaching contribution per organization.

Related Objects

This table is a detail/satellite object whose dependencies centre on the unit offering option it qualifies.

• IGS_PS_UNIT_OFR_OPT_ALL — the parent unit offering option table; joined on UNIT_CD, VERSION_NUMBER, CAL_TYPE, CI_SEQUENCE_NUMBER, LOCATION_CD, and UNIT_CLASS. This is the documented foreign key relationship.
• IGS_PS_TCH_RSOV_ALL — the non-historical counterpart holding current teaching responsibility overrides, useful for comparison against the historical snapshot.
• IGS_PS_UNIT_OFR_OPT_V — the view layer over unit offering options commonly used alongside this table in reporting.
• IGS_PS_UNIT_OFR_ALL — the parent unit offering header, reachable via the option table for higher-level reporting.
• HR_ALL_ORGANIZATION_UNITS — reference for resolving ORG_UNIT_CD into organization names for reporting.
• FND_USER — reference for resolving CREATED_BY, LAST_UPDATED_BY, and HIST_WHO to user identities.