Help > The available views

The available views

Name

Description

V_BacklogClient

Summarizes the documents in the backlog by client. Process steps that are not part of the backlog (IsEnd = 1) are not included.

V_BacklogOverall

Shows the total number of documents in the backlog for all clients. It also outputs the total number of documents (for all clients) with a task (IsEnd >=0).

V_BacklogOverallDetail

Shows the total number of documents in the backlog per reporting category.

V_BacklogProcess

Shows the total number of documents that are assigned to a reporting category, per process step, regardless of whether they are in the backlog or not – that is, regardless of IsEnd.

V_BacklogVolume

Shows how many documents have a task, per client. This includes all process steps that are assigned to a reporting category, regardless of whether they are in the backlog or not – that is, regardless of IsEnd.

V_DocumentReport

Contains aggregate field values and validity statistics, as well as several types of Capture data.

V_EmptyPagesPerDocument

Shows the number of sheets, pages, images, and blank pages per root document.

V_FieldDocumentReport

Contains processed Capture values for a field, as well as corresponding information about the client, process and reporting category.

V_FieldPerDocument

Contains processed Capture values for a field.

V_FieldStepsReport

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.

V_InteractiveField

Shows the fields in a document that passed an interactive step (ServiceType = 6).

V_InteractiveStepsDocReport

 

Contains information about an executed interactive process step (ServiceType = 6).

V_ProcessStepWithCategory

Contains all of the process steps with their corresponding reporting category (when one is assigned).

V_SheetPageImagePerProcess

Shows the number of sheets, pages and images of each root document in a process.

V_ShPaImPerProcessStep

Shows the number of sheets, pages, and images in each process step in the backlog. Includes only documents whose history is saved.

V_Steps

Shows information about an executed process step. It shows the names (labels) of the objects (process steps, clients, etc.) instead of their IDs.

V_StepsDocReport

 

Contains information about an executed process step and documents.

V_StepsInteractive

 

Shows information about an executed interactive process step (ServiceType = 6).

V_StepsInteractiveTimeSum

 

Shows the time per document needed for the interactive process steps.

V_StepsReports

Contains information about an executed process step, with the processed name. It shows the names (labels) of the objects (process steps, clients, etc.) instead of their IDs. This view is used for reporting.

V_StepsVerification

Contains information about an executed Verification process step (RepCatName='Verification').

V_StepsVerificationTimeSum

 

Shows the time per document needed for the Verification process steps.

V_StepThroughput

Shows how many documents were processed in the last hour.

V_StepThroughputSum

Shows how many documents were processed per process step in the last hour.

V_SumDuration

Shows the processing time per process step from check-out to check-in and calculates worker performance.

V_SumDurationCurrentHour

Shows the processing time per process step from check-out to check-in and calculates worker performance in the past hour.

V_ThroughputDetail

Shows the time elapsed from check-out to check-in per service type (ServiceType), as well as worker performance for the elapsed time.  

V_ThroughputDetailCurrHour

Shows the total processing time per service type (ServiceType) from check-out to check-in and calculates total worker performance during the past hour.

V_ThroughputOverall

Summarizes the processing time (from check-out to check-in) and calculates total performance.

V_ThroughputOverallCurrHour

Summarizes the processing time (from check-out to check-in) and calculates total performance in the past hour.

V_VerificationField

 

Shows the fields in a document that passed a Verification step (RepCatName = 'Verification').

V_VerificationStepsDocReport

 

Contains information about an executed Verification step (RepCatName = 'Verification').

The available tables

Overview of the database

Introduction