Placement Search Agency Assignments
Placement Search Agency Assignments
| Field | Type | Description |
|---|---|---|
placement_search_agency_assignment_id 🔑 | INTEGER | Unique identifier for the cross-agency placement search assignment (link between the custodial search and the partner agency's search). |
originating_search_id 🔗 | INTEGER | The placement search at the custodial (originating) agency for the child or sibling group. |
originating_agency_id 🔗 | INTEGER | The agency ID of the custodial (originating) placement search. |
assigned_search_id 🔗 | INTEGER | The partner agency's linked placement search for the same child or sibling group. |
assigned_agency_id 🔗 | INTEGER | The agency ID of the partner placement search. |
response | STRING | The partner agency's response status (e.g. awaiting response, placement options available). |
detailed_response | STRING | Free-text detail from the partner agency about the response, if provided. |
responded_at | TIMESTAMP | When the partner agency responded, if a response has been recorded. |
withdrawn_at | TIMESTAMP | When the cross-agency request was withdrawn, if applicable. |
created_at | TIMESTAMP | When the placement search agency assignment record was created. |
updated_at | TIMESTAMP | When the placement search agency assignment record was last updated. |
Key Information
Primary Keys
placement_search_agency_assignment_id- Unique identifier for the cross-agency placement search assignment (link between the custodial search and the partner agency's search).
Foreign Keys
originating_search_id- The placement search at the custodial (originating) agency for the child or sibling group.originating_agency_id- The agency ID of the custodial (originating) placement search.assigned_search_id- The partner agency's linked placement search for the same child or sibling group.assigned_agency_id- The agency ID of the partner placement search.
Updated 20 days ago