Database Schema Tables / Engage Dimension and Fact Tables |
Stores a distinct set of event paths (for example: Clinical Path 1, Clinical Path 2).
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 |