Penn Computing

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

ROOMSPACE Table - Data Element Index

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

Data element Definition
Allocateexclude

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

Allocatesortorder

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

Comments

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

Description

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

Extensionid

Indexed - no
Format - Number
May be Null? Y

Hold

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

Networked

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

Recordtypeenum

Indexed - no
Format - Number
May be Null? Y

Roombaseid

Indexed - no
Format - Number
May be Null? Y

Roomid

Indexed - no
Format - Number
May be Null? Y

Roomrateid

Indexed - no
Format - Number
May be Null? Y

Roomspaceid

Indexed - yes
Format - Number
May be Null? N

Roomspacetypeenum

Indexed - no
Format - Number
May be Null? Y

Sortorder

Indexed - no
Format - Number
May be Null? Y

Street

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

Street2

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

Webdescription

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

ROOMSPACE 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