Results for “igs_ps_usec_occurs_all_u1”

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

Overview

IGS.IGS_PS_USEC_OCCURS_ALL is a transactional table in the Oracle E-Business Suite Student System (IGS) schema. It describes the occurrences of a unit section — that is, the scheduled meetings or sessions belonging to a specific offering option of a unit. Each row represents a discrete occurrence instance, defined by its day pattern, start and end times, assigned building and room, and schedule status. The table resides in the APPS_TS_TX_DATA tablespace with PCT Free 10, and its indexes are held in APPS_TS_TX_IDX, a configuration consistent with high-volume transactional data.

In Data Vault modeling terms, this object is heuristically classified as a hub. This classification derives from the presence of stable business keys and the table's role as the anchor for multiple downstream dependent tables. Modelers should treat this as a suggestion rather than a documented ETRM attribute, since the classification was mined from the foreign key structure rather than the official metadata.

Key Information Stored

The table contains 62 documented columns. The most operationally significant are:

• UNIT_SECTION_OCCURRENCE_ID (NUMBER(10), mandatory) — the surrogate unique identifier for the occurrence, enforced by unique index IGS_PS_USEC_OCCURS_ALL_U1.
• UOO_ID — the unit section identifier linking the occurrence to its parent offering option.
• OCCURRENCE_IDENTIFIER — the business-facing occurrence number. Together with UOO_ID, it forms the composite unique key IGS_PS_USEC_OCCURS_ALL_U2 and the declared primary key IGS_PS_USEC_OCCURS_ALL_UK.
• MONDAY … SUNDAY (VARCHAR2) — flags indicating the days on which the class is conducted.
• START_TIME, END_TIME (DATE) — the scheduled meeting window.
• START_DATE, END_DATE — the effective date range of the occurrence.
• BUILDING_CODE, ROOM_CODE, plus DEDICATED_BUILDING_CODE, DEDICATED_ROOM_CODE, PREFERRED_BUILDING_CODE, and PREFERRED_ROOM_CODE — facility assignment and preference data.
• INSTRUCTOR_ID — the assigned instructor, referencing HZ_PARTIES.
• SCHEDULE_STATUS (VARCHAR2(30)) and STATUS_LAST_UPDATED — current scheduling state and its timestamp.
• INST_NOTIFY_IND, NOTIFY_STATUS — instructor notification control and tracking.
• CANCEL_FLAG, ABORT_FLAG, TO_BE_ANNOUNCED, NO_SET_DAY_IND — operational status indicators.
• ORG_ID — the multi-org operating unit context.
• ATTRIBUTE_CATEGORY through ATTRIBUTE20 — the standard descriptive flexfield columns.

Standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) and concurrent request columns (REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, ERROR_TEXT) are also present.

Common Use Cases and Queries

Typical usage centers on timetable reporting, room utilization analysis, and instructor scheduling. A frequent query retrieves all occurrences for a unit section offering:

SELECT uso.unit_section_occurrence_id,
       uso.occurrence_identifier,
       uso.start_time, uso.end_time,
       uso.building_code, uso.room_code,
       uso.schedule_status
FROM   igs_ps_usec_occurs_all uso
WHERE  uso.uoO_id = :uoO_id
ORDER BY uso.occurrence_identifier;

Room and building utilization reports join to IGS_AD_ROOM_ALL and IGS_AD_BUILDING_ALL to resolve codes to descriptive names. Instructor workload reports use INSTRUCTOR_ID against HZ_PARTIES. Cancellation audits filter on CANCEL_FLAG or ABORT_FLAG, while notification monitoring filters on INST_NOTIFY_IND and NOTIFY_STATUS. Because the table carries DFF columns, attribute-based reporting on institution-specific extensions is also common.

Related Objects

The table participates in an extensive referential network:

• IGS_PS_UNIT_OFR_OPT_ALL — parent of the occurrence; joined via UOO_ID.
• IGS_AD_BUILDING_ALL — referenced by BUILDING_CODE, DEDICATED_BUILDING_CODE, and PREFERRED_BUILDING_CODE.
• IGS_AD_ROOM_ALL — referenced by ROOM_CODE, DEDICATED_ROOM_CODE, and PREFERRED_ROOM_CODE.
• HZ_PARTIES — referenced by INSTRUCTOR_ID for instructor identity.
• IGS_AS_USEC_SESSNS — attendance sessions linked via UNIT_SECTION_OCCURRENCE_ID.
• IGS_PS_USO_INSTRCTRS — instructors assigned to the occurrence.
• IGS_PS_USO_FACILITY — facility allocations for the occurrence.
• IGS_PS_SH_USEC_OCCURS — occurrence instances for scheduling purposes.
• IGS_PS_USEC_OCUR_REF — reference data associated with the occurrence.

These dependencies confirm the table's role as a scheduling hub within the Student System, feeding attendance, facility, and instructor subsystems.