Placement Periods

Placement Periods

FieldTypeDescription
id 🔑INTEGERThe unique identifier for the placement period record.
child_id 🔗INTEGERThe unique identifier for the child in this placement period.
license_id 🔗INTEGERThe ID of the license associated with this placement, if applicable.
placement_provider_id 🔗INTEGERThe ID of the placement provider (caregiver) for this placement period.
placement_start_dateDATEThe date when the child's placement began.
placement_end_dateDATEThe date when the child's placement ended, if applicable.
facility_typeSTRINGThe type of facility where the child was placed (e.g., Community Family, Private Agency, etc.).
placement_end_reasonSTRINGThe reason why the child's placement ended.
placement_period_external_idSTRINGExternal identifier for the placement period.
facility_infoSTRINGAdditional information about the placement facility.
partner_agency_placed_id 🔗INTEGERThe ID of the agency where the child is placed, if different from the child's own agency.

Key Information

Primary Keys

  • id - The unique identifier for the placement period record.

Foreign Keys

  • child_id - The unique identifier for the child in this placement period.
  • license_id - The ID of the license associated with this placement, if applicable.
  • placement_provider_id - The ID of the placement provider (caregiver) for this placement period.
  • partner_agency_placed_id - The ID of the agency where the child is placed, if different from the child's own agency.