Database Schema Tables / Engage Dimension and Fact Tables |
Stores a distinct set of beds.
Column | Description | Example |
---|---|---|
facility_id | bigint The unique facility id. |
1 |
unit_id | bigint The unique unit id. |
7 |
room_id | bigint The unique room id. |
103 |
bed_id | bigint The unique bed id. |
10 |
facility_name | varchar The facility name for the event. |
MYHOSP |
unit_name | varchar The unit name for the event. |
06PP |
room_name | varchar The room name for the event. |
6029 |
bed_name | varchar The bed name for the event. |
1 |
created_at | datetime The creation date. |
2017-12-06 04:37:15.910000 |
updated_at | datetime The last updated date. |
2017-12-06 04:37:15.910000 |
control_id | bigint The control id, indicating when the record was loaded or updated. |
12639 |
source_id | bigint The source id of the appliance providing data. |
1 |