The Scenarios module uses the following tables to store information about business processes:
drpt_stage_reached
This table contains information associated with a business process stage.
Column | Data Type | Constraint | |
---|---|---|---|
| VARCHAR(40) | NOT NULL | The unique identifier associated with the business process stage reached dataset. |
| VARCHAR(40) | NOT NULL | The ID of the |
| TIMESTAMP | NOT NULL | The time a |
| TIMESTAMP | NOT NULL | The time the stage is reached. |
| VARCHAR(225) | NOT NULL | The business process name. |
| VARCHAR(225) | NULL | The business process stage name. |
| NUMERIC (1,0) | NOT NULL | Indicates if the user who reached the business stage is logged in. |
| INTEGER | NOT NULL | The index of this stage in the business process. |
dss_user_bpmarkers
This table contains information associated with markers used for business process tracking purposes.
Column | Data Type | Constraint | |
---|---|---|---|
| VARCHAR(40) | NOT NULL | The unique identifier associated with the marker. |
| VARCHAR(40) | NOT NULL | The ID of the Profile for that has a marker. |
| VARCHAR(100) | NOT NULL | The name of the business process associated with the marker. |
| VARCHAR(100) | NULL | The name of the business process stage associated with the marker. |
| VARCHAR(100) | NULL | This column is not currently in use. |
| TIMESTAMP | NULL | The date the business process stage is reached and the marker is assigned to the Profile. |
| INTEGER | NOT NULL | The marker repository version number. This information is managed and used internally by the repository. |
| INTEGER | NULL | This column is not currently in use. |