Project Data Tables Database > td Schema : td.BPM_ELEMENTS Table |
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 imbedded. 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 |
Index | Description | Primary | Unique |
---|---|---|---|
BPME_GUID_IX2 | |||
BPME_PARENT_IX1 | |||
BPME_PRIMARYKEY |