What's new in Customer Journeys?

Connect and learn more! ×
Public Holiday and Calendar events join with employee assignments — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Public Holiday and Calendar events join with employee assignments

Received Response
49
Views
2
Comments
edited Apr 26, 2020 2:00AM in Workforce Management 2 comments

Summary

Public Holiday and Calendar events in Exception of work schedule

Content

select eve.*

   FROM
   per_cal_event_coverage cov,
   per_calendar_events_tl ev,
   per_calendar_events eve

   where 1=1
   and cov.calendar_event_id = ev.calendar_event_id
   and ev.calendar_event_id = eve.calendar_event_id
   and eve.CATEGORY = 'PH'   --- 'Public Holiday

  Above query and tables are for calendar events that are having Public Holidays.
I need to link those tables with employee assignments. 

PER_SCHEDULE_ASSIGNMENTS
PER_SCHEDULE_EXCEPTIONS

​Please help me
   
   

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!