agency_code

-1 rows


Description

An agency is an organized and named grouping of people that interacts in some way with the Ministry.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
agency_code varchar 10 null
comp_mthd_recv_cd_agcy_cd_xref.agency_code FK_comp_mthd_recv_cd_agcy_cd_xref_agencycode R
complaint.owned_by_agency_code FK_complaint_owned_by_agencycode R
complaint_type_code.agency_code FK_complaint_type_code_agency_code R
feature_agency_xref.agency_code FK_agencycode R
geo_org_unit_structure.agency_code FK_gorgustrct_agencycode R
team.agency_code team_agency_code_fk R
violation_code.agency_code FK_violation_code_agency_code R

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

The short description of the agency code.
long_description varchar 250 √ null

The long description of the agency code.
display_order int4 10 null

The order in which the values of the agency code table should be displayed when presented to a user in a list.
active_ind bool 1 null

A boolean indicator to determine if the agency code is active.
create_user_id varchar 32 null

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

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

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

Indexes

Constraint Name Type Sort Column(s)
PK_agengycode Primary key Asc agency_code

Relationships

Close relationships within degrees of separation