SLATHRESHOLDTRAVERSALS view
The SLATHRESHOLDTRAVERSALS view is an implicit tracking group view that tracks a value whenever an activity with an attached SLA completes. An activity has an attached SLA if there is an SLA with a condition dependent on a metric of that activity.
The SLATHRESHOLDTRAVERSALS view includes the following columns:
| Column | Description |
|---|---|
| METRIC_GUID | The GUID of the metric referenced in the SLA. |
| METRIC_VALUE | The value of the metric referenced in the SLA. |
| TARGET_VALUE | The value that the metric is compared to in the SLA. |
| TRACKING_POINT_GUID | The GUID of the tracking point corresponding to where this traversal occurred, which is the end autotracking point for the activity. |
| VIOLATION_LEVEL | An indication of how much of a violation this particular occurrence is. This value is only relevant and, thus, populated for greater than SLA conditions, and is basically METRIC_VALUE/TARGET_VALUE. |
| TRACKING_GROUP_ID | The primary key of the Tracking Group to which this entry corresponds. This column links to the TRACKINGGROUPS view. |
| TRACKING_POINT_ID | The primary key of the Tracking Point to which this entry corresponds. This column links to the TRACKINGPOINTS view. |
| TASK_ID | The primary key of the task to which this entry corresponds. This column links to the TASKS view. |
| FUNCTIONAL_TASK_ID | The primary key of the BPD instance to which this entry corresponds. This column links to the TASKS view. |
| TIME_STAMP | The date and time at which the corresponding tracking point was traversed. |
| SNAPSHOT | The snapshot (version) of the process application or toolkit to which this entry corresponds. If no snapshots exist, a Null value is stored in this column. |
| ACRONYM | The acronym of the process application or toolkit to which this entry corresponds. |
| 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. |