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.

ParetoPercentage

Cumulative number of cases covered by the process variant and the more frequent variants.

ParetoClassVariant

The field has three different values: A, B and C. These values describe the process variants by ABC-Analysis. A-variants are the most common process variants that make up 80 percent of all cases. B-variants are those variants that cover the next 15% of cases and the last 5% of cases are covered by the C-variants.

VariantComposition

The variant composition describes by which activity types a process variant is composed. The possible values are A; A,B ; A,B,C ; A,C ; B; BC and C.

AVGWaitingTimeOnNextActivity

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