Database Schema Tables
Parent topic
:
Database Schema Tables
Engage Dimension and Fact Tables
These tables contain Engage data and its associated descriptive information.
Note:
For dimensional data, the source_id field enables
Vocera Analytics
to distinguish between distinct sets of values.
anl_conversation_history
Stores historical conversations.
anl_conversation_message_history
Stores historical messages tied to a conversation.
anl_conversation_message_recipient_history
Stores historical message recipients for each message in a conversation.
anl_dim_activity_states
Stores a distinct set of activity states.
anl_dim_application_versions
Stores a distinct set of application versions.
anl_dim_beds
Stores a distinct set of beds.
anl_dim_care_team_members
Stores a distinct set of care team members, normalized by each member.
anl_dim_care_teams
Stores a distinct set of care teams.
anl_dim_conversation_types
Stores a distinct set of conversation types.
anl_dim_department_cross_reference
Stores denormalized crosswalk units to departments.
anl_dim_departments
Stores a distinct set of crosswalk departments.
anl_dim_device_status
Stores a distinct set of device statuses.
anl_dim_device_vendors
Stores a distinct set of device vendors.
anl_dim_devices
Stores devices and associated attributes: hardware version, line number, OS version, UUID, vendor where applicable.
anl_dim_event_classes
Stores a distinct set of event classes.
anl_dim_event_paths
Stores a distinct set of event paths (for example: Clinical Path 1, Clinical Path 2).
anl_dim_event_types
Stores a distinct set of alert/alarm types.
anl_dim_facilities
Stores a distinct set of facilities.
anl_dim_hardware_versions
Stores a distinct set of device hardware versions.
anl_dim_os_versions
Stores a distinct set of device OS versions.
anl_dim_priorities
Stores a distinct set of priorities.
anl_dim_recipients
Stores a distinct set of delivery recipients.
anl_dim_rooms
Stores a distinct set of rooms for a given unit and facility.
anl_dim_site_cross_reference
Stores denormalized crosswalk facilities to sites.
anl_dim_sites
Stores a distinct set of crosswalk sites.
anl_dim_sources
Stores a distinct set of appliances.
anl_dim_states
Stores a distinct set of states.
anl_dim_tiers
Stores a distinct set of tiers of escalation for each event. These tiers are used in the client's alert escalation strategy.
anl_dim_units
Stores a distinct set of units for a given facility.
anl_dim_user_devices
Stores users and device use over time (use start, use end).
anl_dim_users
Stores a distinct set of users (for example: XMPP, Care teams, delivery recipients).
anl_event_child_history
Tracks the child event for reprocessing (ETL only, not for reports).
anl_event_delivery_detail_history
Stores historical deliveries details tied to an event as deliveries change over time.
anl_event_delivery_history
Stores historical deliveries tied to an event.
anl_event_detail_history
Stores historical event details/states as the events change over time.
anl_event_history
Stores historical events.
anl_event_location_history
Stores historical event location/facility/unit/room/bed as the events change over time.
anl_event_response_history
Stores historical responses tied to an event.
anl_registration_transaction_history
Stores historical device registration.