Search Results igs_ps_sch_instr_all




Overview
Explore in AI Chat

Overview

The IGS_PS_SCH_INSTR_ALL table is a component of the Oracle E-Business Suite Student System (IGS) product family, which is documented as obsolete in the ETRM 12.1.1 / 12.2.2 reference set. The table stores information about all instructors associated with a unit section occurrence for a particular transaction, effectively acting as the assignment record that links a named instructor to a scheduled occurrence of a teaching unit. In the ETRM metadata it is explicitly marked "Not implemented in this database," meaning the object exists in the documented physical schema but no runtime implementation is present in the reference environment.

The documented physical schema is owned by the IGS schema and contains thirteen columns. The relationship metadata classifies the table with a heuristic Data Vault designation of satellite-leaning, based on the mined foreign key structure. Under this modeling suggestion, IGS_PS_SCH_INSTR_ALL behaves as a descriptive satellite attached to a parent occurrence entity, carrying the instructor-specific attributes that qualify that relationship rather than serving as an independent hub of business keys.

Key Information Stored

The documented columns fall into four functional groups: identity, descriptive name attributes, foreign key linkage, and standard audit columns.

The distinction between the surrogate key (INT_INSTRUC_ID) and the foreign key linkage (INT_OCCURS_ID) is central to understanding the table: the former uniquely identifies the assignment, while the latter defines its parent context.

Common Use Cases and Queries

Because the table is obsolete in current EBS releases, practical use is largely confined to historical reporting, data migration, and archiving projects that must reconstruct scheduling and instructor assignment history. Typical patterns include resolving the instructor roster for a given occurrence and flattening instructor names against their scheduled parent records.

A representative join uses the documented foreign key path:

  • SELECT i.INT_INSTRUC_ID, i.INSTRUCTOR_ID, i.PERSON_NAME, i.SURNAME, o.INT_OCCURS_ID FROM IGS_PS_SCH_INSTR_ALL i, IGS_PS_SCH_INT_ALL o WHERE i.INT_OCCURS_ID = o.INT_OCCURS_ID;
  • Filtering by ORG_ID supports operating-unit-specific extracts.
  • Filtering on LAST_UPDATE_DATE supports incremental migration or change-audit reporting.

Reporting use cases include instructor workload summaries per unit section occurrence, validation that each occurrence has at least one assigned instructor, and reconciliation of denormalized name attributes against the authoritative person records during data conversion.

Related Objects

The documented relationship data identifies the following significant dependencies:

  • IGS_PS_SCH_INT_ALL — the parent table referenced by IGS_PS_SCH_INSTR_ALL.INT_OCCURS_ID; this is the only foreign key relationship documented for the table and represents the occurrence context to which instructors are attached.
  • IGS_PS_SCH_INSTR_ALL_PK — the primary key constraint enforcing uniqueness of INT_INSTRUC_ID.
  • IGS_PS_SCH_INSTR_ALL_U1 — the unique index on INT_INSTRUC_ID, documented as the business-key candidate.
  • IGS (schema) — the owning schema for the object in the documented 12.1.1 physical schema.

Broader dependencies within the IGS Student System, such as instructor and person entities referenced through INSTRUCTOR_ID, are implied by the column semantics but are not enumerated as foreign keys in the supplied metadata. Analysts should treat IGS_PS_SCH_INT_ALL as the definitive join target and confirm any additional relationships directly against the customer's implemented schema, given the object's obsolete status.