CAPTUREit Database Schema Overview - CAPTUREit - Foundation 23.1 - Foundation 23.1 - AnyDoc - external

CAPTUREit

Platform
AnyDoc
Product
CAPTUREit
Release
Foundation 23.1
License

The local CAPTUREit database is an Access database file named remote50.mdb that resides in the directory C:\ProgramData\AnyDoc\CAPTUREit\CONTROL\. The database contains two tables:

  • Capture_Active

    Contains information about current batches.

  • Capture_History

    Contains information about batches released or deleted.

Both tables contain the following fields:

Field

Type

Description

RemoteProfile

Number

0 = Undefined

1 = local

2 = Remote

3 = OnTheFly

OCRFFBatchID

Text

Pre-assigned OCR for AnyDoc Batch ID Number.

DeferQATicket

Number

Internal number used for Distributed QA.

RecordKey

Number

A unique system-assigned number.

BatchCreateTime

Number

The time the batch was created.

FamilyName

Text

If the capture profile's destination is an OCR for AnyDoc form family, this is the form family file name.

BatchID

Number

The system assigned batch ID.

ServerAssignedBatchID

Number

The batch ID assigned by CAPTUREit Server.

LocalStatus

Number

The status of the batch. Status codes are:

  • 0: Idle

  • 1: Scanning

  • 2: Importing

  • 4: Pending Processing

  • 8: Preprocess

  • 16: Released

  • 32: Quality Assure

  • 64: Pending Release

  • 128: Releasing

  • 256: Complete

  • 5: Deleted

  • 1024: Failed

InActiveJobQueue

Number

 

ServerName

Text

The server to which this workstation connects to access CAPTUREit Server.

StationID

Number

The unique ID assigned to this workstation by CAPTUREit Server. This is the value of the Key field in the CAPTUREit Server database CAPTUREitStations table.

LocalCacheDirectory

Text

The path to the local cache directory for the batch.

TotalImages

Number

The total number of images in the batch.

Uploaded Images

Number

The number of images uploaded through CAPTUREit Server.

LastOCRADUpdateTime

Date/Time

The date and time of the last message from OCR for AnyDoc for this batch. In the Capture_Active table, this is always 12:00:00 AM, because the batches have not yet been sent to OCR for AnyDoc. In the Capture_History table, this value is 12:00:00 AM for batches whose destination was not OCR for AnyDoc.

LastOCRADUpdate

Number

The last message received from OCR for AnyDoc for this batch. In the Capture_Active table, this is always -1, because the batches have not yet been sent to OCR for AnyDoc. In the Capture_History table, this value is -1 for batches whose destination was not OCR for AnyDoc. In the Capture_History table, the values are: 1Imported 2Committed 3Deleted

LastImprinter

Text

The last imprinter string in the batch.

FirstImprinter

Text

The first imprinter string in the batch.

UserBatchID

Text

The user defined batch control number.

DocSets

Number

The number of document sets in the batch.

ServerBatchKey

Number

-1 for local batches. For batches sent to a remote directory or to OCR for AnyDoc via CAPTUREit Server, this is the unique ID assigned to the batch by CAPTUREit Server.

ProfileMode

Number

The type of profile: 0 = Remote to OCR for AnyDoc via CAPTUREit Server 1 = Local Capture to Sub-Directory 2 = Remote to Directory via CAPTUREit Server 3 = On The Fly Capture 4 = Local Capture to FTP

BatchUploadTimeSecs

Number

The number of seconds required to upload the batch.

BatchCompleteTime

Number

The time the batch was completed.

ProfileName

Text

The capture profile name.

PatchTCount

Number

The number of Patch T patch code pages scanned.

Patch1Count

Number

The number of Patch 1 patch code pages scanned.

Patch2Count

Number

The number of Patch 2 patch code pages scanned.

Patch3Count

Number

The number of Patch 3 patch code pages scanned.

Patch4Count

Number

The number of Patch 4 patch code pages scanned.

Patch6Count

Number

The number of Patch 6 patch code pages scanned.

PatchTDocSet

Number

The number of document sets that appear after a Patch T patch code page.

Patch1DocSet

Number

The number of document sets that appear after a Patch 1 patch code page.

Patch2DocSet

Number

The number of document sets that appear after a Patch 2 patch code page.

Patch3DocSet

Number

The number of document sets that appear after a Patch 3 patch code page.

Patch4DocSet

Number

The number of document sets that appear after a Patch 4 patch code page.

Patch6DocSet

Number

The number of document sets that appear after a Patch 6 patch code page.