anl_dim_departments

Stores a distinct set of crosswalk departments.

Table 1. anl_dim_departments table
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.