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 BPD 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. |