case_file

-1 rows


Description

The central entity of the case management system.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
case_file_guid uuid 2147483647 case_management.uuid_generate_v4()
action.case_guid FK_action__case_guid R
authorization_permit.case_file_guid fk_authorization_permit__case_file_guid R
case_note.case_file_guid FK_case_note__case_file_guid R
decision.case_file_guid fk_decision__case_file_guid R
lead.case_identifier FK_lead__case_identifier R
site.case_file_guid fk_site__case_file_guid R
wildlife.case_file_guid fk_wildlife__case_file_guid R

System generated unique key for a case. This key should never be exposed to users via any system utilizing the tables.
case_code varchar 10 null
case_code.case_code FK_case_file__case_code R

A human readable code used to identify a case type.
owned_by_agency_code varchar 10 null
agency_code.agency_code FK_case_file__owned_by_agency_code R

A human readable code used to identify the agency that owns this case.
inaction_reason_code varchar 10 √ null
inaction_reason_code.inaction_reason_code FK_case_file__inaction_reason_code R

A human readable code used to identify a reason why no action on the case was taken.
action_not_required_ind bool 1 √ null

True only if no action required was explicitly indicated for the case. It is assumed that action is required if not set.
review_required_ind bool 1 √ null

A flag to indicate that a further review of the file by a supervisor is required.
create_user_id varchar 32 null

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

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

The timestamp when the case was updated. The timestamp is stored in UTC with no Offset.
complainant_contacted_ind bool 1 √ null

A boolean indicator to determine if complainant is contacted.
attended_ind bool 1 √ null

A boolean indicator to determine if the COS officer attended the assessment.
case_location_code varchar 10 √ null
case_location_code.case_location_code fk_case_file__case_location_code R

A human readable code used to identify a location type.
case_conflict_history_code varchar 10 √ null
conflict_history_code.conflict_history_code fk_case_file__case_conflict_history_code R

A human readable code used to identify a conflict history type.
case_threat_level_code varchar 10 √ null
threat_level_code.threat_level_code fk_case_file__case_threat_level_code R

A human readable code used to identify a threat level type.

Indexes

Constraint Name Type Sort Column(s)
PK_case_file_guid Primary key Asc case_file_guid

Relationships

Close relationships within degrees of separation