View: V_InteractiveStepsDocReport

Available in XBOUND 3.8 and later.

This view contains information about an executed interactive process step (ServiceType = 6). It includes only documents whose history is saved.

Column	Description
Process	The name of the process (Process in V_StepsReports).
Client	The name of the client (Client in V_StepsReports).
UserName	The Windows user in whose name the client process ran (UserName in V_StepsReports).
InteractiveTimeSum	The sum of the execution time of an interactive process step.
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).
Name	The name of the document (Name in W_Document).
CreatedAt	When the document was created (CreatedAt in W_Document).
BatchID	The ID of the root document (BatchID 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 name of the new (reclassified) document type (Name in C_DocType).
DocCreateDateOnly	Only the date (without the time) from the CreatedAt field in W_Document.
InterActTimeHours	The period of time in hours during which the document was checked out in an interactive process step.

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

SQL Script

CREATE VIEW [dbo].[V_InteractiveStepsDocReport]
AS
SELECT dbo.V_StepsInteractiveTimeSum.Process, dbo.V_StepsInteractiveTimeSum.Client, dbo.V_StepsInteractiveTimeSum.UserName, 
	        dbo.V_StepsInteractiveTimeSum.InterActiveTimeSum, dbo.W_Document.ID AS DocID, dbo.W_Document.ParentID, 
	        dbo.W_Document.Name, dbo.W_Document.CreatedAt, dbo.W_Document.BatchID, 
	        dbo.W_DocReport.CorrectValid, 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.CurrentSheetCount, 
	        dbo.W_DocReport.CurrentPageCount, dbo.W_DocReport.CurrentImageCount,
    (SELECT ProcessID
FROM dbo.W_Document AS Doc1
          WHERE (ID = dbo.W_Document.BatchID)) AS ProcessID,
    (SELECT Name
          FROM dbo.C_DocType
          WHERE (ID = dbo.W_DocReport.OriginalDocTypeID)) AS OriginalDocName,
    (SELECT Name
          FROM dbo.C_DocType AS C_DocType_1
          WHERE (ID = dbo.W_DocReport.ReclassifiedTypeID)) AS ReclassifiedDocName, 
              CONVERT(datetime, CONVERT(char(10), dbo.W_Document.CreatedAt, 112)) 
              AS DocCreateDateOnly, dbo.V_StepsInteractiveTimeSum.InterActiveTimeSum / 3600 AS InterActTimeHours
FROM  dbo.W_Document INNER JOIN
         dbo.V_StepsInteractiveTimeSum ON dbo.W_Document.BatchID = dbo.V_StepsInteractiveTimeSum.DocumentID INNER JOIN
         dbo.W_DocReport ON dbo.W_Document.ID = dbo.W_DocReport.DocumentID

Uses

The available tables

The available views