vORA_COS_ROOMS view

Shows all rooms and their maximum capacity at all campuses.

Source: BANINST1.COS_SV_ROOMS

DW Field

Description or Sample

SLBRDEF_ROOM_NUMBER

Room number

SLBRDEF_BLDG_CODE

Building

SLBRDEF_DESC

Description (Classrm, Classroom, Office, Lab, etc)

SLBRDEF_MAXIMUM_CAPACITY

The maximum capacity of the room

CAMPUS

Code for the campus where the room exists