Components installed with Workplace Connectors

  • Release version: Yokohama
  • Updated January 30, 2025
  • 2 minutes to read

    • Several types of components are installed with the installation of the Workplace Connectors application, including user roles and tables.

    Note:
    The Application Files table lists the components that are installed with this application.

    Roles installed with Workplace Connectors

    Table 1. User roles
    Role title [name] Description Contains roles
    sn_wsd_wc.manager Provides read access to all data including Occupancy Dashboard and other dashboards. sn_wsd_wc.user
    sn_wsd_wc.admin Provides admin access to configure and set up the Workplace Connectors application. sn_wsd_wc.manager
    sn_wsd_wc.user Provides read access to only a few columns and fields. The read access is set up by administrators. None

    Tables installed with Workplace Connectors

    Table 2. Table components
    Table Description
    Providers [sn_wsd_wc_provider] Stores Space Occupancy sensor data provided by occupancy data providers.
    Connector Configuration

    [sn_wsd_wc_connector_config]

    		 Configures a connector to connect with the integration framework. This configuration fetches the data from the integration to workplace applications.

    This table holds information about the workplace connectors that are defined in the application. For example, Badging data, Occupancy sensors, and so on. This table can also process data for each of the connectors through extension points.
    Provider Execution

    [sn_wsd_wc_provider_execution]

    Stores all the scheduled job execution timestamps. Every time the scheduled job Process Provider data record runs, this table has an entry for the last query time. The time taken to import data from the source table (Badging data) to the target table (Employee attendance data) table is updated in the Last query time.

    t
    Provider connector configuration

    [sn_wsd_wc_provider_config]

    		 Stores provider data (Occupancy or badging). Imports data from the source table to the target table.
    Connector Events

    [sn_wsd_wc_connector_events]

    		 The Connector Events table (sn_wsd_wc_connector_events) loads the badging data shared by badging vendors.

    The Scheduled Job Process webhook provider data records runs every minute to load the badging data from the Connector Events table (data with State New) to the Employee Attendance Data table. For more information, see Configure a webhook event.
    Provider Space Type Mapping sn_wsd_wc_provider_space_type_mapping Stores mapping between Workplace Core space or location records and sensor provider data records for occupancy data.
    Provider Space Mapping [sn_wsd_wc_provider_space_mapping] Stores external Ids shared by a sensor provider, for example, Metrikus. The external Ids from sensors providers are mapped with spaces shared by Workplace Connectors.
    Action Configuration [sn_wsd_wc_action_config] Stores actions, subflows, and transform definitions from Metrikus Spoke.
    Badging Data [sn_wsd_wc_badging_data] Stores employee badging data details.
    Badging Data Choices [sn_wsd_wc_badging_data_choice] Stores the badging status details for Swipe-in and Swipe-out event types.
    Occupancy and Environment Data [sn_wsd_wc_occ_env_data] Stores data for occupancy and envirnment data such as carbon dioxide value, ozone, sound, light, temperature, pressure, and humidity levels for a workplace location.
    Wi-fi Data [sn_wsd_wc_wifi_data] Stores Wi-Fi data.
    Unit of Measure [sn_wsd_wc_unit_of_measure] Unit of measure for air, temperature, VOC, and so on. For more information, see Set up the Units of measure data table for environmental sensors.
    Space Occupancy Daily Summary Data [sn_wsd_wc_space_occupancy_daily_summary_data] Stores space occupancy daily summary data.
    Wi-Fi Daily Summary Data [sn_wsd_wc_wifi_daily_summary_data] Stores Wi-Fi daily summary data.
    Environmental Daily Summary Data [sn_wsd_wc_environmental_daily_summary_data] Stores environmental daily summary data.
    Environmental Hourly Summary Data [sn_wsd_wc_environmental_hourly_summary_data] Stores environmental hourly summary data.

    Scheduled job

    Navigate to All > System Definition > Scheduled jobs. Search for Workplace Connectors in the Application column.
    • Process webhook provider data records: Runs every minute to process webhook event provider data records. For more information, see Configure a webhook event.
    • Process provider data records; Runs every 5 minutes to process provider data records in Workplace Connectors.
    • Refresh Provider Space Mapping records: Runs daily runs daily and executes the space filter condition on the Provider Connector configuration table for the active records where the Auto-refresh field is set to True. For more information, see Provider Connector Configuration.