Placement Searches
Placement Searches
| Field | Type | Description |
|---|---|---|
placement_search_id š | INTEGER | The unique identifier for the placement search record. |
child_id š | INTEGER | The unique identifier for the child this placement search is for. |
agency_id š | INTEGER | The ID of the agency this placement search belongs to. |
primary_worker_id š | INTEGER | The user ID of the primary (lead) agency worker assigned to the search, if any. |
requested_at | TIMESTAMP | When the placement search was requested. |
due_at | TIMESTAMP | When the placement is due, if set. |
closed_at | DATE | When the search was closed, if it has been closed. |
reason_requested | STRING | Label for why the placement was requested. |
reason_closed | STRING | Label for how or why the search was closed, if applicable. |
created_at | TIMESTAMP | When the placement search record was created. |
updated_at | TIMESTAMP | When the placement search record was last updated. |
Key Information
Primary Keys
placement_search_id- The unique identifier for the placement search record.
Foreign Keys
child_id- The unique identifier for the child this placement search is for.agency_id- The ID of the agency this placement search belongs to.primary_worker_id- The user ID of the primary (lead) agency worker assigned to the search, if any.
Updated 20 days ago