anl_dim_event_paths

Stores a distinct set of event paths (for example: Clinical Path 1, Clinical Path 2).

Table 1. anl_dim_event_paths table
Column Description Example
event_path_id

bigint

The unique path identifier.

1
event_path_name

varchar

The path name (for example: NURSE CALL PATH 1, UNDELIVERED, SUPPRESSED).

NURSE CALL PATH 1
created_at

datetime

The creation date.

2017-12-06 04:35:27.461000
updated_at

datetime

The last updated date.

2017-12-06 04:35:27.461000
control_id

bigint

The control id, indicating when the record was loaded or updated.

12638
source_id

bigint

The source id of the appliance providing data.

1