Determine the Parent ID of an Entity on a Case Record

This sample SQL query demonstrates how to determine the Parent ID of an entity (if it is a child entity) on a Case record via ODBC.

SELECT e.parent_id
FROM SUPPORT_INCIDENTS si
JOIN ENTITY e
ON si.company_id = e.entity_id
WHERE si.CASE_NUMBER = <case number>