TASKS view
The TASKS view contains one row for each task that is run and an additional row for each BPD instance that is started.
The TASKS view includes the following columns:
| Column | Description |
|---|---|
| TASK_ID | The primary key of this task in the Business Performance Data Warehouse. |
| FUNCTIONAL_TASK_ID | The primary key in the Business Performance Data Warehouse of the BPD to which this entry corresponds. In the case where this row corresponds to the beginning of a BPD instance, it will equal TASK_ID. |
| CREATION_TIME | The date and time that the task was created. |
| START_TIME | The date and time that the task was started. If CREATION_TIME and START_TIME are not equal, the lag indicates that the task was not immediately started by the user. |
| END_TIME | The date and time that the task was finished. |
| SYSTEM_USER_ID | The primary key of the user in the Process Data Warehouse that ran this task. |
| USERNAME | The name of the user who ran this task. |
| BPDNAME | The name of the BPD that triggered this task. |
| STARTING_PROCESS_ID | The primary key in the Process Data Warehouse of the BPD instance that created this task. |
| ACTIVITY_NAME | The name of the Activity that triggered this task. |
| SYSTEM_TASK_ID | The primary key in the Process Data Warehouse of the task. This entry includes a trailing a if the task is an activity. |
| SYSTEM_FUNCTIONAL_TASK_ID | The primary key in the Process Data Warehouse of the BPD instance. |
| SNAPSHOT | The snapshot (version) of the process application or toolkit that triggered this task. If no snapshots exist, a Null value is stored in this column. |
| ACRONYM | The acronym of the process application or toolkit that triggered this task. |