WF_PROC_DEFS
Description
Contains the process definition (process templates).
Columns
For the descriptions in this table, the term item refers to a process definition.
| Column Name | Data Type | Size | Description |
|---|---|---|---|
| BASE_DEF_ID | varchar | 32 | The ID of the first version of the process definition (template). For the initial version, the DEF_ID and BASE_DEF_ID are the same. |
| DEF_ID | varchar | 32 | (Primary key) The unique item ID. |
| DEF_NAME | nvarchar | 256 | The name of the process definition. |
| STATUS | nvarchar | 16 |
The status of the process definition. Created: When the process template is added into the database. Released: When the process template was released. Retired: When the new version of the process template was released, the previous version becomes 'Retired', but the running process instances may continue to exist with it. Disabled: When the process template was disabled. Checkedout: When process template was checked out for changes. NOTE: Only Released and Checked out process templates can be initiated process instances. |
| PRE_VERSION | nvarchar | 16 | The previous version of the process definition (template). |
| VERSION | nvarchar | 16 | The version of the process definition (template). |
| DESCRIPTION | nvarchar | 2048 | The description you entered in the process template. |
| OWNER | nvarchar | 256 | The owner of the process definition as defined in the process template. |
| DOC_REF | nvarchar | 256 | The document reference as defined in the process template. |
| CREATED_DATE | datetime | 8 | The date the item was created. |
| CREATED_BY | nvarchar | 64 | The user who created the item. |
| CHECKED_OUT_DATE | datetime | 8 | The date the process definition was checked-out. |
| CHECKED_OUT_BY | nvarchar | 64 | The person who checked out the process definition. |
| CLASS_NAME | nvarchar | 64 | The name of the custom class associated with the process definition. |
| EXPECTED_TIME | nvarchar | 256 | The expected process duration defined in the process template. |
| DIAGNOSTIC | varchar | 3 | A boolean value used to represent if the process definition is currently in diagnostic mode. Yes=Process template is under testing, process template and all instances will be removed when the server re-starts. |
| ASSEMBLY_NAME | nvarchar | 128 | The name of the assembly the process definition is associated with. |
| APPL_NAME | nvarchar | 256 | The name of the application associated with the item. |
| RELEASE_DATE | datetime | 8 | The time stamp for when the process definition was released. |
| INITIATE_CONSTRAINT | nvarchar | 64 | The type of process model. This determines the category for which this process model is associated under the license model. If the process model is of type ChildProcess, it cannot be initiated as a stand alone process. A ParentChildProcess can be initiated as either a Parent or Child process, it counts as a Parent process. |
Relationships
| Table Name | Relationship |
|---|---|
| WF_PROC_INSTS | 1 – n |