ROOMSPACE_CLOSED Table . Tables and Data Elements . Housing Home . Data Warehouse Home

Custombit1 Custombit2 Datecreated Dateend Datemodified Datestart Roomspaceclosedid Roomspaceid

Data element	Definition
Custombit1 Indexed - no Format - Varchar2(40) May be Null? Y	The future change flag - in essence is set if housing does not want a room counted in the max capacity. Typically, this is determined by whether it’s a rentable space or not. If they create a new bed space, since at the bed level it goes back in time, they check the box since that room doesn’t exist in the past, nor the present until the next cycle hits. This is the most common scenario.
Custombit2 Indexed - no Format - Varchar2(40) May be Null? Y
Datecreated Indexed - no Format - Date May be Null? Y
Dateend Indexed - no Format - Date May be Null? Y
Datemodified Indexed - no Format - Date May be Null? Y
Datestart Indexed - no Format - Date May be Null? Y
Roomspaceclosedid Indexed - yes Format - Number May be Null? N
Roomspaceid Indexed - no Format - Number May be Null? Y

ROOMSPACE_CLOSED Table . Tables and Data Elements . Housing Home . Data Warehouse Home