This guide last modified:
2021-04-23 06:46.
.
| 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 |
This guide last modified:
2021-04-23 06:46.
.