This guide last modified:
2021-04-23 06:46.
.
| Database Schema Tables / Engage Report Summary Tables | |
Holds report metrics for the Nurse Summary and Nurse Detail reports.
| Column | Description | Example |
|---|---|---|
| source_id | bigint The source id of the appliance providing data. |
1 |
| source_name | varchar The source name. |
MySourceName |
| user_id | bigint The unique user id. |
554 |
| user_login | varchar The user login name. |
johnsmith |
| tier_id | bigint The unique tier id. |
411415 |
| tier_name | varchar The tier name (for example: PRIMARY, SECONDARY, TERTIARY). |
PRIMARY |
| facility_id | bigint The facility id. |
1 |
| facility_name | varchar The event facility name. |
MYHOSPITAL |
| unit_id | bigint The unique unit id. |
13 |
| unit_name | varchar The event unit name. |
16SRG |
| room_id | bigint The unique room id. |
870 |
| room_name | varchar The event room name. |
16024 |
| bed_id | bigint The unique bed id. |
942 |
| bed_name | varchar The event bed name. |
1 |
| priority_id | bigint The unique priority id. |
2 |
| priority_name | varchar The event priority name (for example: LOW, RED ALARM). |
LOW |
| event_type_id | bigint The unique event type id. |
68 |
| event_type_name | varchar The type of alarm/alert (for example: APNEA, ASYSTOLE). |
PATIENT |
| event_class_id | bigint The unique class id. |
4 |
| event_class_name | varchar The source of the alarm/alert (for example: NURSE CALLS, PATIENT MONITOR). |
NURSE CALLS |
| report_date | datetime The system-generated report date. |
2017-12-05 00:00:03.356000 |
| 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. |
0 |
| declined_count | int The number of declined alarms/alerts. |
0 |
| notresponded_count | int The number of alarms/alerts for which there was no reply. |
1 |
| avg_responded_time | double The average alarm/alert reply time. |
61.023 |
| high_accepted_time | double The longest alarm/alert accepted time. |
|
| avg_accepted_time | double The average alarm/alert accepted time. |
|
| low_accepted_time | double The shortest alarm/alert accepted time. |
|
| 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. |
61.023 |
| avg_notresponded_time | double The average alarm/alert no reply time. |
61.023 |
| low_notresponded_time | double The shortest alarm/alert no reply time. |
61.023 |
| event_delay | double The delay time between the event creation and the start of the tier. |
0.345 |
| total_time | double The total time between the eent creation and the first accept/decline response. |
This guide last modified:
2021-04-23 06:46.
.