Archive for February, 2017

Genealogy based Audit trails in Camstar

February 6, 2017

The MES manager has been receiving calls from the QA folks regarding specific product complaints on a regular basis and spends an inordinate amount of time to figure out what went wrong. The manager wanted to find the root cause, which lot, which batch and when a particular component was produced. Historically, the audit trail served this purpose and he used it to a good extent. But the issue is, it takes time. Viewing Audit trail sometimes might get complicated, in case one is analyzing an issue and interrelated containers are involved and specially if they have long histories.

We customized the Audit trails keeping the above issues in mind to make the histories run faster and more user friendly. This is built using Camstar history APIs but with few variations.

We gave users an option, whether they want audit trail that gives entire genealogy (cross reference details) or short history which gives the details of the transactions executed directly against the interested container.

This feature enables the users to look at what they are interested precisely rather than spending time in searching in a lengthy historical data. We reduced the number of mouse clicks and key strokes needed to access the data of interest. This improved the user friendliness by expanding the details and reducing the time it takes to gain access to the critical data. We added on top of this, features like Export to excel so the manager could share that information with the quality folks. Not only that, but they can also change the sort order, exclude or include transaction reversal info etc.

This solution is heavily used and now the MES manager is free to focus on more significant areas. The necessary folks have access to the Audit trail and they can see for themselves and it brought in the much-needed transparency and accountability.

If you would like to know more about it, please feel free to reach out to me.