action_code

-1 rows


Description

Contains a list of all possible actions that can be performed on a case.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
action_code varchar 10 null
action_type_action_xref.action_code FK_action_type_action_xref__action_code R

A human readable code used to identify a case management action.
short_description varchar 250 √ null

The short description of a case management action.
long_description varchar 250 √ null

The long description of a case management action.
active_ind bool 1 √ null

A boolean indicator to determine if the case management action is active.
create_user_id varchar 32 null

The id of the user that created the case management action.
create_utc_timestamp timestamp 29,6 null

The timestamp when the case management action was created. The timestamp is stored in UTC with no Offset.
update_user_id varchar 32 √ null

The id of the user that updated the case management action.
update_utc_timestamp timestamp 29,6 √ null

The timestamp when the case management action was updated. The timestamp is stored in UTC with no Offset.

Indexes

Constraint Name Type Sort Column(s)
PK_action_code Primary key Asc action_code

Relationships

Close relationships within degrees of separation