View: V_Steps

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

A similar view (the one used for reporting): V_StepsReports

Column	Description
DocumentID	The ID of the document (ID in W_Step).
DocumentSiteId	Currently not used.
DocumentName	The name of the document (Name in W_Document).
DoneAt	When the step was executed (DoneAt in W_Step).
CheckOutDuration	The period of time in seconds during which the document was checked out for this step. (CheckOutDuration in W_Step.)
Action	Create Check out Check In Check in with Error Routed Manually Undo Check out Statistics (ActionType in W_Step)
DocType	The ID of the document type (TypeID in W_Document).
DocumentType	The name of the document type (Name in C_DocType).
ProcessStepID	The ID of the process step (ProcessStepID in W_Step).
ProcessStep	The name of the process step (Name in C_ProcessStep).
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).
Machine	The computer on which the process ran (Machine in W_Step).
ID	The ID of the process step (ID in W_Step).
SiteId	Currently not used.
DateOnly	Only the date (not the time) from the DoneAt field.
CheckOutDurationHours	The period of time in hours during which the document was checked out for this 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 C_Feature)

SQL Script

CREATE VIEW [dbo].[V_Steps]
AS
SELECT  dbo.W_Step.DocumentID, dbo.W_Step.DocumentSiteId, dbo.W_Document.Name AS DocumentName, dbo.W_Step.DoneAt, dbo.W_Step.CheckOutDuration, 
         CASE ActionType
            WHEN 0 THEN 'Create'
            WHEN 1 THEN 'CheckOut'
            WHEN 2 THEN 'CheckIn'
            WHEN 3 THEN 'CheckInWithError'
            WHEN 4 THEN 'RoutedManually'
            WHEN 5 THEN 'CheckIn' 
            WHEN 6 THEN 'CheckIn' END AS Action,
	      dbo.W_Document.TypeID AS DocType, dbo.C_DocType.Name AS DocumentType, dbo.W_Step.ProcessStepID, 
	      dbo.C_ProcessStep.Name AS ProcessStep, dbo.C_Process.Name AS Process, dbo.C_Client.Name AS Client, dbo.W_Step.UserName, 
	      dbo.W_Step.Machine, dbo.W_Step.ID, dbo.W_Step.SiteId, CONVERT(datetime, CONVERT(char(10), dbo.W_Step.DoneAt, 112)) AS DateOnly, 
	      dbo.W_Step.CheckOutDuration / 3600 AS CheckOutDurationHours, dbo.C_Feature.ServiceType
FROM  dbo.C_Client INNER JOIN
	      dbo.C_Process ON dbo.C_Client.ID=dbo.C_Process.ClientID INNER JOIN
	      dbo.W_Step INNER JOIN
	      dbo.W_Document  ON  dbo.W_Step.DocumentID=dbo.W_Document.ID AND dbo.W_Step.DocumentSiteId=dbo.W_Document.SiteId INNER JOIN
	      dbo.C_ProcessStep ON dbo.W_Step.ProcessStepID=dbo.C_ProcessStep.ID ON dbo.C_Process.ID=dbo.C_ProcessStep.ProcessID INNER JOIN
	      dbo.C_Feature ON dbo.C_ProcessStep.FeatureID=dbo.C_Feature.ID LEFT OUTER JOIN
	      dbo.C_DocType ON dbo.W_Document.TypeID=dbo.C_DocType.ID

Uses

The available tables

The available views