Tables [dbo].[OCR_CONTENTS]
Optical Character Recognition table. Contains the recognized text on a docuemnt.
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Cluster Primary Key PK_OCR_CONTENTS: QIDQIDint4NOT NULL1 - 1Key to the OCR_Contents table
InsertTimedatetime8NULL allowed(getdate())Date OCR conversion started.
Indexes IX_OCR_CONTENTS_IMAGEIDImageIDvarchar(50)50NOT NULLImage. Link to doc_detail.imageid, batch_detail.imageid, or file cabinet (ie FCD0000001.imageid)
FileTypeint4NOT NULLID of filetype. (1 = .tif, 501 = .pdf, 505 = .tiff etc)
ContenttextmaxNULL allowedThe interpreted text from the image
TimeStamptimestamp8NULL allowedA timestamp of when the interpretation finished
OCRElapsedTimeint4NULL allowedHow long the interpretation took