| Database Schema Tables / Engage Dimension and Fact Tables | |
Stores a distinct set of states.
| Column | Description | Example |
|---|---|---|
| state_id | bigint The unique state id. |
1 |
| state | varchar The event state (PRIMARY, SECONDARY, TERTIARY). |
NOCAREGIVERS |
| created_at | datetime The creation date. |
2017-12-06 04:38:08.089000 |
| updated_at | datetime The last updated date. |
2017-12-06 04:38:08.089000 |
| 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. |
12639 |