Tables installed with Facilities Visualization Workbench

  • Release version: Washingtondc
  • Updated February 1, 2024
  • 1 minute to read

    • Facilities visualization workbench adds the following tables.

    Table Description
    Building

    [alm_building]

    		 Stores building records
    Bathroom

    [fm_bathroom]

    		 Stores bathroom records
    Campus

    [fm_campus]

    		 Stores campus records
    Conference Room

    [fm_conference_room]

    		 Stores conference room records
    Cubicle

    [fm_cubicle]

    		 Stores cubicle records
    Elevator

    [fm_elevator]

    		 Stores elevator records
    Hallway

    [fm_hallway]

    		 Stores hallway records
    Level

    [fm_level]

    		 Stores level records
    Spaces to Zones

    [fm_m2m_space_to_zone]

    		 Stores space assignment to zone records
    Associated User

    [fm_m2m_user_to_space]

    		 Stores associated user records
    Associated Department

    [fm_m2m_department_to_space]

    		 Stores associated department records
    Office

    [fm_office]

    		 Stores office records
    Point

    [fm_point]

    		 Stores point records
    Facility Space

    [fm_space]

    		 Stores facility space records
    Stairs

    [fm_stairs]

    		 Stores stairs records
    Facility Zone

    [fm_zone]

    		 Stores zones records
    Facilities Data

    [imp_facilities_data]

    		 Import set table used as the source for transforming facilities space records
    Facilities Floor Data

    [imp_facilities_level_data]

    		 Import set table used as the source for transforming facilities floors
    Facility Map Option

    [fm_map_option]

    		 Specify what space types show labels by default
    Facility Map Task Option

    [fm_map_task]

    		 Specify what task types can be seen on a map
    Facility Feature

    [fm_facility_feature]

    		 Specify what features are parsed
    Space Icon Mapping

    [fm_m2m_space_icon]

    		 Associate an icon with a space
    Facilities Map Menu Item

    [fm_map_menu_item]

    		 Specify what catalog items are available on a map
    Fm Map Filter

    [fm_map_filter]

    		 Create a custom filter for a map
    Facilities Map Set Transformed

    [fm_map_set_transformed]

    		 Holds transformed GeoJSON as attachments, with the transformation showing the map in a "straight up" manner
    Facility Icon

    [fm_icon]

    		 Specify icons that can be added to the map
    Facilities Map Set

    [fm_map_set]

    		 Holds GeoJSON files as attachments
    Facility Map Color

    [fm_map_color]

    		 Specifies map colors