CData Python Connector for SugarCRM

Build 25.0.9454

DRI_SubWorkflows

Stores execution instances of Customer Journey sub-processes. This table supports step-level progress monitoring and guided interaction flows.

Columns

Name Type ReadOnly Description
Id [KEY] String False

Unique identifier (Id) for the subworkflow record.

Name String False

The display name of the subworkflow, used to distinguish this workflow step within a broader Customer Journey.

Date_Entered Datetime True

The date and time at which the subworkflow record was initially created in the system.

Date_Modified Datetime True

The date and time at which the subworkflow record was most recently updated.

Modified_User_Id String True

The Id of the user who last modified the subworkflow record.

Modified_By_Name String True

The name of the user who last modified the subworkflow record.

Created_By String True

The Id of the user who originally created the subworkflow record.

Created_By_Name String True

The name of the user who originally created the subworkflow record.

Description String False

A free-form description that provides narrative context, workflow notes, or business meaning for this subworkflow.

Deleted Bool False

A Boolean field that returns a value of

Label String False

The descriptive label that is shown to end users when displaying this subworkflow in UI workflows or playbooks.

State String False

The current operational state of the subworkflow (for example, 'not started', 'in progress', or 'completed').

Start_Next_Journey_Id String False

The Id of the next Customer Journey that is configured to begin automatically when this subworkflow reaches completion. This configuration supports sequential or chained journey execution.

Progress Double True

A numeric value between 0 and 1 that indicates the proportion of subworkflow work that is complete. This field supports progress bars and workflow tracking dashboards.

Momentum_Ratio Double True

A calculated ratio that reflects the rate of progress relative to expected pacing or configured workflow timing.

Score Int True

A cumulative score value that captures the performance or quality of the subworkflow outcome.

Points Int True

A point value that is assigned to this workflow stage for scoring or incentive tracking across journeys.

Momentum_Points Int True

The number of points awarded based on movement through the workflow in a timely or efficient manner.

Momentum_Score Int True

The total momentum-based scoring value that is derived from workflow pacing and execution performance.

Sort_Order Int False

The numeric ordering value that determines the sequence in which this subworkflow appears relative to other workflow stages.

Date_Started Datetime True

The date and time at which the subworkflow was first initiated. This field is used for SLA and analytics tracking.

Date_Completed Datetime True

The date and time at which the subworkflow was finished or closed out.

Is_Journey_Saved Bool False

A Boolean field that returns a value of

Dri_Subworkflow_Template_Id String False

The Id of the workflow template that defines the expected structure and behavior of this subworkflow instance.

Dri_Subworkflow_Template_Name String True

The name of the workflow template from which this subworkflow instance originates.

Dri_Workflow_Id String False

The Id of the parent workflow that contains and orchestrates this subworkflow.

Dri_Workflow_Name String False

The name of the parent workflow that contains this subworkflow within the Customer Journey model.

Following Bool False

A Boolean field that returns a value of

My_Favorite Bool False

A Boolean field that returns a value of

Tag String False

A set of tags that are associated with the record to support search grouping, categorization, and filtering.

Commentlog String True

The collaborative comment log that is associated with this record for internal discussion and interaction.

Locked_Fields String True

Fields that are restricted from modification based on administrative configuration or role-based access controls.

Sync_Key String True

The system-generated synchronization token that is used to align record states across integrations or external systems.

Team_Id String False

The Id of the primary team that is assigned access to this subworkflow record.

Team_Set_Id String False

The Id of the team set that grants visibility and sharing access to multiple teams.

Acl_Team_Set_Id String False

The Id of the governing team set that is applied to enforce access control rules.

Team_Count String False

The number of teams that are associated with this subworkflow for visibility, access governance, and record-level permissions.

Team_Name String False

The display name of the primary team that is associated with this record.

Acl_Team_Names String True

The list of team names that are associated with this record for access control and sharing policies.

Assigned_User_Id String False

The Id of the user who is currently assigned responsibility for progressing or completing the subworkflow.

Assigned_User_Name String True

The display name of the user who is currently assigned responsibility for the subworkflow.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9454