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 process 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. |
This topic only applies to BAW, and is located in the BAW repository. Last updated on 2025-03-13 12:15