Results for “exam_day”

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

Overview

IGS_EN_USEC_EXAM_SCH_V is a read-only database view owned by the APPS schema in the Oracle E-Business Suite Student System (IGS) product family. Its documented purpose is to expose final exam schedule details for scheduled unit offerings within an institution's examination timetable. The view consolidates examination date, time, venue, and lead instructor information into a single denormalized result set, sparing report developers and integrators the need to reconstruct the multi-table join themselves.

The object carries a status of VALID in the ETRM registry for both 12.1.1 and 12.2.2. Views of this type are typically consumed by concurrent programs, Oracle Reports or BI Publisher layouts, OBIEE extracts, and custom SQL that surfaces examination timetables to students, faculty, and administrative staff. Because the view is defined in the APPS schema, access is governed by standard EBS security and grants rather than by the underlying student tables directly.

Underlying Base Objects

The view text documents three referenced objects, all themselves views in the IGS schema:

• IGS_PS_USEC_AS_V (alias USAS) — supplies the assessment/examination scheduling attributes, including FINAL_EXAM_DATE, EXAM_START_TIME, EXAM_END_TIME, and the location, building, and room descriptors.
• IGS_PS_UNIT_OFR_OPT_V (alias UOOV) — supplies unit offering option detail: ROW_ID, UNIT_CD, UNIT_CLASS, CALL_NUMBER, TITLE, and the UOO_ID key.
• IGS_PS_USEC_TCH_RESP_V (alias UTR) — supplies teaching responsibility records, from which the lead instructor is derived.

The three sources are joined on UOO_ID (unit offering option identifier), which acts as the de facto driving key. The join to IGS_PS_USEC_TCH_RESP_V is filtered with LEAD_INSTRUCTOR_FLAG = 'Y', so each exam schedule row is associated with the nominated lead instructor rather than the complete teaching team. No physical base tables are documented as directly referenced; all dependencies resolve through the three intermediate views.

Key Columns

• ROW_ID, UOO_ID — surrogate identifiers for the unit offering option record; used for joining back to other IGS entities.
• UNIT_CD, UNIT_CLASS, CALL_NUMBER, TITLE — academic unit and class identification, including the call number used for enrollment reference.
• FINAL_EXAM_DATE — the scheduled examination date; the primary search attribute associated with the term "exam_day".
• EXAM_DAY — derived in the view as INITCAP(TO_CHAR(FINAL_EXAM_DATE,'DAY')), yielding a friendly weekday name such as "Monday".
• EXAM_START_TIME / EXAM_END_TIME — the scheduled start and finish times of the examination.
• LOCATION_CD, LOCATION_DESC, BUILDING_CODE, BUILDING_DESC, ROOM_CODE, ROOM_DESC — venue hierarchy identifying where the examination is held.
• INSTRUCTOR_PERSON_NUMBER, INSTRUCTOR_SURNAME — lead instructor identity; PERSON_NUMBER is the stable integration key.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit columns inherited from the assessment scheduling source.

Common Use Cases and Queries

Typical consumers include examination timetable reports, room utilization analysis, and student-facing schedule extracts. A representative query filtering by weekday and examination date is shown below:

SELECT unit_cd, unit_class, call_number, title,
       final_exam_date, exam_day, exam_start_time, exam_end_time,
       building_desc, room_desc, instructor_surname
FROM   apps.igs_en_usec_exam_sch_v
WHERE  exam_day = 'Monday'
AND    final_exam_date BETWEEN :p_start_date AND :p_end_date
ORDER  BY final_exam_date, exam_start_time, unit_cd;

Because EXAM_DAY is a formatted character representation, filtering on it is convenient for user-facing prompts but less efficient than filtering on FINAL_EXAM_DATE itself. Analysts commonly aggregate counts by venue to detect scheduling conflicts, or join on UOO_ID and UNIT_CD to the wider IGS unit offering views for enrollment headcounts. When the view returns fewer rows than expected, the LEAD_INSTRUCTOR_FLAG filter and the requirement for a matching assessment scheduling record on UOO_ID are the usual causes.