Search Results final_exam_date




Overview
Explore in AI Chat

Overview

IGS_PS_USEC_AS is a table in the IGS (Student System) product schema of Oracle E-Business Suite, valid in both 12.1.1 and 12.2.2. It captures the relationship between Unit Sections and the Assessments conducted within them. In institutional terms, a unit section is a specific teaching offering of a unit of study, and an assessment is any graded instrument — an examination, assignment, or test — associated with that offering. This table therefore acts as the scheduling and venue registry for assessments tied to a particular unit section offering option.

Under the heuristic Data Vault classification mined from its foreign key structure, IGS_PS_USEC_AS is best modeled as a link entity. It resolves the association between a unit section offering and its assessment events, carrying descriptive attributes such as examination date, time window, and physical location. This classification is a modeling suggestion derived from the FK topology rather than a mandated design.

Key Information Stored

The table contains 13 documented columns. The most significant are listed below:

Two unique indexes are documented. IGS_PS_USEC_AS_PK enforces uniqueness on UNIT_SECTION_ASSESSMENT_ID, confirming it as the surrogate key. IGS_PS_USEC_AS_U2 enforces uniqueness across the composite of UOO_ID, FINAL_EXAM_DATE, LOCATION_CD, BUILDING_CODE, and ROOM_CODE, making it the strongest business-key candidate — it prevents duplicate scheduling of the same offering into the same venue on the same date. IGS_PS_USEC_AS_U1 references UNIT_SECTION_ASSESSMENT_ID as well.

Common Use Cases and Queries

Typical uses include generating examination timetables, verifying venue allocations, and resolving clashes where the same room is double-booked. A representative query listing examinations for a given offering option:

  • SELECT a.unit_section_assessment_id, a.uoO_id, a.final_exam_date, a.exam_start_time, a.exam_end_time, a.building_code, a.room_code FROM igs_ps_usec_as a WHERE a.uoO_id = :offering_option_id ORDER BY a.final_exam_date, a.exam_start_time;
  • Venue utilisation reporting groups rows by BUILDING_CODE and ROOM_CODE across a date range to reveal capacity and conflicts.
  • Joining to IGS_PS_UNIT_OFR_OPT_ALL resolves the human-readable unit and section context for institutional reporting.

Related Objects

The documented foreign key relationship ties IGS_PS_USEC_AS.UOO_ID to IGS_PS_UNIT_OFR_OPT_ALL, the primary parent object that supplies the unit offering option context. All assessment scheduling rows depend on a valid record in that table; orphaned rows are prevented at the database level. Additional related objects in the Student System that commonly participate in assessment reporting include the unit offering, unit section, and assessment definition tables within the IGS schema, which together let developers trace an examination from its assessment definition through the section offering to its scheduled date, time, and room.