Vocera Voice Server Dimension Tables

Dimension tables contain descriptive attributes (or fields) that are typically textual fields (or discrete numbers that behave like text). These tables will be used mostly for populating filter data.

dim_device_use_status
Dimension table pertaining to device use status. It is populated when Vocera Analytics is installed. Values from this table are used in Asset dashboards and reports.
dim_interrupttypes_detail
Specifies interrupt types one level down. This table is populated when Vocera Analytics is installed.
dimdevices
Dimension table delivering details for devices (badges) and smartphones on which the VCS client is installed. These details include the MAC address, serial number, label, status tracking time, owning group, site id, whether the device is shared, and the internal name.
dimdevicestatus
Dimension table delivering details on device status. This table is populated from the Vocera Voice Server.
dimdevicetypes_generic
Dimension Table delivering device type details in more generic form.
dimgroups
Dimension table delivering group details, including hierarchy details and alias group names. Vocera Voice Server groups, departments, and sub-departments are populated in this table.
dimgroupsusers
Dimension table delivering detailed associativity for users to groups.
dimgroupsdepartments
Dimension table delivering detailed associativity between group and department.
diminterrupttypes
Specifies the interrupt types.
dimlicenseinfo
Table for storing Vocera Voice Server license information.
dimlocationaccesspoints
Dimension table delivering details on the location of access points.
dimlocations
Dimension table delivering location details.
dimschedulererrors
Dimension table delivering the id and name of the error categories that may occur in the report scheduler.
dimseverity
Dimension table delivering the severity type of Vocera Voice Server interrupts.
dimsites
Dimension table delivering information on Vocera Voice Server sites.
dimunansweredreason
Dimension Table delivering the list of all reasons that a call interruption can be left unanswered.
dimusers
Dimension table delivering detailed associativity for Vocera Voice Server user details.
dimusersbuddies
Dimension table delivering details on Vocera Voice Server users and their buddies, which are the users frequently called by each user in the table.
dimusersdepartments
Dimension table delivering information on Vocera Voice Server users associated with departments.
dimvmiclients
Stores the VMI client ids.
dimvmiresponse
Information on VMI responses.

Parent topic: Database Schema Tables