Want to understand about the fields Finished and Lastupdated in DB Table bpaworkqueueitem

[Sheela]

Hi All,

I would like to understand about the fields Finished and Lastupdated in DB Table bpaworkqueueitem.

For one of the Item in queue, we can see the completed&finished value are set as same(eg Feb 12) but lastupdated value as other(eg Feb 13).

If there is any update on the item, then finished value also should be updated. But it is not updated.

I would like to understand when these fields get updated. 

Appreciate your response.

BP Version  used is V6.10.2

Regards,

Sheela

------------------------------
Sheela Parthasarathy
Assistant Vice President
Deutsche Bank Group
Pacific/Apia
------------------------------

[steven.boggs]

Hi Sheela,

In the BPAWorkQueueItem table, the Finished column is defined as "the date the item was finished (ie. exceptioned or completed), null if it is not finished." 

LastUpdated is "Date that the item last changed - ie. loaded or finished."

So it's possible that while the item in question was exceptioned or completed, it may have been loaded at a later date/time to reflect the data shown in the LastUpdated column.

You can request Data Dictionary and Database Schema Definitions documentation (made available under NDA) by opening a request with us in Support and providing the relevant Blue Prism version. See this KB here for more information.

------------------------------
Steve Boggs
Senior Product Support Engineer
Blue Prism
Austin, TX
------------------------------