Results for “igs_ps_sh_usec_occurs”

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

Overview

IGS_PS_SH_USEC_OCCURS is a shadow table within the Oracle E-Business Suite Student System (IGS) product family. Its documented purpose is to store a shadow copy of the Unit Section Occurrence table, providing a staging or historical mirror of scheduling occurrence records associated with unit sections. In Oracle EBS 12.1.1 and 12.2.2, the IGS product is classified as Obsolete, and this specific object is documented as not implemented in the reference database. It therefore serves primarily as a legacy or reserved structure rather than an actively populated operational table in current installations.

From a heuristic Data Vault modeling perspective, mined from its foreign key structure, the table is classified as satellite-leaning. This suggests the object behaves as a descriptive satellite attached to a parent hub or link represented by the primary Unit Section Occurrence table, carrying attribute detail rather than defining new business entities.

Key Information Stored

The documented physical schema for IGS_PS_SH_USEC_OCCURS contains nineteen columns. The most significant of these are described below.

• USECSH_ID — The surrogate primary key, defined by the constraint IGS_PS_SH_USEC_OCCURS_PK and backed by unique index IGS_PS_SH_USEC_OCCURS_U1. This is the shadow-side identifier distinguishing each staged occurrence record.
• UNIT_SECTION_OCCURRENCE_ID — The foreign key linking back to IGS_PS_USEC_OCCURS_ALL, and also the business-key candidate supported by unique index IGS_PS_SH_USEC_OCCURS_U2. This column ties the shadow row to its source occurrence.
• MONDAY, TUESDAY, WEDNESDAY, THURSDAY, FRIDAY, SATURDAY, SUNDAY — Day-of-week indicator columns capturing the recurring schedule pattern for the occurrence.
• ROOM_CODE and BUILDING_CODE — Location attributes identifying where the scheduled occurrence takes place.
• START_TIME and END_TIME — The scheduled start and end times for the occurrence.
• INSTRUCTOR_ID — The identifier of the instructor assigned to the occurrence.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard Oracle EBS audit columns tracking record creation and modification lineage.

The distinction between the surrogate key (USECSH_ID) and the business-key candidate (UNIT_SECTION_OCCURRENCE_ID) is significant: the former provides internal row identity, while the latter preserves the relationship to the authoritative source record.

Common Use Cases and Queries

Because the table is a shadow mirror, typical usage focuses on reconciliation, auditing, and schedule reporting against the parent occurrence table. A representative join pattern is:

• SELECT s.USECSH_ID, s.UNIT_SECTION_OCCURRENCE_ID, s.ROOM_CODE, s.BUILDING_CODE, s.START_TIME, s.END_TIME FROM IGS_PS_SH_USEC_OCCURS s JOIN IGS_PS_USEC_OCCURS_ALL m ON s.UNIT_SECTION_OCCURRENCE_ID = m.UNIT_SECTION_OCCURRENCE_ID;
• Comparison queries detecting differences in day-of-week flags, room, building, time, or instructor between shadow and source rows.
• Schedule and facility reporting extracting day, room, and time attributes for occurrence analysis.
• Audit queries using CREATION_DATE and LAST_UPDATE_DATE to trace when shadow records were staged.

Related Objects

• IGS_PS_USEC_OCCURS_ALL — The authoritative Unit Section Occurrence table, joined on UNIT_SECTION_OCCURRENCE_ID. This is the primary relationship for the shadow record.
• IGS_PS_SH_USEC_OCCURS_PK — The primary key constraint defined on USECSH_ID.
• IGS_PS_SH_USEC_OCCURS_UK — The unique key constraint defined on UNIT_SECTION_OCCURRENCE_ID.
• IGS_PS_SH_USEC_OCCURS_U1 and _U2 — Unique indexes supporting the surrogate and business keys respectively.
• Owning schema IGS — Under which all the above objects reside, denoting the Student System product boundary.