WF_PROC_DEFS

Stores a process model.

Columns

Column Name Definition

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

APPL_NAME
Function:
The name of the app associated with the process model.
Data Type:
nvarchar
Size:
256
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

ASSEMBLY_NAME
Function:
The name of the assembly associated with the process model.
Data Type:
nvarchar
Size:
128
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

BASE_DEF_ID
Function:
The ID of the first version of the process model. For the initial version, the DEF_ID and BASE_DEF_ID are the same.
Data Type:
varchar
Size:
32
Can Be Null:
No
Primary Key:
No
Foreign Key:
No

CHECKED_OUT_BY
Function:
The user who checked out the process model.
Data Type:
nvarchar
Size:
256
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

CHECKED_OUT_DATE
Function:
The date the process model was checked out.
Data Type:
datetime
Size:
8
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

CLASS_NAME
Function:
The name of the custom class associated with the process model.
Data Type:
nvarchar
Size:
64
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

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

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

DEF_NAME
Function:
The name of the process model.
Data Type:
nvarchar
Size:
256
Can Be Null:
No
Primary Key:
No
Foreign Key:
No

DESCRIPTION
Function:
A free text description for the process model.
Data Type:
nvarchar
Size:
2048
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

DIAGNOSTIC
Function:
Specifies whether the process model is currently in diagnostic mode.
Values:
  • Yes - The process model is under testing. The process model and all instances will be removed when the server restarts.
  • No - The process model is not under testing.
Data Type:
varchar
Size:
3
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

DOC_REF
Function:
The document reference for the process model.
Data Type:
nvarchar
Size:
256
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

EXECUTION_BEHAVIOR
Function:
Specifies whether an app is a process-based app or a form-based app.
Values:
  • 0 - Standard. A process-based app.
  • 1 - NotInstantiable. A form-based app.
  • 2 - Interactive. The process is interactive, which means it is event based.
Data Type:
Int
Size:
Null
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

EXPECTED_TIME
Function:
The expected process instance duration specified in the process model.
Values:

Example:

<Length>1 </Length><Unit><Value>2</Value> </Unit><BusinessTime>false</BusinessTime>

Data Type:
nvarchar
Size:
256
Can Be Null:
No
Primary Key:
No
Foreign Key:
No

INITIATE_CONSTRAINT
Function:
Specifies whether the process model is a parent process or a child process.
Values:
  • ChildProcess - The subprocess can not be initiated as a standalone process.
  • ParentChildProcess - The process can be initiated as either a parent process or subprocess, and it counts as a parent process.
  • ParentProcess - A form-based app, which can not have any child processes associated.
Data Type:
nvarchar
Size:
64
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

LABEL_ID
Function:
The unique label ID for an app.
Data Type:
varchar
Size:
32
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
  • WF_APP_LABEL - n:1

OWNER
Function:
The owner of the process model.
Data Type:
nvarchar
Size:
256
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

PRE_VERSION
Function:
The previous version of the process model.
Data Type:
nvarchar
Size:
16
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

PRIMARY_DATA_SOURCE
Function:
Specifies the information for the data source binding.
Values:
  • User\SharePointDataSource - SharePoint data source.
  • User\SalesforceDataSource - Salesforce data source.
  • User\InfoPathDataSource - InfoPath data source.
  • User\DatabaseDataSource - Database data source.
  • User\APDataEntityDataSource - AgilePoint Data Entities data source.
  • User\ExcelTableDataSource - Microsoft Excel data source.
Data Type:
nvarchar
Size:
64
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

PRIMARY_INITIATE_EVENT
Function:
Specifies how the process is started.
Values:
  • Eforms - Specifies the process starts when an eForm is submitted. This includes form-based apps.
  • Parent Process - Specifies a subprocess is started from a parent process.
  • Any - The process is initiated by a message or event.
  • SPSIntegration - The process is initiated from SharePoint.
  • InfoPathIntegration - The process is initiated from InfoPath.
  • Salesforce - The process is initiated from Salesforce.
Data Type:
nvarchar
Size:
64
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

RELEASE_DATE
Function:
The time stamp when the process model was released.
Data Type:
datetime
Size:
8
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

STATUS
Function:
The status of the process model.
Values:
  • Created - The process model is added into the database.
  • Released - The process model was released.
  • Retired - Once a newer version of the process model is published or released, the previous version becomes retired. However, the running process instances may continue to exist with it.
  • Disabled - The process model was disabled.
  • Checkedout - The process model was checked out for changes.
Data Type:
nvarchar
Size:
16
Can Be Null:
No
Primary Key:
No
Foreign Key:
No

VERSION
Function:
The version of the process model.
Data Type:
nvarchar
Size:
16
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

Relationships

Table Name Relationship
WF_PROC_INSTS 1:n