Field Name

Explanation

CaseStartDate

Start date for a Case and the key to the table MasterCalendar

%CaseID

Unique Case identification which is the key to the pa_activity_log table

CaseCounter

Counter that can be used to efficiently count the cases (sum(CaseCounter))

ProcessFinished

Flag is 1 if case is finished and 0 if not. Calculation is based on script variable, mvProcessFinished

CaseEndDate

End date of case

Target processing time missed

Processes with a summed processing time (event duration) above or below a defined threshold

Target idle time missed

Processes with a summed waiting time above or below a defined threshold

Target lead time missed

Processes with a lead time above or below a defined threshold

<Subprocess> target time missed

For each subprocess a flag is addes, that indicates whether the subprocess lead time is above or below a defined threshold

Low process governance

Processes with a process governance below a defined threshold

Low automation rate

Processes with an automation rate below a defined threshold

Reworked Case

Processes that contain at least one rework activity

B-Activity Case

Processes that contain b-activities

C-Activity Case

Processes that contain c-activities

CaseID

Unique case identification