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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6561 | 6/21/2021 10:39:00 AM | 3/28/2022 7:07:05 AM | six months recommendation | journal processed<br/><b>Journal Number</b>: [361497]<br/><b>Journal Amount</b>: [-R39,372.12] | 27 | 3 | 5685 | 15 | 2 | 23 | 1 | 67 | [{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-06-21T10:40:55.872Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-06-21T14:16:35.174Z"}] | 1 | 67 | 3/28/2022 7:07:05 AM | 15 | 3 | |||||||||||||||||||||||
| 6560 | 6/21/2021 10:37:00 AM | 3/28/2022 7:23:36 AM | account over read | 100% credit passed<br/><b>Journal Number</b>: [854632]<br/><b>Journal Amount</b>: [-R15,290.85] | 27 | 3 | 5683 | 13 | 2 | 23 | 1 | 49 | [{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-06-21T10:38:56.192Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-06-21T14:17:00.744Z"}] | 1 | 49 | 3/28/2022 7:23:36 AM | 13 | 3 | |||||||||||||||||||||||
| 6559 | 6/21/2021 10:34:44 AM | 7/3/2022 12:36:32 PM | Water query | <span style="font-size:11.0pt;font-family:"Calibri",sans-serif; mso-fareast-font-family:Calibri;mso-fareast-theme-font:minor-latin;mso-ansi-language: EN-ZA;mso-fareast-language:EN-ZA;mso-bidi-language:AR-SA">The high water consumption between 4 August 2020 and 1 September 2020 as billed on the September invoice was as a result of a water leak</span> | 27 | 3 | 5681 | 4 | 2 | 23 | 1 | 67 | [{"op":"R","uid":"20","un":"nzwanam","dt":"2021-06-21T10:33:53.289Z"}] | 1 | 67 | 7/3/2022 12:36:32 PM | 134512 | 11 | 11 | ||||||||||||||||||||||
| 6558 | 6/21/2021 10:33:17 AM | 11/5/2022 10:08:43 AM | Water query | Consumption decreased ,To contact consumer.<div><br></div><div>QRC RESPONSE: Query Closed</div><div>Resolved 2020/02 with a leak rebate. Consumption on new meter averaging above 23kl</div> | 27 | 3 | 5680 | 12 | 2 | 23 | 1 | 67 | [{"op":"R","uid":"20","un":"nzwanam","dt":"2021-06-21T10:32:26.987Z"}] | 1 | 67 | 11/5/2022 10:08:43 AM | 3 | 3 | |||||||||||||||||||||||
| 6557 | 6/21/2021 10:32:16 AM | 3/28/2022 7:23:36 AM | Water query | Water query - high consumption <div>RESPONSE: SIX MONTHS POLICY ADJUSTED</div><div>JOURNAL NUMBER: 747655</div><br/><b>Journal Number</b>: [BJ71747655] | 24 | 3 | 5678 | 2 | 23 | 1 | 67 | [{"op":"R","uid":"20","un":"nzwanam","dt":"2021-06-21T10:31:25.700Z"},{"op":"R","uid":"15","un":"chumab","dt":"2021-11-13T07:16:55.118Z"},{"op":"R","uid":"15","un":"chumab","dt":"2021-11-13T07:20:29.574Z"},{"op":"R","uid":"15","un":"chumab","dt":"2021-11-13T08:07:19.833Z"}] | 1 | 101 | 15 | 15 | |||||||||||||||||||||||||
| 6555 | 6/21/2021 10:31:22 AM | 11/5/2022 7:31:23 AM | WATER QUERY WITH PLUMBERS LETTER | WATER QUERY WITH PLUMBERS LETTER<div><br></div><div>QRC RESPONSE: Query Closed as account is up to date</div><div>If leaks were repaired, kindly upload a signed copy of the plumbers letter stating what was repaired with date of repairs or contact the call centre on 0861113017 for further advisement</div> | 27 | 3 | 5677 | 17 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"18","un":"lindan","dt":"2021-06-21T10:30:31.446Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-08-14T08:47:34.588Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-09-27T07:03:21.403Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2022-01-04T08:08:49.519Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2022-02-12T06:30:27.050Z"},{"op":"R","uid":"18","un":"lindan","dt":"2022-02-12T07:00:42.887Z"}] | 1 | 96 | 11/5/2022 7:31:23 AM | 3 | 3 | |||||||||||||||||||||||
| 6556 | 6/21/2021 10:30:56 AM | 3/28/2022 7:23:36 AM | Water query | Water query - high consumption for month of October 2020.<div><br></div><div>Journal processed and approved. Query resolved.</div> | 27 | 3 | 5676 | 13 | 2 | 23 | 1 | 67 | [{"op":"R","uid":"20","un":"nzwanam","dt":"2021-06-21T10:30:05.211Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-08-18T08:29:07.315Z"},{"op":"R","uid":"214","un":"nandipan","dt":"2022-02-15T07:22:29.284Z"}] | 1 | 111 | 214 | 3/28/2022 7:23:36 AM | 13 | 214 | ||||||||||||||||||||||
| 6554 | 6/21/2021 10:29:29 AM | 5/11/2022 7:05:25 AM | refuse domestic | refuse domestic -- double charge<div><br><div><br></div><div><br></div></div><br/><b>Journal Number</b>: [652736] | 27 | 3 | 5675 | 5 | 2 | 23 | 4 | 105 | [{"op":"R","uid":"20","un":"nzwanam","dt":"2021-06-21T10:28:39.186Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-10-12T13:13:11.833Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-10-12T13:13:26.086Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-10-12T13:13:29.647Z"},{"op":"R","uid":"5","un":"ivanh","dt":"2022-05-10T13:47:58.705Z"},{"op":"R","uid":"5","un":"ivanh","dt":"2022-05-11T06:38:06.013Z"},{"op":"R","uid":"5","un":"ivanh","dt":"2022-05-11T06:42:21.696Z"},{"op":"R","uid":"5","un":"ivanh","dt":"2022-05-11T07:04:30.310Z"}] | 4 | 119 | 5 | 5/11/2022 7:05:25 AM | 5 | 5 | ||||||||||||||||||||||
| 426841 | 4561 | 6/21/2021 10:28:15 AM | 6/21/2021 10:28:17 AM | IVR call: balance | Received call for balance for account 10015804 undefined | 7 | 2 | 3878 | 78 | 78 | 6/21/2021 10:28:17 AM | ||||||||||||||||||||||||||||||
| 426834 | 4561 | 6/21/2021 10:24:40 AM | 6/21/2021 10:25:00 AM | IVR call: statement | Received call for statement for account 10015804 sent message: 428 | 8 | 2 | 3878 | 79 | 79 | 6/21/2021 10:25:00 AM | 116157 | |||||||||||||||||||||||||||||
| 6553 | 6/21/2021 10:23:33 AM | 7/3/2022 11:44:41 AM | rates | consumer states that the category that she charged on should be agricultural instead of residential. he is also disputing the municipal valuation of the property.<div><div>Duplicate Query Ref no 6692.</div><div><br></div></div> | 27 | 3 | 5673 | 13 | 2 | 23 | 8 | 62 | [{"op":"R","uid":"16","un":"cumilem","dt":"2021-06-21T10:23:35.035Z"}] | 8 | 62 | 7/3/2022 11:44:13 AM | 12 | 12 | |||||||||||||||||||||||
| 6553 | 6/21/2021 10:21:44 AM | 7/3/2022 11:42:30 AM | refuse query | consumer states that he should not be charged for refuse collection.<div><br></div><div>No refuse collection on farms - Confirm with E. Dlelapantsi</div> | 23 | 3 | 5673 | 2 | 1 | 4 | 106 | [{"op":"R","uid":"16","un":"cumilem","dt":"2021-06-21T10:21:46.384Z"},{"op":"R","uid":"5","un":"ivanh","dt":"2022-05-11T07:58:19.543Z"},{"op":"R","uid":"5","un":"ivanh","dt":"2022-05-11T08:46:48.384Z"}] | 4 | 120 | 5 | 12 | |||||||||||||||||||||||||
| 6552 | 6/21/2021 10:16:05 AM | 3/12/2023 6:56:38 AM | high consumption due to leak | to monitor account for three months. Consumption still high consumer has to check internal leak and re log query. | 22 | 3 | 5672 | 17 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-06-21T10:18:01.461Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2022-02-15T06:55:16.232Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2022-05-18T09:23:44.640Z"}] | 1 | 96 | 123903 | 14 | ||||||||||||||||||||||||
| 426757 | 6551 | 6/21/2021 9:50:52 AM | 6/21/2021 9:51:37 AM | IVR call: statement | Received call for statement for account 10407345 sent message: 427 | 8 | 2 | 5669 | 79 | 79 | 6/21/2021 9:51:37 AM | 116156 | |||||||||||||||||||||||||||||
| 426739 | 6549 | 6/21/2021 9:40:50 AM | 6/21/2021 9:42:11 AM | IVR call: statement | Received call for statement for account 10307642 sent message: 426 | 8 | 2 | 5668 | 79 | 79 | 6/21/2021 9:42:11 AM | 116155 | |||||||||||||||||||||||||||||
| 426735 | 6548 | 6/21/2021 9:38:56 AM | 6/23/2021 7:43:38 AM | IVR call: statement | Received call for statement for account 10310361 sent message: 425 | 8 | 2 | 5667 | 79 | [{"op":"R","uid":"16","un":"cumilem","dt":"2021-06-23T07:42:44.973Z"}] | 79 | 6/23/2021 7:43:38 AM | 116154 | 16 | |||||||||||||||||||||||||||
| 426726 | 6547 | 6/21/2021 9:26:22 AM | 6/21/2021 9:26:24 AM | IVR call: balance | Received call for balance for account 10015808 undefined | 7 | 2 | 5666 | 78 | 78 | 6/21/2021 9:26:24 AM | ||||||||||||||||||||||||||||||
| 6546 | 6/21/2021 9:26:20 AM | 7/21/2021 12:52:55 PM | no valid query details submitted | <span lang="EN-US" style="font-size:11.0pt;font-family: "Calibri",sans-serif;mso-fareast-font-family:Calibri;mso-fareast-theme-font: minor-latin;mso-ansi-language:EN-US;mso-fareast-language:EN-ZA;mso-bidi-language: AR-SA">no valid query details submitted</span><br> | 27 | 3 | 5665 | 17 | 2 | 23 | 1 | 44 | [{"op":"R","uid":"13","un":"unathig","dt":"2021-06-21T09:26:22.055Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-13T10:02:05.716Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T12:53:11.558Z"}] | 1 | 44 | 7/21/2021 12:52:55 PM | 17 | 14 | |||||||||||||||||||||||
| 6545 | 6/21/2021 9:20:38 AM | 3/28/2022 7:07:05 AM | FIRE LEVY QUERY | FIRE LEVY QUERY<div><br></div><div><table border="0" cellpadding="0" cellspacing="0" width="249" style="border-collapse: collapse;width:187pt"><tbody><tr height="19" style="height:14.4pt"> <td height="19" class="xl65" width="249" style="height:14.4pt;width:187pt"> NO PROOF OF NEW OWNER </td></tr></tbody></table><div><br></div></div> | 4 | 3 | 5664 | 15 | 2 | 23 | 3 | 105 | [{"op":"R","uid":"18","un":"lindan","dt":"2021-06-21T09:19:47.797Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-08-13T07:03:39.018Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-08-13T08:38:52.470Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-08-13T09:04:13.379Z"}] | 3 | 105 | 3/28/2022 7:07:05 AM | 15 | 4 | |||||||||||||||||||||||
| 6529 | 6/21/2021 9:10:45 AM | 4/22/2022 12:00:06 PM | Leak Credit | Kindly assess a leak credit on this account for the period 202012 | 27 | 3 | 5663 | 8 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-06-21T09:09:55.167Z"},{"op":"R","uid":"214","un":"nandipan","dt":"2022-02-19T09:03:11.530Z"},{"op":"R","uid":"201","un":"nonkosim","dt":"2022-02-22T13:11:27.846Z"},{"op":"R","uid":"204","un":"lulamamv","dt":"2022-03-22T08:21:09.566Z"},{"op":"R","uid":"204","un":"lulamamv","dt":"2022-03-22T09:07:33.139Z"},{"op":"R","uid":"204","un":"lulamamv","dt":"2022-03-22T09:08:12.149Z"},{"op":"R","uid":"206","un":"noncedem","dt":"2022-04-22T12:00:06.523Z"}] | 1 | 96 | 214 | 4/22/2022 12:00:06 PM | 126275 | 8 | 214 |