Search Results room_desc




Overview
Explore in AI Chat

Overview

IGS_PS_USEC_AS_V is an Oracle E-Business Suite view owned by the APPS schema. It belongs to the Student Systems product family (the IGS_ prefix denotes the former Student System / Oracle Student System heritage, now delivered within the Oracle EBS footprint). The view presents assessment scheduling and examination logistics data for student unit section assessments — that is, the exam or assessment event associated with a unit offering option (UOO) within a teaching period. Its principal role is denormalization: it enriches the base assessment record with human-readable descriptive text for the physical location, building, and room in which an exam is scheduled, without requiring the report or integration developer to write the join logic. The view is read-only and is intended for reporting, concurrent program queries, and outbound integration extracts rather than for transactional maintenance.

Underlying Base Objects

The view is defined over four documented base tables. The driving table is IGS_PS_USEC_AS (aliased USAS), which stores the unit section assessment record itself, including the scheduled exam date and times and the physical location codes. Three reference tables provide descriptions and are outer-joined: IGS_AD_LOCATION (LOC) supplies the location description via an inner join on LOCATION_CD, while IGS_AD_BUILDING (BLD) is outer-joined on BUILDING_CODE = BUILDING_ID (+) and IGS_AD_ROOM (ROM) is outer-joined on ROOM_CODE = ROOM_ID (+). The outer joins are significant: an assessment may be scheduled to a location without a specific building or room being recorded, in which case BUILDING_DESC and ROOM_DESC return NULL while the assessment row is still returned. Conversely, because the location join is an inner join, any assessment whose LOCATION_CD does not resolve to a valid IGS_AD_LOCATION row is filtered out of the result set entirely.

Key Columns

  • ROW_ID — the ROWID of the underlying IGS_PS_USEC_AS row, useful for addressing the base record.
  • UNIT_SECTION_ASSESSMENT_ID — primary identifier of the assessment record; the key link for downstream detail queries.
  • UOO_ID — the unit offering option to which the assessment belongs, linking to the unit offering option structure.
  • FINAL_EXAM_DATE, EXAM_START_TIME, EXAM_END_TIME — the scheduled examination date and time window.
  • LOCATION_CD / LOCATION_DESC — the location code and its descriptive name.
  • BUILDING_CODE / BUILDING_DESC — the building identifier and description; nullable via outer join.
  • ROOM_CODE / ROOM_DESC — the room identifier and the room description that matches the searched term "room_desc"; nullable via outer join.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit columns (WHO columns) inherited from the base table.

Common Use Cases and Queries

The view is typically used for exam timetable reports, room utilization extracts, and assessment scheduling integrations. A common pattern is to list all scheduled assessments with their resolved descriptions for a given unit or period, filtering on the room description where room-level detail is required.

SELECT unit_section_assessment_id, uoo_id, final_exam_date, exam_start_time, exam_end_time, location_desc, building_desc, room_desc FROM apps.igs_ps_usec_as_v WHERE final_exam_date BETWEEN :p_start AND :p_end;

To isolate assessments scheduled in a specific room, the descriptive column is queried directly:

SELECT uoo_id, final_exam_date, room_desc FROM apps.igs_ps_usec_as_v WHERE room_desc IS NOT NULL AND UPPER(room_desc) LIKE UPPER(:p_room) ORDER BY final_exam_date;

Because BUILDING_DESC and ROOM_DESC are outer-joined, queries that must surface all assessments should avoid filtering on those columns in the WHERE clause, as doing so silently converts the outer join to an inner join and drops assessments lacking building or room detail. Analysts should also restrict access appropriately, since the view is granted through the APPS schema and exposes institutional scheduling data.