You must enable javascript in order to view this page or you can go
here
to view the webhelp.
Vocera Analytics Database Schema Guide
Content
Search
Loading, please wait ...
How Vocera Analytics Works
Supported Vocera Products
Hardware Requirements
Hardware Details
Customer Deployment Sizing
Database Schema Tables
Vocera Voice Server Dimension Tables
dim_device_use_status
dim_interrupttypes_detail
dimdevices
dimdevicestatus
dimdevicetypes_generic
dimgroups
dimgroupsusers
dimgroupsdepartments
diminterrupttypes
dimlicenseinfo
dimlocationaccesspoints
dimlocations
dimschedulererrors
dimseverity
dimsites
dimunansweredreason
dimusers
dimusersbuddies
dimusersdepartments
dimvmiclients
dimvmiresponse
Vocera Voice Server Fact Tables
dnd
fctactionsongroup
fctaudit
fctcalls
fctdeviceactivity
fctdevicefirmware
fctdevicestatuschange
fctemailmessages
fctgeniesession
fctlogins
fctmessageactivity
fctrecresults
fctserverspeechchannelstatsevent
fctsimultaneoususerbyfacility
fcttelephony
fctvmiactions
fctvmievent
fctvmimessages
vmialerts
Summary Tables
summarycalls
summarydeviceactivity
summaryengagedata
summarymessages
summaryspeech
summaryspeechlocation
summaryspeechowninggroup
summaryspeechuser
summaryvmialerts
VMP Tables
dimvmpdistributionlists
dimvmpdistributionlistsinuser
dimvmpsites
dimvmpusers
fcttextconversation
fcttextconversationparticipant
fcttextconversationrcpdistlist
fcttextconversationrcpuser
fcttextmessage
fcttextmessageusercall
vmpmessages
Engage Dimension and Fact Tables
anl_conversation_history
anl_conversation_message_history
anl_conversation_message_recipient_history
anl_dim_activity_states
anl_dim_application_versions
anl_dim_beds
anl_dim_care_team_members
anl_dim_care_teams
anl_dim_conversation_types
anl_dim_department_cross_reference
anl_dim_departments
anl_dim_device_status
anl_dim_device_vendors
anl_dim_devices
anl_dim_event_classes
anl_dim_event_paths
anl_dim_event_types
anl_dim_facilities
anl_dim_hardware_versions
anl_dim_os_versions
anl_dim_priorities
anl_dim_recipients
anl_dim_rooms
anl_dim_site_cross_reference
anl_dim_sites
anl_dim_sources
anl_dim_states
anl_dim_tiers
anl_dim_units
anl_dim_user_devices
anl_dim_users
anl_event_child_history
anl_event_delivery_detail_history
anl_event_delivery_history
anl_event_detail_history
anl_event_history
anl_event_location_history
anl_event_response_history
anl_registration_transaction_history
Engage Report Summary Tables
anl_rpt_bed_summary_detail
anl_rpt_mobile_user_activity
anl_rpt_nurse_detail
anl_rpt_unit_summary_detail
CrossWalk Tables
cwfacility
cwunit
Database View Tables
v_dimgroups
v_dimgroupsdepartments
v_dimgroupsusers
v_dimsites
v_dimusers
v_dimusersgroups
v_fctcalls
v_groupconversations
v_vmpusers
Legal Notices
Download PDF Documentation
Your browser does not support iframes.