A customer service manager needs a report showing the average duration of Resolution SLAs broken down by Account. Which table should be the source of this report?
Trap 1: SLA Definition [contract_sla]
Contract SLA stores the definition templates, not the individual runtime instances needed for duration reporting.
Trap 2: Metric Instance [metric_instance]
Metric instance tracks database field durations, not native SLA runtime metrics.
Trap 3: Case [sn_customerservice_case]
While cases contain SLA flags, detailed SLA duration and breach metrics reside on the Task SLA table.
- A
SLA Definition [contract_sla]
Why wrong: Contract SLA stores the definition templates, not the individual runtime instances needed for duration reporting.
- B
Task SLA [task_sla]
The Task SLA table contains runtime records of all attached SLAs, capturing exact durations, breach status, and related task details.
- C
Metric Instance [metric_instance]
Why wrong: Metric instance tracks database field durations, not native SLA runtime metrics.
- D
Case [sn_customerservice_case]
Why wrong: While cases contain SLA flags, detailed SLA duration and breach metrics reside on the Task SLA table.