To begin, we use Vault Pro 2012, Items to control file lifecycles, and the ECO release process for all lifecycle changes.
Does any one know how to access ECO comment data for use in report writing? We have a fairly rigorous ECO routing process, and really have need to access data in the comments of an ECO.
My two objectives are as follows:
1) Create a report that shows the "time through system" of an ECO in each stage of the routing process. What I'd like to know is the time stamp from the approval of user MaterialsApp to approval of user AccountingApp (these generic user names cover up to 5 people in a department certified to sign off on an ECO, that's another issue I'd love to see resolved in the future). It would be extra useful, since we use the comments on the approval to show who signed off on the ECO, to also pull that data for reporting so we can go back and audit/search/track/whatever for our generic users.
2) Inform the next user group in the ECO process that the ECO is "on their desk" so to speak as we try to push to fully electronic ECO approvals (ISO 14001/TS 16949 benefits). Right now everyone in the approver pool sees any ECO "In Review", and really we desire the control to say it goes to dept A->B->C->D and D doesn't see it until C signs off on it. If I could run worklists based on the last user to approve an ECO, i could quickly create worklists for all the user groups in the ECO sign off process.