LOCATION_HISTORY

type: history entity, schedule: daily

A record of historical values for the location table.

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) → location
• 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)
• HISTORY_START_TIME (datetime, mandatory)
• HISTORY_END_TIME (datetime)

LOCATION_HISTORY_BY_DAY

type: view

For every day with data, this view returns the row in the location history table corresponding to midnight at the end of that day.

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.

• HISTORY_DATE (date, mandatory) → day
• LOCATION_ID (int, mandatory) → location
• 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)
• HISTORY_START_TIME (datetime, mandatory)

VILLAGE_LOCATION_HISTORY

type: history entity, schedule: daily

A record of historical values for the village location table.

• VILLAGE_LOCATION_ID (int, mandatory) → village location
• 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
• HISTORY_START_TIME (datetime, mandatory)
• HISTORY_END_TIME (datetime)

VILLAGE_LOCATION_HISTORY_BY_DAY

type: view

For every day with data, this view returns the row in the village location history table corresponding to midnight at the end of that day.

• HISTORY_DATE (date, mandatory) → day
• VILLAGE_LOCATION_ID (int, mandatory) → village location
• 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
• HISTORY_START_TIME (datetime, mandatory)

REGION_HISTORY

type: history entity, schedule: daily

A record of historical values for the region table.

• REGION_ID (int, mandatory) → region
• 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)
• HISTORY_START_TIME (datetime, mandatory)
• HISTORY_END_TIME (datetime)

REGION_HISTORY_BY_DAY

type: view

For every day with data, this view returns the row in the region history table corresponding to midnight at the end of that day.

• HISTORY_DATE (date, mandatory) → day
• REGION_ID (int, mandatory) → region
• 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)
• HISTORY_START_TIME (datetime, mandatory)

REGION_ANCESTOR_HISTORY

type: history entity, schedule: daily

A record of historical values for the region ancestor table.

• REGION_ID (int, mandatory) → region ancestor
• ANCESTOR_LEVEL (smallint, mandatory) → region ancestor
• ANCESTOR_REGION_ID (int, mandatory) → region
• HISTORY_START_TIME (datetime, mandatory)
• HISTORY_END_TIME (datetime)

REGION_ANCESTOR_HISTORY_BY_DAY

type: view

For every day with data, this view returns the row in the region ancestor history table corresponding to midnight at the end of that day.

• HISTORY_DATE (date, mandatory) → day
• REGION_ID (int, mandatory) → region ancestor
• ANCESTOR_LEVEL (smallint, mandatory) → region ancestor
• ANCESTOR_REGION_ID (int, mandatory) → region
• HISTORY_START_TIME (datetime, mandatory)

REGION_ANCESTOR_FULL_HISTORY_BY_DAY

type: view

• HISTORY_DATE (date, mandatory) → day
• REGION_ID (int, mandatory) → region
• ANCESTOR_LEVEL (smallint, mandatory)
• ANCESTOR_REGION_ID (int, mandatory) → region
• HISTORY_START_TIME (datetime, mandatory)

REGION_METRICS_HISTORY

type: history entity, schedule: daily

A record of historical values for the region metrics table.

• REGION_ID (int, mandatory) → region metrics
• 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
• HISTORY_START_TIME (datetime, mandatory)
• HISTORY_END_TIME (datetime)

REGION_METRICS_HISTORY_BY_DAY

type: view

For every day with data, this view returns the row in the region metrics history table corresponding to midnight at the end of that day.

• HISTORY_DATE (date, mandatory) → day
• REGION_ID (int, mandatory) → region metrics
• 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
• HISTORY_START_TIME (datetime, mandatory)

BUILDING_HISTORY

type: history entity, schedule: daily

A record of historical values for the building table.

• BUILDING_ID (int, mandatory) → building
• 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)
• HISTORY_START_TIME (datetime, mandatory)
• HISTORY_END_TIME (datetime)

BUILDING_HISTORY_BY_DAY

type: view

For every day with data, this view returns the row in the building history table corresponding to midnight at the end of that day.

• HISTORY_DATE (date, mandatory) → day
• BUILDING_ID (int, mandatory) → building
• 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)
• HISTORY_START_TIME (datetime, mandatory)

BUILDING_CUSTOM_FIELD_VALUE_HISTORY

type: history entity, schedule: daily

A record of historical values for the building custom field value table.

• BUILDING_ID (int, mandatory) → building
• CUSTOM_FIELD_NAME (string, mandatory)
• CUSTOM_FIELD_VALUE (string)
• HISTORY_START_TIME (datetime, mandatory)
• HISTORY_END_TIME (datetime)

BUILDING_CUSTOM_FIELD_VALUE_HISTORY_BY_DAY

type: view

For every day with data, this view returns the row in the building custom field value history table corresponding to midnight at the end of that day.

• HISTORY_DATE (date, mandatory) → day
• BUILDING_ID (int, mandatory) → building
• CUSTOM_FIELD_NAME (string, mandatory)
• CUSTOM_FIELD_VALUE (string)
• HISTORY_START_TIME (datetime, mandatory)

BUILDING_CUSTOM_FIELDS_HISTORY

type: view

A record of historical values for the building custom fields table.

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

BUILDING_CUSTOM_FIELDS_HISTORY_BY_DAY

type: view

For every day with data, this view returns the row in the building custom fields history table corresponding to midnight at the end of that day.

• HISTORY_DATE (date, mandatory) → day
• BUILDING_ID (int, mandatory) → building
• HISTORY_START_TIME (datetime, mandatory)
• <custom fields>

BUILDING_METRICS_HISTORY

type: history entity, schedule: daily

A record of historical values for the building metrics table.

• BUILDING_ID (int, mandatory) → building metrics
• 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
• HISTORY_START_TIME (datetime, mandatory)
• HISTORY_END_TIME (datetime)

BUILDING_METRICS_HISTORY_BY_DAY

type: view

For every day with data, this view returns the row in the building metrics history table corresponding to midnight at the end of that day.

• HISTORY_DATE (date, mandatory) → day
• BUILDING_ID (int, mandatory) → building metrics
• 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
• HISTORY_START_TIME (datetime, mandatory)

COMMENTS_HISTORY

type: history entity, schedule: daily

A record of historical values for the comments table.

• TABLE_NAME (string, mandatory) → comments
• ID (int, mandatory) → comments
• PERSON_ID (int, mandatory) → comments
• DATE (datetime, mandatory) → comments
• COMMENT (string, mandatory) → comments
• HISTORY_START_TIME (datetime, mandatory)
• HISTORY_END_TIME (datetime)

COMMENTS_HISTORY_BY_DAY

type: view

For every day with data, this view returns the row in the comments history table corresponding to midnight at the end of that day.

• HISTORY_DATE (date, mandatory) → day
• TABLE_NAME (string, mandatory) → comments
• ID (int, mandatory) → comments
• PERSON_ID (int, mandatory) → comments
• DATE (datetime, mandatory) → comments
• COMMENT (string, mandatory) → comments
• HISTORY_START_TIME (datetime, mandatory)

COMMENT_HISTORY

type: history entity, schedule: daily

A record of historical values for the comment table.

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

COMMENT_HISTORY_BY_DAY

type: view

For every day with data, this view returns the row in the comment history table corresponding to midnight at the end of that day.

• HISTORY_DATE (date, mandatory) → day
• ID (int, mandatory) → comment
• USER_ID (int) → user
• COMMENTABLE_ID (int)
• COMMENTABLE_NAME (string)
• CREATED_AT (datetime)
• UPDATED_AT (datetime)
• BODY (string)
• HISTORY_START_TIME (datetime, mandatory)

VILLAGE_HISTORY

type: history entity, schedule: daily

A record of historical values for the village table.

• VILLAGE_ID (int, mandatory) → village
• LOCATION_ID (int, mandatory) → location
• VILLAGE_NAME (string)
• COLOR (string)
• TARGET_ASSIGNMENT_RATIO (decimal, mandatory)
• HISTORY_START_TIME (datetime, mandatory)
• HISTORY_END_TIME (datetime)

VILLAGE_HISTORY_BY_DAY

type: view

For every day with data, this view returns the row in the village history table corresponding to midnight at the end of that day.

• HISTORY_DATE (date, mandatory) → day
• VILLAGE_ID (int, mandatory) → village
• LOCATION_ID (int, mandatory) → location
• VILLAGE_NAME (string)
• COLOR (string)
• TARGET_ASSIGNMENT_RATIO (decimal, mandatory)
• HISTORY_START_TIME (datetime, mandatory)

VILLAGE_METRICS_HISTORY

type: history entity, schedule: daily

A record of historical values for the village metrics table.

• VILLAGE_ID (int, mandatory) → village metrics
• 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
• HISTORY_START_TIME (datetime, mandatory)
• HISTORY_END_TIME (datetime)

VILLAGE_METRICS_HISTORY_BY_DAY

type: view

For every day with data, this view returns the row in the village metrics history table corresponding to midnight at the end of that day.

• HISTORY_DATE (date, mandatory) → day
• VILLAGE_ID (int, mandatory) → village metrics
• 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
• HISTORY_START_TIME (datetime, mandatory)

FLOOR_HISTORY

type: history entity, schedule: daily

A record of historical values for the floor table.

• FLOOR_ID (int, mandatory) → floor
• 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)
• HISTORY_START_TIME (datetime, mandatory)
• HISTORY_END_TIME (datetime)

FLOOR_HISTORY_BY_DAY

type: view

For every day with data, this view returns the row in the floor history table corresponding to midnight at the end of that day.

• HISTORY_DATE (date, mandatory) → day
• FLOOR_ID (int, mandatory) → floor
• 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)
• HISTORY_START_TIME (datetime, mandatory)

FLOOR_CUSTOM_FIELD_VALUE_HISTORY

type: history entity, schedule: daily

A record of historical values for the floor custom field value table.

• FLOOR_ID (int, mandatory) → floor
• CUSTOM_FIELD_NAME (string, mandatory)
• CUSTOM_FIELD_VALUE (string)
• HISTORY_START_TIME (datetime, mandatory)
• HISTORY_END_TIME (datetime)

FLOOR_CUSTOM_FIELD_VALUE_HISTORY_BY_DAY

type: view

For every day with data, this view returns the row in the floor custom field value history table corresponding to midnight at the end of that day.

• HISTORY_DATE (date, mandatory) → day
• FLOOR_ID (int, mandatory) → floor
• CUSTOM_FIELD_NAME (string, mandatory)
• CUSTOM_FIELD_VALUE (string)
• HISTORY_START_TIME (datetime, mandatory)

FLOOR_CUSTOM_FIELDS_HISTORY

type: view

A record of historical values for the floor custom fields table.

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

FLOOR_CUSTOM_FIELDS_HISTORY_BY_DAY

type: view

For every day with data, this view returns the row in the floor custom fields history table corresponding to midnight at the end of that day.

• HISTORY_DATE (date, mandatory) → day
• FLOOR_ID (int, mandatory) → floor
• HISTORY_START_TIME (datetime, mandatory)
• <custom fields>

FLOOR_METRICS_HISTORY

type: history entity, schedule: daily

A record of historical values for the floor metrics table.

• FLOOR_ID (int, mandatory) → floor metrics
• 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
• HISTORY_START_TIME (datetime, mandatory)
• HISTORY_END_TIME (datetime)

FLOOR_METRICS_HISTORY_BY_DAY

type: view

For every day with data, this view returns the row in the floor metrics history table corresponding to midnight at the end of that day.

• HISTORY_DATE (date, mandatory) → day
• FLOOR_ID (int, mandatory) → floor metrics
• 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
• HISTORY_START_TIME (datetime, mandatory)

ZONE_HISTORY

type: history entity, schedule: daily

A record of historical values for the zone table.

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) → zone
• 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)
• HISTORY_START_TIME (datetime, mandatory)
• HISTORY_END_TIME (datetime)

ZONE_HISTORY_BY_DAY

type: view

For every day with data, this view returns the row in the zone history table corresponding to midnight at the end of that day.

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.

• HISTORY_DATE (date, mandatory) → day
• ZONE_ID (int, mandatory) → zone
• 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)
• HISTORY_START_TIME (datetime, mandatory)

ZONE_CUSTOM_FIELD_VALUE_HISTORY

type: history entity, schedule: daily

A record of historical values for the zone custom field value table.

• ZONE_ID (int, mandatory) → zone
• CUSTOM_FIELD_NAME (string, mandatory)
• CUSTOM_FIELD_VALUE (string)
• HISTORY_START_TIME (datetime, mandatory)
• HISTORY_END_TIME (datetime)

ZONE_CUSTOM_FIELD_VALUE_HISTORY_BY_DAY

type: view

For every day with data, this view returns the row in the zone custom field value history table corresponding to midnight at the end of that day.

• HISTORY_DATE (date, mandatory) → day
• ZONE_ID (int, mandatory) → zone
• CUSTOM_FIELD_NAME (string, mandatory)
• CUSTOM_FIELD_VALUE (string)
• HISTORY_START_TIME (datetime, mandatory)

ZONE_CUSTOM_FIELDS_HISTORY

type: view

A record of historical values for the zone custom fields table.

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

ZONE_CUSTOM_FIELDS_HISTORY_BY_DAY

type: view

For every day with data, this view returns the row in the zone custom fields history table corresponding to midnight at the end of that day.

• HISTORY_DATE (date, mandatory) → day
• ZONE_ID (int, mandatory) → zone
• HISTORY_START_TIME (datetime, mandatory)
• <custom fields>

ZONE_METRICS_HISTORY

type: history entity, schedule: daily

A record of historical values for the zone metrics table.

• ZONE_ID (int, mandatory) → zone metrics
• 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
• HISTORY_START_TIME (datetime, mandatory)
• HISTORY_END_TIME (datetime)

ZONE_METRICS_HISTORY_BY_DAY

type: view

For every day with data, this view returns the row in the zone metrics history table corresponding to midnight at the end of that day.

• HISTORY_DATE (date, mandatory) → day
• ZONE_ID (int, mandatory) → zone metrics
• 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
• HISTORY_START_TIME (datetime, mandatory)

NEIGHBORHOOD_HISTORY

type: history entity, schedule: daily

A record of historical values for the neighborhood table.

• NEIGHBORHOOD_ID (int, mandatory) → neighborhood
• 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)
• HISTORY_START_TIME (datetime, mandatory)
• HISTORY_END_TIME (datetime)

NEIGHBORHOOD_HISTORY_BY_DAY

type: view

For every day with data, this view returns the row in the neighborhood history table corresponding to midnight at the end of that day.

• HISTORY_DATE (date, mandatory) → day
• NEIGHBORHOOD_ID (int, mandatory) → neighborhood
• 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)
• HISTORY_START_TIME (datetime, mandatory)

NEIGHBORHOOD_CUSTOM_FIELD_VALUE_HISTORY

type: history entity, schedule: daily

A record of historical values for the neighborhood custom field value table.

• NEIGHBORHOOD_ID (int, mandatory) → neighborhood
• CUSTOM_FIELD_NAME (string, mandatory)
• CUSTOM_FIELD_VALUE (string)
• HISTORY_START_TIME (datetime, mandatory)
• HISTORY_END_TIME (datetime)

NEIGHBORHOOD_CUSTOM_FIELD_VALUE_HISTORY_BY_DAY

type: view

For every day with data, this view returns the row in the neighborhood custom field value history table corresponding to midnight at the end of that day.

• HISTORY_DATE (date, mandatory) → day
• NEIGHBORHOOD_ID (int, mandatory) → neighborhood
• CUSTOM_FIELD_NAME (string, mandatory)
• CUSTOM_FIELD_VALUE (string)
• HISTORY_START_TIME (datetime, mandatory)

NEIGHBORHOOD_CUSTOM_FIELDS_HISTORY

type: view

A record of historical values for the neighborhood custom fields table.

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

NEIGHBORHOOD_CUSTOM_FIELDS_HISTORY_BY_DAY

type: view

For every day with data, this view returns the row in the neighborhood custom fields history table corresponding to midnight at the end of that day.

• HISTORY_DATE (date, mandatory) → day
• NEIGHBORHOOD_ID (int, mandatory) → neighborhood
• HISTORY_START_TIME (datetime, mandatory)
• <custom fields>

NEIGHBORHOOD_METRICS_HISTORY

type: history entity, schedule: daily

A record of historical values for the neighborhood metrics table.

• NEIGHBORHOOD_ID (int, mandatory) → neighborhood metrics
• 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
• HISTORY_START_TIME (datetime, mandatory)
• HISTORY_END_TIME (datetime)

NEIGHBORHOOD_METRICS_HISTORY_BY_DAY

type: view

For every day with data, this view returns the row in the neighborhood metrics history table corresponding to midnight at the end of that day.

• HISTORY_DATE (date, mandatory) → day
• NEIGHBORHOOD_ID (int, mandatory) → neighborhood metrics
• 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
• HISTORY_START_TIME (datetime, mandatory)

SPACE_HISTORY

type: history entity, schedule: daily

A record of historical values for the space table.

• SPACE_ID (int, mandatory) → space
• 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)
• HISTORY_START_TIME (datetime, mandatory)
• HISTORY_END_TIME (datetime)

SPACE_HISTORY_BY_DAY

type: view

For every day with data, this view returns the row in the space history table corresponding to midnight at the end of that day.

• HISTORY_DATE (date, mandatory) → day
• SPACE_ID (int, mandatory) → space
• 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)
• HISTORY_START_TIME (datetime, mandatory)

SPACE_CUSTOM_FIELD_VALUE_HISTORY

type: history entity, schedule: daily

A record of historical values for the space custom field value table.

• SPACE_ID (int, mandatory) → space
• CUSTOM_FIELD_NAME (string, mandatory)
• CUSTOM_FIELD_VALUE (string)
• HISTORY_START_TIME (datetime, mandatory)
• HISTORY_END_TIME (datetime)

SPACE_CUSTOM_FIELD_VALUE_HISTORY_BY_DAY

type: view

For every day with data, this view returns the row in the space custom field value history table corresponding to midnight at the end of that day.

• HISTORY_DATE (date, mandatory) → day
• SPACE_ID (int, mandatory) → space
• CUSTOM_FIELD_NAME (string, mandatory)
• CUSTOM_FIELD_VALUE (string)
• HISTORY_START_TIME (datetime, mandatory)

SPACE_CUSTOM_FIELDS_HISTORY

type: view

A record of historical values for the space custom fields table.

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

SPACE_CUSTOM_FIELDS_HISTORY_BY_DAY

type: view

For every day with data, this view returns the row in the space custom fields history table corresponding to midnight at the end of that day.

• HISTORY_DATE (date, mandatory) → day
• SPACE_ID (int, mandatory) → space
• HISTORY_START_TIME (datetime, mandatory)
• <custom fields>

SPACE_METRICS_HISTORY

type: history entity, schedule: daily

A record of historical values for the space metrics table.

• SPACE_ID (int, mandatory) → space metrics
• 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
• HISTORY_START_TIME (datetime, mandatory)
• HISTORY_END_TIME (datetime)

SPACE_METRICS_HISTORY_BY_DAY

type: view

For every day with data, this view returns the row in the space metrics history table corresponding to midnight at the end of that day.

• HISTORY_DATE (date, mandatory) → day
• SPACE_ID (int, mandatory) → space metrics
• 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
• HISTORY_START_TIME (datetime, mandatory)

SPACE_TYPE_HISTORY

type: history entity, schedule: daily

A record of historical values for the space type table.

• SPACE_TYPE_ID (int, mandatory) → space type
• 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
• HISTORY_START_TIME (datetime, mandatory)
• HISTORY_END_TIME (datetime)

SPACE_TYPE_HISTORY_BY_DAY

type: view

For every day with data, this view returns the row in the space type history table corresponding to midnight at the end of that day.

• HISTORY_DATE (date, mandatory) → day
• SPACE_TYPE_ID (int, mandatory) → space type
• 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
• HISTORY_START_TIME (datetime, mandatory)

SPACE_TYPE_CUSTOM_FIELD_VALUE_HISTORY

type: history entity, schedule: daily

A record of historical values for the space type custom field value table.

• SPACE_TYPE_ID (int, mandatory) → space type
• CUSTOM_FIELD_NAME (string, mandatory)
• CUSTOM_FIELD_VALUE (string)
• HISTORY_START_TIME (datetime, mandatory)
• HISTORY_END_TIME (datetime)

SPACE_TYPE_CUSTOM_FIELD_VALUE_HISTORY_BY_DAY

type: view

For every day with data, this view returns the row in the space type custom field value history table corresponding to midnight at the end of that day.

• HISTORY_DATE (date, mandatory) → day
• SPACE_TYPE_ID (int, mandatory) → space type
• CUSTOM_FIELD_NAME (string, mandatory)
• CUSTOM_FIELD_VALUE (string)
• HISTORY_START_TIME (datetime, mandatory)

SPACE_TYPE_CUSTOM_FIELDS_HISTORY

type: view

A record of historical values for the space type custom fields table.

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

SPACE_TYPE_CUSTOM_FIELDS_HISTORY_BY_DAY

type: view

For every day with data, this view returns the row in the space type custom fields history table corresponding to midnight at the end of that day.

• HISTORY_DATE (date, mandatory) → day
• SPACE_TYPE_ID (int, mandatory) → space type
• HISTORY_START_TIME (datetime, mandatory)
• <custom fields>

SPACE_TYPE_ANCESTOR_HISTORY

type: history entity, schedule: daily

A record of historical values for the space type ancestor table.

• SPACE_TYPE_ID (int, mandatory) → space type ancestor
• ANCESTOR_LEVEL (smallint, mandatory) → space type ancestor
• ANCESTOR_SPACE_TYPE_ID (int, mandatory) → space type
• HISTORY_START_TIME (datetime, mandatory)
• HISTORY_END_TIME (datetime)

SPACE_TYPE_ANCESTOR_HISTORY_BY_DAY

type: view

For every day with data, this view returns the row in the space type ancestor history table corresponding to midnight at the end of that day.

• HISTORY_DATE (date, mandatory) → day
• SPACE_TYPE_ID (int, mandatory) → space type ancestor
• ANCESTOR_LEVEL (smallint, mandatory) → space type ancestor
• ANCESTOR_SPACE_TYPE_ID (int, mandatory) → space type
• HISTORY_START_TIME (datetime, mandatory)

SPACE_ATTRIBUTES_HISTORY

type: history entity, schedule: daily

A record of historical values for the space attributes table.

• SPACE_ID (int, mandatory) → space attributes
• ATTRIBUTE (string, mandatory) → space attributes
• HISTORY_START_TIME (datetime, mandatory)
• HISTORY_END_TIME (datetime)

SPACE_ATTRIBUTES_HISTORY_BY_DAY

type: view

For every day with data, this view returns the row in the space attributes history table corresponding to midnight at the end of that day.

• HISTORY_DATE (date, mandatory) → day
• SPACE_ID (int, mandatory) → space attributes
• ATTRIBUTE (string, mandatory) → space attributes
• HISTORY_START_TIME (datetime, mandatory)

SPACE_TYPE_ANCESTOR_FULL_HISTORY_BY_DAY

type: view

• HISTORY_DATE (date, mandatory) → day
• SPACE_TYPE_ID (int, mandatory) → space type
• ANCESTOR_LEVEL (smallint, mandatory)
• ANCESTOR_SPACE_TYPE_ID (int, mandatory) → space type
• HISTORY_START_TIME (datetime, mandatory)

NEIGHBORHOOD_TEAM_PORTIONS_HISTORY

type: history entity, schedule: daily

A record of historical values for the neighborhood team portions table.

• TEAM_LOCATION_ID (int, mandatory) → neighborhood team portions
• 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
• HISTORY_START_TIME (datetime, mandatory)
• HISTORY_END_TIME (datetime)

NEIGHBORHOOD_TEAM_PORTIONS_HISTORY_BY_DAY

type: view

For every day with data, this view returns the row in the neighborhood team portions history table corresponding to midnight at the end of that day.

• HISTORY_DATE (date, mandatory) → day
• TEAM_LOCATION_ID (int, mandatory) → neighborhood team portions
• 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
• HISTORY_START_TIME (datetime, mandatory)

BASELINE_METRICS_HISTORY

type: history entity, schedule: daily

A record of historical values for the baseline metrics table.

• LOCATION_ID (int, mandatory) → baseline metrics
• 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
• HISTORY_START_TIME (datetime, mandatory)
• HISTORY_END_TIME (datetime)

BASELINE_METRICS_HISTORY_BY_DAY

type: view

For every day with data, this view returns the row in the baseline metrics history table corresponding to midnight at the end of that day.

• HISTORY_DATE (date, mandatory) → day
• LOCATION_ID (int, mandatory) → baseline metrics
• 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
• HISTORY_START_TIME (datetime, mandatory)

CITY_HISTORY

type: history entity, schedule: daily

A record of historical values for the city table.

• CITY (string, mandatory) → city
• COUNTY (string, mandatory) → city
• COUNTY_CODE (string)
• STATE (string, mandatory) → city
• STATE_CODE (string)
• HISTORY_START_TIME (datetime, mandatory)
• HISTORY_END_TIME (datetime)

CITY_HISTORY_BY_DAY

type: view

For every day with data, this view returns the row in the city history table corresponding to midnight at the end of that day.

• HISTORY_DATE (date, mandatory) → day
• CITY (string, mandatory) → city
• COUNTY (string, mandatory) → city
• COUNTY_CODE (string)
• STATE (string, mandatory) → city
• STATE_CODE (string)
• HISTORY_START_TIME (datetime, mandatory)

TEAM_VALIDATIONS_HISTORY

type: history entity, schedule: daily

A record of historical values for the team validations table.

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

TEAM_VALIDATIONS_HISTORY_BY_DAY

type: view

For every day with data, this view returns the row in the team validations history table corresponding to midnight at the end of that day.

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

CONFIGURATION_HISTORY

type: history entity, schedule: daily

A record of historical values for the configuration table.

• CONFIGURATION_ID (int, mandatory) → configuration
• CONFIGURATION (string)
• DESCRIPTION (string)
• VALUE (string)
• HISTORY_START_TIME (datetime, mandatory)
• HISTORY_END_TIME (datetime)

CONFIGURATION_HISTORY_BY_DAY

type: view

For every day with data, this view returns the row in the configuration history table corresponding to midnight at the end of that day.

• HISTORY_DATE (date, mandatory) → day
• CONFIGURATION_ID (int, mandatory) → configuration
• CONFIGURATION (string)
• DESCRIPTION (string)
• VALUE (string)
• HISTORY_START_TIME (datetime, mandatory)

ORG_UNIT_HISTORY

type: history entity, schedule: daily

A record of historical values for the org unit table.

• ORG_UNIT_ID (int, mandatory) → org unit
• 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.
• HISTORY_START_TIME (datetime, mandatory)
• HISTORY_END_TIME (datetime)

ORG_UNIT_HISTORY_BY_DAY

type: view

For every day with data, this view returns the row in the org unit history table corresponding to midnight at the end of that day.

• HISTORY_DATE (date, mandatory) → day
• ORG_UNIT_ID (int, mandatory) → org unit
• 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.
• HISTORY_START_TIME (datetime, mandatory)

ORG_UNIT_CUSTOM_FIELD_VALUE_HISTORY

type: history entity, schedule: daily

A record of historical values for the org unit custom field value table.

• ORG_UNIT_ID (int, mandatory) → org unit
• CUSTOM_FIELD_NAME (string, mandatory)
• CUSTOM_FIELD_VALUE (string)
• HISTORY_START_TIME (datetime, mandatory)
• HISTORY_END_TIME (datetime)

ORG_UNIT_CUSTOM_FIELD_VALUE_HISTORY_BY_DAY

type: view

For every day with data, this view returns the row in the org unit custom field value history table corresponding to midnight at the end of that day.

• HISTORY_DATE (date, mandatory) → day
• ORG_UNIT_ID (int, mandatory) → org unit
• CUSTOM_FIELD_NAME (string, mandatory)
• CUSTOM_FIELD_VALUE (string)
• HISTORY_START_TIME (datetime, mandatory)

ORG_UNIT_CUSTOM_FIELDS_HISTORY

type: view

A record of historical values for the org unit custom fields table.

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

ORG_UNIT_CUSTOM_FIELDS_HISTORY_BY_DAY

type: view

For every day with data, this view returns the row in the org unit custom fields history table corresponding to midnight at the end of that day.

• HISTORY_DATE (date, mandatory) → day
• ORG_UNIT_ID (int, mandatory) → org unit
• HISTORY_START_TIME (datetime, mandatory)
• <custom fields>

ORG_UNIT_ANCESTOR_HISTORY

type: history entity, schedule: daily

A record of historical values for the org unit ancestor table.

• ORG_UNIT_ID (int, mandatory) → org unit ancestor
• ANCESTOR_LEVEL (smallint, mandatory) → org unit ancestor
• ANCESTOR_ORG_UNIT_ID (int, mandatory) → org unit
• HISTORY_START_TIME (datetime, mandatory)
• HISTORY_END_TIME (datetime)

ORG_UNIT_ANCESTOR_HISTORY_BY_DAY

type: view

For every day with data, this view returns the row in the org unit ancestor history table corresponding to midnight at the end of that day.

• HISTORY_DATE (date, mandatory) → day
• ORG_UNIT_ID (int, mandatory) → org unit ancestor
• ANCESTOR_LEVEL (smallint, mandatory) → org unit ancestor
• ANCESTOR_ORG_UNIT_ID (int, mandatory) → org unit
• HISTORY_START_TIME (datetime, mandatory)

ORG_UNIT_ANCESTOR_FULL_HISTORY_BY_DAY

type: view

• HISTORY_DATE (date, mandatory) → day
• ORG_UNIT_ID (int, mandatory) → org unit
• ANCESTOR_LEVEL (smallint, mandatory)
• ANCESTOR_ORG_UNIT_ID (int, mandatory) → org unit
• HISTORY_START_TIME (datetime, mandatory)

ORG_UNIT_METRICS_HISTORY

type: history entity, schedule: daily

A record of historical values for the org unit metrics table.

• ORG_UNIT_ID (int, mandatory) → org unit metrics
• 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
• HISTORY_START_TIME (datetime, mandatory)
• HISTORY_END_TIME (datetime)

ORG_UNIT_METRICS_HISTORY_BY_DAY

type: view

For every day with data, this view returns the row in the org unit metrics history table corresponding to midnight at the end of that day.

• HISTORY_DATE (date, mandatory) → day
• ORG_UNIT_ID (int, mandatory) → org unit metrics
• 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
• HISTORY_START_TIME (datetime, mandatory)

PERSON_HISTORY

type: history entity, schedule: daily

A record of historical values for the person table.

• PERSON_ID (int, mandatory) → person
• 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.
• HISTORY_START_TIME (datetime, mandatory)
• HISTORY_END_TIME (datetime)

PERSON_HISTORY_BY_DAY

type: view

For every day with data, this view returns the row in the person history table corresponding to midnight at the end of that day.

• HISTORY_DATE (date, mandatory) → day
• PERSON_ID (int, mandatory) → person
• 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.
• HISTORY_START_TIME (datetime, mandatory)

PERSON_CUSTOM_FIELD_VALUE_HISTORY

type: history entity, schedule: daily

A record of historical values for the person custom field value table.

• PERSON_ID (int, mandatory) → person
• CUSTOM_FIELD_NAME (string, mandatory)
• CUSTOM_FIELD_VALUE (string)
• HISTORY_START_TIME (datetime, mandatory)
• HISTORY_END_TIME (datetime)

PERSON_CUSTOM_FIELD_VALUE_HISTORY_BY_DAY

type: view

For every day with data, this view returns the row in the person custom field value history table corresponding to midnight at the end of that day.

• HISTORY_DATE (date, mandatory) → day
• PERSON_ID (int, mandatory) → person
• CUSTOM_FIELD_NAME (string, mandatory)
• CUSTOM_FIELD_VALUE (string)
• HISTORY_START_TIME (datetime, mandatory)

PERSON_CUSTOM_FIELDS_HISTORY

type: view

A record of historical values for the person custom fields table.

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

PERSON_CUSTOM_FIELDS_HISTORY_BY_DAY

type: view

For every day with data, this view returns the row in the person custom fields history table corresponding to midnight at the end of that day.

• HISTORY_DATE (date, mandatory) → day
• PERSON_ID (int, mandatory) → person
• HISTORY_START_TIME (datetime, mandatory)
• <custom fields>

PERSON_MANAGER_ANCESTOR_HISTORY

type: history entity, schedule: daily

A record of historical values for the person manager ancestor table.

• PERSON_ID (int, mandatory) → person manager ancestor
• ANCESTOR_LEVEL (smallint, mandatory) → person manager ancestor
• ANCESTOR_MANAGER_PERSON_ID (int, mandatory) → person
• HISTORY_START_TIME (datetime, mandatory)
• HISTORY_END_TIME (datetime)

PERSON_MANAGER_ANCESTOR_HISTORY_BY_DAY

type: view

For every day with data, this view returns the row in the person manager ancestor history table corresponding to midnight at the end of that day.

• HISTORY_DATE (date, mandatory) → day
• PERSON_ID (int, mandatory) → person manager ancestor
• ANCESTOR_LEVEL (smallint, mandatory) → person manager ancestor
• ANCESTOR_MANAGER_PERSON_ID (int, mandatory) → person
• HISTORY_START_TIME (datetime, mandatory)

PERSON_MANAGER_ANCESTOR_FULL_HISTORY_BY_DAY

type: view

• HISTORY_DATE (date, mandatory) → day
• PERSON_ID (int, mandatory) → person
• ANCESTOR_LEVEL (smallint, mandatory)
• ANCESTOR_MANAGER_PERSON_ID (int, mandatory) → person
• HISTORY_START_TIME (datetime, mandatory)

TEAM_HISTORY

type: history entity, schedule: daily

A record of historical values for the team table.

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) → team
• 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)
• HISTORY_START_TIME (datetime, mandatory)
• HISTORY_END_TIME (datetime)

TEAM_HISTORY_BY_DAY

type: view

For every day with data, this view returns the row in the team history table corresponding to midnight at the end of that day.

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.

• HISTORY_DATE (date, mandatory) → day
• TEAM_ID (int, mandatory) → team
• 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)
• HISTORY_START_TIME (datetime, mandatory)

TEAM_CUSTOM_FIELD_VALUE_HISTORY

type: history entity, schedule: daily

A record of historical values for the team custom field value table.

• TEAM_ID (int, mandatory) → team
• CUSTOM_FIELD_NAME (string, mandatory)
• CUSTOM_FIELD_VALUE (string)
• HISTORY_START_TIME (datetime, mandatory)
• HISTORY_END_TIME (datetime)

TEAM_CUSTOM_FIELD_VALUE_HISTORY_BY_DAY

type: view

For every day with data, this view returns the row in the team custom field value history table corresponding to midnight at the end of that day.

• HISTORY_DATE (date, mandatory) → day
• TEAM_ID (int, mandatory) → team
• CUSTOM_FIELD_NAME (string, mandatory)
• CUSTOM_FIELD_VALUE (string)
• HISTORY_START_TIME (datetime, mandatory)

TEAM_CUSTOM_FIELDS_HISTORY

type: view

A record of historical values for the team custom fields table.

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

TEAM_CUSTOM_FIELDS_HISTORY_BY_DAY

type: view

For every day with data, this view returns the row in the team custom fields history table corresponding to midnight at the end of that day.

• HISTORY_DATE (date, mandatory) → day
• TEAM_ID (int, mandatory) → team
• HISTORY_START_TIME (datetime, mandatory)
• <custom fields>

TEAM_ADMINISTRATORS_HISTORY

type: history entity, schedule: daily

A record of historical values for the team administrators table.

• PERSON_ID (int, mandatory) → team administrators
• TEAM_ID (int, mandatory) → team administrators
• ADMINISTRATOR_TYPE (string, mandatory) → team administrators
• HISTORY_START_TIME (datetime, mandatory)
• HISTORY_END_TIME (datetime)

TEAM_ADMINISTRATORS_HISTORY_BY_DAY

type: view

For every day with data, this view returns the row in the team administrators history table corresponding to midnight at the end of that day.

• HISTORY_DATE (date, mandatory) → day
• PERSON_ID (int, mandatory) → team administrators
• TEAM_ID (int, mandatory) → team administrators
• ADMINISTRATOR_TYPE (string, mandatory) → team administrators
• HISTORY_START_TIME (datetime, mandatory)

TEAM_METRICS_HISTORY

type: history entity, schedule: daily

A record of historical values for the team metrics table.

• TEAM_ID (int, mandatory) → team metrics
• 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
• HISTORY_START_TIME (datetime, mandatory)
• HISTORY_END_TIME (datetime)

TEAM_METRICS_HISTORY_BY_DAY

type: view

For every day with data, this view returns the row in the team metrics history table corresponding to midnight at the end of that day.

• HISTORY_DATE (date, mandatory) → day
• TEAM_ID (int, mandatory) → team metrics
• 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
• HISTORY_START_TIME (datetime, mandatory)

TEAM_MEMBER_HISTORY

type: history entity, schedule: daily

A record of historical values for the team member table.

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 member
• TEAM_ID (int, mandatory) → team
• PERSON_ID (int) → person
• IS_FLOATING (bool)
• HISTORY_START_TIME (datetime, mandatory)
• HISTORY_END_TIME (datetime)

TEAM_MEMBER_HISTORY_BY_DAY

type: view

For every day with data, this view returns the row in the team member history table corresponding to midnight at the end of that day.

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

• HISTORY_DATE (date, mandatory) → day
• TEAM_MEMBER_ID (int, mandatory) → team member
• TEAM_ID (int, mandatory) → team
• PERSON_ID (int) → person
• IS_FLOATING (bool)
• HISTORY_START_TIME (datetime, mandatory)

TEAM_ALLOCATION_HISTORY

type: history entity, schedule: daily

A record of historical values for the team allocation table.

• TEAM_ALLOCATION_ID (int, mandatory) → team allocation
• 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)
• HISTORY_START_TIME (datetime, mandatory)
• HISTORY_END_TIME (datetime)

TEAM_ALLOCATION_HISTORY_BY_DAY

type: view

For every day with data, this view returns the row in the team allocation history table corresponding to midnight at the end of that day.

• HISTORY_DATE (date, mandatory) → day
• TEAM_ALLOCATION_ID (int, mandatory) → team allocation
• 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)
• HISTORY_START_TIME (datetime, mandatory)

TEAM_ALLOCATION_SPACE_HISTORY

type: history entity, schedule: daily

A record of historical values for the team allocation space table.

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

TEAM_ALLOCATION_SPACE_HISTORY_BY_DAY

type: view

For every day with data, this view returns the row in the team allocation space history table corresponding to midnight at the end of that day.

• HISTORY_DATE (date, mandatory) → day
• TEAM_ALLOCATION_ID (int, mandatory) → team allocation space
• SPACE_ID (int, mandatory) → team allocation space
• HISTORY_START_TIME (datetime, mandatory)

SPACE_PERSON_ASSIGNMENT_HISTORY

type: history entity, schedule: daily

A record of historical values for the space person assignment table.

• SPACE_PERSON_ASSIGNMENT_ID (int, mandatory) → space person assignment
• SPACE_ID (int, mandatory) → space
• PERSON_ID (int) → person
• HISTORY_START_TIME (datetime, mandatory)
• HISTORY_END_TIME (datetime)

SPACE_PERSON_ASSIGNMENT_HISTORY_BY_DAY

type: view

For every day with data, this view returns the row in the space person assignment history table corresponding to midnight at the end of that day.

• HISTORY_DATE (date, mandatory) → day
• SPACE_PERSON_ASSIGNMENT_ID (int, mandatory) → space person assignment
• SPACE_ID (int, mandatory) → space
• PERSON_ID (int) → person
• HISTORY_START_TIME (datetime, mandatory)

RETENTION_STATUS_HISTORY

type: history entity, schedule: daily

A record of historical values for the retention status table.

• NAME (string, mandatory) → retention status
• 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.
• HISTORY_START_TIME (datetime, mandatory)
• HISTORY_END_TIME (datetime)

RETENTION_STATUS_HISTORY_BY_DAY

type: view

For every day with data, this view returns the row in the retention status history table corresponding to midnight at the end of that day.

• HISTORY_DATE (date, mandatory) → day
• NAME (string, mandatory) → retention status
• 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.
• HISTORY_START_TIME (datetime, mandatory)

PERSON_LOCATION_HISTORY

type: history entity, schedule: daily

A record of historical values for the person location table.

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

PERSON_LOCATION_HISTORY_BY_DAY

type: view

For every day with data, this view returns the row in the person location history table corresponding to midnight at the end of that day.

• HISTORY_DATE (date, mandatory) → day
• PERSON_LOCATION_ID (int, mandatory) → person location
• PERSON_ID (int) → person
• LOCATION_ID (int, mandatory) → location
• IS_FLEXIBLE (bool, mandatory)
• TEAM_ID (int) → team
• ORG_UNIT_ID (int) → org unit
• HISTORY_START_TIME (datetime, mandatory)

PERSON_LOCATION_SUMMARY_HISTORY_BY_DAY

type: view

For every day with data, this view returns the row in the person location summary table corresponding to midnight at the end of that day.

• HISTORY_DATE (date, mandatory) → day
• 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.

ASSET_HISTORY

type: history entity, schedule: daily

A record of historical values for the asset table.

• ASSET_ID (int, mandatory) → asset
• 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
• HISTORY_START_TIME (datetime, mandatory)
• HISTORY_END_TIME (datetime)

ASSET_HISTORY_BY_DAY

type: view

For every day with data, this view returns the row in the asset history table corresponding to midnight at the end of that day.

• HISTORY_DATE (date, mandatory) → day
• ASSET_ID (int, mandatory) → asset
• 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
• HISTORY_START_TIME (datetime, mandatory)

ASSET_CUSTOM_FIELD_VALUE_HISTORY

type: history entity, schedule: daily

A record of historical values for the asset custom field value table.

• ASSET_ID (int, mandatory) → asset
• CUSTOM_FIELD_NAME (string, mandatory)
• CUSTOM_FIELD_VALUE (string)
• HISTORY_START_TIME (datetime, mandatory)
• HISTORY_END_TIME (datetime)

ASSET_CUSTOM_FIELD_VALUE_HISTORY_BY_DAY

type: view

For every day with data, this view returns the row in the asset custom field value history table corresponding to midnight at the end of that day.

• HISTORY_DATE (date, mandatory) → day
• ASSET_ID (int, mandatory) → asset
• CUSTOM_FIELD_NAME (string, mandatory)
• CUSTOM_FIELD_VALUE (string)
• HISTORY_START_TIME (datetime, mandatory)

ASSET_CUSTOM_FIELDS_HISTORY

type: view

A record of historical values for the asset custom fields table.

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

ASSET_CUSTOM_FIELDS_HISTORY_BY_DAY

type: view

For every day with data, this view returns the row in the asset custom fields history table corresponding to midnight at the end of that day.

• HISTORY_DATE (date, mandatory) → day
• ASSET_ID (int, mandatory) → asset
• HISTORY_START_TIME (datetime, mandatory)
• <custom fields>

SWITCH_PORT_HISTORY

type: history entity, schedule: daily

A record of historical values for the switch port table.

• SWITCH_PORT_ID (int, mandatory) → switch port
• LABEL (string)
• NAME (string)
• SWITCH_ID (int) → asset
• HISTORY_START_TIME (datetime, mandatory)
• HISTORY_END_TIME (datetime)

SWITCH_PORT_HISTORY_BY_DAY

type: view

For every day with data, this view returns the row in the switch port history table corresponding to midnight at the end of that day.

• HISTORY_DATE (date, mandatory) → day
• SWITCH_PORT_ID (int, mandatory) → switch port
• LABEL (string)
• NAME (string)
• SWITCH_ID (int) → asset
• HISTORY_START_TIME (datetime, mandatory)

LOCATION_PORT_MAPPING_HISTORY

type: history entity, schedule: daily

A record of historical values for the location port mapping table.

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

LOCATION_PORT_MAPPING_HISTORY_BY_DAY

type: view

For every day with data, this view returns the row in the location port mapping history table corresponding to midnight at the end of that day.

• HISTORY_DATE (date, mandatory) → day
• LOCATION_PORT_MAPPING_ID (int, mandatory) → location port mapping
• SWITCH_PORT_ID (int) → switch port
• SPACE_ID (int) → space
• LOCATION_ID (int) → location
• NAME (string)
• HISTORY_START_TIME (datetime, mandatory)

FUTURE_BOOKING_HISTORY

type: history entity, schedule: daily

A record of historical values for the future booking table.

• FUTURE_BOOKING_ID (int, mandatory) → future booking
• 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)
• HISTORY_START_TIME (datetime, mandatory)
• HISTORY_END_TIME (datetime)

FUTURE_BOOKING_HISTORY_BY_DAY

type: view

For every day with data, this view returns the row in the future booking history table corresponding to midnight at the end of that day.

• HISTORY_DATE (date, mandatory) → day
• FUTURE_BOOKING_ID (int, mandatory) → future booking
• 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)
• HISTORY_START_TIME (datetime, mandatory)

FUTURE_BOOKING_ATTENDEE_HISTORY

type: history entity, schedule: daily

A record of historical values for the future booking attendee table.

• FUTURE_BOOKING_ATTENDEE_ID (int, mandatory) → future booking attendee
• 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.
• HISTORY_START_TIME (datetime, mandatory)
• HISTORY_END_TIME (datetime)

FUTURE_BOOKING_ATTENDEE_HISTORY_BY_DAY

type: view

For every day with data, this view returns the row in the future booking attendee history table corresponding to midnight at the end of that day.

• HISTORY_DATE (date, mandatory) → day
• FUTURE_BOOKING_ATTENDEE_ID (int, mandatory) → future booking attendee
• 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.
• HISTORY_START_TIME (datetime, mandatory)

FUTURE_BOOKING_SPACE_HISTORY

type: history entity, schedule: daily

A record of historical values for the future booking space table.

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

FUTURE_BOOKING_SPACE_HISTORY_BY_DAY

type: view

For every day with data, this view returns the row in the future booking space history table corresponding to midnight at the end of that day.

• HISTORY_DATE (date, mandatory) → day
• FUTURE_BOOKING_ID (int, mandatory) → future booking space
• SPACE_ID (int, mandatory) → future booking space
• CODE (string)
• SPACE_EMAIL (string)
• HISTORY_START_TIME (datetime, mandatory)

CUSTOM_FIELD_TYPE_HISTORY

type: history entity, schedule: daily

A record of historical values for the custom field type table.

• TABLE_NAME (string, mandatory) → custom field type - 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
• HISTORY_START_TIME (datetime, mandatory)
• HISTORY_END_TIME (datetime)

FLOORPLAN_HISTORY

type: history entity, schedule: daily

A record of historical values for the floorplan table.

• FLOOR_ID (int, mandatory) → floorplan
• 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.
• HISTORY_START_TIME (datetime, mandatory)
• HISTORY_END_TIME (datetime)

FLOORPLAN_HISTORY_BY_DAY

type: view

For every day with data, this view returns the row in the floorplan history table corresponding to midnight at the end of that day.

• HISTORY_DATE (date, mandatory) → day
• FLOOR_ID (int, mandatory) → floorplan
• 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.
• HISTORY_START_TIME (datetime, mandatory)

SHAPE_HISTORY

type: history entity, schedule: daily

A record of historical values for the shape table.

• SHAPE_ID (int, mandatory) → shape
• 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)
• HISTORY_START_TIME (datetime, mandatory)
• HISTORY_END_TIME (datetime)

SHAPE_HISTORY_BY_DAY

type: view

For every day with data, this view returns the row in the shape history table corresponding to midnight at the end of that day.

• HISTORY_DATE (date, mandatory) → day
• SHAPE_ID (int, mandatory) → shape
• 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)
• HISTORY_START_TIME (datetime, mandatory)

SPACE_PROXIMITY_HISTORY

type: history entity, schedule: daily

A record of historical values for the space proximity table.

• SPACE_ID (int, mandatory) → space proximity
• PROXIMATE_SPACE_ID (int, mandatory) → space proximity
• DISTANCE_M (decimal, mandatory)
• DISTANCE_FT (decimal, mandatory)
• HISTORY_START_TIME (datetime, mandatory)
• HISTORY_END_TIME (datetime)

SPACE_PROXIMITY_HISTORY_BY_DAY

type: view

For every day with data, this view returns the row in the space proximity history table corresponding to midnight at the end of that day.

• HISTORY_DATE (date, mandatory) → day
• SPACE_ID (int, mandatory) → space proximity
• PROXIMATE_SPACE_ID (int, mandatory) → space proximity
• DISTANCE_M (decimal, mandatory)
• DISTANCE_FT (decimal, mandatory)
• HISTORY_START_TIME (datetime, mandatory)

TENANT_HISTORY

type: history entity, schedule: daily

A record of historical values for the tenant table.

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

TENANT_HISTORY_BY_DAY

type: view

For every day with data, this view returns the row in the tenant history table corresponding to midnight at the end of that day.

• HISTORY_DATE (date, mandatory) → day
• TENANT_ID (string, mandatory) → tenant
• NAME (string)
• PLATFORM (string) - One of 'Serraview', 'SiQ' or 'Archibus'.
• AWS_REGION (string)
• IS_INSIGHTS_DEPLOYED (bool)
• HISTORY_START_TIME (datetime, mandatory)

USER_HISTORY

type: history entity, schedule: daily

A record of historical values for the user table.

• USER_ID (int, mandatory) → user
• 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)
• HISTORY_START_TIME (datetime, mandatory)
• HISTORY_END_TIME (datetime)

USER_HISTORY_BY_DAY

type: view

For every day with data, this view returns the row in the user history table corresponding to midnight at the end of that day.

• HISTORY_DATE (date, mandatory) → day
• USER_ID (int, mandatory) → user
• 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)
• HISTORY_START_TIME (datetime, mandatory)

USER_TO_ROLE_HISTORY

type: history entity, schedule: daily

A record of historical values for the user to role table.

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

• USER_ID (int, mandatory) → user to role
• ROLE_ID (int, mandatory) → user to role
• HISTORY_START_TIME (datetime, mandatory)
• HISTORY_END_TIME (datetime)

USER_TO_ROLE_HISTORY_BY_DAY

type: view

For every day with data, this view returns the row in the user to role history table corresponding to midnight at the end of that day.

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

• HISTORY_DATE (date, mandatory) → day
• USER_ID (int, mandatory) → user to role
• ROLE_ID (int, mandatory) → user to role
• HISTORY_START_TIME (datetime, mandatory)

ROLE_HISTORY

type: history entity, schedule: daily

A record of historical values for the role table.

A list of all the available security roles in Serraview.

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

ROLE_HISTORY_BY_DAY

type: view

For every day with data, this view returns the row in the role history table corresponding to midnight at the end of that day.

A list of all the available security roles in Serraview.

• HISTORY_DATE (date, mandatory) → day
• ROLE_ID (int, mandatory) → role
• NAME (string, mandatory)
• DESCRIPTION (string)
• HISTORY_START_TIME (datetime, mandatory)

ROLE_TO_PERMISSION_HISTORY

type: history entity, schedule: daily

A record of historical values for the role to permission table.

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

• ROLE_ID (int, mandatory) → role to permission
• PERMISSION (string, mandatory) → role to permission
• DESCRIPTION (string)
• HISTORY_START_TIME (datetime, mandatory)
• HISTORY_END_TIME (datetime)

ROLE_TO_PERMISSION_HISTORY_BY_DAY

type: view

For every day with data, this view returns the row in the role to permission history table corresponding to midnight at the end of that day.

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

• HISTORY_DATE (date, mandatory) → day
• ROLE_ID (int, mandatory) → role to permission
• PERMISSION (string, mandatory) → role to permission
• DESCRIPTION (string)
• HISTORY_START_TIME (datetime, mandatory)

SERVICE_REQUEST_HISTORY

type: history entity, schedule: daily

A record of historical values for the service request table.

• SERVICE_REQUEST_ID (int, mandatory) → service request
• 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
• HISTORY_START_TIME (datetime, mandatory)
• HISTORY_END_TIME (datetime)

SERVICE_REQUEST_HISTORY_BY_DAY

type: view

For every day with data, this view returns the row in the service request history table corresponding to midnight at the end of that day.

• HISTORY_DATE (date, mandatory) → day
• SERVICE_REQUEST_ID (int, mandatory) → service request
• 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
• HISTORY_START_TIME (datetime, mandatory)

SPACE_REQUEST_HISTORY

type: history entity, schedule: daily

A record of historical values for the space request table.

• SPACE_REQUEST_ID (int, mandatory) → space request
• 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)
• HISTORY_START_TIME (datetime, mandatory)
• HISTORY_END_TIME (datetime)

SPACE_REQUEST_HISTORY_BY_DAY

type: view

For every day with data, this view returns the row in the space request history table corresponding to midnight at the end of that day.

• HISTORY_DATE (date, mandatory) → day
• SPACE_REQUEST_ID (int, mandatory) → space request
• 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)
• HISTORY_START_TIME (datetime, mandatory)

SERVICE_REQUEST_PERSON_HISTORY

type: history entity, schedule: daily

A record of historical values for the service request person table.

• SERVICE_REQUEST_PERSON_ID (int, mandatory) → service request person
• 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
• HISTORY_START_TIME (datetime, mandatory)
• HISTORY_END_TIME (datetime)

SERVICE_REQUEST_PERSON_HISTORY_BY_DAY

type: view

For every day with data, this view returns the row in the service request person history table corresponding to midnight at the end of that day.

• HISTORY_DATE (date, mandatory) → day
• SERVICE_REQUEST_PERSON_ID (int, mandatory) → service request person
• 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
• HISTORY_START_TIME (datetime, mandatory)

SHARED_CHARGEBACK_HISTORY

type: history entity, schedule: daily

A record of historical values for the shared chargeback table.

• SHARED_CHARGEBACK_ID (int, mandatory) → shared chargeback
• 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)
• HISTORY_START_TIME (datetime, mandatory)
• HISTORY_END_TIME (datetime)

SHARED_CHARGEBACK_HISTORY_BY_DAY

type: view

For every day with data, this view returns the row in the shared chargeback history table corresponding to midnight at the end of that day.

• HISTORY_DATE (date, mandatory) → day
• SHARED_CHARGEBACK_ID (int, mandatory) → shared chargeback
• 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)
• HISTORY_START_TIME (datetime, mandatory)