WF_PROC_BASE_ELEMENTS

Description

Contains the metadata information about process activities, such as activity title, description, activity icon, in all of the supported languages. If you want to show a custom activity in the Process Builder, you must put the metadata for the activity in this table.

Columns

For the descriptions in this table, the term item refers to a process base element.

Column Name	Data Type	Size	Description
ID	varchar	32	(Primary key) The unique item ID.
ELEMENT_ID	varchar	32	(Foreign key to WF_LARGE_DATA table) The ID (GUID) of an activity (element).
COMPONENT_ID	varchar	64	The ID (GUID) of the activity.
ELEMENT_NAME	nvarchar	128	The name of an activity (element).
LOCALE	nvarchar	8	The locale of the item.
ELEMENT_VERSION	nvarchar	16	The version number of the activity (element).
STATUS	nvarchar	16	The status of the item.
ELEMENT_TITLE	nvarchar	256	The activity (element) title in the item.
ELEMENT_VENDOR	nvarchar	64	The name of the organizational entity that creates the custom activity, usually a company name.
GROUP_NAME	nvarchar	128	The internal name of a group.
GROUP_TITLE	nvarchar	128	The display name of a group.
GROUP_IMAGE_PATH	nvarchar	256	The image path for the created group.
CONTEXTMENU_IMAGE_PATH	nvarchar	256	The context menu image path for the item.
COLOR_CODE	nvarchar	16	The color code for the group name.
GROUP_DESCRIPTION	nvarchar	2048	The description of the group.
ELEMENT_TYPE	nvarchar	32	The type of an activity (element). It can be a functional or non-functional activity, such as swimlanes.
ENABLEMENT	nvarchar	16	The type of enablement. The only accepted value is WebOnly. This field is reserved for future use.
MASTER_ICON_PATH	nvarchar	256	The path of the master icon.
TREEVIEW_ICON_PATH	nvarchar	256	The path of the tree view icon.
ELEMENT_DESCRIPTION	nvarchar	2048	The description of the activity (element).
EXECUTABLE_ENV	nvarchar	16	The environment for the execution. This column is reserved for future use.
EXECUTABLE_KEY	nvarchar	2048	A unique key of the activity.
DOCUMENTATION_LINK	nvarchar	2048	The documentation link of the item.
ORDER_BY	int	4	Represents the position of an activity within the tab.
CREATED_DATE	datetime	8	The date the item was created.
CREATED_BY	nvarchar	64	The user who created the item.
LAST_UPDATED_DATE	datetime	8	The date the item was last updated.
LAST_UPDATED_BY	nvarchar	64	The user who last updated, or modified, the item.
MODEL_TYPE	nvarchar	16	The type of the model used to create the item. The only accepted value is BPM. This column is reserved for future use.

Relationships

Table Name	Relationship
WF_LARGE_DATA	n – 1