Placement Periods

Field	Type	Description
`id` 🔑	INTEGER	Legacy row identifier (same value as placement_period_id).
`placement_period_id`	INTEGER	The unique identifier for the placement period record.
`child_id` 🔗	INTEGER	The unique identifier for the child in this placement period.
`license_id` 🔗	INTEGER	The ID of the license associated with this placement, if applicable.
`placement_provider_id` 🔗	INTEGER	The ID of the profile associated with the placement provider (caregiver) for this placement period.
`agency_placement_id` 🔗	INTEGER	The ID of the agency placement associated with this placement period.
`placement_start_date`	DATE	The date when the child's placement began.
`placement_end_date`	DATE	The date when the child's placement ended, if applicable.
`respite_placement`	BOOLEAN	Boolean where true indicates that the placement period was with a respite provider.
`facility_type`	STRING	The type of facility where the child was placed (e.g., Community Family, Private Agency, etc.).
`placement_end_reason`	STRING	The reason why the child's placement ended.
`placement_period_external_id`	STRING	External identifier for the placement period.
`facility_info`	STRING	Additional information about the placement facility.
`partner_agency_placed_id` 🔗	INTEGER	The ID of the agency where the child is placed, if different from the child's own agency.

Key Information

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 profile associated with the placement provider (caregiver) for this placement period.
agency_placement_id - The ID of the agency placement associated with 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.