|
Name |
|
|
Comment |
See documentation on MF_Room in the StarsSpaceDiagram package. |
|
Dimensional Type |
Fact |
|
SELECT |
|
Name |
Parent Table/View |
|
ViewReference_142 |
|
|
ViewReference_143 |
|
|
ViewReference_144 |
|
Name |
|
Grant |
User |
|
SELECT,VIEW DEFINITION |
EnergyReader |
|
SELECT,VIEW DEFINITION |
SpaceReader |
|
Name |
Data Type |
Comment |
Length |
|
MD_Room_SurrogateKey |
numeric |
|
|
|
MD_Building_SurrogateKey |
numeric |
|
|
|
MD_CarlDept_SurrogateKey |
numeric |
|
|
|
MF_Room_Area |
int |
Room area in square feet. May be NULL, since not all rooms/spaces have area values entered into Colleague. |
|
|
MF_Room_Capacity |
int |
Room capacity in people (i.e., an integer count). May be NULL, since not all rooms actually have capacities marked in Colleague. |
|
|
MF_Room_Count |
int |
Count of applicable rooms. Do not use as the divisor in average area and capacity calculations, since the area and/or capacity may be null. |
|
|
|
|