inaction_reason_code

-1 rows


Description

Contains the list of available reasons a user can select to indicate that the reason why they did not take any action on a case. Values are Organization specific.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
inaction_reason_code varchar 10 null
case_file.inaction_reason_code FK_case_file__inaction_reason_code R

A human readable code used to identify a reason why no action on the case was taken.
agency_code varchar 10 null
agency_code.agency_code FK_inaction_reason_code__agency_code R

A human readable code used to identify an agency.
short_description varchar 50 √ null

The short description of the reason why no action on the case was taken.
long_description varchar 250 √ null

The long description of the reason why no action on the case was taken.
display_order int4 10 √ null

The order in which the values of the reasons why no action on the case was taken should be displayed when presented to a user in a list.
active_ind bool 1 √ null

A boolean indicator to determine if the reason why no action on the case was taken is active.
create_user_id varchar 32 null

The id of the user that created the reason why no action on the case was taken.
create_utc_timestamp timestamp 29,6 null

The timestamp when the reason why no action on the case was taken 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 reason why no action on the case was taken.
update_utc_timestamp timestamp 29,6 √ null

The timestamp when the reason why no action on the case was taken was updated. The timestamp is stored in UTC with no Offset.

Indexes

Constraint Name Type Sort Column(s)
PK_inaction_reason_code Primary key Asc inaction_reason_code

Relationships

Close relationships within degrees of separation