Components installed with Workplace Connectors

Release version: Australia

Updated March 12, 2026

3 minutes to read

Summarize

Summarized using AI

Summary of Components Installed with Workplace Connectors

The Workplace Connectors application installs several components, including user roles and tables, essential for managing and integrating workplace data effectively. Understanding these components is crucial for leveraging the application's capabilities in your organization.

Show full answer Show less

Key Features

User Roles:
- snwsdwc.manager: Grants read access to all data, including dashboards.
- snwsdwc.user: Provides limited read access as configured by administrators.
- snwsdwc.admin: Offers administrative access for configuration and setup.
Installed Tables:
- Providers: Stores Space Occupancy sensor data.
- Connector Configuration: Manages connector settings for data integration.
- Employee Attendance Data: Imports and stores employee badging data.
- Provider Execution: Records timestamps for scheduled job executions.
- Connector Events: Loads badging data from vendors to the attendance table.
- Environmental Data: Manages sensor data related to air quality and temperature.
- Archived Data: Separate tables for archiving environmental and occupancy data.
Scheduled Jobs: Automates data processing tasks at defined intervals, such as processing webhook provider data every minute and refreshing space mapping records daily.

Key Outcomes

Implementing the Workplace Connectors application allows organizations to efficiently manage workplace data, enhance visibility into occupancy and attendance, and streamline integration with external data sources. As a result, teams can make informed decisions based on real-time data insights and improve overall workplace management.

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.
Employee Attendance Data [sn_wsd_wc_employee_attendance_data]	Employee Attendance data table is the target table to which data is imported from the source table (Badging data table). This table holds badging data information of employees, like user id, badging time along with any other event defined in the connectors.
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.
Providers (sn_wsd_wc_provider)	Stores Space Occupancy sensor data provided by occupancy data providers.
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_type_mapping]	Stores Workplace Core location records.
Action Configuration [sn_wsd_wc_action_config]	Stores actions, subflows, and transform definitions from Metrikus Spoke.
Space Occupancy Data [sn_wsd_wc_space_occupancy]	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.
Environmental Data [sn_wsd_wc_space_environment]	Stores data for environmental sensor data (air and temperature levels for a workplace location). For more information, see Configure environmental sensor data for a workplace location.
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.
Archive Environmental Data [ar_sn_wsd_wc_space_environment]	Archives environmental data. For more information see Archive and purge Environmental data.
Archive Space Occupancy [ar_sn_wsd_wc_space_occupancy]	Archives space occpancy data. For more information, see Archive and Purge space occupancy 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.