lead

-1 rows


Description

A lead is any potential issue that an agency is made aware of. This could be a complaint, referral, etc. A lead needs to be evaluated to determine if it will become a case.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
lead_identifier varchar 20 null

Natural key for a complaint generated by an external system.
case_identifier uuid 2147483647 null
case_file.case_file_guid FK_lead__case_identifier R

System generated unique key for a case. This key should never be exposed to users via any system utilizing the tables.
create_user_id varchar 32 null

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

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

The timestamp when the complaint/case relationship was updated. The timestamp is stored in UTC with no Offset.

Indexes

Constraint Name Type Sort Column(s)
PK_lead_identifier Primary key Asc lead_identifier

Relationships

Close relationships within degrees of separation