|
The CaseTimes Table |
Scroll Previous Topic Top Next Topic More |
This table contains information about the individual PPIs of a case, such as the total case idle time classes between the process start and the process end of the subprocesses. The table contains one row per case per subprocess and one row per case which measures the process lead time from start to end. The table is created automatically by the mpmX analytics methods.
Field Name |
Explanation |
CaseStartDate |
Start date for a Case and key to the table MasterCalendar. |
%CaseID |
The field contains the unique case identification. |
Subprocess |
Partial processes for which the lead time and other time related measures will be calculated. |
SubprocessFinished |
Flag 0 or 1, if the subprocess is finished or not. |
SubprocessStartDate |
Start date for a subprocess. |
SubprocessEndDate |
End date for a subprocess. |
CaseLeadTime |
Lead Time from start to end. |
SubProcessCurrentLeadTime |
Displays the current lead time of the subprocess. |
TotalCaseEventDuration |
The field contains the sum of all activity durations for each case. |
TotalCaseIdleTime |
The field contains the sum of all waiting times for each case. |
CaseLeadTimeClass |
All lead times from all cases are used to build Lead Time Classes to show 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). |
SubprocessTargetTimeMissed |
Flag 0 or 1, if the subprocess target time is missed or not. |
SubprocessTargetTime |
Indicates the subprocess target time. |
SubprocessTargetTimeOperator |
Specifies whether the subprocess target time is a desired upper or lower limit. |
SubprocessStartTime |
The start time of the subprocess. |
SubprocessEndTime |
The end time of the subprocess. |
.
