The EventCalendar Table

Zoom Window Out
Larger Text | Smaller Text
Hide Page Header
Show Expanding Text
Printable Version
Provide Feedback
Save Permalink URL

Navigation: Developer Guide > Understand the MPM Data Model > Understand the MPM Core Tables

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.

Please enable JavaScript to view this site.