Search Results igs_ps_tch_resp_ovrd_all




Overview
Explore in AI Chat

Overview

The IGS.IGS_PS_TCH_RESP_OVRD_ALL table is a core Student System (IGS) object in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores teaching responsibility override records for a given unit offering option. Teaching responsibility in EBS defines the organizational units, academic staff, or cost centers that share accountability for delivering a unit (course or module) during a teaching period. Where the standard teaching responsibility distribution fails to reflect local agreements, an override row set is recorded here, and the percentages across a given unit offering option must total 100%. The table is owned by the IGS schema and is validated in the ETRM data dictionary.

In Data Vault modeling terms, the heuristic classification derived from the foreign key structure is a link. This is consistent with the table's role: it associates a unit offering option with organizational responsibility attributes rather than describing a single business entity like a hub. The UOO_ID foreign key to IGS_PS_UNIT_OFR_OPT_ALL links each override record to the offering option it qualifies, and the composite business key provides the grain.

Key Information Stored

The table contains 20 columns. The most significant are outlined below.

Common Use Cases and Queries

Typical scenarios include verifying that overrides total 100%, reporting organizational teaching load, and auditing responsibility changes for accreditation or funding returns. A validation query checks percentage totals per offering option: 

SELECT uoo_id, SUM(percentage) AS total_pct
FROM   igs.igs_ps_tch_resp_ovrd_all
GROUP  BY uoo_id
HAVING SUM(percentage) != 100;

A reporting query joining to the offering option for descriptive context: 

SELECT o.unit_cd, o.version_number, r.org_unit_cd, r.percentage
FROM   igs.igs_ps_tch_resp_ovrd_all r,
       igs.igs_ps_unit_ofr_opt_all o
WHERE  r.uoo_id = o.uoo_id
AND    r.org_id = :p_org_id;

These patterns support teaching workload analysis, cost allocation, and data-quality reconciliation between overrides and default responsibility records.

Related Objects

These dependencies reflect the documented foreign key and business key relationships and should guide join design in custom reports and interfaces.