| Database Schema Tables / Engage Dimension and Fact Tables | |
Stores a distinct set of crosswalk departments.
| Column | Description |
|---|---|
| department_id | bigint The unique department id. |
| department_name | varchar The department name. |
| site_id | bigint The unique site identifier. |
| site_name | varchar The site name. |
| created_at | datetime The date that the message was created. |
| updated_at | datetime The date that the message was updated. |
| control_id | bigint Control identifier, indicating when the record was loaded or updated. |
| source_id | bigint The source id of the appliance providing data. |