Total Items: 106116
| EscalationLevel | LatestCall | LatestChat | LatestSms | LatestEmail | LatestFax | Campaign | IsOpen | Customer | LatestTicket | CreatedAt | UpdatedAt | Subject | Description | Priority | Disposition | ConversationType | Parent | Account | OpenedBy | AssignedTo | Region | Department | QueryType | SubQueryType | Escalation | EscalationCron | History | CreatedBy | UpdatedBy | Category | Subcategory | CreatedBy1 | UpdatedBy1 | ResolvedAt | Thread | ResolvedBy | WasCreatedByCustomer | HasIvrcall | Creator | Updator | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 131 | 6/21/2020 8:41:43 AM | 3/28/2022 7:25:06 AM | water query | there is a leak at the property, and bill is very high | 27 | 3 | 154 | 17 | 17 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-15T12:04:59.993Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-16T11:15:36.897Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T08:17:48.172Z"}] | 1 | 96 | 3/28/2022 7:25:06 AM | 17 | 17 | 14 | ||||||||||||||||||||
| 0 | 130 | 6/21/2020 8:21:47 AM | 3/28/2022 7:25:06 AM | Water Query | Leak credit to be done, as consumer has already sent plumbers invoice. | 27 | 3 | 153 | 17 | 17 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-15T08:20:35.397Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-16T11:13:38.645Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T07:56:27.763Z"}] | 1 | 96 | 3/28/2022 7:25:06 AM | 17 | 17 | 14 | ||||||||||||||||||||
| 0 | 129 | 6/21/2020 7:47:35 AM | 3/28/2022 7:25:06 AM | water Query | Consumer has sent a plumbers invoice already, an adjustment is due | 27 | 3 | 152 | 17 | 17 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-15T12:06:12.447Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-16T11:16:01.284Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T08:18:18.984Z"}] | 1 | 96 | 3/28/2022 7:25:06 AM | 17 | 17 | 14 | ||||||||||||||||||||
| 0 | 128 | 6/21/2020 7:34:19 AM | 3/28/2022 7:25:06 AM | Water Query | consumer has sent a plumbers letter already, a leak credit is due | 27 | 3 | 151 | 17 | 17 | 3 | 23 | 1 | 96 | [{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-15T12:11:58.603Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-16T11:33:28.375Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T08:24:21.970Z"}] | 1 | 96 | 3/28/2022 7:25:06 AM | 17 | 17 | 14 | ||||||||||||||||||||
| 0 | 127 | 6/21/2020 7:20:51 AM | 3/28/2022 7:25:06 AM | Water Query | There is a leak on the meter of the property and account is high due to the leak.Advised consumer to get a plumber and send us a plumbers invoice. | 27 | 3 | 150 | 17 | 17 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-15T07:59:42.094Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-15T08:14:04.012Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-16T11:12:54.315Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T07:49:55.490Z"}] | 1 | 96 | 3/28/2022 7:25:06 AM | 17 | 17 | 14 | ||||||||||||||||||||
| 0 | 126 | 6/21/2020 7:05:40 AM | 3/28/2022 7:25:06 AM | Sewerage Query | Sewerage incorrectly billed, needs to be reversed | 4 | 3 | 149 | 17 | 17 | 2 | 23 | 3 | 53 | [{"op":"R","uid":"5","un":"ivanh","dt":"2021-06-01T09:38:54.280Z"},{"op":"R","uid":"5","un":"ivanh","dt":"2021-06-01T10:52:27.257Z"}] | 3 | 53 | 3/28/2022 7:25:06 AM | 17 | 17 | 5 | ||||||||||||||||||||
| 0 | 125 | 6/21/2020 6:53:24 AM | 3/28/2022 7:25:06 AM | Late termination | Late termination | 27 | 3 | 148 | 17 | 17 | 2 | 23 | 6 | 107 | [{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-15T12:18:34.403Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-16T11:34:26.507Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T08:47:38.906Z"}] | 6 | 107 | 3/28/2022 7:25:06 AM | 17 | 17 | 14 | ||||||||||||||||||||
| 0 | 124 | 6/21/2020 6:40:41 AM | 3/28/2022 7:25:06 AM | water Query | Six months policy to be applied, as meter was not read over a six months period.<div><br></div><div>2020/03 billing Does not qualify as the adjustment results in a debit charge. Consumer to assess if any leaks or to reduce consumption to avoid penalty tariffs</div> | 27 | 3 | 147 | 17 | 3 | 4 | 23 | 1 | 95 | [{"op":"R","uid":"3","un":"fareezar","dt":"2021-03-23T12:22:02.038Z"},{"op":"R","uid":"15","un":"chumab","dt":"2021-05-31T10:35:49.242Z"}] | 1 | 95 | 3/28/2022 7:25:06 AM | 3 | 17 | 15 | ||||||||||||||||||||
| 0 | 123 | 6/18/2020 10:03:29 AM | 3/19/2022 10:16:45 AM | water query | water query - high consumption | 27 | 3 | 146 | 14 | 14 | 2 | 23 | 1 | 67 | [{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-15T13:31:37.866Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-16T11:36:01.856Z"},{"op":"R","uid":"889","un":"rethabilel","dt":"2022-03-19T10:16:45.577Z"}] | 1 | 67 | 3/19/2022 10:16:45 AM | 14 | 14 | 889 | ||||||||||||||||||||
| 0 | 122 | 6/18/2020 7:16:55 AM | 5/19/2022 7:51:12 AM | plumbers letter | no valid query details submitted | 27 | 3 | 145 | 16 | 16 | 2 | 23 | 1 | 44 | [{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-15T08:22:56.464Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T08:05:23.465Z"}] | 1 | 44 | 5/19/2022 7:51:12 AM | 16 | 16 | 14 | ||||||||||||||||||||
| 0 | 121 | 6/17/2020 10:13:19 AM | 3/2/2022 7:53:56 AM | Log Query | Duplicate query - see reference #6207 | 27 | 3 | 137 | 34 | 34 | 2 | 23 | 1 | 67 | [{"op":"R","uid":"2","un":"debbiecr","dt":"2021-06-15T10:01:33.651Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2021-06-15T10:03:00.230Z"}] | 1 | 67 | 3/2/2022 7:53:56 AM | 34 | 34 | 2 | ||||||||||||||||||||
| 0 | 120 | 6/17/2020 9:12:24 AM | 3/2/2022 7:53:56 AM | Log Query | INVALID QUERY | 27 | 3 | 136 | 34 | 34 | 2 | 23 | 1 | 67 | [{"op":"R","uid":"13","un":"unathig","dt":"2021-10-16T10:26:18.350Z"}] | 1 | 50 | 13 | 3/2/2022 7:53:56 AM | 34 | 34 | 13 | |||||||||||||||||||
| 0 | 119 | 6/17/2020 7:33:47 AM | 3/2/2022 7:53:56 AM | Log Query | Invalid info | 27 | 3 | 135 | 34 | 34 | 2 | 23 | 1 | 67 | [{"op":"R","uid":"16","un":"cumilem","dt":"2021-07-23T10:17:59.089Z"},{"op":"R","uid":"16","un":"cumilem","dt":"2021-07-23T10:26:20.479Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-09-03T07:05:28.107Z"}] | 1 | 67 | 3/2/2022 7:53:56 AM | 34 | 34 | 3 | ||||||||||||||||||||
| 0 | 49455 | 118 | 6/16/2020 11:15:40 AM | 10/13/2021 9:13:27 AM | Meter Reading | readings up-to-date | 27 | 3 | 134 | 32 | 32 | 2 | 23 | 1 | 44 | [{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-15T09:51:31.119Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-15T09:52:04.392Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-10-13T09:10:34.254Z"}] | 1 | 111 | 17 | 10/13/2021 9:13:27 AM | 32 | 32 | 17 | ||||||||||||||||||
| 0 | 117 | 6/12/2020 1:54:14 PM | 3/28/2022 6:35:04 AM | HIGH CONSUMPTION | <br><b>Monitoring Reason</b>: [HIGH CONSUMPTION]<div>check reading sent to meter readings 15/08/2021</div> | 27 | 3 | 133 | 5 | 5 | 2 | 23 | 1 | 44 | [{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-15T10:20:16.128Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-15T10:20:51.850Z"}] | 1 | 44 | 3/28/2022 6:35:04 AM | 5 | 5 | 12 | ||||||||||||||||||||
| 0 | 116 | 6/12/2020 12:51:17 PM | 5/31/2021 8:44:54 AM | water query | Leak rebate for May 2020 repairs<br/><b>Journal Amount</b>: [-R19,319.81] | 27 | 3 | 132 | 14 | 14 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"3","un":"fareezar","dt":"2021-05-31T08:43:26.330Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-05-31T08:44:50.508Z"}] | 1 | 96 | 5/31/2021 8:44:54 AM | 14 | 14 | 3 | ||||||||||||||||||||
| 0 | 115 | 6/12/2020 12:41:16 PM | 6/30/2021 1:18:42 PM | High consumption | Query Resolved with jrnl no 1158912 | 27 | 3 | 131 | 14 | 14 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"2","un":"debbiecr","dt":"2021-06-30T13:16:17.054Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2021-06-30T13:17:39.588Z"}] | 1 | 96 | 6/30/2021 1:18:42 PM | 14 | 14 | 2 | ||||||||||||||||||||
| 0 | 114 | 6/12/2020 12:24:55 PM | 7/21/2021 7:44:05 AM | late termination | late termination | 27 | 3 | 130 | 14 | 14 | 2 | 23 | 6 | 107 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-07-13T09:39:58.319Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-15T07:53:48.501Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-16T11:11:45.599Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T07:45:20.601Z"}] | 6 | 107 | 7/21/2021 7:44:05 AM | 14 | 14 | 14 | ||||||||||||||||||||
| 0 | 113 | 6/12/2020 11:56:19 AM | 7/21/2021 8:50:17 AM | water query | no valid query details submitted | 27 | 3 | 129 | 14 | 14 | 2 | 23 | 1 | 44 | [{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-15T12:20:19.661Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T08:50:09.091Z"}] | 1 | 44 | 7/21/2021 8:50:17 AM | 14 | 14 | 14 | ||||||||||||||||||||
| 0 | 112 | 6/12/2020 11:42:32 AM | 7/21/2021 9:14:49 AM | water query | no valid query details submitted | 27 | 3 | 128 | 14 | 14 | 2 | 23 | 1 | 44 | [{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-15T13:31:10.328Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T09:14:45.940Z"}] | 1 | 44 | 7/21/2021 9:14:49 AM | 14 | 14 | 14 |