This guide last modified:
2021-04-23 06:46.
.
| Database Schema Tables / Engage Report Summary Tables | |
Holds report metrics for the Unit Summary and Unit Summary Detail reports.
| Column | Description | Example |
|---|---|---|
| source_id | bigint The source id of the appliance providing data. |
1 |
| source_name | varchar The source name. |
MySourceName |
| report_date | datetime The system-generated report date. |
2017-12-05 00:00:00.000000 |
| tier_id | bigint The unique tier id. |
411344 |
| tier_name | varchar The tier name (for example: PRIMARY, SECONDARY, TERTIARY, NOCAREGIVERS). |
PRIMARY |
| facility_id | bigint The unique facility id. |
1 |
| facility_name | varchar The event facility name. |
MYHOSPITAL |
| unit_id | bigint The unique unit id. |
27 |
| unit_name | varchar The event unit name. |
PACU |
| priority_id | bigint The unique priority id. |
3 |
| priority_name | varchar The event priority name (for example: HARD INOP, LOW). |
HARD INOP |
| event_class_id | bigint The unique class id. |
3 |
| event_class_name | varchar The source of the alarm/alert (for example: PATIENT MONITOR, NURSE CALLS). |
|
| event_type_id | bigint The unique event type id. |
12 |
| event_type_name | varchar The type of alarm/alert (for example: APNEA, ASYSTOLE). |
***LEADS OFF |
| event_count | int The total number of alarms/alerts. |
1 |
| delivered_count | int The number of delivered alarms/alerts. |
1 |
| accepted_count | int The number of accepted alarms/alerts. |
1 |
| declined_count | int The number of declined alarms/alerts. |
0 |
| notresponded_count | int The number of alarms/alerts for which there was no reply. |
0 |
| avg_responded_time | double The average alarm/alert reply time. |
20.246 |
| high_accepted_time | double The longest alarm/alert accepted time. |
20.246 |
| avg_accepted_time | double The average alarm/alert accepted time. |
20.246 |
| low_accepted_time | double The shortest alarm/alert accepted time. |
20.246 |
| high_declined_time | double The longest alarm/alert declined time. |
|
| avg_declined_time | double The average alarm/alert declined time. |
|
| low_declined_time | double The shortest alarm/alert declined time. |
|
| high_notresponded_time | double The longest alarm/alert no reply time. |
|
| avg_notresponded_time | double The average alarm/alert no reply time. |
|
| low_notresponded_time | double The shortest alarm/alert no reply time. |
|
| event_delay | double The delay time between the event creation and the start of the tier. |
0.323 |
| total_time | double The total time between the event creation and the first accept/decline response. |
21.045 |
This guide last modified:
2021-04-23 06:46.
.