anl_dim_department_cross

Stores denormalized crosswalk units to departments.

Table 1. anl_dim_department_cross_reference table
Column	Description
department_cross_reference_id	`bigint` The department cross-reference id.
site_id	`bigint` The unique site id.
site_name	`varchar` The site name.
facility_id	`bigint` The unique facility id.
facility_name	`varchar` The facility name.
department_id	`bigint` The unique department id.
department_name	`varchar` The department name.
facility_id	`bigint` The unique facility id.
facility_name	`varchar` The facility name.
engage_units_hash	`varchar` The Engage units hash table entry.
engage_units	`mediumtext` The Engage units.
xref_started	`datetime` The date that the cross-reference was started.
xref_ended	`datetime` The date that the cross-reference was ended.
created_at	`datetime` The date that the cross-reference was created.
control_id	`bigint` The control id, indicating when the record was loaded or updated.
source_id	`bigint` The source id of the appliance providing data.

anl_dim_department_cross_reference