Request for Assistance: Seeking Clarification on Placements Data

[Cantare John]

I want to have more information about Placements such as status, parent status, etc. I am using this request to get all placements:

{
    "pageSize": 10000,
    "query": "SELECT detail_placement_view.display_name, detail_placement_view.group_placement_target_url, detail_placement_view.placement, detail_placement_view.placement_type, detail_placement_view.resource_name, detail_placement_view.target_url FROM detail_placement_view"
}

But the status is not there as a field. I tried to search in campaign_criterion or ad_group_criterion by setting the type to Placements, but I couldn't find an id that links Placements from the first query with the response coming from the second query.