View: V_ProcessStepWithCategory

This view contains all of the process steps with their corresponding reporting category (when one is assigned). Diagram:

Column	Description
ProcessStepID	The ID of the process step (ID in C_ProcessStep).
ProcessID	The ID of the process (ID in C_Process).
ProcessStepName	The name of the process step (Name in C_ProcessStep).
FeatureID	The ID of the feature (ID in C_Feature).
TokensToJoin	The number of tasks to synchronize.
Stopped	1 = process step disabled (paused). (Stopped in C_ProcessStep.)
ProcCanceled	Whether a process the process is canceled.
ReportingCatID	The ID of the reporting category (ID in C_ReportingCat).
AllowParallel	Allow parallel tasks can be selected in the Input and Output Rules dialog.
IsEnd	The Production End Point setting. 0 = belongs to the backlog. 1 = not part of the backlog. (IsEnd in C_ProcessStep)
IsCaptureEnd	The Capture End Point setting. 0 = Not a Capture end point, and therefore relevant for Capture statistics. Fields can be evaluated and the documents can be included in the Capture statistics in the reports. 1 = This is a Capture end point, and therefore not relevant for Capture statistics. (IsCaptureEnd in C_ProcessStep)
RepCatID	The ID of the reporting category.
ReportingCat	The name of the reporting category (Name in C_ReportingCat).
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_ProcessStepWithCategory]
AS
SELECT dbo.C_ProcessStep.ID AS ProcessStepID, dbo.C_ProcessStep.ProcessID, dbo.C_ProcessStep.Name AS 
ProcessStepName, dbo.C_ProcessStep.FeatureID, dbo.C_ProcessStep.TokensToJoin, dbo.C_ProcessStep.Stopped, 
	      dbo.C_ProcessStep.ProcCanceled, dbo.C_ProcessStep.ReportingCatID, 
	      dbo.C_ProcessStep.AllowParallel, dbo.C_ProcessStep.IsEnd,dbo.C_ProcessStep.IsCaptureEnd,
           CASE WHEN dbo.C_ProcessStep.ReportingCatID = 0 THEN C_Feature.ReportingCatID 
	    ELSE dbo.C_ProcessStep.ReportingCatID END AS RepCatID, 
         (SELECT Name FROM dbo.C_ReportingCat 
    WHERE (ID  = CASE WHEN dbo.C_ProcessStep.ReportingCatID = 0 THEN C_Feature.ReportingID ELSE dbo.C_ProcessStep.ReportingCatID END))
    AS ReportingCat,  dbo.C_Feature.ServiceType FROM  dbo.C_Feature INNER JOIN
          dbo.C_ProcessStep ON dbo.C_Feature.ID = dbo.C_ProcessStep.FeatureID

Uses

The available tables

The available views