Field Name

Explanation

CaseStartDate

Start date for a Case and key to the table MasterCalendar

CaseID (Key)

Unique Case identification

ProcessFinished

Flag 0 or 1, if Case is finished or not. Calculation based on script variable, mvProcessFinished

CaseEndDate

End date of Case

CaseLeadTime

Lead Time from Start to End

NetCaseLeadTime

Lead Time from Start to End but with subtracting the non-working-time like holidays, breaks, weekends.

TotalCaseEventDuration

Sum of all activity durations for each Case

TotalCaseIdleTIme

Sum of all waiting times for each Case

CaseLeadTimeClass

All lead times from all Cases are used to build Lead Time Classes, shows the respective class for this Case. Width/number of classes is determined by using the 75%/25% quantiles of the lead time

CaseEventDurationClass

Class for the sum of event durations per Case (similar to CaseLeadTimeClass)

CaseIdleTimeClass

Class for the sum of waiting times per Case (similar to CaseLeadTimeClass)

NetTotalCaseEventDuration

Sum of all activity durations for each Case but with subtracting the non-working-time like holidays, breaks, weekends.

NetTotalCaseIdleTIme

Sum of all waiting times for each Case but with subtracting the non-working-time like holidays, breaks, weekends.

NetCaseLeadTimeClass

All lead times from all Cases are used to build Lead Time Classes, shows the respective class for this Case. Width/number of classes is determined by using the 75%/25% quantiles of the lead time (but with subtracting the non-working-time like holidays, breaks, weekends)

NetCaseEventDurationClass

Class for the sum of event durations per Case (similar to CaseLeadTimeClass) but with subtracting the non-working-time like holidays, breaks, weekends.

NetCaseIdleTimeClass

Class for the sum of waiting times per Case (similar to CaseLeadTimeClass) but with subtracting the non-working-time like holidays, breaks, weekends.

CaseCounter

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

<CustomLeadTimeQualifier>_StartDate

Start date of Subprocess. To generate this field refer to Define Custom Lead Times.

<CustomLeadTimeQualifier>_EndDate

End date of Subprocess. To generate this field refer to Define Custom Lead Times.

<CustomLeadTimeQualifier>_LeadTime

Lead time of Subprocess. To generate this field refer to Define Custom Lead Times.

<CustomLeadTimeQualifier>_FormatCLT

Format (days, hours, minutes or seconds) of Subprocess. To generate this field refer to Define Custom Lead Times.

<CustomLeadTimeQualifier>_LeadTimeClass

Lead time class of Subprocess. To generate this field refer to Define Custom Lead Times.

<CustomLeadTimeQualifier>_formatted_LeadTime

Formatted lead time of Subprocess. To generate this field refer to Define Custom Lead Times.

(Net)CaseLeadTime_median        

Median of (net) case lead time

(Net)CaseLeadTime_average        

Average of (net) case lead time

(Net)CaseLeadTime_75Percentil

Case lead time where 75% of the cases is below and 25% is above.

(Net)CaseLeadTime_25Percentil

Case lead time where 25% of the cases is below and 75% is above.

(Net)TotalCaseEventDuration_75Percentil

Total case event duration where 75% of the cases is below and 25% is above.

(Net)TotalCaseEventDuration_25Percentil

Total case event duration where 25% of the cases is below and 75% is above.

(Net)TotalCaseIdleTime_75Percentil

Flag =1 if the (net) total case idle time is higher than the lead time of 75% of the cases, else the flag is 0.

(Net)TotalCaseIdleTime_25Percentil

Flag =1 if the (net) total case idle time is lower than the lead time of 25% of the cases, else the flag is 0.

Case Lead Time Exceeds Median

Flag =1 if the case lead time is higher than the lead time median of the cases, else the flag is 0.

Case Lead Time Exceeds Average

Flag =1 if the case lead time is higher than the lead time average of the cases, else the flag is 0.

Case Lead Time Exceeds 75 Percentile

Flag =1 if the case lead time is higher than the lead time of 75% of the cases, else the flag is 0.

Case Lead Time Below 25 Percentile

Flag =1 if the (net) case lead time is lower than the lead time of 25% of the cases, else the flag is 0.

Total Case Event Duration Exceeds 75 Percentile

Flag =1 if the total case event duration is higher than the lead time of 75% of the cases, else the flag is 0.