Search Results inst_notify_ind

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

Overview

IGS_PS_USEC_OCCURS_ALL is a Student System (IGS) table that describes the occurrences of a unit section — the scheduled meetings of a class offering within the Oracle E-Business Suite academic structure. It belongs to the IGS product family, which is marked obsolete in the later EBS releases; the ETRM metadata records it as "Not implemented in this database" for the documented 12.1.1 schema, and therefore the table should be treated as a legacy artifact. Its logical role is to hold each dated meeting instance derived from a unit section occurrence, capturing teaching time patterns, facility assignment, instructor assignment, and scheduling status.

Based on the foreign-key topology, the table behaves as a hub in a Data Vault model: it carries a durable business key (UNIT_SECTION_OCCURRENCE_ID, plus the UOO_ID / OCCURRENCE_IDENTIFIER combination), and it is the parent of several dependent tables. The classification is a heuristic modeling suggestion derived from the FK structure, not a documented ETRM attribute.

Key Information Stored

The documented physical schema contains 62 columns. The most significant are:

• UNIT_SECTION_OCCURRENCE_ID — the surrogate primary key of the occurrence and the anchor referenced by dependent tables; it also appears in unique index IGS_PS_USEC_OCCURS_ALL_U1.
• UOO_ID and OCCURRENCE_IDENTIFIER — the business-key candidate combination captured by unique index IGS_PS_USEC_OCCURS_ALL_U2 and by the named unique key IGS_PS_USEC_OCCURS_ALL_UK.
• MONDAY through SUNDAY — day-of-week flags that define the recurring teaching pattern.
• START_TIME, END_TIME, START_DATE, END_DATE — the temporal boundaries of the occurrence.
• BUILDING_CODE, ROOM_CODE, PREFERRED_BUILDING_CODE, PREFERRED_ROOM_CODE, DEDICATED_BUILDING_CODE, DEDICATED_ROOM_CODE — the assigned and preferred physical teaching locations.
• INSTRUCTOR_ID — reference to the teaching party, modeled against HZ_PARTIES.
• SCHEDULE_STATUS, STATUS_LAST_UPDATED, CANCEL_FLAG, ABORT_FLAG, NO_SET_DAY_IND, TO_BE_ANNOUNCED — lifecycle and scheduling indicators.
• INST_NOTIFY_IND, NOTIFY_STATUS, ERROR_TEXT — instructor notification and error-handling state.
• ORG_ID plus the standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) and the ATTRIBUTE1–20 flexfield columns.

Common Use Cases and Queries

Typical reporting scenarios include class timetable generation, room and building utilisation analysis, and instructor workload review. Because the table is a hub, most queries join outward to resolve descriptive attributes.

• Timetable extract for a given unit offering option:

  SELECT o.UNIT_SECTION_OCCURRENCE_ID, o.OCCURRENCE_IDENTIFIER,
         o.START_DATE, o.END_DATE, o.START_TIME, o.END_TIME
  FROM   IGS_PS_USEC_OCCURS_ALL o
  WHERE  o.UOO_ID = :uoo_id
  AND    NVL(o.CANCEL_FLAG,'N') = 'N';

• Room utilisation by joining room and building references:

  SELECT o.ROOM_CODE, r.DESCRIPTION, o.START_TIME, o.END_TIME
  FROM   IGS_PS_USEC_OCCURS_ALL o, IGS_AD_ROOM_ALL r
  WHERE  o.ROOM_CODE = r.ROOM_CODE(+);

• Instructor assignment listing through INSTRUCTOR_ID against HZ_PARTIES.
• Scheduling exception review using SCHEDULE_STATUS, CANCEL_FLAG and ABORT_FLAG.

Related Objects

The most significant referencing and referenced objects are:

• IGS_PS_UNIT_OFR_OPT_ALL — parent of the occurrence via UOO_ID.
• IGS_AD_BUILDING_ALL — referenced through BUILDING_CODE, PREFERRED_BUILDING_CODE and DEDICATED_BUILDING_CODE.
• IGS_AD_ROOM_ALL — referenced through ROOM_CODE, PREFERRED_ROOM_CODE and DEDICATED_ROOM_CODE.
• HZ_PARTIES — referenced through INSTRUCTOR_ID.
• IGS_AS_USEC_SESSNS — child session records via UNIT_SECTION_OCCURRENCE_ID.
• IGS_PS_USO_INSTRCTRS — instructor assignments for the occurrence.
• IGS_PS_USO_FACILITY — facility assignments for the occurrence.
• IGS_PS_SH_USEC_OCCURS — occurrence scheduling detail.
• IGS_PS_USEC_OCUR_REF — occurrence reference data.