View: V_InteractiveField

Available in XBOUND 3.8 and later.

This view shows the fields in a document that passed an interactive step (ServiceType = 6). It includes only documents and fields whose history is saved.

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).
DocumentID	The ID of the document (DocumentID in W_Field).
Name	The name of the field (Name in W_Field).
BatchID	The ID of the root document (BatchID in W_Field).
ProcessID	The ID of the process (ProcessID in V_StepsReports).

SQL Script

CREATE VIEW [dbo].[V_InteractiveField]
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.BatchID, dbo.V_InteractiveStepsDocReport.ProcessID
FROM   dbo.W_Field INNER JOIN
	        dbo.W_FieldReport ON dbo.W_Field.ID = dbo.W_FieldReport.FieldID INNER JOIN
	        dbo.V_InteractiveStepsDocReport ON dbo.W_Field.DocumentID = dbo.V_InteractiveStepsDocReport.DocID

Uses

The available tables

The available views