View: V_FieldPerDocument

Available in XBOUND 3.8 and later. Extended in XBOUND 3.8.1.

This view contains processed Capture values for a field. The data is provided by the Agent for Reporting.

This view provides the number of processed fields for the Capture Statistic report and the Detailed Capture Statistics report.

Column	Description
FieldID	The ID of the field (FieldID in W_FieldReport).
OCRValue	The field value after the last OCR process step (Cat=OCR). (OCRValue in W_FieldReport.)
OCRValid	The status of the field after the last OCR process step (Cat=OCR). (OCRValid in W_FieldReport.)
CorrectValue	The field value of the last corrective OCR process step (Cat=CORR). (CorrectValue in W_FieldReport.)
CorrectValid	The status of the field after the last corrective OCR process step (Cat=CORR). (CorrectValid in W_FieldReport.)
FieldEvaluation	0 = CorrectValid (AUTOM_VALUE = CORR_VALUE and AUTOM_VALID = Valid) 1 = Substitution (AUTOM_VALUE <> CORR_VALUE and AUTOM_VALID = Valid) 2 = SuggestionCorrect (AUTOM_VALUE = CORR_VALUE and AUTOM_VALID <> Valid) 3 = SuggestionWithFault (AUTOM_VALUE <> CORR_VALUE and AUTOM_VALID <> Valid 4 = NoEval (no OCR_Value) (FieldEvaluation in W_FieldReport).
AutomValue	The field value after the last automatic process step (Cat=AUTOM). (AutomValue in W_FieldReport.)
AutomValid	The status of the field after the last automatic process step (Cat=AUTOM). (AutomValid in W_FieldReport.)
CaptureEndValue	The value reported after the last process step that is configured in the XBOUND reporting category as the capture end point (CaptureEndValue in W_FieldReport). For more information, see XBOUND Help topic "Configuring a reporting category".
CaptureEndValid	The status of the field after the last process step that is configured in the XBOUND reporting category as the capture end point (CaptureEndValid in W_FieldReport).
Name	The name of the field (Name in W_Field).
Type	The field type (Type in W_Field). Possible values: 0 = group 1 = string 2 = integer 3 = float 4 = datetime
VarcharValue	Field value when Type=1 (string). (VarcharValue in W_FieldReport.)
IntValue	Field value when Type=2 (int). (IntValue in W_FiedlHistory.)
FloatValue	Field value when Type=3 (float). (FloatValue in W_FieldReport.)
DatetimeValue	Field value when Type=4 (datetime). (DatetimeValue in W_FieldReport.)
BatchID	The ID of the root document (BatchID in W_Document).
ProcessID	The ID of the process (ProcessID in W_Document).
ProcessName	The name of the process.
OriginalDocType	The name of the document type when the document was first created (Name in C_DocType).
DocumentID	The ID of the document (ID in W_Document).
DocCorrectValid	The number of error-free fields. (Sum of fields in this document for which FieldEvalution=0 in the W_FieldReport table.)*
Substitutions	The number of fields with substitution errors. (Sum of fields in this document for which FieldEvaluation=1 in W_FieldReport.)*
SuggestionCorrect	The number of fields with correct field suggestions. (Sum of fields in this document for which FieldEvaluation=2 in W_FieldReport.)*
SuggestionFaulty	The number of fields with incorrect field suggestions. (Sum of fields in this document for which FieldEvaluation=3 in W_FieldReport.)*
OcrTime	The total length of time during which the document was checked out by an OCR activity (Cat=OCR). (CheckOutDuration from W_Step.)
OcrDate	The date of the last OCR activity (Cat=OCR) for this document.
VerifyDate	The date of the last Verify activity (Cat=CORR) for this document.
OriginalDocTypeID	The document type when the document was first created. (ID in C_DocType.)
ReclassifiedTypeID	The document type after the last process step that is configured in the XBOUND reporting category as the Capture end point (IsCaptureEnd in C_ProcessStep). This is the value of ID in C_DocType. For more information, see XBOUND Help topic "Configuring a reporting category".
OrigClassField	The value of the business_class field after the last automatic process step (Cat=Autom).
FinalClassField	The value of the business_class field after the last process step that is configured in the XBOUND reporting category as the Capture end point (IsCaptureEnd in C_ProcessStep).
ReclassifiedField	Currently not used.
CurrentSheetCount	The number of sheets for this document in the last step.
CurrentPageCount	The number of pages for this document in the last step.
CurrentImageCount	The number of images for this document in the last step.
LastStep	The last process step that was performed on this document. Unique identifier (StepID in W_Step).
ReclassifiedDocType	The name of the document type after the last process step that is configured in the XBOUND reporting category as the Capture end point (IsCaptureEnd in C_ProcessStep). For more information, see XBOUND Help topic "Configuring a reporting category".
VerifyDateOnly	Only the date (without the time) from the VerifyDate field in W_DocReport.
CreatedAt	When the document was created (CreatedAt in W_Document).
DocCreateDateOnly	Only the date (without the time) from the CreatedAt field in W_Document.

* For more information see the description of the FieldEvaluation column in W_FieldReport.

SQL Script

CREATE VIEW [dbo].[V_FieldPerDocument]
AS
SELECT  dbo.W_FieldReport.FieldID,dbo.W_FieldReport.OCRValue, dbo.W_FieldReport.OCRValid, 
	        dbo.W_FieldReport.CorrectValue, dbo.W_FieldReport.CorrectValid, dbo.W_FieldReport.FieldEvaluation, dbo.W_FieldReport.AutomValue, 
	        dbo.W_FieldReport.AutomValid, dbo.W_FieldReport.CaptureEndValue, dbo.W_FieldReport.CaptureEndValid, dbo.W_Field.Name, 
	        dbo.W_Field.Type, dbo.W_Field.VarcharValue, dbo.W_Field.IntValue, dbo.W_Field.FloatValue, 
	        dbo.W_Field.DatetimeValue, dbo.W_Document.BatchID, dbo.W_Document_1.ProcessID, dbo.C_Process.Name AS ProcessName,
	        dbo.C_DocType.Name AS OriginalDocType, dbo.W_DocReport.DocumentID, dbo.W_DocReport.CorrectValid AS DocCorrectValid, dbo.W_DocReport.Substitutions, 
	        dbo.W_DocReport.SuggestionCorrect, dbo.W_DocReport.SuggestionFaulty, dbo.W_DocReport.OcrTime, dbo.W_DocReport.OcrDate, 
	        dbo.W_DocReport.VerifyDate, dbo.W_DocReport.OriginalDocTypeID, dbo.W_DocReport.ReclassifiedTypeID,
	        dbo.W_DocReport.OrigClassField, dbo.W_DocReport.FinalClassField, dbo.W_DocReport.ReclassifiedField, 
	        dbo.W_DocReport.CurrentSheetCount, dbo.W_DocReport.CurrentPageCount, dbo.W_DocReport.CurrentImageCount,
	        dbo.W_DocReport.LastStep, C_DocType_1.Name AS ReclassifiedDocType, dbo.W_Document.CreatedAt, 
	        CONVERT(datetime, CONVERT(char(10), dbo.W_Document.CreatedAt, 112)) AS DocCreateDateOnly, 
	        CONVERT(datetime, CONVERT(char(10), dbo.W_DocReport.VerifyDate, 112)) AS VerifyDateOnly
		


FROM    dbo.W_Field INNER JOIN
	        dbo.W_Document ON dbo.W_Field.DocumentID = dbo.W_Document.ID AND
	        dbo.W_Field.DocumentSiteId = dbo.W_Document.SiteId INNER JOIN
	        dbo.W_FieldReport ON dbo.W_Field.ID = dbo.W_FieldReport.FieldID INNER JOIN
	        dbo.W_DocReport  ON dbo.W_Field.DocumentID = dbo.W_DocReport.DocumentID LEFT OUTER JOIN
	        dbo.C_DocType AS C_DocType_1  ON dbo.W_DocReport.ReclassifiedTypeID = C_DocType_1.ID LEFT OUTER JOIN
	        dbo.C_DocType  ON dbo.W_DocReport.OriginalDocTypeID = dbo.C_DocType.ID LEFT OUTER JOIN
	        dbo.W_Document AS W_Document_1  ON dbo.W_Document.BatchID = W_Document_1.ID LEFT OUTER JOIN
	        dbo.C_Process  ON W_Document_1.ProcessID = dbo.C_Process.ID

Uses

The available tables

The available views