View: V_VerificationField

Available in XBOUND 3.8 and later.

This view shows the fields in a document that passed a Verification step (RepCatName = 'Verification'). The data is provided by the Agent for Reporting.

Column	Description
FieldID	The ID of the field (ID 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).
DocumentID	The ID of the document (DocumentID in W_Field).
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
BatchID	The ID of the root document (BatchID in W_Field).

SQL Script

CREATE VIEW [dbo].[V_VerificationField]
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.DocumentID, 
        dbo.W_Field.Name, dbo.W_Field.Type, dbo.W_Field.BatchID
FROM  dbo.W_Field INNER JOIN
	        dbo.W_FieldReport ON dbo.W_Field.ID = dbo.W_FieldReport.FieldID INNER JOIN
	        dbo.V_VerificationStepsDocReport ON dbo.W_Field.DocumentID = dbo.V_VerificationStepsDocReport.DocID

Uses

The available tables

The available views