---

SELECT
    d.id AS decision_id,
    d.date AS decision_date,
    d.accepted IS NOT NULL AS accepted_ok,
    p.id IS NOT NULL AS application_ok,
    sh.id IS NOT NULL AS sharer_ok,
    c.id IS NOT NULL AS contract_ok,
    im.id IS NOT NULL AS deceased_individual_ok,
    ip.id IS NOT NULL AS assignee_individual_ok,
    a.id IS NOT NULL AS agent_ok
FROM back_office.ops_assignee_decision d
LEFT JOIN ourpension.ops_assignee_payment p
    ON p.id = d.ops_assignee_payment_id
LEFT JOIN ourpension.sharer sh
    ON sh.id = p.sharer_id
LEFT JOIN ourpension.contract c
    ON c.id = sh.contract_id
LEFT JOIN ourpension.individual im
    ON im.id = sh.individual_id
LEFT JOIN ourpension.individual ip
    ON ip.id = p.assignee_id
LEFT JOIN ourpension.agent a
    ON a.id = d.agent_id
WHERE d.id = 6880;