Our Commissioner's Office is migrating from one Revenue System to another in a few months. System A's account number is used in a field that talks to a SQL table to auto-populate other fields and that account number field is used by Workflow to auto-name documents, file documents, etc. This same concept will need to be applied using system B's account number after migration.
We could have a table where column A is system A account # and column B is system B account #. I've tested out running a workflow in our development environment to retrieve the current account number (A), query a table of fictitious account numbers (B), and update the field with the new account number. It works on a small set of documents tested.
After the account number fields are updated, documents will need to be reprocessed through the auto-workflow that in addition to naming, and filing as stated above, assigns record management properties, creates shortcuts, in some cases even multiple shortcuts, etc. A LOT of branches in play, many conditional. It is possible that by the time we get to migration we will have 120,000+ documents in this repository to reprocess.
Is there a more efficient way of updating a field in mass than what I have described? Has anyone here reprocessed an extremely large number of documents through a workflow that has numerous branches like this? Is there a "best practice" for this scenario?
Ultimately, we are looking for guidance on both field update process efficiency and process timing, ways of preventing Workflow from "locking up" by processing too many documents at once, or any other "gotchas".
I attached the conversion testing workflow and a file that shows the number of branches on the autofile workflow, not that you can read the details, just to provide an idea of the number of conditional steps that exist.