vORA_COS_ROOMS view
- Jordan Lamb
Owned by Jordan Lamb
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 |