case_location_code

-1 rows


Description

Contains the list of location types a user can select to indicate that where they take an action on a case. Values are Organization specific.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
case_location_code varchar 10 null
case_file.case_location_code fk_case_file__case_location_code R

A human readable code used to identify a location type.
short_description varchar 50 √ null

The short description of the location type where the case was taken.
long_description varchar 250 √ null

The long description of the location type where the case was taken.
display_order int4 10 √ null

The order in which the values of the location type should be displayed when presented to a user in a list.
active_ind bool 1 √ null

A boolean indicator to determine if the location type is active.
create_user_id varchar 32 null

The id of the user that created the location type.
create_utc_timestamp timestamp 29,6 null

The timestamp when the location type 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 location type.
update_utc_timestamp timestamp 29,6 √ null

The timestamp when the location type was updated. The timestamp is stored in UTC with no Offset.

Indexes

Constraint Name Type Sort Column(s)
PK_case_location_code Primary key Asc case_location_code

Relationships

Close relationships within degrees of separation