Supervision Level Log Table - Sirius Case Management

The historic supervision level log for deputies

Stability: The supervision_level_log table is to be considered unstable .

Analytical Platform : Yes

Alternative formats : JSON

supervision_level_log table columns
Column Name Column Type Character Maximum Is Nullable Default Constrained values
id integer NO
order_id integer YES
appliesfrom date NO
createddate timestamp without time zone YES
supervisionlevel character varying 255 YES NULL::character varying GENERAL,
MINIMAL,
notes text NO
assetlevel character varying 255 YES NULL::character varying HIGH,
LOW,
UNKNOWN,