Please enable JavaScript to view this site.

 

 

This table is central for the MPM Template App as it contains the event log information and further dimensions and metrics that has been calculated by the MPM Process Mining method.

 

Extract from the pa_activity_log table:

pa_activity_log table

 

If you want to enhance the template application with visualizations and KPIs, the Qlik Sense® self-service offers you the possibility to easily create new objects in the edit mode of your app. The most important data for a process-related visualization is provided by the process log table "pa_activtiy_log" that is created by the MPM Algorithms.

To use it for your own KPIs etc., the following description of the table gives you a good overwiew:

 

Field Name

Example

Explanation

UniqueCaseActivityRow

4500774918_67290

Combination of CaseID & UniqueSortedRowNo; relevant for proper sorting. Always unique.

CaseID (Key)

4500774918

Unique Case identification (e.g. purchase order, sales order)

ActivityCounter

1

Help field for calculating the number of events that have occured

ActivityStartTimestamp

01.06.2017 00:00:00

Derived timestamp (start of activity)

ActivityEndTimestamp

01.06.2017 01:12:52

Derived timestamp (end of activity)

ActivityType

Create Purchase Requisition

Name of event

ActivityTypeID

1

ID of occuring event

ActivityUserName

User

Name of resource

ActivityGroupID

12

Group to which the Activity belongs. Can be customized in the script.

EdgeID

1-22

ID of edge between two occuring events based on ActivityTypeID

EdgeType

Create Purchase Requisition

Send Purchase Order (PRINT)

Name of edge

nextActivityID

22

ID of next edge

nextActivityTimestamp

05.06.2017 17:21:51

Start timestamp of next event

nextActivityType

Send Purchase Order (PRINT)

Name of next event

ProcessPath

0-1-22-99999999

Sequence of the ActivityTypeIDs of the identified process - containing or not direct loops, which depends on the mwSurpressLoops variable.

ProcessPathUniqueNo

1

ID of a process path

ProcessPathWithLoops

0-1-22-22-99999999

Sequence of the ActivityTypeIDs of the identified process - containing direct loops.

ProcessPath_RelatedDimensionKey

1_Supplier12

Key for conformance checking, to apply dimension related happy paths on the process path.

ProcessStepDuration

4 17:21:51

Calculated duration of an event (start - end)

ProcessStepPreviousIdleTime

2 12:21:32

Calculated duration of the edge before an event (waiting time until the start of the event)

ProcessStepFollowUpIdleTime

1 10:13:25

Calculated duration of the edge after an event (waiting time from the end of the event to the start of the following event)

NetProcessStepDuration

4 17:21:51

Calculated duration of an event (start - end)

NetProcessStepPreviousIdleTime

1 12:21:32

Calculated duration of the edge before an event (waiting time until the start of the event) but with subtracting the non-working-time like holidays, breaks, weekends.

NetProcessStepFollowUpIdleTime

0 10:13:25

Calculated duration of the edge after an event (waiting time from the end of the event to the start of the following event) but with subtracting the non-working-time like holidays, breaks, weekends.

OvertimeFlag

1

Shows if the work was done outside of an offical shift. 1 means overtimes were worked, 0 means, the work took place within a shift.

RealEdge

1

Indicator whether it's a virtual (start/end) edge or a real edge. 0 = Start or End.

RealNode

1

Indicator whether it's a virtual (start/end) event or a real event.. 0 = Start or End

MPM_Scenario        

P2P

If more than on MPM Scenario is loaded.

UniqueSortedRowNo

67290

Unique line ID after sorting events/edges. Not unique when delta load is used.

 

© by MEHRWERK GmbH