Share this page
ALM Project Database Reference
td.BPM_ELEMENTS Table
Description
Parts of a business process model.
Remarks
Examples of elements are activity, event, connector, and so on.
Columns
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | BPME_ID | The record ID. | int | 4 | |||
| BPME_PARENT_ID | The BPM_MODELS.BPMM_ID of the model this element belongs to. | int | 4 | ||||
| BPME_NAME | The element's name. | varchar | 255 | ||||
| BPME_GUID | The element's unique ID as imported from the external tool. | varchar | 80 |  | |||
| BPME_EXTERNAL_ID | The element's ID as imported from the external tool. | varchar | 80 | | |||
| BPME_SUBTYPE_ID | The type of element. For example, connector or activity. | varchar | 50 | ||||
| BPME_ELEMENT_TYPE_ID | The inner type of the element according to the owner model's notation. | int | 4 | | |||
| BPME_LOCATION_X | The element's X coordinate in the diagram as imported from the external tool. | int | 4 | | |||
| BPME_LOCATION_Y | The element's Y coordinate in the diagram as imported from the external tool. | int | 4 | | |||
| BPME_HEIGHT | As imported from the external tool. | int | 4 | | |||
| BPME_WIDTH | As imported from the external tool. | int | 4 | | |||
| BPME_TEXT | The element's visible text. | varchar | 16 | | |||
| BPME_ADDITIONAL_DATA | The element's additional attributes as imported from the external tool. | varchar | 16 | | |||
| BPME_IS_TESTABLE | A value of Y indicates that the element is testable. For future use. | varchar | 1 | | |||
| BPME_IS_VISIBLE | A value of Y indicates that the element is visible in the diagram. | varchar | 1 | | |||
| BPME_IMPORT_DATE | The date the element was imported as part of a business model. | datetime | 4 | | |||
| BPME_IMPORTED_BY | The ALM user who imported the element as part of a business model. | varchar | 60 | ||||
| BPME_CREATION_DATE | The server date when this item was created. | datetime | 4 | | |||
| BPME_CREATED_BY | The user name of the user who created this item. | varchar | 60 | ||||
| BPME_EMBEDDED_IN_GUID | The GUID of the containing sub-process if this element is embedded. Imported from the external tool. | varchar | 80 | | |||
| BPME_LANE_GUID | The GUID of the containing lane. Imported from the external tool. | varchar | 80 | | |||
| BPME_POOL_GUID | The GUID of the containing pool. Imported from the external tool. | varchar | 80 | | |||
| BPME_REF_MODEL_GUID | If a reference activity, the GUID of the referenced model. Imported from the external tool. | varchar | 80 | | |||
| BPME_TEXT_SYNC | For internal use. Do not change data. | varchar | 1 | | |||
| BPME_VTS | The version time stamp. | varchar | 20 | ||||
| BPME_VER_STAMP | The version number of this record. | int | 4 | | |||
| BPME_HAS_ATTACHMENTS | Y if this item has attachments. | varchar | 1 | | |||
| BPME_USER_01 | User-defined field. | varchar | 40 | | |||
| BPME_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 | | |||
| BPME_STATUS | The element status. For future use. | varchar | 40 | | |||
| BPME_PRIORITY | The imported element's priority. | int | 4 | | |||
| BPME_DESCRIPTION | A free text description of this item. | varchar | 16 | | |||
| BPME_COMMENTS | Comments. | varchar | 16 | | |||
| BPME_REP_REQ_ID | The ID of the requirement that represents the imported element. The requirement is created as part of element’s import. | int | 4 | | |||
| BPME_POINTS | If element is a connector, the list of points the connector goes through in the diagram. Imported from the external tool. | varchar | 255 | | |||
| BPME_SOURCE_GUID | If element is a connector, the GUID of the source object. Imported from the external tool. | varchar | 80 | | |||
| BPME_TARGET_GUID | If element is a connector, the GUID of the target object. Imported from the external tool. | varchar | 80 | |
Indexes
| Index | Description | Primary | Unique |
|---|---|---|---|
| BPME_GUID_IX2 | |||
| BPME_PARENT_IX1 | |||
| BPME_PRIMARYKEY | | |
See Also
Related Objects
