Task SLA table
The Task SLA [task_sla] table stores Task SLA records for the SLAs attached to particular tasks.
For each task, attached SLAs are accessible in a related list on the Task's form.
The SLA form for a task shows further details:
Stage values
The following Stage values are defined:
- In progress
- Cancelled
- Paused
- Completed
Note:
The Breached stage value is also available for systems either
using the 2010 SLA engine, or running in compatibility mode.
Timing information
The Timings fields on the Task SLA contain the crucial information powered by the SLA Engine:
| Field | Description |
|---|---|
| Start time | The time the SLA was started. |
| Stop time | The time the SLA ended. |
| Breach time | The time the SLA breaches. The time reflected is adjusted after business pause duration (for task SLAs with a schedule specified) or pause duration (for task SLAs with no schedule). Note: Breach time is the
same as Planned end time. Actual breach time is dynamic and often different from the original breach time calculated when a task SLA is first attached. |
| Actual Elapsed Time | Time between start time and now (minus pause duration). |
| Actual Elapsed Percentage | Percentage of total SLA that has elapsed (minus pause duration). |
| Actual Time Left | Time remaining until SLA breach. |
| Business Elapsed Time | Time within the specified schedule between start time and now (minus pause duration). |
| Business Elapsed Percentage | Percentage of total SLA that has elapsed within the specified schedule (minus pause duration). |
| Business Time Left | Time within the schedule remaining until SLA breach. |
| Original breach time | The date/time the SLA would breach, as calculated when the SLA is first attached after a task record matches an SLA Definition start condition. Note: You may have to configure the form to see this
field. |