Cross Walk Table Maintenance

The Crosswalk tables provide a mechanism to cross walk between Voice Server and Engage Appliance schemas to apply filtering on Dashboards and Reports.

Reports and Dashboard filters are dependent on the information contained in the cwfacility and cwunit Cross Walk tables. The Cross Walk tables provide a mechanism to cross walk between Vocera Voice Server (VS) and Engage Appliance schemas and maintain the relationship between Site-Facility and Department-Unit for applying filter criteria on Dashboards and Reports.

Automatic Updates: For the following configurations, the records for VS only or Vocera Engage Appliance only are updated automatically every day at 12:05 am. Configurations that contain both VS and Engage Appliance require that Site-Facility and Department-Unit be configured utilizing the site management workflow in the Vocera Engage appliance.

Manual Updates: To manually update the cross walk table, you can use any SQL client tool such as HeidiSQL or MySQL Workbench using the following Call statement:

CALL vocera_analytics.UpdateCrosswalkTable();

Engage Appliance workflow pages allow you to select from a list of existing sites, or create new sites that can then be associated with Engage Facilities. This will improve the quality of the relationships since it contains known facilities and units.

Currently, the Dashboard and Report UI filters use the common unit name, that is mapped by default to the Engage facility. Mapping vs_department_name requires the internal name of the Voice Server Department. No placeholder names can exist without this format. Otherwise, dashboard data may display multiple records for each unit.