Penn Computing

University of Pennsylvania
Penn Computing << go backback
ROOMBASE Table . Tables and Data Elements . Housing Home . Data Warehouse Home

ROOMBASE Table - Data Element Index

Select a data element to view its definition and its indexed, format, and null values.

Data element Definition
Allocatesortorder

Indexed - no
Format - Number
May be Null? Y

Area

Indexed - no
Format - Number
May be Null? Y

Bathrooms

Indexed - no
Format - Number
May be Null? Y

Bedcapacity

Indexed - no
Format - Number
May be Null? Y

Bookinghold_Entryid

Indexed - no
Format - Number
May be Null? Y

Bookingholddatetime

Indexed - no
Format - Date
May be Null? Y

Comments

Indexed - no
Format - Varchar2(400)
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(120)
May be Null? Y

Disabledaccess

Indexed - no
Format - Varchar2(40)
May be Null? Y

Flooring

Indexed - no
Format - Varchar2(80)
May be Null? Y

Furniture

Indexed - no
Format - Varchar2(200)
May be Null? Y

Recordtypeenum

Indexed - no
Format - Number
May be Null? Y

Roombaseid

Indexed - yes
Format - Number
May be Null? N

Roomlocationfloorsuiteid

Indexed - no
Format - Number
May be Null? Y

Roomlocationid

Indexed - no
Format - Number
May be Null? Y

Roommanagerid

Indexed - no
Format - Number
May be Null? Y

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

Questions about this page? Email us at da-staff@isc.upenn.edu

Information Systems and Computing
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania