ROOMLOCATION Table - Data Element Index . Tables and Data Elements . Housing Home . Data Warehouse Home

ROOMLOCATION Table

(dwstarrez.roomlocation)

Explanation
Lookup table for Room location. This table is used most frequently in standard reports.

1 = Du Bois College House
2 = Fisher Hassenfeld Col Hse
3 = Fraternity and Sorority
4 = Gregrory College House
5 = Harnwell College House
6 = Harrison College House
7 = Hill College House-OLD
8 = Kings Court-English CH
9 = Riepe College House
10 = Rodin College House
11 = Sansom Place East
12 = Sansom Place West
13 = Sheraton University City
14 = Stouffer College House
15 = Ware College House
16 = ZResidential Program - NQ
17 = ZResidential Program - Q
20 = New College House
21 = Hill College House

Common Uses
Report on data as it appeared in StarRez at end-of-day yesterday.

ROOMLOCATIONID
 

 ROOMBASE
 ROOMLOCATION_AREA
 

• NOTE 1: Sansom East and West are separate locations, therefore 2 separate records in this table.
• NOTE2: There are 2 records for Hill House (original is "Hill College House-OLD")

ROOMLOCATION Table - Data Element Index . Tables and Data Elements . Housing Home . Data Warehouse Home