Need to report on Work schedule with attached work pattern and attached holiday
Summary:
Hi Every one,
I need help to develop one absence report where we can see work schedule and attached exceptions and workday/non workday.
Below is sample output:-
Content (please ensure you mask any confidential information):
SCHEDULE_ID | SCHEDULE_NAME | PATTERN_ID | PATTERN_NAME | PATTERN_LENGTH_DAYS_NUM | YEAR_DATE | WEEKDAY_NAME | DAY_TYPE | HOLIDAY_FLAG | HOLIDAY_NAME |
|---|---|---|---|---|---|---|---|---|---|
300000138661565 | SCH_1 | 300000138661536 | MON,TUE,WED,THU,FRI,SAT,SUN | 7 | 2024/01/01 | MON | Workday | N | |
300000138661565 | SCH_1 | 300000138661536 | MON,TUE,WED,THU,FRI,SAT,SUN | 7 | 2024/01/02 | TUE | Workday | N | |
300000138661565 | SCH_1 | 300000138661536 | MON,TUE,WED,THU,FRI,SAT,SUN | 7 | 2024/01/03 | WED | Workday | N |
Version (include the version you are using, if applicable):
0