View: V_FieldStepsReport

Available in XBOUND 3.8.1 and later.

This view contains information about fields and the related documents that were evaluated by Reporting. That is, the documents passed a process step that was configured in the XBOUND reporting category as the capture end point.

Column	Description
FieldID	The ID of the field (FieldID 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
BatchID	The ID of the root document (BatchID in W_Document).
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.)
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).
CorrectValue	The field value of the last corrective OCR process step (Cat=CORR). (CorrectValue in W_FieldReport.)
DocID	The ID of the document (ID in W_Document).
ParentID	The ID of the root document (only populated when this document is a sub-document). (ParentID in W_Document).
CreatedAt	When the document was created (CreatedAt in W_Document).
CorrectValid	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".
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.
ProcessID	The ID of the process (ProcessID in W_Document).
OriginalDocName	The name of the document type when the document was first created (Name in C_DocType).
ReclassifiedDocName	The document name 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 Name in C_DocType.
DocCreateDateOnly	Only the date (without the time) from the CreatedAt field in W_Document.
Process	The name of the process (Name in C_Process).
Client	The name of the client (Name in C_Client).
UserName	The Windows user in whose name the process ran (UserName in W_Step).
ServiceType	0 = Activity 1 = Collector 2 = Agent 3 = Global Parameter Set 4 = Client Parameter Set 5 = Process Parameter Set 6 = Interactive 7 = Platform 8 = License 9 = Activity and Parameter Set 10 = Feature Group (ServiceType in V_ProcessStepWithCategory)
FieldCorrectValid	The status of the field after the last corrective OCR process step (Cat=CORR).
VerifyDateOnly	Only the date (without the time) from the VerifyDate field in W_DocReport.

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

SQL Script

CREATE VIEW [dbo].[V_FieldStepsReport]
AS
SELECT TOP (100) PERCENT dbo.W_FieldReport.FieldID, dbo.W_Field.Name, dbo.W_Field.Type, dbo.W_Field.BatchID, 
                dbo.W_FieldReport.OCRValue, dbo.W_FieldReport.OCRValid, dbo.W_FieldReport.FieldEvaluation,
                dbo.W_FieldReport.AutomValue, dbo.W_FieldReport.AutomValid, dbo.W_FieldReport.CaptureEndValue, 
                dbo.W_FieldReport.CaptureEndValid, dbo.W_FieldReport.CorrectValue, dbo.V_StepsDocReport.DocID,
                dbo.V_StepsDocReport.ParentID, dbo.V_StepsDocReport.CreatedAt, dbo.V_StepsDocReport.CorrectValid, 
                dbo.V_StepsDocReport.Substitutions, dbo.V_StepsDocReport.SuggestionCorrect,
                dbo.V_StepsDocReport.SuggestionFaulty, dbo.V_StepsDocReport.OcrTime, dbo.V_StepsDocReport.OcrDate, 
                dbo.V_StepsDocReport.VerifyDate, dbo.V_StepsDocReport.OriginalDocTypeID,
                dbo.V_StepsDocReport.ReclassifiedTypeID, dbo.V_StepsDocReport.CurrentSheetCount, 
                dbo.V_StepsDocReport.CurrentPageCount, dbo.V_StepsDocReport.CurrentImageCount, dbo.V_StepsDocReport.ProcessID,
                dbo.V_StepsDocReport.OriginalDocName, dbo.V_StepsDocReport.ReclassifiedDocName, 
                dbo.V_StepsDocReport.DocCreateDateOnly, dbo.V_StepsDocReport.Process, dbo.V_StepsDocReport.Client,
                dbo.V_StepsDocReport.UserName, dbo.V_StepsDocReport.ServiceType, dbo.W_FieldReport.CorrectValid 
                AS FieldCorrectValid, dbo.V_StepsDocReport.VerifyDateOnly
FROM    dbo.W_Field INNER JOIN
	        dbo.W_FieldReport ON dbo.W_Field.ID = dbo.W_FieldReport.FieldID INNER JOIN
	        dbo.W_StepsDocReport ON _1 ON dbo.W_Field.DocumentID = dbo.V_StepsDocReport.DocID

Uses

The available tables

The available views