Database Schema Tables / Engage Dimension and Fact Tables |
Stores historical events.
Column | Description | Example |
---|---|---|
event_id | bigint The unique event id. |
4457523 |
event_type_id | bigint The unique event type id. |
42 |
event_type_name | varchar The type of alarm/alert (for example: APNEA, ASYSTOLE). |
IN PAIN |
parent_event_id | bigint The parent event id. If no parent event exists, use the default of -1. |
-1 |
event_class_id | bigint The event class identifier. |
4 |
event_class_name | varchar The event class, which is the source of the alarm or alert (for example: NURSE CALLS, ORDER). |
NURSE CALLS |
event_year | int The year that the event was created. |
2017 |
event_month | int The month that the event was created. |
11 |
event_day | int The day that the event was created. |
14 |
event_shift | int The shift on which the event was created. |
1 |
event_hour | int The hour at which the event was created. |
8 |
event_created_at | datetime The event creation date. |
2017-11-14 08:52:57.271000 |
event_path_id | bigint The event path id. |
|
event_path_name | varchar The event path name (for example: NURSE CALL PATH 1). |
NURSE CALL PATH 1 |
event_time | int Not populated. |
|
created_at | datetime The system-generated date that this entry was created. |
2017-12-06 04:35:48.297637 |
source_id | bigint The source id of the appliance providing data. |
1 |
control_id | bigint The control identifier, indicating when the record was loaded. |
1268 |
er_state | varchar The ER state (for example: OPEN). |
OPEN |
er_state_changed | datetime The date that the ER state was changed. |
2017-12-06 04:35:38.230000 |