| Data element |
Definition |
| Capacity Indexed - no
Format - Number
May be Null? Y | Holds the capacity of the room |
| Comments Indexed - no
Format - Varchar2(2000)
May be Null? Y | |
| Custombit1 Indexed - no
Format - Varchar2(40)
May be Null? Y | Has kitchen flag |
| 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 | Important for reporting purposes. Valid values are:
"FRAT", "
Faculty/ProfStaff", "ShortTerm", "Student", "StudentStaff"
|
| Customstring2 Indexed - no
Format - Varchar2(200)
May be Null? Y | To designate if room is for Undergraduate or Graduate student. Valid values are "Grad" or "Undergrad" or null. |
| 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(100)
May be Null? Y | |
| Recordtypeenum Indexed - no
Format - Number
May be Null? Y | |
| Roomclosedays Indexed - no
Format - Number
May be Null? Y | |
| Roomclosedaysbusinessonly Indexed - no
Format - Varchar2(40)
May be Null? Y | |
| Roomtypeid Indexed - yes
Format - Number
May be Null? N | Unique Identifier |
| 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 | |
