This view contains the location master data.
Here you will find the names and references of all the active locations, including the hierarchy. Note that when a location is deleted/archived, it will disappear from this view. Otherwise said, this view contains all the locations that are currently active in your portfolio.
The view contains ALL active locations, regardless if they are monitored by sensors or not.
In most cases, this view will be combined with other views (usually with an INNER JOIN).
Data structure
Column | Meaning | Comment |
|---|---|---|
location_name | name of location | cannot be NULL |
location_reference | reference of location | cannot be NULL |
location_class | class of location | built in enumeration: |
area_name | name of area to which a location belongs | can be NULL if the location does not belong to an Area |
area_reference | reference of area to which a location belongs | can be NULL if the location does not belong to an Area |
site_name | name of site to which a location belongs | can be NULL if the location does not belong to a Site |
site_reference | reference of site to which a location belongs | can be NULL if the location does not belong to a Site |
building_name | name of building to which a location belongs | can be NULL if the location does not belong to a Building |
building_reference | reference of building to which a location belongs | can be NULL if the location does not belong to a Building |
floor_name | name of floor to which a location belongs | can be NULL if the location does not belong to a Floor |
floor_reference | reference of floor to which a location belongs | can be NULL if the location does not belong to a Floor |
room_name | name of room to which a location belongs | is NULL when location class is not WORKPLACE or PARKING |
room_reference | reference of room to which a location belongs | is NULL when location class is not WORKPLACE or PARKING |
workplace_name | name of workplace | is NULL when location class is not WORKPLACE |
workplace_reference | reference of workplace | is NULL when location class is not WORKPLACE |
parking_place_name | name of parking place | is NULL when location class is not PARKING |
parking_place_reference | reference of parking place | is NULL when location class is not PARKING |
room_area_sqm | net area of a room (in square meters) | |
room_category | category of a room | as defined in Workplace |
space_class | class of space, as defined in Studio | built in enumeration: |
is_reservable | flag if the location is reservable | |
location_id | unique identifier of the location | primary key |
location_parent_id | unique identifier of the parent location | this column represents the hierarchy of all locations |
area_id | unique identifier of an area | foreign key |
site_id | unique identifier of a site | foreign key |
building_id | unique identifier of a building | foreign key |
floor_id | unique identifier of a floor | foreign key |
room_id | unique identifier of a room | foreign key |
workplace_id | unique identifier of a workplace | foreign key |
parking_place_id | unique identifier of a parking place | foreign key |