Results for “igs_ps_tch_resp_ovrd_all_u1”

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

Overview

IGS.IGS_PS_TCH_RESP_OVRD_ALL is a transactional table in the Oracle EBS Student Systems (IGS) schema that stores teaching responsibility override details for a given unit offering option. Within the EBS 12.1.1 and 12.2.2 data model, this object sits at the intersection of academic unit catalog data and organizational accountability, capturing the percentage of teaching responsibility that each organizational unit bears for a specific unit offering option. The table enforces an important business rule: when an override is specified for a unit offering option, the PERCENTAGE values must total 100%.

The record resides in the APPS_TS_TX_DATA tablespace with a PCT Free of 10, and the unique index and non-unique indexes are held in APPS_TS_TX_IDX. The heuristic Data Vault classification mined from the foreign key structure is link. This suggests modeling the table as a link (junction) entity resolving the many-to-many relationship between unit offering option definitions and organizational units, with the PERCENTAGE attribute acting as a link-level measure rather than a satellite-housed descriptive attribute.

Key Information Stored

The table contains 20 documented columns. The most operationally significant are:

• UNIT_CD, VERSION_NUMBER, CAL_TYPE, CI_SEQUENCE_NUMBER, LOCATION_CD, UNIT_CLASS — the composite academic identifiers describing the unit, its version, teaching calendar type, calendar instance sequence, location, and unit class to which the override applies.
• ORG_UNIT_CD, OU_START_DT — the organizational unit responsible for teaching the unit offering option and the effective start date of that organizational unit assignment.
• UOO_ID — the surrogate identifier for the unit offering option, providing a direct foreign key to the unit offering option definition.
• PERCENTAGE — the percentage of teaching responsibility allocated to the organizational unit; the sum across an offering option must equal 100%.
• ORG_ID — the multi-org operating unit context, enabling operating-unit-scoped queries.
• Standard Who columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, plus REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, and PROGRAM_UPDATE_DATE for concurrent program traceability.

The primary key is IGS_PS_TCH_RESP_OVRD_PK, defined over UNIT_CD, VERSION_NUMBER, CAL_TYPE, CI_SEQUENCE_NUMBER, LOCATION_CD, UNIT_CLASS, ORG_UNIT_CD, and OU_START_DT. The business-key candidate captured by the unique index IGS_PS_TCH_RESP_OVRD_ALL_U1 mirrors this same column set. Two non-unique indexes support alternate access paths: IGS_PS_TCH_RESP_OVRD_ALL_N1 on ORG_UNIT_CD and OU_START_DT, and IGS_PS_TCH_RESP_OVRD_ALL_N2 on UOO_ID.

Common Use Cases and Queries

Typical reporting scenarios include auditing teaching responsibility splits for a unit offering option, validating that overrides total 100%, and listing all offering options assigned to a given organizational unit. A representative query retrieving the override distribution for a specific unit offering option is:

SELECT org_unit_cd, percentage FROM igs.igs_ps_tch_resp_ovrd_all WHERE uoo_id = :p_uoo_id ORDER BY org_unit_cd;

To detect invalid overrides that do not total 100%, aggregate by UOO_ID:

SELECT uoo_id, SUM(percentage) FROM igs.igs_ps_tch_resp_ovrd_all GROUP BY uoo_id HAVING SUM(percentage) <> 100;

A third common pattern lists offerings by teaching organizational unit and effective date, leveraging the N1 index on ORG_UNIT_CD and OU_START_DT. Because the table resides in APPS_TS_TX_DATA and includes ORG_ID, queries should generally be scoped to the appropriate operating unit, and reporting views in the IGS schema should be preferred over direct table access where available.

Related Objects

The foreign key relationships documented for this table reference IGS.IGS_PS_UNIT_OFR_OPT_ALL on both UNIT_CD and UOO_ID, identifying the unit offering option as the principal parent entity. The most significant related objects include:

• IGS.IGS_PS_UNIT_OFR_OPT_ALL — the unit offering option definition, joined on UNIT_CD and UOO_ID.
• IGS.IGS_PS_TCH_RESP_OVRD_PK — the primary key constraint enforcing the composite key.
• Index IGS_PS_TCH_RESP_OVRD_ALL_U1 — the unique business-key index over the academic and organizational composite.
• Indexes _N1 and _N2 — supportive non-unique indexes for organizational-unit and UOO_ID access paths.
• Organizational unit definition tables (referenced via ORG_UNIT_CD and OU_START_DT) — supply the teaching organization context.