CAPTUREitActive - CAPTUREit - Foundation 23.1 - Foundation 23.1 - AnyDoc - external - AnyDoc/CAPTUREit/Foundation-23.1/CAPTUREit/Installation/CAPTUREit-Server-Database-Schema/CAPTUREitActive - 2023-11-17

CAPTUREit

Platform
AnyDoc
Product
CAPTUREit
Release
Foundation 23.1
License

This table contains information regarding active batches in the system across all CAPTUREit stations currently monitored by this server.

Column Name

Description

ServerBatchKey

Contains a batch ID that is unique across all stations monitored by this server.

DomainName

The Network Domain of the CAPTUREit station that produced the batch. DomainName/ComputerName uniquely identifies the CAPTUREit workstation.

OCRFFBatchID

Pre-assigned OCR For AnyDoc Batch ID Number

DeferQATicket

Internal number used for Distributed QA

LocalBatchID

The ID given to the server by the CAPTUREit station. It matches the appropriate batch's LocalBatchID in CAPTUREit.

ProfileName

The CAPTUREit profile name the batch was created in.

FamilyName

This column is not used.

CreateDateTime

The date and time this batch was created, according to the CAPTUREit station.

Status

The station's current status. The status number can be translated into text by looking up the appropriate row in the CAPTUREitStatuses table.

ComputerName

The CAPTUREit station's network ID that produced the batch.

TotalImages

The total number of batch images.

UploadedImages

The number of images that have been uploaded to the server.

UploadTime

The amount of time the batch took to upload to the server.

ProfileMode

The profile's mode when the batch was created. The mode corresponds to one of the following values:

  • Remote to OCRAD
  • Local to subdirectory
  • On the fly processing
  • FTP

UserBatchID

The user supplied batch number (if applicable).

OriginalImages

The original number of images imported.

DocSets

The number of document sets in the batch.

LastUpdate

The last time the batch was updated on the server.

FirstImprinter

The imprinter string for the first image scanned.

LastImprinter

The imprinter string for the last image scanned.

Last_OCRAD_Message

The last message received from OCRAD for this batch. The message numbers correspond to one of the following values:

  • None
  • Imported
  • Commited
  • Deleted

Last_OCRAD_Date

The date/time when the last message was received from OCRAD, according to the OCRAD station posting this message.