04-22-2020 10:07 AM
Hello everyone! OnBase Novice-Newbie here!!
In researching tables and data for an internal reconciliation process, I am using the table "hsi.ItemData". In this table there is a field named "batchnum". The only table I have found relevant to my usage is "ProcessingLog". The batchnum field is in that multiple times, so I tend to believe there is another table where the original, unique "key" value is generated and used. The problem I am having, is, finding that batch number. I have literally scoured all tables in the database (4,218) I have access to, which include dbo, hsi and sys schemas.
Can anyone help with advice or tips of where to find this value, or will I be able to rely on the ProcessingLog table with (relative) confidence?
I appreciate, and am grateful for, anyone's advice.
Thank you all in advance!!
JT
04-22-2020 10:15 AM
Hi JT,
If you are using OnBase 17 or below, you are interested in the hsi.archivedqueue table, which holds a record for all of the batches processed in the system. In OnBase 18, we changed the functionality so that only batches currently in processing are stored in hsi.archivedqueue and committed batches are stored in hsi.archivedcommitq.
You can find the most recent version of the Database Reporting Guide here which also explains this.
Hope this helps,
Joel
04-22-2020 10:17 AM
Hey JT,
You may be looking for the 'archivedqueue' or 'parsedqueue' tables.
If you haven't already, I would download the 'Database Reporting Guide' from Community. The information is limited, but it will help.
04-22-2020 10:18 AM
Hi JT,
Have you looked at the database reporting guide? The newest version for EP2 has a batch table diagram on page 145.
The tables listed there include these that use the batchnum value:
ITEMDATA
ARCHIVEDQUEUE
SCANNINGLOG
PARSEDQUEUE
PROCESSINGLOG
Find what you came for
We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.