ROOM_TYPE Table - Data Element Index . Tables and Data Elements . Housing Home . Data Warehouse Home

ROOM_TYPE Table

(dwstarrez.room_type)

Explanation
Lookup table for Room Type. Examples include:
Single-1BR/shared bath
Double-room
Triple-2 rooms
Quad-4BR/LR/cooktop/fridge ... etc.

CUSTOMSTRING1 and CUSTOMSTRING2 fields are frequently used as an alternative method for grouping rooms.

Common Uses
Report on data as it appeared in StarRez at end-of-day yesterday.

ROOMTYPEID
 

 ROOMCONFIGURATION
 

• CUSTOMSTRING1 - Valid values: "FRAT", "Faculty/ProfStaff", "ShortTerm", "Student", "StudentStaff"
• CUSTOMSTRING2 - Valid values "Grad", "Undergrad", Null

ROOM_TYPE Table - Data Element Index . Tables and Data Elements . Housing Home . Data Warehouse Home