WF_PROC_BASE_ELEMENTS

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

Columns

Column Name Definition

ID
Function:
The unique ID for the activity.
Data Type:
varchar
Size:
32
Can Be Null:
No
Primary Key:
Yes
Foreign Key:
No

COLOR_CODE
Function:
The hexadecimal color for the name of the activity group, or tab.
Data Type:
nvarchar
Size:
16
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

COMPONENT_ID
Function:
The ID (GUID) of the activity.
Data Type:
varchar
Size:
64
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

CONTEXTMENU_IMAGE_PATH
Function:
The image path for the activity context menu.
Data Type:
nvarchar
Size:
256
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

CREATED_BY
Function:
The user who created the activity.
Data Type:
nvarchar
Size:
256
Can Be Null:
No
Primary Key:
No
Foreign Key:
No

CREATED_DATE
Function:
The date the activity was created.
Data Type:
datetime
Size:
8
Can Be Null:
No
Primary Key:
No
Foreign Key:
No

DOCUMENTATION_LINK
Function:
The documentation link for the activity.
Data Type:
nvarchar
Size:
2048
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

ELEMENT_DESCRIPTION
Function:
The description of the activity.
Data Type:
nvarchar
Size:
2048
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

ELEMENT_ID
Function:
The ID (GUID) of the activity.
Data Type:
varchar
Size:
32
Can Be Null:
No
Primary Key:
No
Foreign Key:
  • WF_LARGE_DATA - n:1

ELEMENT_NAME
Function:
The name of the activity.
Data Type:
nvarchar
Size:
128
Can Be Null:
No
Primary Key:
No
Foreign Key:
No

ELEMENT_TITLE
Function:
The activity title.
Data Type:
nvarchar
Size:
256
Can Be Null:
No
Primary Key:
No
Foreign Key:
No

ELEMENT_TYPE
Function:
The type of an activity.

It can be a functional or non-functional activity.

Values:
  • Node - All the other activities except node type connectors.
  • Edge - A connector element from Common activity tab.
Data Type:
nvarchar
Size:
32
Can Be Null:
No
Primary Key:
No
Foreign Key:
No

ELEMENT_VENDOR
Function:
The name of the organization that created a custom activity.
Data Type:
nvarchar
Size:
64
Can Be Null:
No
Primary Key:
No
Foreign Key:
No

ELEMENT_VERSION
Function:
The version number of the activity.
Data Type:
nvarchar
Size:
16
Can Be Null:
No
Primary Key:
No
Foreign Key:
No

ENABLEMENT
Function:
The type of enablement.
Values:
The only accepted value is WebOnly.
Data Type:
nvarchar
Size:
16
Can Be Null:
No
Primary Key:
No
Foreign Key:
No

EXECUTABLE_ENV
Function:
The environment for the execution. This column is reserved for future use.
Values:
This column has one value::
  • CLR - Common language runtime
Data Type:
nvarchar
Size:
16
Can Be Null:
No
Primary Key:
No
Foreign Key:
No

EXECUTABLE_KEY
Function:
A unique key for the activity.
Data Type:
nvarchar
Size:
2048
Can Be Null:
No
Primary Key:
No
Foreign Key:
No

EXECUTABLE_TYPE
Function:
Specifies the activity type for the item.

This column was introduced in AgilePoint NX v9.0, Software Update 1, Cumulative Update 1.

Values:
  • AgilePart - A system activity.
  • AgileExtender - An AgileExtender.
  • Callouts - A callout activity.
  • AgileWork - A human task activity.
Data Type:
varchar
Size:
16
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

GROUP_DESCRIPTION
Function:
The description of the activity group, or tab.
Data Type:
nvarchar
Size:
2048
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

GROUP_IMAGE_PATH
Function:
The path for the image for the activity group, or tab.
Data Type:
nvarchar
Size:
256
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

GROUP_NAME
Function:
The internal name of the activity group, or tab.
Data Type:
nvarchar
Size:
128
Can Be Null:
No
Primary Key:
No
Foreign Key:
No

GROUP_TITLE
Function:
The display name of the activity group, or tab.
Data Type:
nvarchar
Size:
128
Can Be Null:
No
Primary Key:
No
Foreign Key:
No

LAST_UPDATED_BY
Function:
The user who last updated, or modified, the activity.
Data Type:
nvarchar
Size:
256
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

LAST_UPDATED_DATE
Function:
The date the activity was last modified.
Data Type:
datetime
Size:
8
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

LOCALE
Function:
The locale for the activity.
Values:
  • da - Danish
  • He - Hebrew
  • Nl - Dutch
  • hu-HU - Hungarian (Hungary)
  • zh-CN - Chinese
  • Ca - Catalan
  • ja-JP - Japanese (Japan)
  • Ar - Arabic
  • de-DE - German(Germany)
  • Fr - French
  • zh-TW - Chinese(Taiwan)
  • tr-TR - Turkish(Turkey)
  • Ja - Japenese
  • en-US - English (United States)
  • es - Spanish
Data Type:
nvarchar
Size:
8
Can Be Null:
No
Primary Key:
No
Foreign Key:
No

MASTER_ICON_PATH
Function:
The path of the master icon.
Data Type:
nvarchar
Size:
256
Can Be Null:
No
Primary Key:
No
Foreign Key:
No

MODEL_TYPE
Function:
The type of the model used to create the activity. The only accepted value is BPM. This column is reserved for future use.
Data Type:
nvarchar
Size:
16
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

ORDER_BY
Function:
Represents the position of an activity within the tab.
Data Type:
Int
Size:
4
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

STATUS
Function:
The status of the activity.
Values:
  • NEW - Newly introduced beta activities.
  • RELEASE - Released activities.
  • DEPRECATED - Activities that are no longer supported.
Data Type:
nvarchar
Size:
16
Can Be Null:
No
Primary Key:
No
Foreign Key:
No

TREEVIEW_ICON_PATH
Function:
The path of the tree view icon.
Data Type:
nvarchar
Size:
256
Can Be Null:
No
Primary Key:
No
Foreign Key:
No

Relationships

Table Name Relationship
WF_LARGE_DATAn:1