Results for “igs_ss_en_usec_exam_sch_v”

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

Overview

IGS_SS_EN_USEC_EXAM_SCH_V is a seeded Oracle E-Business Suite view owned by the APPS schema within the Student System (IGS) product family. Its stated purpose, per the ETRM repository, is to "display the exam schedule for the sections for the students." In practice, the view consolidates examination timetable information — exam date, start and end times, venue, and lead instructor — alongside the enrolment and unit attempt context for each student and section. This makes it a convenient reporting and integration object for institutions that need to publish exam schedules to students, produce exam timetables, feed external scheduling systems, or validate examination logistics against enrolled candidates. Because the object is a view rather than a table, it carries no storage of its own and is always resolved at query time against the underlying transactional tables.

Underlying Base Objects

The documented view text joins six base objects across the Student System and Trading Community schemas:

• IGS_PS_USEC_AS_V (alias USAS) — the exam schedule / assessment source, supplying final exam date, exam start and end times, location, building, and room descriptions. It is joined to the unit offering option as an outer join.
• IGS_PS_UNIT_OFR_OPT (alias UOOV) — the unit offering option, providing the unit code, unit class, call number, and location context (aliased SUA_LOCATION_CD).
• IGS_PS_USEC_TCH_RESP (alias UTR) — teaching responsibility, restricted to the lead instructor (LEAD_INSTRUCTOR_FLAG = 'Y').
• HZ_PARTIES (alias PE) — the instructor's party record, supplying party number and person name elements.
• IGS_EN_SU_ATTEMPT (alias SUA) — the student unit attempt, supplying person, calendar type, CI sequence, and attempt status.
• IGS_EN_STDNT_PS_ATT (alias SCA) — the student program attempt, supplying course code and version context.

The view also invokes the function IGS_SS_ENR_DETAILS.GET_TITLE_SECTION to derive the section title. The joins are predominantly outer joins, so rows survive where an exam schedule or instructor is not yet recorded. Attempts with a unit attempt status of 'UNCONFIRM' are explicitly excluded.

Key Columns

• ROW_ID / UOO_ID — identifiers for the row and the unit offering option.
• COURSE_CD / COURSEVERSION — course and version the student is attempting.
• PERSON_ID / PARTY_NUMBER / INSTRUCT — student identity and, where present, the lead instructor's name.
• UNIT_CD / UNIT_CLASS / CALL_NUMBER — the unit being examined.
• TITLE — section title derived from GET_TITLE_SECTION.
• EXAM_DATE_TIME and EXAM_TIMETABLE — formatted exam date with start and end times.
• EXAM_DAY — initial-capped day name for the exam date.
• LOCATION_CD / LOCATION_DESC / BUILDING / ROOM — examination venue details.
• UNIT_ATTEMPT_STATUS, CAL_TYPE, CI_SEQUENCE_NUMBER, CORE_INDICATOR_CODE — enrolment and attempt attributes.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Typical uses include producing per-student exam timetables, staff exam schedules by venue, and data extracts for external examination portals.

• Student timetable: SELECT person_id, course_cd, unit_cd, title, exam_timetable, room FROM igs_ss_en_usec_exam_sch_v WHERE person_id = :p_person_id ORDER BY exam_date_time;
• Venue utilisation: SELECT location_cd, building, room, exam_timetable, COUNT(*) FROM igs_ss_en_usec_exam_sch_v GROUP BY location_cd, building, room, exam_timetable;
• Instructor schedule: SELECT instruct, unit_cd, exam_timetable FROM igs_ss_en_usec_exam_sch_v WHERE instruct IS NOT NULL ORDER BY instruct, exam_date_time;

Because the view is APPS-owned and joins Student System tables, query access should be granted through standard EBS responsibility and security profiles rather than direct grants.