Hi

To uniquely identifying a task, I am using combination of PXREFOBJECTKEY and PXFLOWINSKEY from PC_ASSIGN_WORKLIST table. Now, I want to get creation date and completion date for each task. How to get the same?

My understanding is
Task Creation Date - Get PXTIMECREATED of first record from WORK_HISTORY table with PYHISTORYTYPE='A'
Task Completion Date - Get PXTIMECREATED of last record from WORK_HISTORY table with PYHISTORYTYPE='F'

If I look into work_history table then there are multiple records (>100) for one task with PYHISTORYTYPE='F'. Does that mean this task was reopened and completed multiple times?

Thanks,
Aashish