complaint_method_received_code

-1 rows


Description

Methods in which the complaint was received. Examples include: DGIR forward, Direct email or phone call,Minister’s office,RAPP ,Referral

Columns

Column Type Size Nulls Auto Default Children Parents Comments
complaint_method_received_code varchar 10 null
comp_mthd_recv_cd_agcy_cd_xref.complaint_method_received_code FK_comp_mthd_recv_cd_agcy_cd_xref_complaint_method_received_cod R

A human readable code used to define the method in which the complaint was received
short_description varchar 50 null

The short description of a METHOD_COMPLAINT_RECEIVED_CODE
long_description varchar 250 √ null

The long description of a METHOD_COMPLAINT_RECEIVED_CODE
display_order int4 10 null
active_ind bool 1 null

A boolean indicator to determine if the METHOD_COMPLAINT_RECEIVED_CODE is active
create_user_id varchar 32 null

The id of the user that created the wdr schedule code.
create_utc_timestamp timestamp 29,6 null

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

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

Indexes

Constraint Name Type Sort Column(s)
PK_complaint_method_received_code Primary key Asc complaint_method_received_code

Relationships

Close relationships within degrees of separation