Help > Views > V_StepsDocReport

View: V_StepsDocReport

Available in XBOUND 3.8 and later.

This view contains information about 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

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.

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)

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.

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_StepsDocReport]
AS
SELECT    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,
          CONVERT(datetime, CONVERT(char(10), dbo.W_Document.CreatedAt, 112)) AS DocCreateDateOnly,
          dbo.V_StepsReports.Process, dbo.V_StepsReports.Client, dbo.V_StepsReports.UserName, dbo.V_StepsReports.ServiceType,
          W_Document_1.ProcessID, C_DocType_2.Name AS OriginalDocName, dbo.C_DocType.Name AS ReclassifiedDocName,
          CONVERT(datetime, CONVERT(char(10), dbo.W_DocReport.VerifyDate, 112)) AS VerifyDateOnly
FROM      dbo.W_Document AS W_Document_1 RIGHT OUTER JOIN
          dbo.W_Document INNER JOIN
          dbo.W_DocReport ON dbo.W_Document.ID = dbo.W_DocReport.DocumentID INNER JOIN
          dbo.V_StepsReports ON dbo.W_Document.BatchID = dbo.V_StepsReports.DocumentID AND dbo.W_DocReport.LastStep = dbo.V_StepsReports.ID
          ON W_Document_1.ID = dbo.W_Document.BatchID LEFT OUTER JOIN
          dbo.C_DocType AS C_DocType_2 ON dbo.W_DocReport.OriginalDocTypeID = C_DocType_2.ID LEFT OUTER JOIN
          dbo.C_DocType ON dbo.W_DocReport.ReclassifiedTypeID = dbo.C_DocType.ID
WHERE     (dbo.V_StepsReports.ActionType IN (2, 3, 5, 6))

Uses

The available tables

The available views