complaint_referral

-1 rows


Description

Used to track complaint refer actions from an agency to a different agency.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
complaint_referral_guid uuid 2147483647 uuid_generate_v4()

System generated unique key for the referral action.
complaint_identifier varchar 20 null
complaint.complaint_identifier FK_cmplreferral__complaint R

A human readable code used to identify a complaint being referred.
referred_by_agency_code varchar 10 null
agency_code.agency_code FK_cmplreferral__referred_by_agency_code R

The agency that a complaint being reffered from.
referred_to_agency_code varchar 10 null
agency_code.agency_code FK_cmplreferral__referred_to_agency_code R

The agency that a complaint being reffered to.
officer_guid uuid 2147483647 null
officer.officer_guid FK_cmplreferral__officer_guid R

Unique key for an officer who refers a complaint. This key should never be exposed to users via any system utilizing the tables.
referral_date timestamp 29,6 now()

The timestamp when referring a complaint was created. The timestamp is stored in UTC with no offset.
referral_reason varchar 500 null

The reason why refer a complaint.
create_user_id varchar 32 null

The id of the user that refer a complaint.
create_utc_timestamp timestamp 29,6 now()

The timestamp when referring a complaint was created. The timestamp is stored in UTC with no Offset.
update_user_id varchar 32 null

The id of the user that updated referring a complaint.
update_utc_timestamp timestamp 29,6 now()

The timestamp when referring a complaint was updated. The timestamp is stored in UTC with no Offset.
active_ind bool 1 true

A boolean indicator to determine if refer complaint feature is active.

Indexes

Constraint Name Type Sort Column(s)
PK_cmplreferral Primary key Asc complaint_referral_guid

Relationships

Close relationships within degrees of separation