Share this page
ALM Project Database Reference
td.BPM_PATHS Table
Description
Paths in a business process model.
Remarks
A path is composed of business process model elements. Links between a path and its elements are stored in the ASSET_RELATIONS Table.
Columns
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | BPMP_ID | The record ID. | int | 4 | |||
| BPMP_PARENT_ID | The BPM_MODELS.BPMM_ID of the model the path belongs to. | int | 4 | ||||
| BPMP_NAME | The name of the item. | varchar | 255 | ||||
| BPMP_CHECKSUM | Checksum generated according to the elements included in the path. | int | 4 |  | |||
| BPMP_STATUS | The path status. One of: | varchar | 40 | | |||
| BPMP_PRIORITY | The Model path priority. | int | 4 | | |||
| BPMP_DESCRIPTION | A free text description of this item. | varchar | 16 | | |||
| BPMP_COMMENTS | Comments. | varchar | 16 | | |||
| BPMP_CREATION_DATE | The server date when this item was created. | datetime | 4 | | |||
| BPMP_CREATED_BY | The user name of the user who created this item. | varchar | 60 | ||||
| BPMP_PATH_DESCRIPTION | A free text description of this item. | varchar | 16 | | |||
| BPMP_REP_REQ_ID | The requirement ID that represents the imported path. The requirement is created as part of the path’s import. | int | 4 | | |||
| BPMP_TEXT_SYNC | For internal use. Do not change data. | varchar | 1 | | |||
| BPMP_VTS | The version time stamp. | varchar | 20 | ||||
| BPMP_VER_STAMP | The version number of this record. | int | 4 | | |||
| BPMP_HAS_ATTACHMENTS | Y if this item has attachments. | varchar | 1 | | |||
| BPMP_USER_01 | User-defined field. | varchar | 40 | | |||
| BPMP_VC_CHECKOUT_USER_NAME | The user who checked out the item under version control. If the item is not checked out, this field is blank. | varchar | 60 | |
Indexes
| Index | Description | Primary | Unique |
|---|---|---|---|
| BPMP_CHECKSUM_IX2 | |||
| BPMP_NAME_IX1 | | ||
| BPMP_PRIMARYKEY | | |
See Also
Related Objects
