Business process models.
The model elements are in the BPM_ELEMENTS Table. The paths are in the BPM_PATHS Table.
Column Name | Description | Datatype | Length | Allow Nulls | Default | |
---|---|---|---|---|---|---|
![]() | BPMM_ID | The record ID. | int | 4 | ||
BPMM_PARENT_ID | The record ID of the folder that contains this item. | int | 4 | |||
BPMM_NAME | The name of the item. | varchar | 255 | |||
BPMM_GUID | The ID imported from the external tool. | varchar | 80 | ![]() | ||
BPMM_STATUS | The model status. For future use. | varchar | 40 | ![]() | ||
BPMM_DESCRIPTION | A free text description of this item. | varchar | 16 | ![]() | ||
BPMM_COMMENTS | Comments. | varchar | 16 | ![]() | ||
BPMM_REP_REQ_ID | int | 4 | ![]() | |||
BPMM_ADDITIONAL_DATA | The model's additional attributes as imported from the external tool. | varchar | 16 | ![]() | ||
BPMM_IMPORTED_BY | The user who imported this version. | varchar | 60 | |||
BPMM_IMPORT_DATE | The date and time of the last import. | datetime | 4 | ![]() | ||
BPMM_CREATED_BY | The user who imported the first version of the model. | varchar | 60 | |||
BPMM_CREATION_DATE | The date and time of the first import. | datetime | 4 | ![]() | ||
BPMM_SOURCE_FILE_NAME | The name of the file used in the most recent import. | varchar | 255 | ![]() | ||
BPMM_NOTATION | The notation name of the model as imported from the external tool. | varchar | 40 | ![]() | ||
BPMM_NOTATION_VERSION | The version of notation as imported from the external tool | varchar | 40 | ![]() | ||
BPMM_PRIORITY | int | 4 | ![]() | |||
BPMM_PROTOTYPE | One of As-Is or To-Be. | varchar | 20 | ![]() | ||
BPMM_VENDOR | The name of the external tool in which the model was created, as imported from the external tool. | varchar | 60 | ![]() | ||
BPMM_AUTHOR | The model creator, as imported from the external tool. | varchar | 60 | ![]() | ||
BPMM_TEXT_SYNC | For internal use. Do not change data. | varchar | 1 | ![]() | ||
BPMM_VTS | The version time stamp. | varchar | 20 | |||
BPMM_VER_STAMP | The version number of this record. | int | 4 | ![]() | ||
BPMM_HAS_ATTACHMENTS | Y if this item has attachments. | varchar | 1 | ![]() | ||
BPMM_USER_01 | User-defined field. | varchar | 40 | ![]() | ||
BPMM_VC_VERSION_NUMBER | The version ID of the entity. | int | 4 | ![]() | ||
BPMM_VC_STATUS | The version status: Checked in, checked out, or read only. | varchar | 20 | ![]() | ||
BPMM_VC_CHECKIN_USER_NAME | The user name of the user who checked in this version. | varchar | 60 | ![]() | ||
BPMM_VC_CHECKIN_DATE | The date this version was checked in according to the server clock. | datetime | 4 | ![]() | ||
BPMM_VC_CHECKIN_TIME | The time this version was checked in according to the server clock. | varchar | 10 | ![]() | ||
BPMM_VC_CHECKIN_COMMENTS | Comments.The user's comments when checking in the item. | varchar | 16 | ![]() | ||
BPMM_VC_CHECKOUT_USER_NAME | The user who checked out the item under version control. | varchar | 60 | ![]() | ||
BPMM_VC_CHECKOUT_DATE | The date the version was checked out according to the server clock. | datetime | 4 | ![]() | ||
BPMM_VC_CHECKOUT_TIME | The time this version was checked out according to the server clock. | varchar | 10 | ![]() | ||
BPMM_VC_CHECKOUT_COMMENTS | Comments.The user's comments when checking out the item. | varchar | 16 | ![]() |