These tables are the database schema for the Vocera Messaging Platform.
dimvmpdistributionlists
Dimension table delivering detailed insight into VMP distribution lists, and into Vocera Voice Server groups if the Vocera Voice Server is synchronized with VMP.
dimvmpdistributionlistsinuser
Dimension table delivering user details associated with VMP distribution lists. If this distribution list originates from the Vocera Voice Server, this table is not populated.
dimvmpsites
This site table is populated only when Vocera Voice Server synchronization is enabled in the VMP application.
dimvmpusers
Dimension table delivering detailed insight into VMP users.
fcttextconversation
Fact table delivering detailed insight on events and values of text-based conversations. This table is loaded if a VMP source is added or VMP data is migrated.
fcttextmessage
Fact table delivering detailed insight for text messages, including various events and associated values.
fcttextmessageusercall
Fact table delivering user details and events associated with text messages.
vmpmessages
This table is the real source for all text message activity in Vocera Voice Server, and it contains VMP text messages, email messages, and desktop messages. The data in this table is populated every five minutes from all other tables.