|
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.
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. |
