LOCATION

type: entity, schedule: daily

For every entity in the location hierarchy data model, from space to region, there is a corresponding row in the Location table. To enable the simplest queries possible, it contains a number of redundant foreign keys to each entity and parent location in the location hierarchy. This table serves many purposes, including:

• allowing tables to link to different types of location entities without requiring separate foreign keys for each type.
• facilitating a join to the ancestor of a location entity (eg 'building_id') without needing to know the entity's specific type.
• Caches the names of each ancestor location in the hierarchy, allowing addresses to be assembled without multiple joins.
• Greatly improving performance in many circumstances.

This table is not extracted from the source database but instead constructed and maintained during the ETL process, so its primary key LOCATION_ID is generated by the warehouse.

• LOCATION_ID (int, mandatory)
• REGION_ID (int) → region
• REGION_LOCATION_ID (int) → location
• BUILDING_ID (int) → building
• BUILDING_LOCATION_ID (int) → location
• FLOOR_ID (int) → floor
• FLOOR_LOCATION_ID (int) → location
• ZONE_ID (int) → zone
• ZONE_LOCATION_ID (int) → location
• NEIGHBORHOOD_ID (int) → neighborhood
• NEIGHBORHOOD_LOCATION_ID (int) → location
• TEAM_ALLOCATION_ID (int) → team allocation
• TEAM_ALLOCATION_LOCATION_ID (int) → location
• SPACE_ID (int) → space
• ORG_UNIT_ID (int) → org unit
• VILLAGE_ID (int) → village
• VILLAGE_LOCATION_ID (int) → location
• LOCATION_TYPE (string, mandatory) - One of 'village', 'region', 'building', 'floor', 'zone', 'neighborhood', 'team allocation' or 'space'.
• REGION_NAME (string)
• BUILDING_NAME (string)
• BUILDING_SHORT_NAME (string)
• FLOOR_NAME (string)
• ZONE_NAME (string)
• NEIGHBORHOOD_NAME (string)
• TEAM_ALLOCATION_NAME (string)
• SPACE_NAME (string)
• ORG_UNIT_NAME (string)
• VILLAGE_NAME (string)
• BUILDING_IS_MANAGED (bool)
• FLOOR_IS_MANAGED (bool)

VILLAGE_LOCATION

type: entity, schedule: daily

• VILLAGE_LOCATION_ID (int, mandatory)
• LOCATION_ID (int, mandatory) → location
• VILLAGE_ID (int, mandatory) → village
• REGION_ID (int) → region
• BUILDING_ID (int) → building
• FLOOR_ID (int) → floor
• ZONE_ID (int) → zone

REGION

type: entity, schedule: daily

A hierarchy of regions within which a building can be located. Countries, states, cities, suburbs, and even campuses. The content and level of detail is entirely customizable by the client.

• REGION_ID (int, mandatory)
• LOCATION_ID (int, mandatory) → location
• PARENT_REGION_ID (int) → region
• REGION_NAME (string)
• LATITUDE (decimal) - Calculated as the average latitude for all buildings within this region that have a latitude and longitude set.
• LONGITUDE (decimal) - Calculated as the average longitude for all buildings within this region that have a latitude and longitude set.
• HIERARCHY_LEVEL (int, mandatory)

REGION_ANCESTOR

type: entity, schedule: daily

A utility table that allows you to join to the region ancestor at any level.

• REGION_ID (int, mandatory) → region
• ANCESTOR_LEVEL (smallint, mandatory)
• ANCESTOR_REGION_ID (int, mandatory) → region

REGION_METRICS

type: entity, schedule: daily

A collection of calculated location metrics for regions, generally related to spaces and people. Only sum floors where Is Managed is true.

• REGION_ID (int, mandatory) → region
• RENTABLE_AREA_SQ_M (decimal) - the area of this location used by the Serraview Chargeback module
• RENTABLE_AREA_SQ_FT (decimal) - converted from RENTABLE_AREA_SQ_M
• SQUATTER_COUNT (int) - the count of people assigned to workpoints without a team
• WORKPOINT_STACKED (int, mandatory) - the sum of BUILDING.STACKED_WORKPOINTS for associated buildings.
• ASSIGNMENT_RATIO (decimal) - The PERSON_LOCATION_COUNT plus WORKPOINT_RETAINED_OCCUPIED_COUNT divided by the WORKPOINT_COUNT (if WORKPOINT_COUNT is zero, this metric will be null)
• WORKPOINT_COUNT (int, mandatory) - the sum of this metric over each building in this region (including child regions)
• WORKPOINT_FIXED_COUNT (int, mandatory) - the sum of this metric over each building in this region (including child regions)
• WORKPOINT_ALLOCATED_COUNT (int, mandatory) - the sum of this metric over each building in the region
• WORKPOINT_UNALLOCATED_COUNT (int, mandatory) - workpoint_Count - workpoint_allocated_count
• WORKPOINT_FLEXIBLE_COUNT (int, mandatory) - equivalent to SPACE.WORKPOINTS if the space is flexible
• WORKPOINT_OCCUPIED (decimal, mandatory) - the sum of this metric over each building in the region (including child regions)
• WORKPOINT_UNOCCUPIED (int, mandatory) - Total Workpoints - Occupied
• WORKPOINT_RETAINED_COUNT (int, mandatory) - the sum of WORKPOINT_COUNT over associated spaces with a retention status
• WORKPOINT_RETAINED_OCCUPIED_COUNT (int, mandatory) - the sum of WORKPOINT_COUNT over associated occupied spaces with a retention status that counts as occupied
• WORKPOINT_RETAINED_UNOCCUPIED_COUNT (int, mandatory) - the sum of WORKPOINT_COUNT over associated unoccupied spaces with a retention status that counts as unoccupied
• WORKPOINT_DIRECT_SPACE_COUNT (int) - Sum of direct spaces assigned to neighborhoods Workpoint_Count
• SEAT_COUNT (int, mandatory) - the sum of SPACE.SEATS
• ASSIGNED_PEOPLE_COUNT (int, mandatory) - the sum of ASSIGNED_PEOPLE_COUNT for associated teams and spaces
• ASSIGNED_PEOPLE_FIXED_COUNT (int, mandatory) - the sum of ASSIGNED_PEOPLE_FIXED_COUNT for associated teams (INCLUDING teams linked directly to the building)
• ASSIGNED_PEOPLE_FLEXIBLE_COUNT (int, mandatory) - subtract ASSIGNED_PEOPLE_FIXED_COUNT from ASSIGNED_PEOPLE_COUNT
• ASSIGNED_KNOWN_PEOPLE_COUNT (int, mandatory) - the sum of ASSIGNED_KNOWN_PEOPLE_COUNT for associated teams (INCLUDING teams linked directly to the building)
• WORKING_FROM_HOME_COUNT (int) - the count of people assigned to workpoints or teams but marked as working from home
• PEOPLE_ASSIGNMENT_CAPACITY (decimal, mandatory) - the sum of PEOPLE_ASSIGNMENT_CAPACITY for associated buildings
• PERSON_LOCATION_COUNT (int) - the count of people assigned to assigned location
• POLYLINED_AREA_SQ_M (decimal) - the sum of POLYLINED_AREA_SQ_M for associated buildings
• AREA_SQ_M (decimal) - the sum of AREA_SQ_M for associated buildings
• AREA_SQ_FT (decimal) - converted from AREA_SQ_M
• POLYLINED_AREA_SQ_FT (decimal) - converted from POLYLINED_AREA_SQ_M
• AREA_ALLOCATABLE_SQ_M (decimal) - the sum of AREA_ALLOCATABLE_SQ_M for associated buildings
• DIRECT_ALLOCATABLE_SQ_M (decimal) - the sum of DIRECT_ALLOCATABLE_SQ_M for associated buildings/floors
• DIRECT_ALLOCATABLE_SQ_FT (decimal) - the sum of DIRECT_ALLOCATABLE_SQ_FT for associated buildings/floors
• AREA_ALLOCATABLE_SQ_FT (decimal) - converted from AREA_ALLOCATABLE_SQ_M
• AREA_ALLOCATED_SQ_M (decimal) - the sum of AREA_ALLOCATED_SQ_M for associated buildings
• AREA_ALLOCATED_SQ_FT (decimal) - converted from AREA_ALLOCATED_SQ_M
• GROSS_AREA_SQ_M (decimal) - the sum of the GROSS_AREA_SQ_M for associated building
• GROSS_AREA_SQ_FT (decimal) - converted from GROSS_AREA_SQ_M
• BOOKABLE_DESK_COUNT (int)
• NON_BOOKABLE_DESK_COUNT (int)
• BOOKABLE_SPACE_COUNT (int)
• NON_BOOKABLE_SPACE_COUNT (int)
• BOOKABLE_ROOM_COUNT (int) - The sum of buildings Bookable_Room_Count
• NON_BOOKABLE_ROOM_COUNT (int) - The sum of buildings Non_Bookable_Room_Count
• SUBLETTABLE_SQ_M (decimal, mandatory) - the sum of SUBLETTABLE_SQ_M for associated buildings
• SUBLETTABLE_SQ_FT (decimal, mandatory) - the sum of SUBLETTABLE_SQ_FT for associated buildings
• SUBLEASED_SQ_M (decimal, mandatory) - the sum of SUBLEASED_SQ_M for associated buildings
• SUBLEASED_SQ_FT (decimal, mandatory) - the sum of SUBLEASED_SQ_FT for associated buildings
• REMAINING_SQ_M (decimal, mandatory) - GROSS_AREA_SQ_M minus POLYLINED_AREA_SQ_M
• REMAINING_SQ_FT (decimal, mandatory) - GROSS_AREA_SQ_FT minus POLYLINED_AREA_SQ_FT
• RENTABLE_EXCLUSION_SQ_M (decimal, mandatory) - the sum of RENTABLE_EXCLUSION_SQ_M for associated buildings
• RENTABLE_EXCLUSION_SQ_FT (decimal, mandatory) - the sum of RENTABLE_EXCLUSION_SQ_FT for associated buildings
• BASE_BUILDING_SQ_M (decimal, mandatory) - the sum of BASE_BUILDING_SQ_M for associated buildings
• BASE_BUILDING_SQ_FT (decimal, mandatory) - the sum of BASE_BUILDING_SQ_M for associated buildings
• LOCATION_ID (int, mandatory) → location

BUILDING

type: entity, schedule: daily

A building is a structure that people work in! It has an address and contains one or more floors.

• BUILDING_ID (int, mandatory)
• LOCATION_ID (int, mandatory) → location
• REGION_ID (int) → region
• BUILDING_NAME (string)
• BUILDING_SHORT_NAME (string)
• BUILDING_CODE (string)
• BUILDING_TYPE (string)
• SV_LOCATION_TYPE (string)
• STREET (string)
• CITY (string)
• STATE (string)
• STATE_CODE (string)
• COUNTRY (string)
• POSTAL_CODE (string)
• LATITUDE (decimal)
• LONGITUDE (decimal)
• IS_MANAGED (bool) - Corresponds directly to the ShowInVBS flag in Serraview.
• RECHARGEABLE_COST (int)
• COMMENTS (string)
• LEASE_LANDLORD (string)
• LEASE_TERM (int)
• LEASE_EXPIRY (datetime)
• LEASE_OPTIONS (string)
• LEASE_COMMENTS (string)
• ALLOWED_RESERVATIONS_PER15_MINUTES (int)
• ALLOWED_TOTAL_RESERVATIONS (int)
• TIMEZONE (string)
• SHOW_IN_WAYFINDING (bool)
• LEASE_TYPE (string)
• BUILDING_DESCRIPTION (string)
• IS_SKIP_TIMEZONE (bool) - skip insights timezone process to fill up timezone
• CHECKIN_ENABLED (bool) - True if check-ins are enabled for all desks.
• CHECKIN_OPEN_WINDOW (int) - The number of minutes prior to a booking a user can check-in.
• CHECKIN_DURATION (int) - The number of minutes after a booking a user can check-in.
• BOOKING_SAFE (string) - Configuration setting for Engage
• BOOKING_SAFE_DISTANCE (int) - Configuration setting for Engage
• TARGET_ASSIGNMENT_RATIO (decimal, mandatory)

BUILDING_CUSTOM_FIELD_VALUE

type: entity, schedule: daily

The value of a custom field for the specified building entity.

• BUILDING_ID (int, mandatory)
• CUSTOM_FIELD_NAME (string, mandatory)
• CUSTOM_FIELD_VALUE (string)

BUILDING_CUSTOM_FIELDS

type: view

A dynamically created data model whose columns match the custom fields configured by the client for the building table.

• BUILDING_ID (int, mandatory) → building
• <custom fields>

BUILDING_METRICS

type: entity, schedule: daily

A collection of calculated location metrics for buildings, generally related to spaces and people. Only sum floors where Is Managed is true.

• BUILDING_ID (int, mandatory) → building
• RENTABLE_AREA_SQ_M (decimal) - the area of this location used by the Serraview Chargeback module
• RENTABLE_AREA_SQ_FT (decimal) - converted from RENTABLE_AREA_SQ_M
• SQUATTER_COUNT (int) - the count of people assigned to workpoints without a team
• WORKPOINT_COST (decimal) - Building Cost / Building Total Workpoints
• WORKPOINT_STACKED (int, mandatory) - the sum of FLOOR.STACKED_WORKPOINTS for associated floors.
• ASSIGNMENT_RATIO (decimal) - The PERSON_LOCATION_COUNT plus WORKPOINT_RETAINED_OCCUPIED_COUNT divided by the WORKPOINT_COUNT (if WORKPOINT_COUNT is zero, this metric will be null)
• WORKPOINT_COUNT (int, mandatory) - the sum of this metric over each floor in the building
• WORKPOINT_FIXED_COUNT (int, mandatory) - the sum of this metric over each floor in the building
• WORKPOINT_ALLOCATED_COUNT (int, mandatory) - the sum of this metric over each floor in the building
• WORKPOINT_UNALLOCATED_COUNT (int, mandatory) - workpoint_Count - workpoint_allocated_count
• WORKPOINT_FLEXIBLE_COUNT (int, mandatory) - equivalent to SPACE.WORKPOINTS if the space is flexible
• WORKPOINT_OCCUPIED (decimal, mandatory) - the sum of this metric over each floor in the building
• WORKPOINT_UNOCCUPIED (int, mandatory) - Total Workpoints - Occupied
• WORKPOINT_RETAINED_COUNT (int, mandatory) - the sum of WORKPOINT_COUNT over associated spaces with a retention status
• WORKPOINT_RETAINED_OCCUPIED_COUNT (int, mandatory) - the sum of WORKPOINT_COUNT over associated occupied spaces with a retention status that counts as occupied
• WORKPOINT_RETAINED_UNOCCUPIED_COUNT (int, mandatory) - the sum of WORKPOINT_COUNT over associated unoccupied spaces with a retention status that counts as unoccupied
• WORKPOINT_DIRECT_SPACE_COUNT (int) - Sum of direct spaces assigned to neighborhoods Workpoint_Count
• SEAT_COUNT (int, mandatory) - the sum of SPACE.SEATS
• ASSIGNED_PEOPLE_COUNT (int, mandatory) - the sum of ASSIGNED_PEOPLE_COUNT for associated teams (INCLUDING teams linked directly to the building)
• ASSIGNED_PEOPLE_FIXED_COUNT (int, mandatory) - the sum of ASSIGNED_PEOPLE_FIXED_COUNT for associated teams (INCLUDING teams linked directly to the building)
• ASSIGNED_PEOPLE_FLEXIBLE_COUNT (int, mandatory) - subtract ASSIGNED_PEOPLE_FIXED_COUNT from ASSIGNED_PEOPLE_COUNT
• ASSIGNED_KNOWN_PEOPLE_COUNT (int, mandatory) - the sum of ASSIGNED_KNOWN_PEOPLE_COUNT for associated teams (INCLUDING teams linked directly to the building)
• WORKING_FROM_HOME_COUNT (int) - the count of people assigned to workpoints or teams but marked as working from home
• PEOPLE_ASSIGNMENT_CAPACITY (decimal, mandatory) - the sum of PEOPLE_ASSIGNMENT_CAPACITY for associated floors
• PERSON_LOCATION_COUNT (int) - the count of people assigned to assigned location
• POLYLINED_AREA_SQ_M (decimal) - the sum of POLYLINED_AREA_SQ_M for associated floors
• AREA_SQ_M (decimal) - the sum of AREA_SQ_M for associated floors
• AREA_SQ_FT (decimal) - converted from AREA_SQ_M
• POLYLINED_AREA_SQ_FT (decimal) - converted from POLYLINED_AREA_SQ_M
• AREA_ALLOCATABLE_SQ_M (decimal) - the sum of AREA_ALLOCATABLE_SQ_M for associated floors
• DIRECT_ALLOCATABLE_SQ_M (decimal) - the sum of DIRECT_ALLOCATABLE_SQ_M for associated floors
• DIRECT_ALLOCATABLE_SQ_FT (decimal) - the sum of DIRECT_ALLOCATABLE_SQ_FT for associated floors
• AREA_ALLOCATABLE_SQ_FT (decimal) - converted from AREA_ALLOCATABLE_SQ_M
• AREA_ALLOCATED_SQ_M (decimal) - the sum of AREA_ALLOCATED_SQ_M for associated floors
• AREA_ALLOCATED_SQ_FT (decimal) - converted from AREA_ALLOCATED_SQ_M
• GROSS_AREA_SQ_M (decimal) - the sum of the GROSS_AREA_SQ_M for associated floors
• GROSS_AREA_SQ_FT (decimal) - converted from GROSS_AREA_SQ_M
• BOOKABLE_DESK_COUNT (int)
• NON_BOOKABLE_DESK_COUNT (int)
• BOOKABLE_SPACE_COUNT (int)
• NON_BOOKABLE_SPACE_COUNT (int)
• BOOKABLE_ROOM_COUNT (int) - The sum of floors Bookable_Room_Count
• NON_BOOKABLE_ROOM_COUNT (int) - The sum of floors Non_Bookable_Room_Count
• SUBLETTABLE_SQ_M (decimal, mandatory) - the sum of SUBLETTABLE_SQ_M for associated floors
• SUBLETTABLE_SQ_FT (decimal, mandatory) - the sum of SUBLETTABLE_SQ_FT for associated floors
• SUBLEASED_SQ_M (decimal, mandatory) - the sum of SUBLEASED_SQ_M for associated floors
• SUBLEASED_SQ_FT (decimal, mandatory) - the sum of SUBLEASED_SQ_FT for associated floors
• REMAINING_SQ_M (decimal, mandatory) - GROSS_AREA_SQ_M minus POLYLINED_AREA_SQ_M
• REMAINING_SQ_FT (decimal, mandatory) - GROSS_AREA_SQ_FT minus POLYLINED_AREA_SQ_FT
• RENTABLE_EXCLUSION_SQ_M (decimal, mandatory) - the sum of RENTABLE_EXCLUSION_SQ_M for associated floors
• RENTABLE_EXCLUSION_SQ_FT (decimal, mandatory) - the sum of RENTABLE_EXCLUSION_SQ_FT for associated floors
• BASE_BUILDING_SQ_M (decimal, mandatory) - the sum of BASE_BUILDING_SQ_M for associated floors
• BASE_BUILDING_SQ_FT (decimal, mandatory) - the sum of BASE_BUILDING_SQ_M for associated floors
• LOCATION_ID (int, mandatory) → location

COMMENTS

type: entity, schedule: daily

Convert from Serraview comments in XML - AuditComments with Container tables

• TABLE_NAME (string, mandatory)
• ID (int, mandatory)
• PERSON_ID (int, mandatory) → person
• DATE (datetime, mandatory)
• COMMENT (string, mandatory)

COMMENT

type: entity, schedule: daily

A Serraview 3.0 new table Comment

• ID (int, mandatory)
• USER_ID (int) → user
• COMMENTABLE_ID (int)
• COMMENTABLE_NAME (string)
• CREATED_AT (datetime)
• UPDATED_AT (datetime)
• BODY (string)

VILLAGE

type: entity, schedule: daily

A village optionally exists within one or more floors of one or more buildings. It contains neighborhoods and spaces.

• VILLAGE_ID (int, mandatory)
• LOCATION_ID (int, mandatory) → location
• VILLAGE_NAME (string)
• COLOR (string)
• TARGET_ASSIGNMENT_RATIO (decimal, mandatory)

VILLAGE_METRICS

type: entity, schedule: daily

A collection of calculated location metrics for villages, generally related to spaces and people. Only sum floors where Is Managed is true. A collection of calculated location metrics for villages, generally related to spaces and people.

• VILLAGE_ID (int, mandatory) → village
• RENTABLE_AREA_SQ_M (decimal) - the area of this location used by the Serraview Chargeback module
• RENTABLE_AREA_SQ_FT (decimal) - converted from RENTABLE_AREA_SQ_M
• SQUATTER_COUNT (int) - the count of people assigned to workpoints without a team
• ASSIGNMENT_RATIO (decimal) - The PERSON_LOCATION_COUNT plus WORKPOINT_RETAINED_OCCUPIED_COUNT divided by the WORKPOINT_COUNT (if WORKPOINT_COUNT is zero, this metric will be null)
• WORKPOINT_COUNT (int, mandatory) - not applicable
• WORKPOINT_FIXED_COUNT (int, mandatory) - not applicable
• WORKPOINT_ALLOCATED_COUNT (int, mandatory) - not applicable
• WORKPOINT_UNALLOCATED_COUNT (int, mandatory) - workpoint_Count - workpoint_allocated_count
• WORKPOINT_FLEXIBLE_COUNT (int, mandatory) - equivalent to SPACE.WORKPOINTS if the space is flexible
• WORKPOINT_OCCUPIED (decimal, mandatory) - the sum of this metric over each neighborhood in the village
• WORKPOINT_UNOCCUPIED (int, mandatory) - Total Workpoints - Occupied
• WORKPOINT_RETAINED_COUNT (int, mandatory) - the sum of WORKPOINT_COUNT over associated spaces with a retention status
• WORKPOINT_RETAINED_OCCUPIED_COUNT (int, mandatory) - the sum of WORKPOINT_COUNT over associated occupied spaces with a retention status that counts as occupied
• WORKPOINT_RETAINED_UNOCCUPIED_COUNT (int, mandatory) - the sum of WORKPOINT_COUNT over associated unoccupied spaces with a retention status that counts as unoccupied
• WORKPOINT_DIRECT_SPACE_COUNT (int) - Sum of direct spaces assigned to neighborhoods Workpoint_Count
• SEAT_COUNT (int, mandatory) - the sum of SPACE.SEATS
• ASSIGNED_PEOPLE_COUNT (int, mandatory) - not applicable
• ASSIGNED_PEOPLE_FIXED_COUNT (int, mandatory) - not applicable
• ASSIGNED_PEOPLE_FLEXIBLE_COUNT (int, mandatory) - subtract ASSIGNED_PEOPLE_FIXED_COUNT from ASSIGNED_PEOPLE_COUNT
• ASSIGNED_KNOWN_PEOPLE_COUNT (int, mandatory) - not applicable
• WORKING_FROM_HOME_COUNT (int) - the count of people assigned to workpoints or teams but marked as working from home
• PEOPLE_ASSIGNMENT_CAPACITY (decimal, mandatory) - not applicable
• PERSON_LOCATION_COUNT (int) - the count of people assigned to assigned location
• POLYLINED_AREA_SQ_M (decimal) - not applicable
• AREA_SQ_M (decimal) - not applicable
• AREA_SQ_FT (decimal) - converted from AREA_SQ_M
• POLYLINED_AREA_SQ_FT (decimal) - converted from POLYLINED_AREA_SQ_M
• AREA_ALLOCATABLE_SQ_M (decimal) - not applicable
• DIRECT_ALLOCATABLE_SQ_M (decimal) - not applicable
• DIRECT_ALLOCATABLE_SQ_FT (decimal) - not applicable
• AREA_ALLOCATABLE_SQ_FT (decimal) - converted from AREA_ALLOCATABLE_SQ_M
• AREA_ALLOCATED_SQ_M (decimal) - not applicable
• AREA_ALLOCATED_SQ_FT (decimal) - converted from AREA_ALLOCATED_SQ_M
• GROSS_AREA_SQ_M (decimal) - not applicable
• GROSS_AREA_SQ_FT (decimal) - not applicable
• BOOKABLE_DESK_COUNT (int)
• NON_BOOKABLE_DESK_COUNT (int)
• BOOKABLE_SPACE_COUNT (int)
• NON_BOOKABLE_SPACE_COUNT (int)
• BOOKABLE_ROOM_COUNT (int) - The sum of neighborhoods Bookable_Room_Count
• NON_BOOKABLE_ROOM_COUNT (int) - The sum of neighborhoods Non_Bookable_Room_Count

FLOOR

type: entity, schedule: daily

A floor sits within a single building. It contains zones, neighborhoods and spaces.

• FLOOR_ID (int, mandatory)
• LOCATION_ID (int, mandatory) → location
• REGION_ID (int) → region
• BUILDING_ID (int, mandatory) → building
• FLOOR_NAME (string)
• FLOOR_CODE (string)
• SEQUENCE (smallint) - Defines the order of the floors in the building - the higher the sequence number the higher the floor is located in the building.
• IS_MANAGED (bool) - Corresponds directly to the ShowInVBS flag in Serraview.
• LEASED_AREA (decimal)
• LOAD_FACTOR (decimal) - A ratio used in recharge calculations to modify the relative cost of spaces on this floor in comparison to the rest of the building.
• COMMENTS (string)
• WORKPOINTS (int)
• IS_MAPPED (bool) - True if there are shapes defined for the spaces on this floor.
• IS_SERRAVIEW_LIVE_ENABLED (bool)
• BUILDING_NUMBER_OVERRIDE (string)
• NORTH_POINT_ANGLE (int)
• SHOW_IN_WAYFINDING (bool)
• WORKPOINT_COST (decimal) - The cost per workpoint as defined by the Floor Workpoint Cost field in Serraview
• TARGET_ASSIGNMENT_RATIO (decimal, mandatory)

FLOOR_CUSTOM_FIELD_VALUE

type: entity, schedule: daily

The value of a custom field for the specified floor entity.

• FLOOR_ID (int, mandatory)
• CUSTOM_FIELD_NAME (string, mandatory)
• CUSTOM_FIELD_VALUE (string)

FLOOR_CUSTOM_FIELDS

type: view

A dynamically created data model whose columns match the custom fields configured by the client for the floor table.

• FLOOR_ID (int, mandatory) → floor
• <custom fields>

FLOOR_METRICS

type: entity, schedule: daily

A collection of calculated location metrics for floors, generally related to spaces and people. Only sum floors where Is Managed is true.

• FLOOR_ID (int, mandatory) → floor
• RENTABLE_AREA_SQ_M (decimal) - the area of this location used by the Serraview Chargeback module
• RENTABLE_AREA_SQ_FT (decimal) - converted from RENTABLE_AREA_SQ_M
• SQUATTER_COUNT (int) - the count of people assigned to workpoints without a team
• WORKPOINT_STACKED (int, mandatory) - the sum of TEAM.STACKED_WORKPOINTS for associated teams.
• ASSIGNMENT_RATIO (decimal) - The PERSON_LOCATION_COUNT plus WORKPOINT_RETAINED_OCCUPIED_COUNT divided by the WORKPOINT_COUNT (if WORKPOINT_COUNT is zero, this metric will be null)
• WORKPOINT_COUNT (int, mandatory) - the sum of the WORKPOINT_COUNT for allocatable spaces on this floor, or FLOOR.WORKPOINTS for unmapped floors with no spaces
• WORKPOINT_FIXED_COUNT (int, mandatory) - the sum of the WORKPOINT_COUNT for fixed spaces on this floor, or sum of the WORKPOINT_COUNT for fixed teams plus the Unallocated Workpoints for unmapped floors
• WORKPOINT_ALLOCATED_COUNT (int, mandatory) - The sum of Neighborhood WORKPOINT_ALLOCATED_COUNT plus the sum of Teams not in Neighborhoods
• WORKPOINT_UNALLOCATED_COUNT (int, mandatory) - workpoint_Count - workpoint_allocated_count
• WORKPOINT_FLEXIBLE_COUNT (int, mandatory) - equivalent to SPACE.WORKPOINTS if the space is flexible
• WORKPOINT_OCCUPIED (decimal, mandatory) - the sum of this metric for each neighborhood, each team outside of a neighborhood, and each unallocated space on the floor
• WORKPOINT_UNOCCUPIED (int, mandatory) - Total Workpoints - Occupied
• WORKPOINT_RETAINED_COUNT (int, mandatory) - the sum of WORKPOINT_COUNT over associated spaces with a retention status
• WORKPOINT_RETAINED_OCCUPIED_COUNT (int, mandatory) - the sum of WORKPOINT_COUNT over associated occupied spaces with a retention status that counts as occupied
• WORKPOINT_RETAINED_UNOCCUPIED_COUNT (int, mandatory) - the sum of WORKPOINT_COUNT over associated unoccupied spaces with a retention status that counts as unoccupied
• WORKPOINT_DIRECT_SPACE_COUNT (int) - Sum of direct spaces assigned to neighborhoods Workpoint_Count
• SEAT_COUNT (int, mandatory) - the sum of SPACE.SEATS
• ASSIGNED_PEOPLE_COUNT (int, mandatory) - the sum of ASSIGNED_PEOPLE_COUNT for associated teams and spaces
• ASSIGNED_PEOPLE_FIXED_COUNT (int, mandatory) - the sum of ASSIGNED_PEOPLE_FIXED_COUNT for associated teams and spaces
• ASSIGNED_PEOPLE_FLEXIBLE_COUNT (int, mandatory) - subtract ASSIGNED_PEOPLE_FIXED_COUNT from ASSIGNED_PEOPLE_COUNT
• ASSIGNED_KNOWN_PEOPLE_COUNT (int, mandatory) - the sum of ASSIGNED_KNOWN_PEOPLE_COUNT for associated teams
• WORKING_FROM_HOME_COUNT (int) - the count of people assigned to workpoints or teams but marked as working from home
• PEOPLE_ASSIGNMENT_CAPACITY (decimal, mandatory) - the sum of PEOPLE_ASSIGNMENT_CAPACITY for associated neighborhoods, teams without neighborhoods, and unallocated spaces
• PERSON_LOCATION_COUNT (int) - the count of people assigned to assigned location
• POLYLINED_AREA_SQ_M (decimal) - the sum of POLYLINED_AREA_SQ_M for associated spaces
• AREA_SQ_M (decimal) - the sum of AREA_SQ_M for associated spaces
• AREA_SQ_FT (decimal) - converted from AREA_SQ_M
• POLYLINED_AREA_SQ_FT (decimal) - converted from POLYLINED_AREA_SQ_M
• AREA_ALLOCATABLE_SQ_M (decimal) - the sum of AREA_ALLOCATABLE_SQ_M for associated spaces
• DIRECT_ALLOCATABLE_SQ_M (decimal) - the sum of DIRECT_ALLOCATABLE_SQ_M for associated spaces
• DIRECT_ALLOCATABLE_SQ_FT (decimal) - the sum of DIRECT_ALLOCATABLE_SQ_FT for associated spaces
• AREA_ALLOCATABLE_SQ_FT (decimal) - converted from AREA_ALLOCATABLE_SQ_M
• AREA_ALLOCATED_SQ_M (decimal) - the sum of AREA_ALLOCATED_SQ_M for spaces outside of neighborhoods plus the sum of AREA_ALLOCATED_SQ_M of neighborhoods
• AREA_ALLOCATED_SQ_FT (decimal) - converted from AREA_ALLOCATED_SQ_M
• GROSS_AREA_SQ_M (decimal) - the measured area of the entire floor, without any exclusions
• GROSS_AREA_SQ_FT (decimal) - converted from GROSS_AREA_SQ_M
• BOOKABLE_DESK_COUNT (int)
• NON_BOOKABLE_DESK_COUNT (int)
• BOOKABLE_SPACE_COUNT (int)
• NON_BOOKABLE_SPACE_COUNT (int)
• BOOKABLE_ROOM_COUNT (int) - The sum of spaces Bookable_Room_Count
• NON_BOOKABLE_ROOM_COUNT (int) - The sum of spaces Non_Bookable_Room_Count
• SUBLETTABLE_SQ_M (decimal, mandatory) - the sum of SUBLETTABLE_SQ_M for associated spaces
• SUBLETTABLE_SQ_FT (decimal, mandatory) - the sum of SUBLETTABLE_SQ_FT for associated spaces
• SUBLEASED_SQ_M (decimal, mandatory) - the sum of SUBLEASED_SQ_M for associated spaces
• SUBLEASED_SQ_FT (decimal, mandatory) - the sum of SUBLEASED_SQ_FT for associated spaces
• REMAINING_SQ_M (decimal, mandatory) - GROSS_AREA_SQ_M minus POLYLINED_AREA_SQ_M
• REMAINING_SQ_FT (decimal, mandatory) - GROSS_AREA_SQ_FT minus POLYLINED_AREA_SQ_FT
• RENTABLE_EXCLUSION_SQ_M (decimal, mandatory) - the sum of RENTABLE_EXCLUSION_SQ_M for associated spaces
• RENTABLE_EXCLUSION_SQ_FT (decimal, mandatory) - the sum of RENTABLE_EXCLUSION_SQ_FT for associated spaces
• BASE_BUILDING_SQ_M (decimal, mandatory) - the sum of BASE_BUILDING_SQ_M for associated spaces
• BASE_BUILDING_SQ_FT (decimal, mandatory) - the sum of BASE_BUILDING_SQ_FT for associated spaces
• LOCATION_ID (int, mandatory) → location

ZONE

type: entity, schedule: daily

An optional subdivision of a floor, allowing reporting to be broken down in more detail. Multiple zones are only present in large buildings, or where physical obstructions prevent normal activity. Most floors do not have zones.

Floors with a single zone in Serraview will not have a zone in Insights - any data linked to the zone will be linked to the corresponding floor instead.

• ZONE_ID (int, mandatory)
• LOCATION_ID (int, mandatory) → location
• REGION_ID (int) → region
• BUILDING_ID (int, mandatory) → building
• FLOOR_ID (int, mandatory) → floor
• ZONE_NAME (string)
• WORKPOINTS (int)
• IS_MAPPED (bool) - True if there are shapes defined for the spaces on this zone.
• COMMENTS (string)
• WAYFINDING_COMMENTS (string)
• TARGET_ASSIGNMENT_RATIO (decimal, mandatory)

ZONE_CUSTOM_FIELD_VALUE

type: entity, schedule: daily

The value of a custom field for the specified zone entity.

• ZONE_ID (int, mandatory)
• CUSTOM_FIELD_NAME (string, mandatory)
• CUSTOM_FIELD_VALUE (string)

ZONE_CUSTOM_FIELDS

type: view

A dynamically created data model whose columns match the custom fields configured by the client for the zone table.

• ZONE_ID (int, mandatory) → zone
• <custom fields>

ZONE_METRICS

type: entity, schedule: daily

A collection of calculated location metrics for zones, generally related to spaces and people. Only sum floors where Is Managed is true.

• ZONE_ID (int, mandatory) → zone
• RENTABLE_AREA_SQ_M (decimal) - the area of this location used by the Serraview Chargeback module
• RENTABLE_AREA_SQ_FT (decimal) - converted from RENTABLE_AREA_SQ_M
• SQUATTER_COUNT (int) - the count of people assigned to workpoints without a team
• WORKPOINT_STACKED (int, mandatory) - the sum of TEAM.STACKED_WORKPOINTS for associated teams.
• ASSIGNMENT_RATIO (decimal) - The PERSON_LOCATION_COUNT plus WORKPOINT_RETAINED_OCCUPIED_COUNT divided by the WORKPOINT_COUNT (if WORKPOINT_COUNT is zero, this metric will be null)
• WORKPOINT_COUNT (int, mandatory) - the sum of the WORKPOINT_COUNT for allocatable spaces in this zone, or ZONE.WORKPOINTS for unmapped zones with no spaces
• WORKPOINT_FIXED_COUNT (int, mandatory) - the sum of the WORKPOINT_COUNT for fixed spaces in this zone, or sum of the WORKPOINT_COUNT for fixed teams plus the zone WORKPOINT_UNALLOCATED_COUNT for unmapped zones
• WORKPOINT_ALLOCATED_COUNT (int, mandatory) - The sum of Neighborhood WORKPOINT_ALLOCATED_COUNT plus the sum of Teams not in Neighborhoods
• WORKPOINT_UNALLOCATED_COUNT (int, mandatory) - workpoint_Count - workpoint_allocated_count
• WORKPOINT_FLEXIBLE_COUNT (int, mandatory) - equivalent to SPACE.WORKPOINTS if the space is flexible
• WORKPOINT_OCCUPIED (decimal, mandatory) - the sum of this metric for each neighborhood, each team outside of a neighborhood, and each unallocated space within the zone
• WORKPOINT_UNOCCUPIED (int, mandatory) - Total Workpoints - Occupied
• WORKPOINT_RETAINED_COUNT (int, mandatory) - the sum of WORKPOINT_COUNT over associated spaces with a retention status
• WORKPOINT_RETAINED_OCCUPIED_COUNT (int, mandatory) - the sum of WORKPOINT_COUNT over associated occupied spaces with a retention status that counts as occupied
• WORKPOINT_RETAINED_UNOCCUPIED_COUNT (int, mandatory) - the sum of WORKPOINT_COUNT over associated unoccupied spaces with a retention status that counts as unoccupied
• WORKPOINT_DIRECT_SPACE_COUNT (int) - Sum of direct spaces assigned to neighborhoods Workpoint_Count
• SEAT_COUNT (int, mandatory) - the sum of SPACE.SEATS
• ASSIGNED_PEOPLE_COUNT (int, mandatory) - the sum of ASSIGNED_PEOPLE_COUNT for associated teams and spaces
• ASSIGNED_PEOPLE_FIXED_COUNT (int, mandatory) - the sum of ASSIGNED_PEOPLE_FIXED_COUNT for associated teams and spaces
• ASSIGNED_PEOPLE_FLEXIBLE_COUNT (int, mandatory) - subtract ASSIGNED_PEOPLE_FIXED_COUNT from ASSIGNED_PEOPLE_COUNT
• ASSIGNED_KNOWN_PEOPLE_COUNT (int, mandatory) - the sum of ASSIGNED_KNOWN_PEOPLE_COUNT for associated teams
• WORKING_FROM_HOME_COUNT (int) - the count of people assigned to workpoints or teams but marked as working from home
• PEOPLE_ASSIGNMENT_CAPACITY (decimal, mandatory) - the sum of PEOPLE_ASSIGNMENT_CAPACITY over associated neighborhoods, teams without neighborhoods, and unallocated spaces
• PERSON_LOCATION_COUNT (int) - the count of people assigned to assigned location
• POLYLINED_AREA_SQ_M (decimal) - the sum of POLYLINED_AREA_SQ_M for associated spaces
• AREA_SQ_M (decimal) - the sum of AREA_SQ_M for associated spaces
• AREA_SQ_FT (decimal) - converted from AREA_SQ_M
• POLYLINED_AREA_SQ_FT (decimal) - converted from POLYLINED_AREA_SQ_M
• AREA_ALLOCATABLE_SQ_M (decimal) - the sum of AREA_ALLOCATABLE_SQ_M for associated spaces
• DIRECT_ALLOCATABLE_SQ_M (decimal) - the sum of DIRECT_ALLOCATABLE_SQ_M for associated spaces
• DIRECT_ALLOCATABLE_SQ_FT (decimal) - the sum of DIRECT_ALLOCATABLE_SQ_FT for associated spaces
• AREA_ALLOCATABLE_SQ_FT (decimal) - converted from AREA_ALLOCATABLE_SQ_M
• AREA_ALLOCATED_SQ_M (decimal) - the sum of AREA_ALLOCATED_SQ_M for spaces outside of neighborhoods plus the sum of AREA_ALLOCATED_SQ_M of neighborhoods
• AREA_ALLOCATED_SQ_FT (decimal) - converted from AREA_ALLOCATED_SQ_M
• GROSS_AREA_SQ_M (decimal) - the measured area of the entire zone, including unmapped area
• GROSS_AREA_SQ_FT (decimal) - converted from GROSS_AREA_SQ_M
• BOOKABLE_DESK_COUNT (int)
• NON_BOOKABLE_DESK_COUNT (int)
• BOOKABLE_SPACE_COUNT (int)
• NON_BOOKABLE_SPACE_COUNT (int)
• BOOKABLE_ROOM_COUNT (int) - The sum of spaces Bookable_Room_Count
• NON_BOOKABLE_ROOM_COUNT (int) - The sum of spaces Non_Bookable_Room_Count
• SUBLETTABLE_SQ_M (decimal, mandatory) - the sum of SUBLETTABLE_SQ_M for associated spaces
• SUBLETTABLE_SQ_FT (decimal, mandatory) - the sum of SUBLETTABLE_SQ_FT for associated spaces
• SUBLEASED_SQ_M (decimal, mandatory) - the sum of SUBLEASED_SQ_M for associated spaces
• SUBLEASED_SQ_FT (decimal, mandatory) - the sum of SUBLEASED_SQ_FT for associated spaces
• REMAINING_SQ_M (decimal, mandatory) - GROSS_AREA_SQ_M minus POLYLINED_AREA_SQ_M
• REMAINING_SQ_FT (decimal, mandatory) - GROSS_AREA_SQ_FT minus POLYLINED_AREA_SQ_FT
• RENTABLE_EXCLUSION_SQ_M (decimal, mandatory) - the sum of RENTABLE_EXCLUSION_SQ_M for associated spaces
• RENTABLE_EXCLUSION_SQ_FT (decimal, mandatory) - the sum of RENTABLE_EXCLUSION_SQ_FT for associated spaces
• BASE_BUILDING_SQ_M (decimal, mandatory) - the sum of BASE_BUILDING_SQ_M for associated spaces
• BASE_BUILDING_SQ_FT (decimal, mandatory) - the sum of BASE_BUILDING_SQ_FT for associated spaces
• LOCATION_ID (int, mandatory) → location

NEIGHBORHOOD

type: entity, schedule: daily

A group of spaces, almost always contiguous on the floor, to which teams can receive an allocation of workpoints from. This is done without directly allocating the specific spaces to the team - the teams are free to use any of the workpoints in the neighborhood.

• NEIGHBORHOOD_ID (int, mandatory)
• LOCATION_ID (int, mandatory) → location
• REGION_ID (int) → region
• BUILDING_ID (int, mandatory) → building
• FLOOR_ID (int, mandatory) → floor
• ZONE_ID (int) → zone
• VILLAGE_ID (int) → village
• NEIGHBORHOOD_NAME (string)
• WORKPOINTS (int, mandatory)
• COMMENTS (string)
• WAYFINDING_COMMENTS (string)
• NEIGHBORHOOD_COLOR (string)
• TARGET_ASSIGNMENT_RATIO (decimal, mandatory)

NEIGHBORHOOD_CUSTOM_FIELD_VALUE

type: entity, schedule: daily

The value of a custom field for the specified neighborhood entity.

• NEIGHBORHOOD_ID (int, mandatory)
• CUSTOM_FIELD_NAME (string, mandatory)
• CUSTOM_FIELD_VALUE (string)

NEIGHBORHOOD_CUSTOM_FIELDS

type: view

A dynamically created data model whose columns match the custom fields configured by the client for the neighborhood table.

• NEIGHBORHOOD_ID (int, mandatory) → neighborhood
• <custom fields>

NEIGHBORHOOD_METRICS

type: entity, schedule: daily

A collection of calculated location metrics for neighborhoods, generally related to spaces and people. Only sum floors where Is Managed is true.

• NEIGHBORHOOD_ID (int, mandatory) → neighborhood
• SQUATTER_COUNT (int) - the count of people assigned to workpoints without a team
• WORKPOINT_STACKED (int, mandatory) - the sum of TEAM.STACKED_WORKPOINTS for associated teams.
• TEAM_DIRECT_WORKPOINTS (int) - Sum Spaces inside Neighborhood with a Team Metrics.Workpoint_Count
• PEOPLE_TEAM_ASSIGNMENT_CAPACITY (decimal) - Sum Teams in Neighborhoods People_Assignment_Capacity
• ASSIGNMENT_RATIO (decimal) - The PERSON_LOCATION_COUNT plus WORKPOINT_RETAINED_OCCUPIED_COUNT divided by the WORKPOINT_COUNT (if WORKPOINT_COUNT is zero, this metric will be null)
• WORKPOINT_COUNT (int, mandatory) - sum of child spaces WORKPOINT_COUNT. For floors without floorplans equivalent to NEIGHBORHOOD.WORKPOINTS
• WORKPOINT_FIXED_COUNT (int, mandatory) - The sum of WORKPOINT_COUNT for fixed spaces
• WORKPOINT_ALLOCATED_COUNT (int, mandatory) - minimum of (Neighborhood WORKPOINT_COUNT, sum of Teams STACKED_WORKPOINTS)
• WORKPOINT_UNALLOCATED_COUNT (int, mandatory) - workpoint_Count - workpoint_allocated_count
• WORKPOINT_FLEXIBLE_COUNT (int, mandatory) - equivalent to SPACE.WORKPOINTS if the space is flexible
• WORKPOINT_OCCUPIED (decimal, mandatory) - the sum of this metric for each team in the neighborhood plus the sum of unallocated fixed spaces occupied workpoints
• WORKPOINT_UNOCCUPIED (int, mandatory) - Total Workpoints - Occupied
• WORKPOINT_RETAINED_COUNT (int, mandatory) - the sum of WORKPOINT_COUNT over associated spaces with a retention status
• WORKPOINT_RETAINED_OCCUPIED_COUNT (int, mandatory) - the sum of WORKPOINT_COUNT over associated occupied spaces with a retention status that counts as occupied
• WORKPOINT_RETAINED_UNOCCUPIED_COUNT (int, mandatory) - the sum of WORKPOINT_COUNT over associated unoccupied spaces with a retention status that counts as unoccupied
• WORKPOINT_DIRECT_SPACE_COUNT (int) - Sum of direct spaces assigned to neighborhoods Workpoint_Count
• SEAT_COUNT (int, mandatory) - the sum of SPACE.SEATS
• ASSIGNED_PEOPLE_COUNT (int, mandatory) - the sum of ASSIGNED_PEOPLE_COUNT for associated teams and spaces
• ASSIGNED_PEOPLE_FIXED_COUNT (int, mandatory) - the sum of ASSIGNED_PEOPLE_FIXED_COUNT for associated teams and spaces
• ASSIGNED_PEOPLE_FLEXIBLE_COUNT (int, mandatory) - subtract ASSIGNED_PEOPLE_FIXED_COUNT from ASSIGNED_PEOPLE_COUNT
• ASSIGNED_KNOWN_PEOPLE_COUNT (int, mandatory) - the sum of ASSIGNED_KNOWN_PEOPLE_COUNT for associated teams
• WORKING_FROM_HOME_COUNT (int) - the count of people assigned to workpoints or teams but marked as working from home
• PEOPLE_ASSIGNMENT_CAPACITY (decimal, mandatory) - the sum of teams PEOPLE_ASSIGNMENT_CAPACITY plus the WORKPOINT_UNALLOCATED_COUNT multiplied by TARGET_ALLOCATION_RATIO
• PERSON_LOCATION_COUNT (int) - the count of people assigned to assigned location
• POLYLINED_AREA_SQ_M (decimal) - the sum of POLYLINED_AREA_SQ_M for allocated spaces
• AREA_SQ_M (decimal) - the sum of AREA_SQ_M for allocated spaces
• AREA_SQ_FT (decimal) - converted from AREA_SQ_M
• POLYLINED_AREA_SQ_FT (decimal) - converted from POLYLINED_AREA_SQ_M
• AREA_ALLOCATABLE_SQ_M (decimal) - the sum of AREA_ALLOCATABLE_SQ_M for associated spaces
• DIRECT_ALLOCATABLE_SQ_M (decimal) - the sum of DIRECT_ALLOCATABLE_SQ_M for associated spaces that have no team allocation
• DIRECT_ALLOCATABLE_SQ_FT (decimal) - the sum of DIRECT_ALLOCATABLE_SQ_FT for associated spaces that have no team allocation
• AREA_ALLOCATABLE_SQ_FT (decimal) - converted from AREA_ALLOCATABLE_SQ_M
• AREA_ALLOCATED_SQ_M (decimal) - the sum AREA_SQ_M multiplied by the ratio of ALLOCATED_WORKPOINT_COUNT to WORKPOINT_COUNT
• AREA_ALLOCATED_SQ_FT (decimal) - converted from AREA_ALLOCATED_SQ_M
• GROSS_AREA_SQ_M (decimal) - deprecated
• GROSS_AREA_SQ_FT (decimal) - deprecated
• BOOKABLE_DESK_COUNT (int)
• NON_BOOKABLE_DESK_COUNT (int)
• BOOKABLE_SPACE_COUNT (int)
• NON_BOOKABLE_SPACE_COUNT (int)
• BOOKABLE_ROOM_COUNT (int) - The sum of spaces Bookable_Room_Count
• NON_BOOKABLE_ROOM_COUNT (int) - The sum of spaces Non_Bookable_Room_Count
• LOCATION_ID (int, mandatory) → location

SPACE

type: entity, schedule: daily

A specific place where people work, such as desk, table, meeting room or office.

• SPACE_ID (int, mandatory)
• LOCATION_ID (int, mandatory) → location
• REGION_ID (int) → region
• BUILDING_ID (int, mandatory) → building
• FLOOR_ID (int, mandatory) → floor
• ZONE_ID (int) → zone
• VILLAGE_ID (int) → village
• NEIGHBORHOOD_ID (int) → neighborhood
• TEAM_ALLOCATION_ID (int) → team allocation
• ORG_UNIT_ID (int) → org unit
• SPACE_NAME (string)
• SPACE_CODE (string)
• SPACE_TYPE_ID (int) → space type
• RETENTION_STATUS (string) - A status indicating that the space is in use or reserved without have a directly allocated occupant. Join to the retention_status table to determine if this retention status indicates that the space should be considered occupied.
• IS_ALLOCATABLE (bool) - Indicates whether this space can be allocated to a team or neighborhood.
• IS_FLEXIBLE (bool)
• IS_SHOWN_IN_WAYFINDING (bool) - DeprecatedIndicates if the space is visible in Wayfinding or Locator
• IS_BOOKABLE (bool) - Indicates that the space can be booked in an appropriate reservation systemApplies to both Locator and Engage.
• BOOKING_RULE (string) - Details which teams are able to book this space in Engage.
• CHARGE_RULE (string) - One of 'Rentable Exclusions', 'Dedicated Allocation', 'Floor Common All', 'Building Common All', 'Shared Allocation', 'Sublease', 'Base Building', 'Campus Common All', 'Campus Common Internal', 'Floor Common Internal' or 'Building Common Internal'.Describes how the costs for this space are distributed to teams in recharge calculations.
• PHONE_NUMBER (string)
• EMAIL (string)
• COMMENTS (string)
• VALIDATION_COMMENTS (string) - Comments entered by validators or administrators during the space validation process.
• WAYFINDING_COMMENTS (string)
• LAST_VALIDATED_DATE (date) - The most recent date this space was validated.
• OCCUPANCY_CONFIGURATION (string) - Indicates how many, if any, people can be assigned to this space.
• WORKPLACE_NOTES (string) - Notes from the Workplace Module.
• WORKPOINTS (int, mandatory) - The number of workstations in the space that people can work at.
• SEATS (int, mandatory) - The number of chairs in a meeting room, auditorium or similar.
• IS_OCCUPIED (bool, mandatory) - True if a person is assigned to the space OR a valid retention reason is in place
• POLYLINED_AREA_SQ_M (decimal) - The actual area of the space on the floorplan
• POLYLINED_AREA_SQ_FT (decimal) - The actual area of the space on the floorplan
• MEASURED_AREA_SQ_M (decimal) - The actual area of the space on the floorplan
• HAS_SENSOR (bool) - indicated if a space has a sensor
• RETENTION_STATUS_COMMENT (string) - When a retention status is added to a space, a comment can be added alongside it
• RETENTION_STATUS_DATE (datetime)
• RESERVABLE_FROM (date)
• RESERVABLE_TO (date)

SPACE_CUSTOM_FIELD_VALUE

type: entity, schedule: daily

The value of a custom field for the specified space entity.

• SPACE_ID (int, mandatory)
• CUSTOM_FIELD_NAME (string, mandatory)
• CUSTOM_FIELD_VALUE (string)

SPACE_CUSTOM_FIELDS

type: view

A dynamically created data model whose columns match the custom fields configured by the client for the space table.

• SPACE_ID (int, mandatory) → space
• <custom fields>

SPACE_METRICS

type: entity, schedule: daily

A collection of calculated location metrics for spaces, generally related to spaces and people. Only sum floors where Is Managed is true.

• SPACE_ID (int, mandatory) → space
• SQUATTER_COUNT (int) - the count of people assigned to workpoints without a team
• WORKPOINT_OCCUPIED_FIXED_SPACES (int) - the count of workpoints from fixed spaces
• ASSIGNMENT_RATIO (decimal) - The PERSON_LOCATION_COUNT plus WORKPOINT_RETAINED_OCCUPIED_COUNT divided by the WORKPOINT_COUNT (if WORKPOINT_COUNT is zero, this metric will be null)
• WORKPOINT_COUNT (int, mandatory) - equivalent to SPACE.WORKPOINTS
• WORKPOINT_FIXED_COUNT (int, mandatory) - equivalent to SPACE.WORKPOINTS if the space is fixed
• WORKPOINT_ALLOCATED_COUNT (int, mandatory) - equivalent to SPACE.WORKPOINTS if the space is allocated (has a team/org unit)
• WORKPOINT_UNALLOCATED_COUNT (int, mandatory) - workpoint_Count - workpoint_allocated_count
• WORKPOINT_FLEXIBLE_COUNT (int, mandatory) - equivalent to SPACE.WORKPOINTS if the space is flexible
• WORKPOINT_OCCUPIED (decimal, mandatory) - for fixed spaces, the minimum of assigned people and workpoint_count. If there is a retention status that counts as occupied, equivalent to workpoint_count
• WORKPOINT_UNOCCUPIED (int, mandatory) - Total Workpoints - Occupied
• WORKPOINT_RETAINED_COUNT (int, mandatory) - the sum of WORKPOINT_COUNT over associated spaces with a retention status
• WORKPOINT_RETAINED_OCCUPIED_COUNT (int, mandatory) - the sum of WORKPOINT_COUNT over associated occupied spaces with a retention status that counts as occupied
• WORKPOINT_RETAINED_UNOCCUPIED_COUNT (int, mandatory) - the sum of WORKPOINT_COUNT over associated unoccupied spaces with a retention status that counts as unoccupied
• WORKPOINT_DIRECT_SPACE_COUNT (int) - Sum of direct spaces assigned to neighborhoods Workpoint_Count
• SEAT_COUNT (int, mandatory) - the sum of SPACE.SEATS
• ASSIGNED_PEOPLE_COUNT (int, mandatory) - the count of people assigned to this space.
• ASSIGNED_PEOPLE_FIXED_COUNT (int, mandatory) - equivalent to ASSIGNED_PEOPLE_COUNT
• ASSIGNED_PEOPLE_FLEXIBLE_COUNT (int, mandatory) - subtract ASSIGNED_PEOPLE_FIXED_COUNT from ASSIGNED_PEOPLE_COUNT
• ASSIGNED_KNOWN_PEOPLE_COUNT (int, mandatory) - the count of known people assigned to this space (excludes unknown persons and retained spaces).
• WORKING_FROM_HOME_COUNT (int) - the count of people assigned to workpoints or teams but marked as working from home
• PEOPLE_ASSIGNMENT_CAPACITY (decimal, mandatory) - equivalent to WORKPOINT_COUNT
• PERSON_LOCATION_COUNT (int) - the count of people assigned to assigned location
• POLYLINED_AREA_SQ_M (decimal) - the area in m^2^ of the polygon defined in SHAPE.POLYGON_JSON for this space
• AREA_SQ_M (decimal) - the area in m^2^ of the polygon defined in SHAPE.POLYGON_JSON for this space
• AREA_SQ_FT (decimal) - converted from AREA_SQ_M
• POLYLINED_AREA_SQ_FT (decimal) - converted from POLYLINED_AREA_SQ_M
• AREA_ALLOCATABLE_SQ_M (decimal) - equivalent to AREA_SQ_M when SPACE.IS_ALLOCATABLE is true, zero otherwise
• DIRECT_ALLOCATABLE_SQ_M (decimal) - if charge rule is Dedicated Allocated then equivalent to POLYLINED_AREA_SQ_M otherwise 0
• DIRECT_ALLOCATABLE_SQ_FT (decimal) - if charge rule is Dedicated Allocated then equivalent to POLYLINED_AREA_SQ_FT otherwise 0
• AREA_ALLOCATABLE_SQ_FT (decimal) - converted from AREA_ALLOCATABLE_SQ_M
• AREA_ALLOCATED_SQ_M (decimal) - multiply AREA_SQ_M by the proportion of this space that is allocated to a team. This is typically 0% or 100% unless partial allocations are defined.
• AREA_ALLOCATED_SQ_FT (decimal) - converted from AREA_ALLOCATED_SQ_M
• GROSS_AREA_SQ_M (decimal) - deprecated
• GROSS_AREA_SQ_FT (decimal) - deprecated
• BOOKABLE_DESK_COUNT (int)
• NON_BOOKABLE_DESK_COUNT (int)
• BOOKABLE_SPACE_COUNT (int)
• NON_BOOKABLE_SPACE_COUNT (int)
• BOOKABLE_ROOM_COUNT (int) - if Space is bookable and Seats > 0, then 1 else 0
• NON_BOOKABLE_ROOM_COUNT (int) - if Space is not bookable and Seats > 0, then 1 else 0
• SUBLETTABLE_SQ_M (decimal, mandatory) - if charge rule is Sublease then equivalent to POLYLINED_AREA_SQ_M otherwise 0
• SUBLETTABLE_SQ_FT (decimal, mandatory) - if charge rule is Sublease then equivalent to POLYLINED_AREA_SQ_M otherwise 0
• SUBLEASED_SQ_M (decimal, mandatory) - if charge rule is Sublease and there is a team allocation then equivalent to POLYLINED_AREA_SQ_M otherwise 0
• SUBLEASED_SQ_FT (decimal, mandatory) - if charge rule is Sublease and there is a team allocation then equivalent to POLYLINED_AREA_SQ_M otherwise 0
• RENTABLE_EXCLUSION_SQ_M (decimal, mandatory) - if charge rule is Rentable Exclusion then equivalent to POLYLINED_AREA_SQ_M otherwise 0
• RENTABLE_EXCLUSION_SQ_FT (decimal, mandatory) - if charge rule is Rentable Exclusion then equivalent to POLYLINED_AREA_SQ_FT otherwise 0
• BASE_BUILDING_SQ_M (decimal, mandatory) - if charge rule is Base Building then equivalent to POLYLINED_AREA_SQ_M otherwise 0
• BASE_BUILDING_SQ_FT (decimal, mandatory) - if charge rule is Base Building then equivalent to POLYLINED_AREA_SQ_FT otherwise 0
• LOCATION_ID (int, mandatory) → location

SPACE_TYPE

type: entity, schedule: daily

A hierarchical classification system of spaces.

• SPACE_TYPE_ID (int, mandatory)
• PARENT_SPACE_TYPE_ID (int) → space type
• SPACE_TYPE_NAME (string, mandatory)
• HIERARCHY_LEVEL (int, mandatory)
• SEQUENCE (int)
• COLOR (string)
• SPACE_CLASSIFICATION (string) - The classification for this space type. Typically part of a space standard such as BOMA, OSCRE or IFMA
• FUNCTION_NAME (string) - The function for this space type
• DEFAULT_CHARGE_RULE (string) - The default charge rule for this space type
• DEFAULT_OCCUPANCY_CONFIGURATION (string) - The default occupancy configuration for this space type
• DEFAULT_IS_RESERVING_DISABLED (bool) - The default setting for allowing reservations for this space type
• CAN_HAVE_SEATS (bool) - True if this space type can have Seats
• CAN_HAVE_WORKPOINTS (bool) - True if this space type can have Workpoints
• CAN_HAVE_STORAGE (bool) - True if this space type can have Storage
• SHOW_IN_WIREUP (bool) - True if this space type will appear in the wireu-up module
• IS_POINT (bool) - True if this space type’s shape will appear as a point on the floorplan. False if it will appear as a polygon
• STYLIZED_FLOORPLAN_RENDERER (string) - How spaces of this space type are displayed within the Engage application

SPACE_TYPE_CUSTOM_FIELD_VALUE

type: entity, schedule: daily

The value of a custom field for the specified space type entity.

• SPACE_TYPE_ID (int, mandatory)
• CUSTOM_FIELD_NAME (string, mandatory)
• CUSTOM_FIELD_VALUE (string)

SPACE_TYPE_CUSTOM_FIELDS

type: view

A dynamically created data model whose columns match the custom fields configured by the client for the space type table.

• SPACE_TYPE_ID (int, mandatory) → space type
• <custom fields>

SPACE_TYPE_ANCESTOR

type: entity, schedule: daily

A utility table that allows you to join to the space type ancestor at any level.

• SPACE_TYPE_ID (int, mandatory) → space type
• ANCESTOR_LEVEL (smallint, mandatory)
• ANCESTOR_SPACE_TYPE_ID (int, mandatory) → space type

SPACE_ATTRIBUTES

type: entity, schedule: daily

• SPACE_ID (int, mandatory) → space
• ATTRIBUTE (string, mandatory)

NEIGHBORHOOD_TEAM_PORTIONS

type: entity, schedule: daily

• TEAM_LOCATION_ID (int, mandatory) → location
• TEAM_ALLOCATION_ID (int) → location
• NEIGHBORHOOD_ID (int) → neighborhood
• ORG_UNIT_ID (int, mandatory) → org unit
• SQUATTER_COUNT_PORTION (decimal big) - the count of people assigned to unallocated workpoints - i.e. without a team
• WORKPOINT_COUNT_PORTION (decimal big, mandatory) - portion decimals - value between 0 and 1
• WORKPOINT_FIXED_COUNT_PORTION (decimal big, mandatory) - portion decimals - value between 0 and 1
• WORKPOINT_FLEXIBLE_COUNT_PORTION (decimal big, mandatory) - portion decimals - value between 0 and 1
• WORKPOINT_ALLOCATED_COUNT_PORTION (decimal big, mandatory) - portion decimals - value between 0 and 1
• WORKPOINT_UNALLOCATED_COUNT_PORTION (decimal big, mandatory) - portion decimals - value between 0 and 1
• WORKPOINT_OCCUPIED_COUNT_PORTION (decimal big, mandatory) - portion decimals - value between 0 and 1
• WORKPOINT_UNOCCUPIED_COUNT_PORTION (decimal big, mandatory) - portion decimals - value between 0 and 1
• WORKPOINT_RETAINED_COUNT_PORTION (decimal big, mandatory) - portion decimals - value between 0 and 1
• WORKPOINT_RETAINED_OCCUPIED_COUNT_PORTION (decimal big, mandatory) - portion decimals - value between 0 and 1
• WORKPOINT_RETAINED_UNOCCUPIED_COUNT_PORTION (decimal big, mandatory) - portion decimals - value between 0 and 1
• SEAT_COUNT_PORTION (decimal big, mandatory) - portion decimals - value between 0 and 1
• PEOPLE_ASSIGNMENT_CAPACITY_PORTION (decimal big, mandatory) - portion decimals - value between 0 and 1
• PERSON_LOCATION_COUNT_PORTION (decimal big) - portion decimals - value between 0 and 1
• POLYLINED_AREA_SQ_M_PORTION (decimal big) - portion decimals - value between 0 and 1
• POLYLINED_AREA_SQ_FT_PORTION (decimal big) - portion decimals - value between 0 and 1
• POLYLINED_AREA_ALLOCATABLE_SQ_M_PORTION (decimal big) - portion decimals - value between 0 and 1
• POLYLINED_AREA_ALLOCATABLE_SQ_FT_PORTION (decimal big) - portion decimals - value between 0 and 1
• POLYLINED_AREA_ALLOCATED_SQ_M_PORTION (decimal big) - portion decimals - value between 0 and 1
• POLYLINED_AREA_ALLOCATED_SQ_FT_PORTION (decimal big) - portion decimals - value between 0 and 1
• GROSS_AREA_SQ_M_PORTION (decimal big) - portion decimals - value between 0 and 1
• GROSS_AREA_SQ_FT_PORTION (decimal big) - portion decimals - value between 0 and 1
• BOOKABLE_DESK_COUNT_PORTION (int) - portion decimals - value between 0 and 1
• NON_BOOKABLE_DESK_COUNT_PORTION (int) - portion decimals - value between 0 and 1
• BOOKABLE_SPACE_COUNT_PORTION (int) - portion decimals - value between 0 and 1
• NON_BOOKABLE_SPACE_COUNT_PORTION (int) - portion decimals - value between 0 and 1
• REMAINING_SQ_M_PORTION_PORTION (decimal big, mandatory) - portion decimals - value between 0 and 1
• REMAINING_SQ_FT_PORTION (decimal big, mandatory) - portion decimals - value between 0 and 1
• RENTABLE_EXCLUSION_SQ_M_PORTION (decimal big, mandatory) - portion decimals - value between 0 and 1
• RENTABLE_EXCLUSION_SQ_FT_PORTION (decimal big, mandatory) - converted from RENTABLE_EXCLUSION_SQ_M
• BASE_BUILDING_SQ_M_PORTION (decimal big, mandatory) - portion decimals - value between 0 and 1
• BASE_BUILDING_SQ_FT_PORTION (decimal big, mandatory) - portion decimals - value between 0 and 1
• BOOKABLE_ROOM_COUNT_PORTION (int) - portion decimals - value between 0 and 1
• NON_BOOKABLE_ROOM_COUNT_PORTION (int) - portion decimals - value between 0 and 1

BASELINE_METRICS

type: entity, schedule: daily

A collection of calculated location metrics for baselines, generally related to spaces and people. Only sum floors where Is Managed is true.

• LOCATION_ID (int, mandatory) → location
• NEIGHBORHOOD_ID (int) → neighborhood
• NEIGHBORHOOD_LOCATION_ID (int) → location
• TEAM_ALLOCATION_LOCATION_ID (int) → location
• TEAM_ALLOCATION_ID (int) → location
• ORG_UNIT_ID (int) → org unit
• LOCATION_TYPE (string)
• TEAM_WORKPOINTS (decimal)
• NEIGHBORHOOD_METRICS_WORKPOINT_COUNT (decimal)
• UNALLOCATED_PEOPLE_ASSIGNMENT_CAPACITY (decimal)
• WORKPOINT_DIRECT_SPACE_COUNT (decimal) - Sum of direct spaces assigned to neighborhoods Workpoint_Count
• TEAM_DIRECT_WORKPOINTS (decimal) - Sum Spaces inside Neighborhood with a Team Metrics.Workpoint_Count
• SQUATTER_COUNT (decimal) - the count of people assigned to unallocated workpoints - i.e. without a team
• WORKPOINT_COUNT (decimal, mandatory) - equivalent to WORKPOINTS against spaces that are allocatable. For floors with no floorplans, based on the WORKPOINTS field against teams, neighborhoods, zones and floors
• WORKPOINT_FIXED_COUNT (decimal, mandatory) - equivalent to WORKPOINT_COUNT against spaces that are fixed. For floors with no floorplans, based on the WORKPOINTS field against fixed teams, as well as the unallocated portion of WORKPOINTS for zones and floors.
• WORKPOINT_FLEXIBLE_COUNT (decimal, mandatory) - equivalent to WORKPOINT_COUNT against spaces that are flexible. For floors with no floorplans, based on WORKPOINTS field against flexible teams, as well as the unallocated portion of WORKPOINTS for neighborhoods.
• WORKPOINT_ALLOCATED_COUNT (decimal, mandatory) - equivalent to WORKPOINT_COUNT against spaces that are allocated (i.e. have a team). For floors with no floorplan, equivalent to the WORKPOINTS field against teams.
• WORKPOINT_UNALLOCATED_COUNT (decimal, mandatory) - the sum of WORKPOINT_COUNT against spaces that are unallocated (i.e. without a team). For floors with no floorplan, equivalent to the unallocated portion of WORKPOINTS within Neighborhoods, Zones and Floors.
• WORKPOINT_OCCUPIED (decimal, mandatory) - for fixed spaces, equivalent to space Occupied Workpoints. For flexible spaces that are allocated it uses the teams flexible occupied (team minimum of People and Flexible Workpoints) and is then portioned to desks. For floors with no floorplan, always the minimum of each teams People and Workpoints.
• WORKPOINT_UNOCCUPIED (decimal, mandatory) - WORKPOINT_COUNT - WORKPOINT_OCCUPIED
• WORKPOINT_RETAINED_COUNT (decimal, mandatory) - equivalent to spaces WORKPOINT_RETAINED_COUNT.
• WORKPOINT_RETAINED_OCCUPIED_COUNT (decimal, mandatory) - equivalent to spaces WORKPOINT_RETAINED_OCCUPIED_COUNT.
• WORKPOINT_RETAINED_UNOCCUPIED_COUNT (decimal, mandatory) - equivalent to spaces WORKPOINT_RETAINED_UNOCCUPIED_COUNT.
• SEAT_COUNT (decimal, mandatory) - equivalent to spaces SEAT_COUNT.
• PEOPLE_ASSIGNMENT_CAPACITY (decimal, mandatory) - for fixed spaces, equivalent to WORKPOINT_COUNT. For flexible spaces, gets a portion of the assignment capacity of the team or neighborhood. For floors with no floorplan, equivalent to team PEOPLE_ASSIGNMENT_CAPACITY plus leftover neighborhood, zone and floor PEOPLE_ASSIGNMENT_CAPACITY.
• PERSON_LOCATION_COUNT (decimal) - for fixed spaces, the equivalent to PERSON_LOCATION_COUNT plus leftover team PERSON_LOCATION_COUNT when the team is fixed or has no flexible spaces. For flexible spaces, people are portioned out from the team or neighborhood.
• POLYLINED_AREA_SQ_M (decimal) - equivalent to spaces POLYLINED_AREA_SQ_M
• POLYLINED_AREA_SQ_FT (decimal) - converted from POLYLINED_AREA_SQ_M
• POLYLINED_AREA_ALLOCATABLE_SQ_M (decimal) - equivalent to spaces POLYLINED_AREA_ALLOCATABLE_SQ_M
• POLYLINED_AREA_ALLOCATABLE_SQ_FT (decimal) - converted from POLYLINED_AREA_ALLOCATABLE_SQ_M
• POLYLINED_AREA_ALLOCATED_SQ_M (decimal) - the sum of POLYLINED_AREA_SQ_M for associated allocated spaces
• POLYLINED_AREA_ALLOCATED_SQ_FT (decimal) - converted from POLYLINED_AREA_ALLOCATED_SQ_M
• GROSS_AREA_SQ_M (decimal) - equivalent to floor GROSS_AREA_SQ_M
• GROSS_AREA_SQ_FT (decimal) - converted from GROSS_AREA_SQ_M
• BOOKABLE_DESK_COUNT (int) - equivalent to spaces BOOKABLE_DESK_COUNT
• NON_BOOKABLE_DESK_COUNT (int) - equivalent to spaces NON_BOOKABLE_DESK_COUNT
• BOOKABLE_SPACE_COUNT (int) - equivalent to spaces BOOKABLE_SPACE_COUNT
• NON_BOOKABLE_SPACE_COUNT (int) - equivalent to spaces NON_BOOKABLE_SPACE_COUNT
• REMAINING_SQ_M (decimal, mandatory) - equivalent to floor REMAINING_SQ_M
• REMAINING_SQ_FT (decimal, mandatory) - converted from REMAINING_SQ_M
• RENTABLE_EXCLUSION_SQ_M (decimal, mandatory) - equivalent to spaces RENTABLE_EXCLUSION_SQ_M
• RENTABLE_EXCLUSION_SQ_FT (decimal, mandatory) - converted from RENTABLE_EXCLUSION_SQ_M
• BASE_BUILDING_SQ_M (decimal, mandatory) - equivalent to spaces BASE_BUILDING_SQ_M
• BASE_BUILDING_SQ_FT (decimal, mandatory) - converted from BASE_BUILDING_SQ_M
• BOOKABLE_ROOM_COUNT (int) - Sum of spaces Bookable_Room_Count
• NON_BOOKABLE_ROOM_COUNT (int) - Sum of spaces Non_Bookable_Room_Count

CITY

type: entity, schedule: daily

A list of US cities and their associated county and state. Purchased from https://simplemaps.com/data/us-cities and used under license.

• CITY (string, mandatory)
• COUNTY (string, mandatory)
• COUNTY_CODE (string)
• STATE (string, mandatory)
• STATE_CODE (string)

TEAM_VALIDATIONS

type: entity, schedule: daily

One row per validation per team. A team validation occurs in the Serraview Workplace module, where an administrator signs off on that teams state at a given point in time.

• TEAM_VALIDATION_ID (int, mandatory)
• CONFIRMATION_TIME (datetime)
• CONFIRMED_BY (int) → person
• CONFIRMED_WORKPOINTS (int)
• CONFIRMED_ORG_UNIT_ID (int) → org unit
• CONFIRMED_TEAM_ID (int) → team
• COMMENTS (string)

CONFIGURATION

type: entity, schedule: daily

• CONFIGURATION_ID (int, mandatory)
• CONFIGURATION (string)
• DESCRIPTION (string)
• VALUE (string)

ORG_UNIT

type: entity, schedule: daily

A hierarchy of organisational units, such as divisions, departments and business units, that teams, people and space can belong to.

• ORG_UNIT_ID (int, mandatory)
• PARENT_ORG_UNIT_ID (int) → org unit
• ORG_UNIT_NAME (string)
• ORG_UNIT_SHORT_NAME (string)
• ORG_UNIT_CODE (string)
• HIERARCHY_LEVEL (int, mandatory)
• COLOR (string) - The hex color to color this org unit and its associated teams, in the hex format 'FFFFFF'.Combines any specifically assigned colors with those generated in the VBS.

ORG_UNIT_CUSTOM_FIELD_VALUE

type: entity, schedule: daily

The value of a custom field for the specified org unit entity.

• ORG_UNIT_ID (int, mandatory)
• CUSTOM_FIELD_NAME (string, mandatory)
• CUSTOM_FIELD_VALUE (string)

ORG_UNIT_CUSTOM_FIELDS

type: view

A dynamically created data model whose columns match the custom fields configured by the client for the org unit table.

• ORG_UNIT_ID (int, mandatory) → org unit
• <custom fields>

ORG_UNIT_ANCESTOR

type: entity, schedule: daily

A utility table that allows you to join to the org unit ancestor at any level.

• ORG_UNIT_ID (int, mandatory) → org unit
• ANCESTOR_LEVEL (smallint, mandatory)
• ANCESTOR_ORG_UNIT_ID (int, mandatory) → org unit

ORG_UNIT_METRICS

type: entity, schedule: daily

A collection of calculated location metrics for org units, generally related to spaces and people. Only sum floors where Is Managed is true. These metrics are aggregated from the metrics of teams assigned to this org unit or its children.

• ORG_UNIT_ID (int, mandatory) → org unit
• WORKPOINT_STACKED (int, mandatory) - the sum of TEAM.STACKED_WORKPOINTS for associated teams.
• ASSIGNMENT_RATIO (decimal) - The PERSON_LOCATION_COUNT plus WORKPOINT_RETAINED_OCCUPIED_COUNT divided by the WORKPOINT_COUNT (if WORKPOINT_COUNT is zero, this metric will be null)
• WORKPOINT_COUNT (int, mandatory) - the sum of this metric over each team linked to this org unit (or its child org units)
• WORKPOINT_FIXED_COUNT (int, mandatory) - the sum of this metric over each team linked to this org unit (or its child org units)
• WORKPOINT_ALLOCATED_COUNT (int, mandatory) - the sum of this metric over each region in the org unit
• WORKPOINT_UNALLOCATED_COUNT (int, mandatory) - workpoint_Count - workpoint_allocated_count
• WORKPOINT_FLEXIBLE_COUNT (int, mandatory) - equivalent to SPACE.WORKPOINTS if the space is flexible
• WORKPOINT_OCCUPIED (decimal, mandatory) - the sum of this metric over each region in the org unit
• WORKPOINT_UNOCCUPIED (int, mandatory) - Total Workpoints - Occupied
• WORKPOINT_RETAINED_COUNT (int, mandatory) - the sum of WORKPOINT_COUNT over associated spaces with a retention status
• WORKPOINT_RETAINED_OCCUPIED_COUNT (int, mandatory) - the sum of WORKPOINT_COUNT over associated occupied spaces with a retention status that counts as occupied
• WORKPOINT_RETAINED_UNOCCUPIED_COUNT (int, mandatory) - the sum of WORKPOINT_COUNT over associated unoccupied spaces with a retention status that counts as unoccupied
• WORKPOINT_DIRECT_SPACE_COUNT (int) - Sum of direct spaces assigned to neighborhoods Workpoint_Count
• SEAT_COUNT (int, mandatory) - the sum of SPACE.SEATS
• ASSIGNED_PEOPLE_COUNT (int, mandatory) - the sum of ASSIGNED_PEOPLE_COUNT for associated teams and spaces
• ASSIGNED_PEOPLE_FIXED_COUNT (int, mandatory) - the sum of ASSIGNED_PEOPLE_FIXED_COUNT for associated teams
• ASSIGNED_PEOPLE_FLEXIBLE_COUNT (int, mandatory) - subtract ASSIGNED_PEOPLE_FIXED_COUNT from ASSIGNED_PEOPLE_COUNT
• ASSIGNED_KNOWN_PEOPLE_COUNT (int, mandatory) - the sum of ASSIGNED_KNOWN_PEOPLE_COUNT for associated teams
• WORKING_FROM_HOME_COUNT (int) - the count of people assigned to workpoints or teams but marked as working from home
• PEOPLE_ASSIGNMENT_CAPACITY (decimal, mandatory) - the sum of PEOPLE_ASSIGNMENT_CAPACITY for associated teams
• PERSON_LOCATION_COUNT (int) - the count of people assigned to assigned location
• POLYLINED_AREA_SQ_M (decimal) - the sum of POLYLINED_AREA_SQ_M for associated teams
• AREA_SQ_M (decimal) - the sum of AREA_SQ_M for associated teams
• AREA_SQ_FT (decimal) - converted from AREA_SQ_M
• POLYLINED_AREA_SQ_FT (decimal) - converted from POLYLINED_AREA_SQ_M
• AREA_ALLOCATABLE_SQ_M (decimal) - equivalent to AREA_SQ_M
• DIRECT_ALLOCATABLE_SQ_M (decimal) - not applicable
• DIRECT_ALLOCATABLE_SQ_FT (decimal) - not applicable
• AREA_ALLOCATABLE_SQ_FT (decimal) - converted from AREA_ALLOCATABLE_SQ_M
• AREA_ALLOCATED_SQ_M (decimal) - equivalent to AREA_SQ_M
• AREA_ALLOCATED_SQ_FT (decimal) - converted from AREA_ALLOCATED_SQ_M
• GROSS_AREA_SQ_M (decimal) - not applicable
• GROSS_AREA_SQ_FT (decimal) - not applicable
• BOOKABLE_DESK_COUNT (int)
• NON_BOOKABLE_DESK_COUNT (int)
• BOOKABLE_SPACE_COUNT (int)
• NON_BOOKABLE_SPACE_COUNT (int)
• BOOKABLE_ROOM_COUNT (int) - The sum of teams Bookable_Room_Count
• NON_BOOKABLE_ROOM_COUNT (int) - The sum of teams Non_Bookable_Room_Count

PERSON

type: entity, schedule: daily

A person who works for the organisation, both permanently and as a contractor.

• PERSON_ID (int, mandatory)
• IS_ARCHIVED (bool, mandatory) - Archived people no longer work for the organisation, but may of course be linked to existing data created when they were employees.
• ARCHIVED_DATE (date) - The Insights date that Archived people no longer work for the organisation.
• PERSON_ORG_UNIT_ID (int) → org unit - The org unit assigned to the person typically by HR.
• TEAM_ORG_UNIT_ID (int) → org unit - This org unit is inherited by the person from the team they are assigned to. If they are assigned to multiple teams, then use a space assignment over a team assignment. If there are multiple space assignments, use the most recent.
• EMPLOYEE_CODE (string)
• FIRST_NAME (string)
• ACTUAL_FIRST_NAME (string)
• LAST_NAME (string)
• FULL_NAME (string)
• EMAIL (string)
• PHONE_NUMBER (string)
• MOBILE_NUMBER (string)
• INTERNAL_MAIL_ADDRESS (string)
• JOB_TITLE (string)
• EMPLOYEE_TYPE (string)
• LOGON_NAME (string) - The internal system logon name for this person. Can be used by SVLive for the processing of utilization data
• LEVEL (int) - The level of the staff member in the management hierarchy
• HAS_CHILDREN (bool) - True if this person is the manager of any other staff
• EMPLOYEE_CATEGORY (string) - True if this person is the manager of any other staff
• OTHER_NAMES (string)
• EMPLOYMENT_START_DATE (date)
• EMPLOYMENT_END_DATE (date)
• IS_WORKING_FROM_HOME (bool)
• MANAGER_PERSON_ID (int) → person
• HIERARCHY_LEVEL (int, mandatory)
• WORK_ADDRESS (string)
• WORK_COUNTRY (string)
• WORK_CITY (string)
• WORK_POSTCODE (string)
• WORK_STATE (string)
• DATE_ADDED (date, mandatory) - The date in which this person first appeared in insights.

PERSON_CUSTOM_FIELD_VALUE

type: entity, schedule: daily

The value of a custom field for the specified person entity.

• PERSON_ID (int, mandatory)
• CUSTOM_FIELD_NAME (string, mandatory)
• CUSTOM_FIELD_VALUE (string)

PERSON_CUSTOM_FIELDS

type: view

A dynamically created data model whose columns match the custom fields configured by the client for the person table.

• PERSON_ID (int, mandatory) → person
• <custom fields>

PERSON_MANAGER_ANCESTOR

type: entity, schedule: daily

A utility table that allows you to join to the person ancestor at any level.

• PERSON_ID (int, mandatory) → person
• ANCESTOR_LEVEL (smallint, mandatory)
• ANCESTOR_MANAGER_PERSON_ID (int, mandatory) → person

TEAM

type: entity, schedule: daily

A group of people in the organisation that work together. They can be granted one or more allocations of space, potentially on different floors or in different buildings. See the team_allocation table for that information.

In Serraview all space allocated to a team must be in the same neighborhood/zone/floor, so there is a 1 to 1 relationship between a team and a team allocation.

• TEAM_ID (int, mandatory)
• ORG_UNIT_ID (int) → org unit
• TEAM_NAME (string) - The specifically assigned team name if present, otherwise the name of the linked org unit.
• IS_FLEXIBLE (bool, mandatory)
• VILLAGE_ID (int) → village
• COMMENTS (string)
• WAYFINDING_COMMENTS (string)
• TARGET_ASSIGNMENT_RATIO (decimal, mandatory)

TEAM_CUSTOM_FIELD_VALUE

type: entity, schedule: daily

The value of a custom field for the specified team entity.

• TEAM_ID (int, mandatory)
• CUSTOM_FIELD_NAME (string, mandatory)
• CUSTOM_FIELD_VALUE (string)

TEAM_CUSTOM_FIELDS

type: view

A dynamically created data model whose columns match the custom fields configured by the client for the team table.

• TEAM_ID (int, mandatory) → team
• <custom fields>

TEAM_ADMINISTRATORS

type: entity, schedule: daily

People marked as team administrators, typically for the purpose of performing validation of said teams within Serraview.

• PERSON_ID (int, mandatory) → person
• TEAM_ID (int, mandatory) → team
• ADMINISTRATOR_TYPE (string, mandatory)

TEAM_METRICS

type: entity, schedule: daily

A collection of calculated location metrics for teams, generally related to spaces and people. Only sum floors where Is Managed is true. It is possible for spaces to be partially allocated among multiple teams, including spaces with workpoints and assigned occupants. In these cases, the metrics from that space are proportianally divided between the teams - but fractions are rounded up BEFORE summing. This includes workpoint counts, people counts and measured area.

• TEAM_ID (int, mandatory) → team
• WORKPOINT_STACKED (int, mandatory) - equivalent to TEAM.WORKPOINTS.
• WORKPOINT_OCCUPIED_FIXED_SPACES (int) - the count of workpoints from fixed spaces assigned to team
• ASSIGNMENT_RATIO (decimal) - The PERSON_LOCATION_COUNT plus WORKPOINT_RETAINED_OCCUPIED_COUNT divided by the WORKPOINT_COUNT (if WORKPOINT_COUNT is zero, this metric will be null)
• WORKPOINT_COUNT (int, mandatory) - the sum of WORKPOINTS for spaces allocated to the team
• WORKPOINT_FIXED_COUNT (int, mandatory) - The sum of WORKPOINTS for fixed allocated spaces
• WORKPOINT_ALLOCATED_COUNT (int, mandatory) - sum of WORKPOINTS for spaces allocated to the team. For floors with no floorplan, equivalent to TEAM.WORKPOINTS
• WORKPOINT_UNALLOCATED_COUNT (int, mandatory) - workpoint_Count - workpoint_allocated_count
• WORKPOINT_FLEXIBLE_COUNT (int, mandatory) - equivalent to SPACE.WORKPOINTS if the space is flexible
• WORKPOINT_OCCUPIED (decimal, mandatory) - the sum of assingned fixed workpoints occupied plus the minimum of flexible people and flexible workpoints
• WORKPOINT_UNOCCUPIED (int, mandatory) - Total Workpoints - Occupied
• WORKPOINT_RETAINED_COUNT (int, mandatory) - the sum of WORKPOINT_COUNT over associated spaces with a retention status
• WORKPOINT_RETAINED_OCCUPIED_COUNT (int, mandatory) - the sum of WORKPOINT_COUNT over associated occupied spaces with a retention status that counts as occupied
• WORKPOINT_RETAINED_UNOCCUPIED_COUNT (int, mandatory) - the sum of WORKPOINT_COUNT over associated unoccupied spaces with a retention status that counts as unoccupied
• WORKPOINT_DIRECT_SPACE_COUNT (int) - Sum of direct spaces assigned to neighborhoods Workpoint_Count
• SEAT_COUNT (int, mandatory) - the sum of SPACE.SEATS
• ASSIGNED_PEOPLE_COUNT (int, mandatory) - the count of team members
• ASSIGNED_PEOPLE_FIXED_COUNT (int, mandatory) - for fixed teams, equivalent to ASSIGNED_PEOPLE_COUNT; for flexible teams, the sum of ASSIGNED_PEOPLE_FIXED_COUNT for spaces allocated to the team
• ASSIGNED_PEOPLE_FLEXIBLE_COUNT (int, mandatory) - subtract ASSIGNED_PEOPLE_FIXED_COUNT from ASSIGNED_PEOPLE_COUNT
• ASSIGNED_KNOWN_PEOPLE_COUNT (int, mandatory) - the count of known team members (excludes unknown persons)
• WORKING_FROM_HOME_COUNT (int) - the count of people assigned to workpoints or teams but marked as working from home
• PEOPLE_ASSIGNMENT_CAPACITY (decimal, mandatory) - WORKPOINT_COUNT multiplied by TEAM.target_assignment_ratio
• PERSON_LOCATION_COUNT (int) - the count of people assigned to assigned location
• POLYLINED_AREA_SQ_M (decimal) - for teams in neighborhoods, a proportion of the POLYLINED_AREA_SQ_M of that neighborhood equivalent to the team's WORKPOINT_COUNT divided by the neighborhood's WORKPOINT_COUNT. For teams without a neighborhood, the sum of the MEASURED_AREA_SQ_M of all spaces assigned to the team.
• AREA_SQ_M (decimal) - the sum of the AREA_SQ_M of all spaces allocated to the team
• AREA_SQ_FT (decimal) - converted from AREA_SQ_M
• POLYLINED_AREA_SQ_FT (decimal) - converted from POLYLINED_AREA_SQ_M
• AREA_ALLOCATABLE_SQ_M (decimal) - equivalent to AREA_SQ_M
• DIRECT_ALLOCATABLE_SQ_M (decimal) - the sum of DIRECT_ALLOCATABLE_SQ_M for associated spaces
• DIRECT_ALLOCATABLE_SQ_FT (decimal) - the sum of DIRECT_ALLOCATABLE_SQ_FT for associated spaces
• AREA_ALLOCATABLE_SQ_FT (decimal) - converted from AREA_ALLOCATABLE_SQ_M
• AREA_ALLOCATED_SQ_M (decimal) - equivalent to AREA_SQ_M
• AREA_ALLOCATED_SQ_FT (decimal) - converted from AREA_ALLOCATED_SQ_M
• GROSS_AREA_SQ_M (decimal) - deprecated
• GROSS_AREA_SQ_FT (decimal) - deprecated
• BOOKABLE_DESK_COUNT (int)
• NON_BOOKABLE_DESK_COUNT (int)
• BOOKABLE_SPACE_COUNT (int)
• NON_BOOKABLE_SPACE_COUNT (int)
• BOOKABLE_ROOM_COUNT (int) - The sum of spaces Bookable_Room_Count
• NON_BOOKABLE_ROOM_COUNT (int) - The sum of spaces Non_Bookable_Room_Count
• SUBLETTABLE_SQ_M (decimal, mandatory) - the sum of SUBLETTABLE_SQ_M for associated spaces
• SUBLETTABLE_SQ_FT (decimal, mandatory) - the sum of SUBLETTABLE_SQ_FT for associated spaces
• SUBLEASED_SQ_M (decimal, mandatory) - the sum of SUBLEASED_SQ_M for associated spaces
• SUBLEASED_SQ_FT (decimal, mandatory) - the sum of SUBLEASED_SQ_FT for associated spaces
• LOCATION_ID (int, mandatory) → location

TEAM_MEMBER

type: entity, schedule: daily

Links people to team(s) they belong to.

Includes both floating/flexible people assigned directly to a team as well as people assigned to spaces fully allocated to the team.

• TEAM_MEMBER_ID (int, mandatory)
• TEAM_ID (int, mandatory) → team
• PERSON_ID (int) → person
• IS_FLOATING (bool)

TEAM_ALLOCATION

type: entity, schedule: daily

Defines an allocation of space to a team in a neighborhood, zone or floor, as well has how many workpoints are allocated to the team.

• TEAM_ALLOCATION_ID (int, mandatory)
• LOCATION_ID (int, mandatory) → location
• REGION_ID (int) → region
• BUILDING_ID (int, mandatory) → building
• FLOOR_ID (int) → floor
• ZONE_ID (int) → zone
• NEIGHBORHOOD_ID (int) → neighborhood
• VILLAGE_ID (int) → village
• TEAM_ID (int, mandatory) → team
• WORKPOINTS (smallint, mandatory)
• COMMENTS (string)
• WAYFINDING_COMMENTS (string)

TEAM_ALLOCATION_SPACE

type: entity, schedule: daily

Defines the individual spaces that are part of an allocation.

• TEAM_ALLOCATION_ID (int, mandatory) → team allocation
• SPACE_ID (int, mandatory) → space

SPACE_PERSON_ASSIGNMENT

type: entity, schedule: daily

Links people to the fixed spaces they are assigned to.

• SPACE_PERSON_ASSIGNMENT_ID (int, mandatory)
• SPACE_ID (int, mandatory) → space
• PERSON_ID (int) → person

RETENTION_STATUS

type: entity, schedule: daily

This status is applied to traditional spaces that do not have a person assigned to them, but may be in use in another way - or there intent to utilize the space in the future.

• NAME (string, mandatory)
• DESCRIPTION (string)
• IS_OCCUPIED (bool, mandatory) - Specifies whether a space with this retention status should be considered occupied when calculating metrics.
• IS_ENABLED (bool) - True if the retention status is able to be added to spaces. False if it cannot be added to any new spaces. False does not remove it from existing spaces.

PERSON_LOCATION

type: entity, schedule: daily

All the locations that people have been assigned to, either a SPACE or TEAM ALLOCATION, as well as the associated team details (if any).

• PERSON_LOCATION_ID (int, mandatory)
• PERSON_ID (int) → person
• LOCATION_ID (int, mandatory) → location
• IS_FLEXIBLE (bool, mandatory)
• TEAM_ID (int) → team
• ORG_UNIT_ID (int) → org unit

PERSON_LOCATION_SUMMARY

type: view

A single row per person, summarizing details of the locations and teams they have been assigned to. Designed to make it easy to write reports focused on the most common scenario where each person has a single assignment.

• PERSON_ID (int, mandatory) → person
• IS_MULTIPLE_TEAMS (bool, mandatory) - True if the person is assigned to more that one teams.
• UNIQUE_TEAM_ID (int) → team - The team that the person is assigned to, if only assigned to one team.
• UNIQUE_ORG_UNIT_ID (int) → org unit - The org unit of the team that the person is assigned to, if only assigned to one team OR multiple teams with the same org unit.
• UNIQUE_LOCATION_ID (int) → location - The location that the person is assigned to, if only assigned to one location.

PERSON_BUILDING_LOCATION_SUMMARY

type: view

A single row per person per building they have at least one assignment in, summarizing details of the locations and teams they have been assigned to in that building. Designed to make it easy to write reports focused on the most common scenario where each person has a single assignment in a building. If the person does not have ANY assignment in a building, you will need to join to PERSON_LOCATION_SUMMARY to find their team/cost centre across the whole portfolio.

• PERSON_ID (int, mandatory) → person
• BUILDING_ID (int, mandatory) → building
• IS_MULTIPLE_TEAMS (bool, mandatory) - True if the person is assigned to more that one team in the building
• UNIQUE_TEAM_ID (int) → team - The team that the person is assigned to, if only assigned to one team in the building.
• UNIQUE_ORG_UNIT_ID (int) → org unit - The org unit of the team that the person is assigned to, if only assigned to one team in the building OR multiple teams with the same org unit.
• IS_RESIDENT (bool, mandatory) - True if the person is assigned to at least one location in the building.
• UNIQUE_RESIDENT_LOCATION_ID (int) → location - The location that the person is assigned to, if only assigned to one location in the building.

PERSON_FLOOR_LOCATION_SUMMARY

type: view

A single row per person per floor they have at least one assignment in, summarizing details of the locations and teams they have been assigned to in that floor. Designed to make it easy to write reports focused on the most common scenario where each person has a single assignment on a floor. If the person does not have ANY assignment on the floor, you will need to join to PERSON_BUILDING_LOCATION_SUMMARY to find their team/cost centre across the whole building.

• PERSON_ID (int, mandatory) → person
• FLOOR_ID (int, mandatory) → floor
• IS_MULTIPLE_TEAMS (bool, mandatory) - True if the person is assigned to more that one team on the floor
• UNIQUE_TEAM_ID (int) → team - The team that the person is assigned to, if only assigned to one team on the floor.
• UNIQUE_ORG_UNIT_ID (int) → org unit - The org unit of the team that the person is assigned to, if only assigned to one team on the floor OR multiple teams with the same org unit.
• IS_RESIDENT (bool, mandatory) - True if the person is assigned to at least one location on the floor.
• UNIQUE_RESIDENT_LOCATION_ID (int) → location - The location that the person is assigned to, if only assigned to one location in the building.

PERSON_SPACE_LOCATION_SUMMARY

type: view

A single row per person per space they have at least one assignment in, summarizing details of the locations and teams they have been assigned to in that space.

• PERSON_ID (int, mandatory) → person
• SPACE_ID (int, mandatory) → space
• IS_MULTIPLE_TEAMS (bool, mandatory) - True if the person is assigned to more that one team on the space
• UNIQUE_TEAM_ID (int) → team - The team that the person is assigned to, if only assigned to one team on the space.
• UNIQUE_ORG_UNIT_ID (int) → org unit - The org unit of the team that the person is assigned to, if only assigned to one team on the space OR multiple teams with the same org unit.
• IS_RESIDENT (bool, mandatory) - True if the person is assigned to at least one location on the space.
• UNIQUE_RESIDENT_LOCATION_ID (int) → location - The location that the person is assigned to, if only assigned to one location in the space.

PERSON_TEAM_LOCATION_SUMMARY

type: view

A single row per person per space they have at least one assignment in, summarizing details of the locations and teams.

• PERSON_ID (int, mandatory) → person
• TEAM_ID (int, mandatory) → team
• IS_MULTIPLE_TEAMS (bool, mandatory) - True if the person is assigned to more that one team
• UNIQUE_TEAM_ID (int) → team - The team that the person is assigned to, if only assigned to one team.
• UNIQUE_ORG_UNIT_ID (int) → org unit - The org unit of the team that the person is assigned to, if only assigned to one team on the space OR multiple teams with the same org unit.
• IS_RESIDENT (bool, mandatory) - True if the person is assigned to at least one location on the team.
• UNIQUE_RESIDENT_LOCATION_ID (int) → location - The location that the person is assigned to, if only assigned to one location in the team.

PERSON_NEIGHBORHOOD_LOCATION_SUMMARY

type: view

A single row per person per space they have at least one assignment in, summarizing details of the locations and teams they have been assigned to in that neighborhood.

• PERSON_ID (int, mandatory) → person
• NEIGHBORHOOD_ID (int, mandatory) → neighborhood
• IS_MULTIPLE_TEAMS (bool, mandatory) - True if the person is assigned to more that one team
• UNIQUE_TEAM_ID (int) → team - The team that the person is assigned to, if only assigned to one team.
• UNIQUE_ORG_UNIT_ID (int) → org unit - The org unit of the team that the person is assigned to, if only assigned to one team on the space OR multiple teams with the same org unit.
• IS_RESIDENT (bool, mandatory) - True if the person is assigned to at least one location on the team.
• UNIQUE_RESIDENT_LOCATION_ID (int) → location - The location that the person is assigned to, if only assigned to one location in the hood.

ASSET

type: entity, schedule: daily

A generic representation of something that can be owned by a person or team, and/or occupy a space. Examples include lockers, car parks, laptops, printers and sit stand desks.

• ASSET_ID (int, mandatory)
• TYPE (string, mandatory)
• NAME (string)
• NUMBER (string)
• GUID (string)
• SERIAL_NUMBER (string)
• COMMENTS (string)
• TEAM_ID (int) → team - The team that the asset has been assigned to.
• PERSON_ID (int) → person - The person that the asset has been assigned to.
• LOCATION_ID (int) → location - The physical location of the asset.
• FLOOR_ID (int)
• ZONE_ID (int)
• FUTURE_OWNER_ID (int) → person

ASSET_CUSTOM_FIELD_VALUE

type: entity, schedule: daily

The value of a custom field for the specified asset entity.

• ASSET_ID (int, mandatory)
• CUSTOM_FIELD_NAME (string, mandatory)
• CUSTOM_FIELD_VALUE (string)

ASSET_CUSTOM_FIELDS

type: view

A dynamically created data model whose columns match the custom fields configured by the client for the asset table.

• ASSET_ID (int, mandatory) → asset
• <custom fields>

SWITCH_PORT

type: entity, schedule: daily

• SWITCH_PORT_ID (int, mandatory)
• LABEL (string)
• NAME (string)
• SWITCH_ID (int) → asset

LOCATION_PORT_MAPPING

type: entity, schedule: daily

• LOCATION_PORT_MAPPING_ID (int, mandatory)
• SWITCH_PORT_ID (int) → switch port
• SPACE_ID (int) → space
• LOCATION_ID (int) → location
• NAME (string)

SVLIVE_ACTIVITY

type: time series, schedule: time series

Processed utilization data from the SV Live solution, both wifi and wired, linking a person to a location for a specified time period.

This data directly corresponds to the ContainerOccupancyIntermediate table.

• PROVIDER_NAME (string, mandatory, sync group) - One of 'Wifi', 'Wired', 'Aruba' or 'Cisco'.
• LOCATION_ID (int, mandatory) → location
• ZONE_LOCATION_ID (int, mandatory) → location - Deprecated. The zone location for the linked location. Was used to improve the performance when combining wifi and wired data.
• BUILDING_LOCATION_ID (int) → location - The building location for the linked location.
• FLOOR_LOCATION_ID (int) → location - The floor location for the linked location.
• LOCATION_PORT_MAPPING_ID (int) → location_port_mapping
• SWITCH_ID (int)
• SWITCH_PORT_ID (int) → switch port
• SWITCH_LOCATION_ID (int) → location
• SWITCH_FLOOR_ID (int) → floor
• SWITCH_ZONE_ID (int) → zone
• ZONE_ID (int) → zone
• FLOOR_ID (int) → floor
• BUILDING_ID (int) → building
• SWITCH_SPACE_ID (int) → space
• SPACE_ID (int) → space
• USER_NAME (string) - In case of kafka svlive user name having no match at Person table
• PERSON_ID (int) → person
• START_TIME (datetime, mandatory, sync)
• END_TIME (datetime, mandatory)
• STATUS (string, mandatory) - One of 'Active', 'Inactive', 'ACTIVE', 'AWAY', 'OFFLINE' or 'REMOTE'.'inactive' corresponds to 'away' in Serraview.
• RESIDENT_LOCATION_ID (int) → location - If the person has a single assigned space or allocated team on the floor of the activity, or a single assigned space or allocated team in the building of the activity, then it is linked here.
• IS_FLOOR_RESIDENT (bool) - True if the person has one or more assigned spaces or allocated teams on the floor of the activity.
• IS_BUILDING_RESIDENT (bool) - True if the person has one or more assigned spaces or allocated teams in the building of the activity.
• IS_SPACE_RESIDENT (bool) - True if the person has one or more assigned spaces or allocated teams in the space of the activity.
• IS_TEAM_RESIDENT (bool) - True if the person has one or more assigned spaces or allocated teams in the team of the activity.
• IS_NEIGHBORHOOD_RESIDENT (bool) - True if the person has one or more assigned spaces or allocated teams in the neighborhood of the activity.
• IS_REMOTE (bool) - It indicates if svlive data we get is from someone sitting at a desk, or remoting into a desk
• IS_SWITCH_BASED (bool) - True if the data provider is Wired and the location is based off of the switch. False if the data is wired and using wired-up location. Null if the data provider is not Wired

SVLIVE_ACTIVITY_ALL

type: view

A view that replicates the data in SVLIVE_ACTIVITY, but also includes a third set of data with PROVIDER_NAME of 'SV Live' that merges together the wired and wifi activity for each person and zone/floor location. The columns are identical to the SVLIVE_ACTIVITY entity.

SVLIVE_ACTIVITY_MERGED

type: view

A view over the data from SVLIVE_ACTIVITY_ALL that merges together any overlapping activity rows, ignoring the STATUS value of the row as merging that correctly is too complicated. The columns are identical to the SVLIVE_ACTIVITY entity except that the STATUS column is dropped.

SVLIVE_ACTIVITY_ACTIVE_MERGED

type: view

A view over the data from SVLIVE_ACTIVITY_ALL that merges together any overlapping activity rows with the 'active' STATUS. The columns are identical to the SVLIVE_ACTIVITY entity except that the STATUS column is dropped.

SVLIVE_ACTIVITY_BY_HOUR

type: time series, schedule: time series

A processed view over SVLIVE_ACTIVITY_MERGED and SVLIVE_ACTIVITY_ACTIVE_MERGED that replaces start and end times, instead returning a row for every hour that includes activity for a person and location, including the number of minutes they were seen and the number of minutes they were active.

• PROVIDER_NAME (string, mandatory, sync group) - One of 'Wifi', 'Wired', 'Aruba', 'Cisco', 'Combined(Zone)', 'Combined(Building)' or 'Combined(Floor)'.
• LOCATION_ID (int, mandatory) → location
• PERSON_ID (int, mandatory) → person
• LOCATION_PORT_MAPPING_ID (int) → location_port_mapping
• SWITCH_ID (int) → asset
• SWITCH_PORT_ID (int) → switch port
• START_OF_HOUR (datetime, mandatory, sync)
• MINUTES (smallint, mandatory)
• ACTIVE_MINUTES (smallint, mandatory)
• SWITCH_LOCATION_ID (int)
• RESIDENT_LOCATION_ID (int) → location
• IS_FLOOR_RESIDENT (bool)
• IS_BUILDING_RESIDENT (bool)
• IS_SPACE_RESIDENT (bool)
• IS_TEAM_RESIDENT (bool)
• IS_NEIGHBORHOOD_RESIDENT (bool)
• IS_REMOTE (bool) - It indicates if svlive data we get is from someone sitting at a desk, or remoting into a desk

SVLIVE_UTILIZATION_BY_FLOOR_ZONE_PERSON_AND_DAY

type: view

An aggregation over the 'SV Live' provider data from SVLIVE_ACTIVITY_BY_HOUR summing the time they were seen per day, in each zone/floor.

SVLIVE_UTILIZATION_BY_BUILDING_PERSON_AND_DAY

type: view

An aggregation over the 'SV Live' provider data from SVLIVE_ACTIVITY_BY_HOUR summing the time they were seen per day, in each building.

SENSOR_EVENT

type: time series, schedule: time series

Raw sensor data straight from the provider - the state of the sensor at a point in time

• PROVIDER_NAME (string, mandatory, sync group)
• LOCATION_ID (int, mandatory) → location
• TIME (datetime, mandatory, sync)
• STATUS (string, mandatory)
• SENSOR_CODE (string)
• PERSON_COUNT (int)
• FLOOR_X (decimal)
• FLOOR_Y (decimal)
• SPACE_CODE (string)
• BUILDING_NAME (string)
• FLOOR_NAME (string)
• SPACE_ID (int) → space

SVLIVE_EVENT

type: time series, schedule: time series

Raw svlive event data straight from the provider - the state of the sensor at a point in time

• PROVIDER_NAME (string, mandatory, sync group)
• LOCATION_ID (int, mandatory) → location
• TIME (datetime, mandatory, sync)
• STATUS (string, mandatory) - One of 'ACTIVE', 'AWAY', 'REMOTE' or 'OFFLINE'.
• SENSOR_CODE (string)
• PERSON_COUNT (int)
• X_COORDINATE (decimal)
• Y_COORDINATE (decimal)
• RADIUS (decimal)
• USER_NAME (string)
• ASSET_ID (int) → asset - Kafka published switch id
• EVENT_SOURCE (string)
• FLOOR_ID (int) → floor
• FLOOR_NAME (string)
• BUILDING_ID (int) → building
• BUILDING_NAME (string)
• DEVICE_NAME (string)
• ASSET_NAME (string) - Kafka published switch name
• SWITCH_LOCATION_ID (int) → location
• SWITCH_FLOOR_ID (int) → floor
• SWITCH_ZONE_ID (int) → zone
• PERSON_ID (int) → person
• ZONE_LOCATION_ID (int) → location
• BUILDING_LOCATION_ID (int) → location
• FLOOR_LOCATION_ID (int) → location
• SWITCH_PORT_NAME (string) - Kafka published the name of the switch port
• IS_SWITCH_BASED (bool) - True if the data provider is Wired and the location is based off of the switch. False if the data is wired and using wired-up location. Null if the data provider is not Wired

SENSOR_ACTIVITY

type: time series, schedule: time series

Utilization data from various sensor providers.

• PROVIDER_NAME (string, mandatory, sync group)
• LOCATION_ID (int, mandatory) → location
• START_TIME (datetime, mandatory, sync)
• END_TIME (datetime, mandatory)
• SENSOR_CODE (string)
• PERSON_COUNT (int)
• SPACE_ID (int) → space
• ZONE_ID (int) → zone
• FLOOR_ID (int) → floor

SENSOR_OFFLINE

type: time series, schedule: time series

Timespans when the various sensor are in offline state.

• PROVIDER_NAME (string, mandatory, sync group)
• LOCATION_ID (int, mandatory) → location
• START_TIME (datetime, mandatory, sync)
• END_TIME (datetime, mandatory)
• SENSOR_CODE (string)
• PERSON_COUNT (int)

SENSOR_ACTIVITY_MERGED

type: view

A view over the data from SENSOR_ACTIVITY that merges together any overlapping activity rows. The columns are identical to the SENSOR_ACTIVITY entity.

SENSOR_OFFLINE_MERGED

type: view

A view over the data from SENSOR_OFFLINE that merges together any overlapping activity rows. The columns are identical to the SENSOR_OFFLINE entity.

SENSOR_ACTIVITY_BY_HOUR

type: time series, schedule: time series

A processed view over SENSOR_ACTIVITY_MERGED that replaces start and end times, instead returning a row for every hour that includes activity for a location, summing the number of minutes of that activity.

• PROVIDER_NAME (string, mandatory, sync group)
• LOCATION_ID (int, mandatory) → location
• START_OF_HOUR (datetime, mandatory, sync)
• MINUTES (smallint, mandatory)
• PERSON_COUNT (int)

SENSOR_OFFLINE_BY_HOUR

type: time series, schedule: time series

A processed view over SENSOR_OFFLINE_MERGED that displays number of offline minutes.

• PROVIDER_NAME (string, mandatory, sync group)
• LOCATION_ID (int, mandatory) → location
• START_OF_HOUR (datetime, mandatory, sync)
• MINUTES (smallint, mandatory)
• PERSON_COUNT (int)

BADGE_ACTIVITY

type: time series, schedule: time series

Details of when people have entered a building using a badge swipe.

For client's who write badge data to ContainerOccupancyIntermediate, the start and end time will be calculated and multiple rows can be included for the same person/building/day combination.

• BUILDING_ID (int, sync group) → building
• PERSON_ID (int) → person
• IS_VISITOR (bool, mandatory) - Indicates that the person is not a regular employee, such as a contractor or guest.In serraview this data is linked to the 'wf:visitor' employee number.
• IS_UNKNOWN (bool) - True if the person who badged in could not be identified as a known staff member or visitor.True if the person who badged in could not be identified as a known staff member or visitor.
• DATE (date, mandatory, sync)
• BADGE_CODE (string, mandatory)
• BADGE_NAME (string)
• HOURS (int)
• START_TIME (datetime)
• END_TIME (datetime)
• RESIDENT_LOCATION_ID (int) → location - If the person has a single assigned space or allocated team on the floor of the activity, or a single assigned space or allocated team in the building of the activity, then it is linked here.
• IS_BUILDING_RESIDENT (bool) - True if the person has one or more assigned spaces or allocated teams in the building of the activity.

BOOKING

type: time series, schedule: time series

A record of a space booking, including the organizer and the times of the booking.

• BOOKING_ID (int, mandatory)
• PROVIDER_NAME (string, mandatory, sync group) - One of 'Calendar', 'Engage', 'SiQ', 'EXCHANGE' or 'SiQ Calendar'.
• SUMMARY (string)
• START_TIME (datetime, mandatory, sync)
• END_TIME (datetime, mandatory)
• ORGANIZER_PERSON_ID (int) → person
• BOOKING_TIME (datetime)
• CHECK_OUT_TIME (datetime)
• CODE (string)
• ORGANIZER_EMAIL (string)
• ATTENDEE_COUNT (int)
• RESIDENT_ATTENDEE_COUNT (int)
• IS_ALL_DAY_BOOKING (bool)

BOOKING_ATTENDEE

type: time series, schedule: time series

The known details of people invited to a booking, including their response if known. Includes the organizer

• BOOKING_ATTENDEE_ID (int, mandatory)
• BOOKING_ID (int, mandatory, sync) → booking
• PERSON_ID (int) → person
• SPACE_ID (int) → space
• NAME (string)
• EMAIL (string)
• CODE (string)
• RESPONSE (string) - One of 'needsAction', 'declined', 'tentative', 'accepted' or 'unknown'.The attendee's response (if any) to the booking invitation.

BOOKING_SPACE

type: time series, schedule: time series

The space or spaces included in a booking. Note that virtual meetings including people from different geographical locations often include multiple rooms.

• BOOKING_ID (int, mandatory, sync) → booking
• SPACE_ID (int, mandatory) → space
• CODE (string)
• SPACE_EMAIL (string)

BOOKING_CHECKIN

type: time series, schedule: time series

A record of the time that a person attended the booking.

• BOOKING_ID (int, mandatory) → booking
• PERSON_ID (int, mandatory) → person
• CHECKIN_TIME (datetime, mandatory, sync)

BOOKING_BY_HOUR

type: time series, schedule: time series

A processed view over past booking data that replaces start and end times, instead returning a row for every hour that includes activity for a person and space, including the number of minutes the space was booked for.

• PROVIDER_NAME (string, mandatory, sync group) - One of 'Calendar', 'Engage', 'SiQ' or 'EXCHANGE'.
• SPACE_ID (int, mandatory) → location
• ORGANIZER_PERSON_ID (int) → person
• START_OF_HOUR (datetime, mandatory, sync)
• MINUTES (smallint, mandatory)
• HAS_CHECKIN (bool, mandatory)

FUTURE_BOOKING

type: time series entity, schedule: daily

Bookings made for future times. These will be deleted once they are in the past, to reappear in the booking time series if they were not cancelled beforehand. You can of course access older future booking data in the associated history table.

• FUTURE_BOOKING_ID (int, mandatory)
• PROVIDER_NAME (string, mandatory) - One of 'Calendar', 'Engage', 'SiQ' or 'EXCHANGE'.
• SUMMARY (string)
• START_TIME (datetime, mandatory)
• END_TIME (datetime, mandatory)
• ORGANIZER_PERSON_ID (int) → person
• BOOKING_TIME (datetime)
• CHECK_OUT_TIME (datetime)
• CODE (string)
• ORGANIZER_EMAIL (string)
• ATTENDEE_COUNT (int)
• RESIDENT_ATTENDEE_COUNT (int)
• IS_ALL_DAY_BOOKING (bool)
• ONGOING (bool)

FUTURE_BOOKING_ATTENDEE

type: time series entity, schedule: daily

The known details of people invited to a future booking, including their response if known. Includes the organizer

• FUTURE_BOOKING_ATTENDEE_ID (int, mandatory)
• FUTURE_BOOKING_ID (int, mandatory) → future booking
• PERSON_ID (int) → person
• SPACE_ID (int) → space
• NAME (string)
• EMAIL (string)
• CODE (string)
• RESPONSE (string) - One of 'needs action', 'declined', 'tentative' or 'accepted'.The attendee's response (if any) to the booking invitation.

FUTURE_BOOKING_SPACE

type: time series entity, schedule: daily

The space or spaces included in a future booking. Note that virtual meetings including people from different geographical locations often include multiple rooms.

• FUTURE_BOOKING_ID (int, mandatory) → future booking
• SPACE_ID (int, mandatory) → space
• CODE (string)
• SPACE_EMAIL (string)

CANCELLED_BOOKING

type: time series, schedule: time series

Bookings that were cancelled before the time of the booking.

• CANCELLED_BOOKING_ID (int, mandatory)
• PROVIDER_NAME (string, mandatory, sync group) - One of 'Calendar', 'Engage' or 'EXCHANGE'.
• SUMMARY (string)
• START_TIME (datetime, mandatory)
• END_TIME (datetime, mandatory)
• CANCELLED_TIME (datetime, mandatory, sync)
• BOOKING_TIME (datetime)
• ORGANIZER_PERSON_ID (int) → person
• CODE (string)
• ORGANIZER_EMAIL (string)
• ATTENDEE_COUNT (int)
• RESIDENT_ATTENDEE_COUNT (int)
• IS_ALL_DAY_BOOKING (bool)

CANCELLED_BOOKING_ATTENDEE

type: time series, schedule: time series

The known details of people invited to a cancelled booking, including their response if known. Includes the organizer

• CANCELLED_BOOKING_ATTENDEE_ID (int, mandatory)
• CANCELLED_BOOKING_ID (int, mandatory, sync) → cancelled booking
• PERSON_ID (int) → person
• SPACE_ID (int) → space
• NAME (string)
• EMAIL (string)
• CODE (string)
• RESPONSE (string) - One of 'needs action', 'declined', 'tentative' or 'accepted'.The attendee's response (if any) to the booking invitation.

CANCELLED_BOOKING_SPACE

type: time series, schedule: time series

The space or spaces included in a cancelled booking. Note that virtual meetings including people from different geographical locations often include multiple rooms.

• CANCELLED_BOOKING_ID (int, mandatory, sync) → cancelled booking
• SPACE_ID (int, mandatory) → space
• CODE (string)
• SPACE_EMAIL (string)

DAY

type: time series, schedule: time series

Utility table with a row for every day since January 1st 2010 until today.

• DATE (date, mandatory, sync)
• END_DATE (date)
• DAY_OF_WEEK (string)
• DAY_OF_MONTH (int)
• MONTH (int)
• YEAR (int)

MONTH

type: view

Utility table with a row for every month since January 1st 2010.

• START_DATE (date, mandatory, sync)
• END_DATE (date)
• MONTH (int)
• YEAR (int)
• DAYS (int)
• BUSINESS_DAYS (int)

CUSTOM_FIELD_TYPE

type: entity, schedule: daily

Details on the schema of each custom field imported into Insights.

• TABLE_NAME (string, mandatory) - the Insights entity that the custom field is linked to via primary key
• GROUP_NAME (string) - the custom field group that this field belongs to; typically 'Standard'. Engage survey questions will have a value of 'Engage Survey'.
• CUSTOM_FIELD_NAME (string, mandatory) - the column name of the custom field in the *_CUSTOM_FIELDS view
• LABEL (string, mandatory) - an optional user-friendly version of the custom field name
• TYPE (string, mandatory) - One of 'BOOLEAN', 'INT', 'NUMBER(38,4)', 'DATETIME' or 'STRING'.
• DEFAULT_VALUE (string) - the value returned by the *_CUSTOM_FIELDS view if there is no value specified for this custom field on a specific entity
• VALUE_TABLE (string) - The Value Table relates to the type of the entity used for the value (eg. Person, Org Unit, Reference Value)
• SPLITTABLE (bool) - ETL internal usage: implement multi-select entities case

FLOORPLAN

type: entity, schedule: daily

A link to the image URL for the floorplan images of each floor.

• FLOOR_ID (int, mandatory)
• IMAGE_PATH (string) - A URL to the hosted floorplan image at full resolution.This URL will only work when the user is logged in to Serraview in the same browser session.
• RAW_IMAGE_PATH (string) - Internal usage
• WIDTH (string, mandatory) - The width of the floorplan image in pixels.
• HEIGHT (string, mandatory) - The height of the floorplan image in pixels.
• SCALE (decimal, mandatory) - The ratio of pixels in the floorplan image to metres in reality.
• DATE_ADDED (date) - The date when the floorplan was added.

SHAPE

type: entity, schedule: daily

Every entity with a shape that can be drawn on a floorplan has an associated SHAPE row, defining the polyon/point and color. A JSON format is used to store the shapes. Polygon examples: {code}[{"shape":[{"x":1907.22,"y":1569.13},{"x":2027.22,"y":1569.13},{"x":2027.22,"y":1669.45},{"x":1907.22,"y":1669.45}]}] [{"shape":[...],"holes":}] [{"shape":[...]},{"shape":[...]},{"shape":[...],"holes":[...]}]{code} Point example: {code}{"x":1967.22,"y":1719.62}{code}

• SHAPE_ID (int, mandatory)
• LOCATION_ID (int) → location
• FLOOR_ID (int, mandatory) → floor
• SHAPE_TYPE (string, mandatory)
• SHAPE_NAME (string)
• POLYGON_JSON (string) - the JSON representation of the floorplan shape for entities like rooms, zones, neighborhoods and teams
• POINT_JSON (string) - For workpoints this is the X,Y coordinate of the seat. For rooms this is NULL.
• COLOR (string) - The hex color to color this org unit and its associated teams, in the hex format 'FFFFFF'.Combines any specifically assigned colors with those generated in the VBS.
• AREA_SQ_M (decimal)

SPACE_PROXIMITY

type: entity, schedule: daily

A list of all point space pairs on the same zone/floor, that are within at least 2m of each other. The space pairs are listed twice, once in reverse order, for convenience.

• SPACE_ID (int, mandatory) → space
• PROXIMATE_SPACE_ID (int, mandatory) → space
• DISTANCE_M (decimal, mandatory)
• DISTANCE_FT (decimal, mandatory)

TENANT

type: entity, schedule: daily

• TENANT_ID (string, mandatory)
• NAME (string)
• PLATFORM (string) - One of 'Serraview', 'SiQ' or 'Archibus'.
• AWS_REGION (string)
• IS_INSIGHTS_DEPLOYED (bool)

USER

type: entity, schedule: daily

A person or service account with access to the system.

• USER_ID (int, mandatory)
• USER_NAME (string, mandatory)
• USER_TYPE (string, mandatory)
• EMAIL (string)
• PERSON_ID (int) → person
• IS_LOCKED (bool)
• LAST_ACCESS_TIME (datetime)
• IS_INTERNAL (bool)
• CREATED_DATE (date)

USER_TO_ROLE

type: entity, schedule: daily

Links each user to each role that they have been granted in Serraview.

• USER_ID (int, mandatory) → user
• ROLE_ID (int, mandatory) → role

ROLE

type: entity, schedule: daily

A list of all the available security roles in Serraview.

• ROLE_ID (int, mandatory) → role
• NAME (string, mandatory)
• DESCRIPTION (string)

ROLE_TO_PERMISSION

type: entity, schedule: daily

A list of all the secured actions linked to a Serraview role.

• ROLE_ID (int, mandatory) → user
• PERMISSION (string, mandatory)
• DESCRIPTION (string)

SERVICE_REQUEST

type: entity, schedule: daily

A request from the business for a change in space allocation, ranging from requesting a few desks to a major move or new team. See SPACE_REQUEST for the specific location and workpoint count requested.

• SERVICE_REQUEST_ID (int, mandatory)
• SERVICE_REQUEST_CODE (string) - the Service Number of the request
• SUMMARY (string)
• DETAILS (string) - Also known as Additional Instructions
• JUSTIFICATION (string)
• COMMENTS (string)
• SERVICE_REQUEST_TYPE (string, mandatory)
• CREATED_BY_ID (int) → person - The person who first created this Service Request
• ORG_UNIT_ID (int) → org unit - the org unit that the requested space should be allocated to
• CHARGE_TO_ORG_UNIT_ID (int) → org unit - Optionally, the org unit that will be paying for the move
• STATUS (string) - Indicates the progress on a service request, from ‘open’ and ‘planning’ all the way to 'closed'
• SUBMITTED_DATE (date)
• DUE_DATE (date)
• RESOLVED_DATE (date)
• CLOSED_DATE (date)
• PLANNED_DATE (date) - The proposed date for the service request to be completed by

SPACE_REQUEST

type: entity, schedule: daily

Details of a specific location and workpoint count for a service request. There may be multiple rows for a single service request.

• SPACE_REQUEST_ID (int, mandatory)
• SERVICE_REQUEST_ID (int, mandatory) → service request
• FROM_LOCATION_ID (int) → location
• FROM_LOCATION_OTHER (string)
• TO_LOCATION_ID (int) → location
• TO_LOCATION_OTHER (string)
• SPACE_REQUEST_TYPE (string)
• WORKPOINT_COUNT (int)

SERVICE_REQUEST_PERSON

type: entity, schedule: daily

Assigns one service requests to many people or one person to many s ervice requests. Each is given a relationshipTypeID that specifies what role on that service request they fulfill

• SERVICE_REQUEST_PERSON_ID (int, mandatory)
• SERVICE_REQUEST_ID (int, mandatory) → service request
• PERSON_ID (int, mandatory) → person
• RELATIONSHIP_TYPE (string, mandatory)
• COMMENTS (string)
• ONE_TIME_KEY (string)
• CREATED_AT (date)
• SEQUENCE (int)
• APPROVAL_COUNT (int) - The number of times this person approved the Service Request

SHARED_CHARGEBACK

type: entity, schedule: daily

Shared chargeback information

• SHARED_CHARGEBACK_ID (int, mandatory)
• SPACE_ID (int, mandatory) → space
• TEAM_ORG_UNIT_ID (int, mandatory) → org unit
• PERCENTAGE (decimal) - The % of area that is allocated to the teams for recharge purposes.
• WORKPOINTS (int)

ETL_LOG

type: utility

A record of each ETL run for this instance, including the time, version, mode and outcome. This table can be queried to determine the freshness of the data in Insights.

• START_TIME (datetime)
• END_TIME (datetime)
• VERSION (string)
• MODE (string)
• STATUS (string)
• SNAPSHOT_ID (int)
• SNAPSHOT_DATE (datetime)
• REPORT (string)