anl_dim_states

Stores a distinct set of states.

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