ProcessPathUniqueNo (Key)

Unique Number for a process variant, used to link the table to the pa_activity_log_Helpdesk

ProcessStartsWithActivityTypeID

ActivityTypeID for the first activity of a variant, can be used as a filter

ProcessStartsWithActivityType

Activity Type name for the first activity of a variant, can be used as a filter

ProcessEndWithActivityTypeID

ActivityTypeID for the last activity of a variant, can be used as a filter

ProcessEndWithActivityType

Activity Type name for the last activity of a variant, can be used as a filter

For each activity there is a field with the ActivityName. The values are 0 and 1. The field is used to filter on variants that include(1)/exclude(0) that activity (e.g. Insert ticket -> 1, filter all variants with Insert Ticket)

pathVariant_Counter

Field to efficiently calculate the distinct number of process variants

AVGWaitingTimeOnNextActivity

Field from the process path continuation calculation. Avg waiting time for the next activity, if the process is not finished.

NetAVGWaitingTimeOnNextActivity

Field from the process path continuation calculation. Net avg waiting time for the next activity, if the process is not finished.