Search Results igs_en_psv_term_it




Overview
Explore in AI Chat

Overview

The IGS_EN_PSV_TERM_IT table is a core transactional data object within the Oracle E-Business Suite Student System (IGS) product family. It stores the Term Instruction Time Override for a Program in a Load Calendar. In practical terms, the table records deviations from the default instruction time applied to a specific course version within a particular load calendar, allowing institutions to model load or program-specific teaching-hour allocations without altering the underlying standard definitions.

The row's identity is established by a composite primary key, IGS_EN_PSV_TERM_IT_PK, which combines CAL_TYPE, SEQUENCE_NUMBER, COURSE_CD, and VERSION_NUMBER. Because the key is composed entirely of foreign key columns pointing to external parent entities, the heuristic Data Vault classification mined from the foreign key structure is link. Under this modeling suggestion, the table behaves as an associative construct resolving the many-to-many relationship between course versions and load calendar instances, carrying the descriptive attribute TERM_INSTRUCTION_TIME as its payload along with standard audit columns.

Key Information Stored

The ten documented columns group logically into identifying keys, a measure, and audit metadata:

  • CAL_TYPE and SEQUENCE_NUMBER — components of the load calendar instance reference. Together they resolve to a row in IGS_CA_INST_ALL.
  • COURSE_CD and VERSION_NUMBER — components identifying the specific course version, resolving to a row in IGS_PS_VER_ALL.
  • TERM_INSTRUCTION_TIME — the operative measure. This holds the overridden instruction time value that applies to the identified course version within the identified calendar instance.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard Oracle audit columns present on virtually all transactional tables, supporting record provenance and change tracking.

There is no single surrogate (system-generated) primary key column here; the documented unique index IGS_EN_PSV_TERM_IT_PK serves as the business-key candidate, and all four of its constituents are also foreign key columns. This means every row is fully qualified by its parent references, and the descriptive payload is limited to TERM_INSTRUCTION_TIME.

Common Use Cases and Queries

Because the object records overrides, reporting scenarios typically compare the override against the standard instruction time held at the course-version or calendar level.

  • Retrieving overrides for a specific course version: SELECT CAL_TYPE, SEQUENCE_NUMBER, TERM_INSTRUCTION_TIME FROM IGS.IGS_EN_PSV_TERM_IT WHERE COURSE_CD = :course AND VERSION_NUMBER = :version;
  • Auditing unusual instruction times within a load calendar: filter by CAL_TYPE and SEQUENCE_NUMBER and order by TERM_INSTRUCTION_TIME DESC.
  • Refresh/incremental extract based on audit columns: WHERE LAST_UPDATE_DATE > :high_water_mark.
  • Referential integrity checks confirming that every COURSE_CD/VERSION_NUMBER resolves to a valid course version and that every calendar key resolves to a valid calendar instance.

Related Objects

The following objects are most significant given the documented foreign key relationships:

  • IGS_CA_INST_ALL — parent calendar instance; joined on CAL_TYPE and SEQUENCE_NUMBER.
  • IGS_PS_VER_ALL — parent course version; joined on COURSE_CD and VERSION_NUMBER.
  • Program and curriculum tables in the IGS product family that resolve course versions to programs in a load calendar context.
  • Public IGS APIs and concurrent programs that maintain course-version instruction time definitions, which typically supply the standard values compared against these overrides.
  • Reporting views and BI extracts within the Student System that aggregate instruction time by calendar and program.

Any integration or extract touching this table should always join to both IGS_CA_INST_ALL and IGS_PS_VER_ALL to translate the key columns into human-readable calendar and course-version context.