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

Comments Custombit1 Custombit2 Customdate1 Customdate2 Customstring1 Customstring2 Customstring3 Customstring4 Customstring5 Customstring6 Description Gendertypeenum Nonresidential Recordtypeenum Roomlocationareaid Viewonweb Webcomments Webdescription Webimagelocation

Data element	Definition
Comments Indexed - no Format - Varchar2(800) May be Null? Y
Custombit1 Indexed - no Format - Varchar2(40) May be Null? Y
Custombit2 Indexed - no Format - Varchar2(40) May be Null? Y
Customdate1 Indexed - no Format - Date May be Null? Y
Customdate2 Indexed - no Format - Date May be Null? Y
Customstring1 Indexed - no Format - Varchar2(200) May be Null? Y
Customstring2 Indexed - no Format - Varchar2(200) May be Null? Y
Customstring3 Indexed - no Format - Varchar2(200) May be Null? Y
Customstring4 Indexed - no Format - Varchar2(200) May be Null? Y
Customstring5 Indexed - no Format - Varchar2(200) May be Null? Y
Customstring6 Indexed - no Format - Varchar2(200) May be Null? Y
Description Indexed - no Format - Varchar2(140) May be Null? Y
Gendertypeenum Indexed - no Format - Number May be Null? Y
Nonresidential Indexed - no Format - Varchar2(40) May be Null? Y
Recordtypeenum Indexed - no Format - Number May be Null? Y
Roomlocationareaid Indexed - yes Format - Number May be Null? N
Viewonweb Indexed - no Format - Varchar2(40) May be Null? Y
Webcomments Indexed - no Format - Clob May be Null? Y
Webdescription Indexed - no Format - Varchar2(4000) May be Null? Y
Webimagelocation Indexed - no Format - Varchar2(800) May be Null? Y

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