Placement Contact Logs
Placement Contact Logs
| Field | Type | Description |
|---|---|---|
placement_contact_log_id 🔑 | INTEGER | Unique identifier for this placement contact log. |
agency_id 🔗 | INTEGER | The ID of the agency this placement contact log belongs to. |
agency_placement_id 🔗 | INTEGER | The ID of the agency placement that was contacted. |
caseworker_id 🔗 | INTEGER | The user ID of the caseworker who recorded the contact. |
user_id 🔗 | INTEGER | The user ID associated with this contact log, if any. |
message_id 🔗 | INTEGER | The ID of the automated message linked to this contact log, if any. |
availability | STRING | The availability response recorded for the contacted placement. |
why_refused | STRING | The reason the placement refused, when availability is no. |
other_explanation | STRING | Additional explanation when the refusal reason is other. |
comments | STRING | Free-text comments about the contact. |
contacted_at | TIMESTAMP | When the placement was contacted. |
created_at | TIMESTAMP | When the placement contact log record was created. |
updated_at | TIMESTAMP | When the placement contact log record was last updated. |
Key Information
Primary Keys
placement_contact_log_id- Unique identifier for this placement contact log.
Foreign Keys
agency_id- The ID of the agency this placement contact log belongs to.agency_placement_id- The ID of the agency placement that was contacted.caseworker_id- The user ID of the caseworker who recorded the contact.user_id- The user ID associated with this contact log, if any.message_id- The ID of the automated message linked to this contact log, if any.
Updated about 1 month ago
Did this page help you?