anl_event_history

Stores historical events.

Table 1. anl_event_history table
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