Search Results igs_ps_usec_tch_resp_u2

Overview

IGS.IGS_PS_USEC_TCH_RESP is a transactional table in the Oracle E-Business Suite IGS (Student Systems / Institutional Advancement) schema. It captures the teaching responsibilities assigned to instructors for a given unit section. In Oracle Student System terms, a unit offering option (UOO) represents a specific section of a unit of study, and this table records which instructors are responsible for delivering that section, along with allocation, confirmation status, and instructional workload figures.

The object is classified as VALID in the ETRM repository and resides in the APPS_TS_TX_DATA tablespace with a PCTFREE of 10, reflecting its role as an active transactional store rather than a reference or seed table. Its heuristic Data Vault classification is link: the table resolves a many-to-many relationship between unit offering options (sections) and instructors, carrying descriptive attributes that qualify that association. Modelling it as a link table between the section hub and the instructor hub is a reasonable design suggestion when building a Data Vault or reporting layer over this source.

Key Information Stored

The table contains 14 documented columns. The most significant are:

• UNIT_SECTION_TEACH_RESP_ID — surrogate primary key (IGS_PS_USEC_TCH_RESP_PK); the unique identifier of the teaching responsibility record.
• UOO_ID — foreign key to IGS_PS_UNIT_OFR_OPT_ALL, identifying the unit offering option (section) for which the responsibility is defined.
• INSTRUCTOR_ID — the instructor assigned to the section.
• CONFIRMED_FLAG — indicates whether the instructor is confirmed for the teaching responsibility.
• PERCENTAGE_ALLOCATION — the share of the teaching responsibility allocated to the instructor, useful where multiple instructors split a section.
• INSTRUCTIONAL_LOAD — the aggregate instructional load assigned to the instructor.
• LEAD_INSTRUCTOR_FLAG — identifies the lead instructor for the unit section.
• INSTRUCTIONAL_LOAD_LAB and INSTRUCTIONAL_LOAD_LECTURE — respective workload figures for laboratory and lecture components.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard Who columns providing audit traceability.

Two unique indexes act as business-key candidates: IGS_PS_USEC_TCH_RESP_U1 on UNIT_SECTION_TEACH_RESP_ID (which also corresponds to the primary key) and IGS_PS_USEC_TCH_RESP_U2 on (UOO_ID, INSTRUCTOR_ID), enforcing that an instructor appears only once per unit section. The user's search target, igs_ps_usec_tch_resp_u1, is therefore the unique index backing the surrogate primary key.

Common Use Cases and Queries

Typical reporting and integration scenarios include listing all instructors for a section, identifying lead instructors, and analysing instructional workload distribution across a teaching period. A representative query joining responsibilities to sections is:

• SELECT t.UNIT_SECTION_TEACH_RESP_ID, t.UOO_ID, t.INSTRUCTOR_ID, t.CONFIRMED_FLAG, t.PERCENTAGE_ALLOCATION, t.INSTRUCTIONAL_LOAD, t.LEAD_INSTRUCTOR_FLAG FROM IGS.IGS_PS_USEC_TCH_RESP t WHERE t.UOO_ID = :p_uoo_id;
• Confirming coverage: filter on CONFIRMED_FLAG to find sections with unconfirmed teaching arrangements.
• Load analysis: aggregate INSTRUCTIONAL_LOAD, INSTRUCTIONAL_LOAD_LAB, and INSTRUCTIONAL_LOAD_LECTURE by instructor.
• Allocation checks: sum PERCENTAGE_ALLOCATION by UOO_ID to ensure allocations reconcile to 100 percent.

Related Objects

The documented foreign key relationships and dependent objects for this table include:

• IGS.IGS_PS_UNIT_OFR_OPT_ALL — referenced via UOO_ID; supplies the unit offering option (section) context.
• IGS_PS_USEC_TCH_RESP_PK — primary key constraint on UNIT_SECTION_TEACH_RESP_ID.
• IGS_PS_USEC_TCH_RESP_U1 — unique index on UNIT_SECTION_TEACH_RESP_ID.
• IGS_PS_USEC_TCH_RESP_U2 — unique index on (UOO_ID, INSTRUCTOR_ID).
• Instructor master data (typically via INSTRUCTOR_ID) and unit offering option structures (IGS_PS_UNIT_OFR_OPT) are commonly joined for teaching-load and timetable reporting.