How to connect periods of service with schedule assignments
Summary:
Hello,
I am currently trying to report on the work schedule assignments for employees with a past termination date.
Would anybody know how to connect the two tables PER_SCHEDULE_ASSIGNMENTS and PER_PERIODS_OF_SERVICE?
Code Snippet (add any code snippets that support your topic, if applicable):
SELECT DISTINCT
(SELECT DISTINCT K3.PERSON_NUMBER FROM PER_ALL_PEOPLE_F K3 WHERE K3.PERSON_ID = K2.PERSON_ID) "PERSON_NUMBER",
(SELECT DISTINCT K.SCHEDULE_NAME FROM ZMM_SR_SCHEDULES_TL K WHERE K1.SCHEDULE_ID = K.SCHEDULE_ID) "SCHEDULE_NAME",
K1.RESOURCE_TYPE,
TO_CHAR(K1.START_DATE,'MM/DD/YYYY') "START_DATE",