Placement Searches

Placement Searches

FieldTypeDescription
placement_search_id 🔑INTEGERThe unique identifier for the placement search record.
child_id 🔗INTEGERThe unique identifier for the child this placement search is for.
agency_id 🔗INTEGERThe ID of the agency this placement search belongs to.
primary_worker_id 🔗INTEGERThe user ID of the primary (lead) agency worker assigned to the search, if any.
requested_atTIMESTAMPWhen the placement search was requested.
due_atTIMESTAMPWhen the placement is due, if set.
closed_atDATEWhen the search was closed, if it has been closed.
reason_requestedSTRINGLabel for why the placement was requested.
reason_closedSTRINGLabel for how or why the search was closed, if applicable.
created_atTIMESTAMPWhen the placement search record was created.
updated_atTIMESTAMPWhen 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.