Decipher DB Flags Column

[bbobo]

Is there any documentation on the flags column in the Batches table? I'm hoping to use that column as an indicator for if a specific batch needs to be verified. From what I can tell they are laid out as follows: 

• Ready for Export = Starts with '107564'
• Ready for Data Verification = Starts with '104901'
• Ready for Class Verification = Starts with '104899' 

Is that an accurate interpretation or will those numbers change? I know from v1.1 to v1.2 the flags seemed to change but it's not a big deal if we have to update those values as part of an upgrade process. 

Thanks!

[Ben.Lyons1]

Hi Ben,

The flags don't give you current status of a batch, I have several deleted batches with the same status as one waiting for verification.

However, you can get some pf this from the 'State' column using the key below.

• 0 – Invalid
• 1 – UserCreating – The batch is being created by user
• 2 – UserSending – The batch is being sent by user
• 3 – UserReceiving – The batch is being received by user
• 4 – UserProcessing – The batch is being processed by user
• 5 – ReadyForProcessing – The batch is ready to be processed by next role
• 6 – Finished – The batch has finished the processing by all defined roles and is exported
• 7 – Closed – The batch has been manually closed. It stops appearing in the list of active batches, but all data about its documents and pages is stored, so it can be opened again in the future.
• 8 – AutoClosed – The batch has been automatically closed. The system automatically closes a batch if all its documents have been closed manually (for now only in Admin station). If one of the documents is opened by an admin, its batch will be automatically opened.
• 9 – Deleted – The batch has been explicitly deleted – it cannot be recovered anymore because the deletion removes its image data. The object metadata is still in the system and can be seen during Reporting (information about which batches are deleted, why, when etc.)
• 10 – UserUploading – The batch is currently being uploaded (directly using files) by the user application
• 11 – WaitingForImageProcessing – The batch created from file(s) upload is waiting for image processing
• 12 – InImageProcessing – The batch created from file(s) upload is in image processing. The input files of the batch are sent simultaneously to the available Image Processing clients
• 100 – Exception – The batch has been classified as an exception

Thanks

Ben