Could you please let me know how could i find the work item related to process, by using process number or GUID or by any other means.
Why I need this?? : Recently here in my client they have deleted(>1000 items) pending work items (dated <= 08/01/09) using SWWL,(I know this is not better way to do it , but they did it already). Now they implemented collision rules on the HCM forms. Due to this they are not able to instantiate any new process on employee whose pending work item was deleted. Looks like SWWL doesn't clear form related data. I verified for some of the employees in question and i could see the process is in STARTED status in the table t5asrprocesses. Now i need to find out in the system, how many employees have this problem and update corresponding tables, so that they can process the actions on employees.
I don't want to update the table t5asrprocesses with process status COMPLETED, with out checking any pending work item corresponds to it.
Please let know in which table i could find the relation between process and work item. And also let me know if you know of any other better way to solve this. if you could list out any FMs related to this, that would be more helpful.