Field Name

Explanation

ActivityStartDate

The ActivityStartDate serves as key to connect each case’s start date with the EventCalendar table. One ActivityStarteDate can refer to several cases (which then have the same start date).

Events_ExampleProcess_MonthYearID

An identifier for the combined year and month of the date.

Events_ExampleProcess_AvailableWorkingTime

The sum of sift hours per day, the available working time on the specific date.

Events_ExampleProcess_day

Gives the weekday of the date.

Events_ExampleProcess_week

Gives the week of the date.

Events_ExampleProcess_week_previous

Gives the previous week of the date.

Events_ExampleProcess_month

Gives the abbreviated month name of the date: Dec

Events_ExampleProcess_month_no

Gives the month number of the date: 9

Events_ExampleProcess_quarter

Gives the quarter of the date: 3

Events_ExampleProcess_year

Gives the week of the date: 2021

Events_ExampleProcess_year_monthname

Gives a combined year-month expression for the date: 2021-Jan

Events_ExampleProcess_year_week

Gives a combined year-week expression for the date: 2012-45

Events_ExampleProcess_year_month

Gives a combined year-month expression for the date: 2021-09

Events_ExampleProcess_workday

1 or 0 if the date's day is a value between Monday and Friday

Events_ExampleProcess_weekend

1 or 0 if the date's day is weekend or not

Events_ExampleProcess_days_ago

This field stores how many days have passed between the current date and the last reload date or the maximum date in the process data (depending on the configuration in the mpmX back-end).

Events_ExampleProcess_months_ago

This field stores how many months have passed between the current date and the last reload date or the maximum date in the process data (depending on the configuration in the mpmX back-end).

Events_ExampleProcess_yearPrevious

Gives the previous year of the date.

Events_ExampleProcess_fiscal_year

Gives the fiscal year of the date.

Events_ExampleProcess_fiscal_quarter

Gives the fiscal quarter of the date.

Events_ExampleProcess_fiscal_week

Gives the fiscal week of the date.

Events_ExampleProcess_fiscal_month

Gives the abbreviated fiscal month name of the date.

Events_ExampleProcess_YTD

This field marks if a date is or is not in the relevant time range to be considered as “year to date”, containing 1 or 0 as value.

Events_ExampleProcess_FYTD

This field marks if a date is or is not in the relevant time range to be considered as “fiscal year to date”, containing 1 or 0 as a value.

Events_ExampleProcess_MTD

This field marks if a date is or is not in the relevant time range to be considered as “month to date”, containing 1 or 0 as a value.

Field Name

Explanation

CaseStartDate

The CaseStartDate serves as key to connect each case’s start date with the MasterCalendar table. One CaseStarteDate can refer to several cases (which then have the same start date).

ExampleProcess_MonthYearID

An identifier for the combined year and month of the date.

ExampleProcess_AvailableWorkingTime

The sum of sift hours per day, the available working time on the specific date.

ExampleProcess_day

Gives the weekday of the date.

ExampleProcess_week

Gives the week of the date.

ExampleProcess_week_current

Gives the previous week of the date.

ExampleProcess_week_previous

Gives the abbreviated month name of the date: Dec

ExampleProcess_month

Gives the month number of the date: 9

ExampleProcess_month_no

Gives the quarter of the date: 3

ExampleProcess_month_current

Gives the week of the date: 2021

ExampleProcess_quarter

Gives a combined year-month expression for the date: 2021-Jan

ExampleProcess_year

Gives a combined year-week expression for the date: 2012-45

ExampleProcess_year_monthname

Gives a combined year-month expression for the date: 2021-09

ExampleProcess_year_week

1 or 0 if the date's day is a value between Monday and Friday

ExampleProcess_year_month

1 or 0 if the date's day is weekend or not

ExampleProcess_workday

1 or 0 if the date's day is a value between Monday and Friday

ExampleProcess_weekend

1 or 0 if the date's day is weekend or not

ExampleProcess_days_ago

This field stores how many days have passed between the current date and the last reload date or the maximum date in the process data (depending on the configuration in the mpmX back-end).

ExampleProcess_months_ago

This field stores how many months have passed between the current date and the last reload date or the maximum date in the process data (depending on the configuration in the mpmX back-end).

ExampleProcess_yearPrevious

Gives the previous year of the date.

ExampleProcess_fiscal_year

Gives the fiscal year of the date.

ExampleProcess_fiscal_quarter

Gives the fiscal quarter of the date.

ExampleProcess_fiscal_week

Gives the fiscal week of the date.

ExampleProcess_fiscal_month

Gives the abbreviated fiscal month name of the date.

ExampleProcess_YTD

This field marks if a date is or is not in the relevant time range to be considered as “year to date”, containing 1 or 0 as value.

ExampleProcess_FYTD

This field marks if a date is or is not in the relevant time range to be considered as “fiscal year to date”, containing 1 or 0 as a value.

ExampleProcess_MTD

This field marks if a date is or is not in the relevant time range to be considered as “month to date”, containing 1 or 0 as a value.

ExampleProcess_AvailableNetWorkingTime

The available net working time on a certain date. This field is only calculated when the shift calendar is activated.