Question

1
Replies
774
Views
Aashisho Member since 2017 1 post
Amazon
Posted: 3 years ago
Last activity: 3 years ago
Closed

Completion date for a task from WORK_HISTORY table

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

Data Integration
Moderation Team has archived post
Share this page LinkedIn