Family Finding Contact Logs
Family Finding Contact Logs
| Field | Type | Description |
|---|---|---|
family_finding_contact_log_id 🔑 | INTEGER | Unique identifier for this family finding contact log. |
agency_id 🔗 | INTEGER | The ID of the agency this family finding contact log belongs to. |
worker_id 🔗 | INTEGER | The user_id of the worker who recorded the contact. |
family_finding_bulk_outreach_campaign_id 🔗 | INTEGER | The ID of the family finding bulk outreach campaign this contact log belongs to. |
contact_method | STRING | The method of contact used for this contact log. |
contacted_on | DATE | The calendar date the contact was made. |
contacted_on_time_known | BOOLEAN | Whether the date and time the contact was made is known. |
status | STRING | The status of the contact log. |
notes | STRING | The notes for this contact log. |
locked | BOOLEAN | Whether the contact log is locked. |
created_at | TIMESTAMP | The date and time the contact log was created. |
updated_at | TIMESTAMP | The date and time the contact log was last updated. |
Key Information
Primary Keys
family_finding_contact_log_id- Unique identifier for this family finding contact log.
Foreign Keys
agency_id- The ID of the agency this family finding contact log belongs to.worker_id- The user_id of the worker who recorded the contact.family_finding_bulk_outreach_campaign_id- The ID of the family finding bulk outreach campaign this contact log belongs to.
Updated 2 days ago