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 | |
(primary key) | 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 | |
(primary key) | The unique identifier associated with the marker. | ||
| VARCHAR(40) | NOT NULL | |
(primary key) | 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. |