Help > Views > V_StepsVerification

View: V_StepsVerification

Available in XBOUND 3.8 and later.

This view contains information about an executed Verification process step (RepCatName='Verification').

Column	Description
DocumentID	The ID of the document (ID in W_Step).
DocumentName	The name of the document (Name 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).
RepCatName	The name of the reporting category.
StepID	The ID of the process step (ID in W_Step).
Action	Create Check out Check In Check in with Error Routed Manually Undo Check out Statistics (ActionType in W_Step)
CheckOutDuration	The period of time in seconds during which the document was checked out for this step. (CheckOutDuration in W_Step.)

SQL Script

CREATE VIEW [dbo].[V_StepsVerification]
AS
SELECT  DocumentID, DocumentName, Process, Client, UserName, RepCatName, ID AS StepID, Action, CheckOutDuration
FROM   dbo.V_StepsReports
WHERE  (ActionType IN (2, 3, 5, 6)) AND (RepCatName = 'Verification')

Uses

V_StepsReports

The available tables

The available views