WF_CUSTOM_ATTRS_ITCS

Stores information about interceptors for process data variables, sometimes called custom attributes.

Columns

Column Name Definition

CREATED_DATE

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

EVENT_NAME

Function:
The name of the event that triggers the interceptor.
Values:
  • Query - Retrieves the variable.
  • Update - Updates the variable.
Data Type:
nvarchar
Size:
64
Can Be Null:
No
Primary Key:
No
Foreign Key:
No

ITEM_ID

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

OWNER_ID

Function:
The ID for the activity instance which the interceptor is associated.
Data Type:
varchar
Size:
32
Can Be Null:
No
Primary Key:
No
Foreign Key:
  • WF_ACTIVITY_INSTS - n:1

PARAMETER

Function:
A parameter associated with the interceptor.
Data Type:
nvarchar
Size:
1024
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

REF_ID

Function:
The process instance ID associated with the interceptor.
Data Type:
varchar
Size:
64
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
  • WF_PROC_INSTS - n:1

STARTED_DATE

Function:
The date the interceptor started.
Data Type:
datetime
Size:
8
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

STATUS

Function:
The status of the interceptor.
Values:
  • 0 - Started
  • 1 - Pending
  • 2 - Finished
  • 3 - Cancelled
Data Type:
varchar
Size:
16
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

Relationships

Table Name Relationship
WF_ACTIVITY_INSTS 1:n
WF_PROC_INSTS 1:n