Search Results class_time

Overview

IGS_SS_USEC_OCCURENCES_V is a reporting view owned by the APPS schema in the Oracle E-Business Suite Student System (IGS) product family. Its documented purpose is to store and present Unit Section Occurrences — the individual scheduled meetings that make up a teaching unit section within an academic term. The view denormalizes scheduling data (day pattern, time window, building, room, and location) together with instructor identity attributes drawn from the Trading Community Architecture party model, producing a single flat row per occurrence that is directly consumable by reports, concurrent programs, and integration extracts. Because the underlying schedule is held in normalized form across several IGS tables, this view serves as the canonical read-only surface for timetable and instructor-assignment reporting in EBS 12.1.1 and 12.2.2.

Underlying Base Objects

Per the ETRM definition, the view is constructed from four base tables joined with outer joins to preserve occurrences that lack a fully defined facility or instructor:

• IGS_PS_USEC_OCCURS (alias C) — the driving table holding the unit section occurrence record, including day flags, start/end times, building and room codes, instructor identifier, and the occurrence validity dates.
• IGS_AD_BUILDING (alias D) — building master; joined on C.BUILDING_CODE = D.BUILDING_ID(+) and supplies the building code and building description.
• IGS_AD_ROOM (alias E) — room master; joined on C.ROOM_CODE = E.ROOM_ID(+) and supplies the room code and room description.
• IGS_AD_LOCATION (alias B) — location master; joined on D.LOCATION_CD = B.LOCATION_CD(+) and supplies the location description.
• HZ_PARTIES (alias F) — the TCA party record for the instructor; joined on C.INSTRUCTOR_ID = F.PARTY_ID(+) and supplies surname, given names, middle name, and person title.

The outer-join pattern means an occurrence is never suppressed merely because facility or instructor reference data is missing, which is important for operational reporting where incomplete setup should remain visible.

Key Columns

• UNIT_SECTION_OCCURRENCE_ID / UOO_ID — primary and alternate identifiers for the occurrence; used as join keys back to scheduling entities.
• CLASS_DAY — a concatenated day code (MON, TUE, WED, THU, FRI, SAT, SUN) built from the individual day flags via DECODE; NULL when no day flag is set.
• CLASS_TIME — formatted start and end time string, for example "09:00AM-10:30AM".
• LOCATION_CD / LOCATION_DESCRIPTION — campus or location identifier and its description.
• BUILDING_ID / BUILDING_CD / BUILDING_DESCRIPTION — building reference and descriptive text.
• ROOM_ID / ROOM_CD / ROOM_DESCRIPTION — room reference and descriptive text.
• INSTRUCTOR_ID — the HZ_PARTIES party identifier of the assigned instructor.
• SURNAME / GIVEN_NAMES / PERSON_TITLE — instructor name components sourced from HZ_PARTIES; PERSON_TITLE is the column most frequently searched, returning honorifics such as Dr, Prof, or Mr.
• INSTRUCTOR_NAME — a derived concatenation of last name, first name, and middle name for display.
• START_DATE / END_DATE — the effective date range of the occurrence.

Common Use Cases and Queries

Typical uses include timetable publication, room utilization analysis, and instructor workload reports. Because DISTINCT is applied in the view text, callers need not deduplicate the result set themselves.

• List all scheduled occurrences with instructor titles for a term.
• Find instructors holding a particular title across all sections.
• Identify occurrences lacking a valid room or instructor assignment.

Sample queries:

SELECT uoo_id, class_day, class_time, instructor_name, person_title FROM apps.igs_ss_usec_occurrences_v WHERE person_title = 'Dr';

SELECT uoo_id, class_day, class_time, location_description, building_description, room_description, instructor_name FROM apps.igs_ss_usec_occurrences_v WHERE building_description IS NULL OR instructor_name IS NULL;

Queries should always be qualified with the APPS schema or an equivalent synonym, and filtered on START_DATE/END_DATE to scope results to the intended academic period.