Vocera Analytics Database Schema Guide

Content
Search
Loading, please wait ...

Loading

  • 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