What is TotalRunningDuration field mean in Frs_data_escalation_watch mean and why does some some Service Request show a null value in the TotalRunningDuration field?

Version 1

    Details

    What is TotalRunningDuration field mean in Frs_data_escalation_watch mean and why does some some Service Request show a null value in the TotalRunningDuration field?


    Resolution

     

    TotalRunningDuration field in frs_data_escalation_watch table is the time in seconds of how long has the escalation been in running state. The TotalRunningDuration gets recalculated when the status of the escalation watch changes and it does observe the HOP associated with the escalation watch (meaning it will only count the time during the HOP when the escalation watch has been in the running state)


    The reason TotalRunningDuration would appear null in the database would be if was never  in a status that was in a run state in an active escalation schedule that was set to Run.