The following query shows all currently active work relationships for rehired employees:
select *
from per_periods_of_service
where person_id in
(select person_id
from per_periods_of_service
group by person_id
having count(*)>1
)
January 3, 2021
**Business Consulting*Proof of concepts*Skill Enhancement***
The following query shows all currently active work relationships for rehired employees:
select *
from per_periods_of_service
where person_id in
(select person_id
from per_periods_of_service
group by person_id
having count(*)>1
)