TRACKINGPOINTVALUE view
In the TRACKINGPOINTVALUE view, a row is recorded each
time a tracking point is traversed. When autotracking is enabled,
there are two rows for every task that is run, because autotracking
defines start and end tracking points for each autotracked activity.
The TRACKINGPOINTVALUE view includes the following columns:
| Column | Description |
|---|---|
| TRACKING_POINT_ID | The primary key of the tracking point. This column links to the TRACKINGPOINTS view. |
| TASK_ID | The primary key in the Business Performance Data Warehouse of the task that corresponds to this tracking point. This column links to the TASKS view. |
| FUNCTIONAL_TASK_ID | The primary key in the Business Performance Data Warehouse of the process instance that corresponds to this tracking point. This column links to the TASKS view. |
| TIME_STAMP | The date and time at which the tracking point was traversed. |
| SNAPSHOT | The snapshot (version) of the task that corresponds to this tracking point. If no snapshots exist, a Null value is stored in this column. |
| ACRONYM | The acronym of the process application or toolkit that contains the task that corresponds to this tracking point. |
| TIME_STAMP_DAYS | TIME_STAMP truncated to days. |
| TIME_STAMP_WEEKS | TIME_STAMP truncated to weeks. |
| TIME_STAMP_MONTHS | TIME_STAMP truncated to months. |
| TIME_STAMP_QUARTERS | TIME_STAMP truncated to quarters. |
| TIME_STAMP_YEARS | TIME_STAMP truncated to years. |
This topic only applies to BAW, and is located in the BAW repository. Last updated on 2025-01-20 10:38