|
The EventCalendar Table |
Scroll Previous Topic Top Next Topic More |
This table contains information about the events timestamp like on which workday, holiday or in which shift it took place. This table is only calculated when the shift calendar is activated and the variable mvCalculateEventCalendar is set to 1.
Field Name |
Explanation |
ActivityDate |
The date on which the event took place. |
weekday_Event |
The weekday on which the event took place. |
weekendWork |
If the event took place on the weekend, 1 = yes, 0 = no. |
standardWorkday |
If the event took place on a standard workday (Mo-Fr), 1 = yes, 0 = no. |
holiday |
If the day was a holiday. |
isWorkday |
If the event took place on a workday (depending on shifts), 1 = yes, 0 = no. |
shift |
The shift in which the event took place. |
startTime |
The shift's start time. |
endTime |
The shift's end time. |
ActivityStartTimestamp |
The key to the pa_activity_log. |
