agency_code

-1 rows


Description

Contains a list of all the organizations that have been onboarded onto the Case Management System. This can be used to restrict some content to organization specific values.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
agency_code varchar 10 null
case_file.owned_by_agency_code FK_case_file__owned_by_agency_code R
decision.lead_agency_code fk_decision__lead_agency_code R
inaction_reason_code.agency_code FK_inaction_reason_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.
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.
display_order int4 10 √ null

The order in which the values of the agency should be displayed when presented to a user in a list.

Indexes

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

Relationships

Close relationships within degrees of separation