Components installed with Workplace Connectors
Several types of components are installed with the installation of the Workplace Connectors application, including user roles and tables.
Roles installed with Workplace Connectors
| 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 | 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
- 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.