SQL Query to get the no of employees assigned a Work Schedule Assignment Administration

SELECT DISTINCT SCHEDULE_NAME,
SCHEDULE_TYPE_CODE ,
ASSIGNMENT_NUM
FROM FUSION.ZMM_SR_SCHEDULES_VL
WHERE SCHEDULE_NAME LIKE '%Provide your workschedule name here%' 

I hope this blog post was helpful for you. If you have any questions or feedback, please leave a comment below.

Technical Contents - SQL Query
Posted by : Mohammad
Follow on Linkedin