Search Results igs_ps_tch_resp_u1

Overview

IGS.IGS_PS_TCH_RESP is a transactional table in the Oracle EBS Student Systems (IGS) product family that records the breakdown of teaching responsibility for a unit of study across one or more organizational units. The allocation is expressed as a percentage, permitting a unit to be shared among multiple academic or administrative departments, faculties, or cost centres. The table resides in the APPS_TS_TX_DATA tablespace with a PCT Free of 10 and is defined with the FND Design Data reference IGS.IGS_PS_TCH_RESP. Its status is VALID in the documented environment, and it is registered as a dependency of the APPS synonym IGS_PS_TCH_RESP.

From a dimensional modeling perspective, the mined Data Vault classification is satellite-leaning. This is consistent with the table's structure: it carries descriptive, time-variant attributes (notably PERCENTAGE and OU_START_DT) that qualify a parent business key rather than introducing a wholly new entity. The natural hub context is drawn from IGS_PS_UNIT_VER_ALL, to which UNIT_CD and VERSION_NUMBER resolve.

Key Information Stored

The table is documented with ten columns. The primary key is identified as IGS_PS_TCH_RESP_PK, comprising UNIT_CD, VERSION_NUMBER, ORG_UNIT_CD, and OU_START_DT. A separate unique index, IGS_PS_TCH_RESP_U1, carries the identical column list, confirming that this composite represents the business key as well as the physical access path. A non-unique index, IGS_PS_TCH_RESP_N1, is defined on ORG_UNIT_CD and OU_START_DT to support organization-centric lookups.

• UNIT_CD (VARCHAR2 10) — the code identifying the unit of study. This is the principal join column to the unit version entity.
• VERSION_NUMBER (NUMBER) — the version of the unit record, distinguishing successive revisions of the same unit.
• ORG_UNIT_CD (VARCHAR2 30) — the code identifying an academic or administrative organizational unit within the university structure, mapped to DEET element reference 333.
• OU_START_DT (DATE) — the effective-from date of the organizational unit assignment, providing the temporal grain of the record.
• PERCENTAGE (NUMBER) — the percentage of teaching responsibility allocated to the organizational unit for that unit of study. This is the principal measure carried by the satellite.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard Who columns inherited from the EBS audit framework.

The documented foreign key relationship is UNIT_CD referencing IGS_PS_UNIT_VER_ALL, anchoring each row to a specific version of a unit.

Common Use Cases and Queries

The most frequent reporting requirement is a teaching-load or workload distribution analysis, in which responsibility percentages are aggregated by organizational unit for a given term or version. A representative query joins the responsibility rows to the unit version entity:

• SELECT t.UNIT_CD, t.VERSION_NUMBER, t.ORG_UNIT_CD, t.OU_START_DT, t.PERCENTAGE FROM IGS.IGS_PS_TCH_RESP t WHERE t.UNIT_CD = :unit AND t.VERSION_NUMBER = :version ORDER BY t.ORG_UNIT_CD, t.OU_START_DT;
• Aggregation for cross-departmental reporting: SELECT ORG_UNIT_CD, SUM(PERCENTAGE) FROM IGS.IGS_PS_TCH_RESP WHERE OU_START_DT BETWEEN :from_dt AND :to_dt GROUP BY ORG_UNIT_CD;
• Integrity check to confirm that allocations sum to 100 percent: SELECT UNIT_CD, VERSION_NUMBER, SUM(PERCENTAGE) FROM IGS.IGS_PS_TCH_RESP GROUP BY UNIT_CD, VERSION_NUMBER HAVING SUM(PERCENTAGE) <> 100;
• Effective-dated lookup: SELECT * FROM IGS.IGS_PS_TCH_RESP WHERE ORG_UNIT_CD = :org AND OU_START_DT <= SYSDATE

Because the unique index IGS_PS_TCH_RESP_U1 mirrors the primary key, single-row access by the composite key is index-driven and efficient. The non-unique index IGS_PS_TCH_RESP_N1 supports the reverse access pattern, retrieving all units assigned to a given organizational unit for a period.

Related Objects

The table's principal dependency is on the unit version entity, and it is exposed to the applications layer through the APPS synonym IGS_PS_TCH_RESP.

• IGS.IGS_PS_UNIT_VER_ALL — referenced via UNIT_CD and VERSION_NUMBER; the parent unit version record.
• APPS.IGS_PS_TCH_RESP — the application-facing synonym over the table.
• IGS.IGS_PS_UNIT_VER — the base unit version table underlying the _ALL view.
• IGS.IGS_PS_UNIT_OFR_OPT — offering options that contextualise the unit for a teaching period.
• IGS.IGS_OR_UNIT — the organizational unit definition supplying ORG_UNIT_CD.
• IGS.IGS_EN_ACT_V — student activity views that join teaching responsibility to enrolled delivery.

The responsible teaching allocation recorded here typically feeds teaching-load analysis, costing, and regulatory reporting extracts within the institution.