Share this page
ALM Project Database Reference
td.BPM_MODELS Table
Description
Business process models.
Remarks
The model elements are in the BPM_ELEMENTS Table. The paths are in the BPM_PATHS Table.
Columns
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | 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 | The requirement ID that represents the imported model. The requirement is created as part of model’s import. | 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 | The imported model's 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 who checked in this version of the item. If this item has not been checked in, the field is blank. | 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. If the item is not checked out, this field is blank. | 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 | |
Indexes
| Index | Description | Primary | Unique |
|---|---|---|---|
| BPMM_GUID_IX2 | |||
| BPMM_NAME_IX1 | | ||
| BPMM_PRIMARYKEY | | |
See Also
Related Objects
