This guide last modified:
2021-04-23 06:46.
.
| Database Schema Tables / Engage Dimension and Fact Tables | |
Stores a distinct set of users (for example: XMPP, Care teams, delivery recipients).
| Column | Description | Example |
|---|---|---|
| user_id | bigint The unique user id. |
2 |
| user_login | varchar The user's login name. |
johnsmith |
| user_first_name | varchar The user's first name. |
John |
| user_middle_initial | varchar The user's middle initial, if provided. |
|
| user_last_name | varchar The user's last name. |
Smith |
| user_title | varchar The user's title. |
Registered Nurse I |
| user_email | varchar The user's email address. |
jsmith@companyname.com |
| user_unit_id | varchar The user's unit id. |
20 |
| user_unit_name | varchar The user's unit name. |
07PP |
| user_facility_id | varchar The user's facility id. |
1 |
| user_facility_name | varchar The user's facility name. |
MYHOSPITAL |
| created_at | datetime The creation date. |
2017-12-06 04:34:11.009000 |
| updated_at | datetime The last updated date. |
2017-12-06 04:34:11.009000 |
| source_id | bigint The source id of the appliance providing data. |
1 |
| control_id | bigint The control id, indicating when the record was loaded or updated. |
12637 |
This guide last modified:
2021-04-23 06:46.
.