This guide last modified:
2021-04-23 06:46.
.
| Database Schema Tables / Engage Dimension and Fact Tables | |
Stores a distinct set of rooms for a given unit and facility.
| Column | Description | Example |
|---|---|---|
| facility_id | bigint The unique facility id. |
1 |
| unit_id | bigint The unique unit id. |
12 |
| room_id | bigint The unique room id. |
3 |
| facility_name | varchar The facility name. |
MYHOSPITAL |
| unit_name | varchar The unit name. |
14SRG |
| room_name | varchar The room name. |
14003 |
| created_at | datetime The creation date. |
2017-12-06 04:36:51.052000 |
| updated_at | datetime The last updated date. |
2017-12-06 04:36:51.052000 |
| 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 |
This guide last modified:
2021-04-23 06:46.
.