This is the percent of time that water is available to customers, using service disruption duration compared to total hours in a period, per customer account. It is an innovative way of aggregating the service reliability impact of multiple areas of interest, such as response time, repair time, and system improvement efforts. A 99.999% result means that the average customer account is out of service only 5 minutes and 15 seconds a year.

MEASURE ARCHIVED 11/8/18 PER REQUEST FROM DEPARTMENT

The number of accounts is obtained from the Customer Relations section. Crews document the duration of water service disruption and the number of customers out of service. The query is ran against the maxprod_restore database on the maxt03 server. The language is as follows: SELECT workorder.wonum, workorder.reportdate, workorder.description, workorder.failurecode, workorder.problemcode, workorder.crewid, workorder.wolo2, workorder.interwateroffact, workorder.interwateronact, workorder.interimpactaptunit, workorder.interimpactbus, workorder.interimpacthouses, Max(wostatus.changedate) AS 'WCCdatemax' FROM MAX_PROD.dbo.workorder workorder, MAX_PROD.dbo.wostatus wostatus WHERE wostatus.siteid = workorder.siteid AND wostatus.wonum = workorder.wonum GROUP BY workorder.wonum, workorder.reportdate, workorder.description, workorder.failurecode, workorder.problemcode, workorder.crewid, workorder.wolo2, workorder.interwateroffact, workorder.interwateronact, workorder.interimpactaptunit, workorder.interimpactbus, workorder.interimpacthouses, workorder.status, wostatus.status, wostatus.changedate HAVING (workorder.status<>'5B-CAN') AND (workorder.interwateroffact>1) AND (wostatus.status='3C-WCC') AND (wostatus.changedate>{ts '2015-01-01 00:00:00'} And wostatus.changedate<{ts '2016-01-01 00:00:00'}) AND (workorder.failurecode<>'CNTSUPP') AND (workorder.problemcode Not In ('tonfl','TOFFFL'))

100*(((number of hours in period*number of customer accounts)-total hours off in period)/(number of hours in period*number of customer accounts))

Field Ops will just enter the number as a percent example 99.995