BIP (Reports) – Query to check if the contact is an employee

select CASE WHEN COUNT(ppos.period_of_service_id) = 0
            THEN 'N'
            ELSE 'Y'
        END working_as_employee
from per_periods_of_service ppos
where ppos.person_id = pcr.CONTACT_PERSON_ID -- person_id of contact
and NVL(ppos.actual_termination_date, TRUNC(sysdate)) >= TRUNC(sysdate)