Thank you for your reply! I found a test preview of the table which was shared by a classmate. You can see that the EventID is the unique value. ProcessID CH1 is the process I have described in the example in my first post. You can see that several employees can have the same ProcessID. ProcessID describes what kind of process it is, while EventID contains each individual process. The proper order for the CH1 is select - open - check - close. In this case for employee David Kent we can derive from the start and endtime that the order is open - check - close for EventID 2756899. (Lets assume that the step "select" for this EventID was also displayed in this preview and that the end time was before the "open" step). This sequence for EventID 2756899 would count as proper order. I hope this clarifies it a bit.
... View more