comp_mthd_recv_cd_agcy_cd_xref

-1 rows


Description

complaint_method_received_code and AGENCIES that allow for features to be displayed or hidden as required.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
comp_mthd_recv_cd_agcy_cd_xref_guid uuid 2147483647 uuid_generate_v4()
complaint.comp_mthd_recv_cd_agcy_cd_xref_guid complaint_comp_mthd_recv_cd_agcy_cd_xref_fk R
agency_code varchar 10 null
agency_code.agency_code FK_comp_mthd_recv_cd_agcy_cd_xref_agencycode R

A human readable code used to identify an AGENCY.
complaint_method_received_code varchar 10 null
complaint_method_received_code.complaint_method_received_code FK_comp_mthd_recv_cd_agcy_cd_xref_complaint_method_received_cod R

A human readable code used to identify a complaint_method_received_code that is controlled by the comp_mthd_recv_cd_agcy_cd_xref table.
active_ind bool 1 null

A boolean indicator to determine if the complaint_method_received_code should be rendered the for users in the given AGENCY
create_user_id varchar 32 null

The id of the user that created the complaint_method_received_code / AGENCY mapping.
create_utc_timestamp timestamp 29,6 null

The timestamp when the complaint_method_received_code / AGENCY mapping 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 complaint_method_received_code / AGENCY mapping
update_utc_timestamp timestamp 29,6 null

The timestamp when the complaint_method_received_code / AGENCY mapping was updated. The timestamp is stored in UTC with no Offset.

Indexes

Constraint Name Type Sort Column(s)
PK_comp_mthd_recv_cd_agcy_cd_xref Primary key Asc comp_mthd_recv_cd_agcy_cd_xref_guid
UK_comp_mthd_recv_cd_agcy_cd_xref Must be unique Asc/Asc agency_code + complaint_method_received_code

Relationships

Close relationships within degrees of separation