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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2777 | 3/26/2021 10:39:29 AM | 7/2/2022 12:24:53 PM | Leak letter and six months policy | Affidavit for leak provided by consumer.<div>Please also assess for six months policy for period 2018/01-2019/03</div><div><br></div><div>No letter received.</div><div>Debt Written off June 2022. Acc up to date and query closed</div><div><br></div> | 27 | 3 | 2443 | 75 | 3 | 23 | 1 | 96 | [{"op":"R","uid":"173","un":"olgad","dt":"2021-03-26T10:35:41.904Z"},{"op":"R","uid":"173","un":"olgad","dt":"2021-03-26T10:40:49.513Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-08-15T06:45:24.149Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T08:28:22.222Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T08:28:47.368Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T08:29:26.648Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2022-02-19T06:33:47.369Z"}] | 1 | 96 | 18 | 7/2/2022 12:24:53 PM | 3 | 3 | ||||||||||||||||||||||
| 2780 | 3/26/2021 10:38:50 AM | 3/28/2022 6:33:19 AM | 6 MONTHS POLICY | 6 MONTHS PROCESSED....WAITING TO BE AUTHORISED<br><b>Journal Number</b>: [769811]<div><br></div><div>Query resolved with journal adjustment</div> | 27 | 3 | 2445 | 3 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-03-26T10:38:52.970Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-03-26T11:40:21.746Z"}] | 1 | 96 | 3/28/2022 6:33:19 AM | 3 | 3 | |||||||||||||||||||||||
| 2779 | 3/26/2021 10:38:32 AM | 11/14/2021 10:42:51 AM | Leak Credit | Kindly assess a leak credit. There was a breakage of water pipes that happened on the 24th December 2020 .<div><b>Response from QRC</b>, plumbers letter received or affidavit.</div> | 30 | 3 | 2444 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-03-26T10:38:55.669Z"},{"op":"R","uid":"173","un":"olgad","dt":"2021-06-11T06:45:54.824Z"},{"op":"R","uid":"173","un":"olgad","dt":"2021-06-11T06:46:14.103Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-09-14T06:44:34.625Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T08:26:57.477Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T08:27:13.880Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T08:28:06.697Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-11-14T10:42:51.441Z"}] | 1 | 96 | 18 | 18 | |||||||||||||||||||||||||
| 2778 | 3/26/2021 10:35:28 AM | 3/28/2022 7:08:29 AM | 06 Month Policy 2019/12 | 06 Month Policy adjustment done for the 2019/12 billing<div><br><b>Journal Number</b>: [bj71744816]</div><br><b>Journal Amount</b>: [-R3,232.41]<div><br></div><div><br></div><div><u>Leak CR,202003-202101 AVE 13KL</u></div><div><u><br></u></div><div><b>Journal Number</b>: [235003]<u><br></u></div><div><br></div><div><b>RESPONSE QRC</b>: Leak CR,202003-202101 AVE 13KL,Journal{235003}Authorized</div><div><br></div><div><br></div> | 27 | 3 | 2442 | 6 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-03-26T10:35:30.797Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-08-14T11:07:39.033Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T08:25:20.662Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T08:26:06.816Z"},{"op":"R","uid":"15","un":"chumab","dt":"2021-11-09T09:29:46.253Z"},{"op":"R","uid":"15","un":"chumab","dt":"2021-11-09T09:30:03.663Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-11-10T08:14:57.388Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-11-10T08:15:27.115Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-11-12T12:04:20.679Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2022-03-24T08:07:01.579Z"}] | 1 | 101 | 230 | 3/28/2022 7:08:29 AM | 6 | 230 | ||||||||||||||||||||||
| 2776 | 3/26/2021 10:32:56 AM | 3/28/2022 6:33:19 AM | LEAK CREDIT JOURNAL DONE | LEAK CREDIT JOURNAL DONE<br/><b>Journal Number</b>: [770335]<br/><b>Journal Amount</b>: [R137,545.39] | 27 | 3 | 2441 | 3 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"6","un":"lusandad","dt":"2021-03-26T10:33:00.079Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-04-19T12:03:37.214Z"}] | 1 | 96 | 3/28/2022 6:33:19 AM | 3 | 3 | |||||||||||||||||||||||
| 2775 | 3/26/2021 10:29:18 AM | 5/19/2022 7:53:10 AM | WATER QUERY | WATER QUERY | 27 | 3 | 2440 | 18 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"18","un":"lindan","dt":"2021-03-26T10:25:33.460Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-23T08:15:52.674Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-29T10:05:06.892Z"}] | 77 | 67 | 5/19/2022 7:53:10 AM | 18 | 12 | |||||||||||||||||||||||
| 2774 | 3/26/2021 10:28:52 AM | 5/16/2023 7:46:31 AM | Leak letter | Affidavit provided by consumer dated 15/09/2020<div>Journal Done</div> | 23 | 3 | 2439 | 17 | 3 | 23 | 1 | 96 | [{"op":"R","uid":"173","un":"olgad","dt":"2021-03-26T10:25:05.218Z"},{"op":"R","uid":"173","un":"olgad","dt":"2021-03-26T10:39:41.813Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-08-14T09:43:18.503Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-08-15T06:44:07.788Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-10-14T07:24:06.957Z"},{"op":"R","uid":"232","un":"philiswan","dt":"2022-04-26T06:16:16.620Z"},{"op":"R","uid":"232","un":"philiswan","dt":"2022-04-29T06:12:43.210Z"}] | 1 | 96 | 17 | 128304 | 778 | |||||||||||||||||||||||
| 2773 | 3/26/2021 10:28:15 AM | 3/24/2023 9:33:06 AM | Leak Credit | Kindly assess a leak credit that was checked on the 19 March 2021. <div><b>QRC Response 2023/02/23</b> ,Plumber's letter received.</div><div><i style="">Leak adjustment has been done for period 202010-202104 ,journal submitted for </i><i>review and authorization .<b>Journal Number:</b> [735432]</i></div><div><i>Water had been adjusted with a CR of R 166 149.25 (Inclusive of vat and Interest</i><i> )for period 202010-202104</i></div><br/><b>Journal Amount</b>: [166125.45] | 27 | 3 | 2438 | 17 | 4 | 23 | 1 | 96 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-03-26T10:28:39.507Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T08:23:55.790Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T08:24:20.046Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T08:24:49.187Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-11-14T08:30:27.061Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-11-14T09:33:43.012Z"}] | 1 | 96 | 18 | 3/24/2023 9:32:59 AM | 119793 | 2 | 2 | |||||||||||||||||||||
| 2772 | 3/26/2021 10:26:52 AM | 3/26/2021 10:26:54 AM | 2 | [{"op":"R","uid":"73","un":"nombongof","dt":"2021-03-26T10:26:54.117Z"}] | 73 | ||||||||||||||||||||||||||||||||||||
| 2770 | 3/26/2021 10:20:01 AM | 3/15/2022 9:12:15 AM | Leak letter | Affidavit provided by consumer dated 13/09/2020<div>Journal Done</div> | 27 | 3 | 2437 | 75 | 3 | 23 | 1 | 96 | [{"op":"R","uid":"173","un":"olgad","dt":"2021-03-26T10:16:14.721Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-08-15T06:41:47.932Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-10-14T10:44:13.682Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-11-14T08:29:32.738Z"},{"op":"R","uid":"911","un":"trylizam","dt":"2022-03-15T09:12:04.777Z"}] | 1 | 96 | 17 | 3/15/2022 9:12:15 AM | 173 | 17 | ||||||||||||||||||||||
| 2769 | 3/26/2021 10:04:18 AM | 10/29/2021 10:46:04 AM | Leak Credit and 6 Months Policy | <table border="0" cellpadding="0" cellspacing="0" width="668" style="border-collapse: collapse;width:501pt"><tbody><tr height="26" style="height:19.5pt"> <td height="26" class="xl65" width="668" style="height:19.5pt;width:501pt">Query is being voided as no details of query were logged. Query was logged only as "Log Query" with no category or sub category selected. New query to be logged with full information of query.</td></tr></tbody></table> | 4 | 3 | 74 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-03-26T10:04:42.516Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T08:23:16.168Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-29T10:45:09.131Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-29T10:45:17.277Z"}] | 9 | 123 | 14 | 10/29/2021 10:46:04 AM | 172 | 14 | |||||||||||||||||||||||
| 2760 | 3/26/2021 9:59:27 AM | 5/29/2022 10:26:33 AM | Leak letter | Affidavit provided by consumer dated 18/01/19<div>leak credit adjustment done for 201810-201902 AV 3kl</div><br/><b>Journal Number</b>: [156899]<br/><b>Journal Amount</b>: [-R3,508.22] | 27 | 3 | 2436 | 12 | 3 | 23 | 1 | 96 | [{"op":"R","uid":"173","un":"olgad","dt":"2021-03-26T09:55:39.770Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T08:21:39.516Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T08:22:26.078Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-11-14T08:24:18.542Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-11-27T08:08:02.591Z"},{"op":"R","uid":"232","un":"philiswan","dt":"2022-03-23T13:45:14.980Z"}] | 1 | 96 | 6 | 5/29/2022 10:26:29 AM | 3 | 3 | ||||||||||||||||||||||
| 2767 | 3/26/2021 9:57:39 AM | 5/19/2022 7:53:10 AM | WATER QUERY | WATER QUERY | 27 | 3 | 2435 | 18 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"18","un":"lindan","dt":"2021-03-26T09:53:54.226Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-23T08:13:35.433Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-10-16T10:14:40.801Z"}] | 1 | 112 | 4 | 5/19/2022 7:53:10 AM | 18 | 4 | ||||||||||||||||||||||
| 2766 | 3/26/2021 9:45:26 AM | 11/21/2021 8:25:58 AM | 6 Months Policy | Kindly assess a Leak that was discovered on the 8th July 2020. Repairs were completed on the 3rd September 2020.<div>Credit is due </div> | 27 | 3 | 2434 | 74 | 2 | 23 | 1 | 95 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-03-26T09:45:49.891Z"},{"op":"R","uid":"172","un":"sesonad","dt":"2021-03-26T09:59:02.683Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T08:19:17.361Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T08:20:17.239Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T08:21:24.712Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-11-14T08:21:06.381Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-11-14T11:29:38.103Z"},{"op":"R","uid":"13","un":"unathig","dt":"2021-11-21T08:24:40.982Z"}] | 1 | 101 | 4 | 11/21/2021 8:25:58 AM | 119772 | 172 | 4 | |||||||||||||||||||||
| 2761 | 3/26/2021 9:27:45 AM | 5/19/2022 7:53:10 AM | WATER AND REFUSE QUERY | WATER AND REFUSE QUERY | 27 | 3 | 2433 | 18 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"18","un":"lindan","dt":"2021-03-26T09:24:00.521Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-22T08:13:35.666Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-23T08:13:59.267Z"}] | 77 | 67 | 5/19/2022 7:53:10 AM | 18 | 14 | |||||||||||||||||||||||
| 2759 | 3/26/2021 9:09:56 AM | 4/12/2022 9:42:39 AM | WATER QUERY | BCMM fixed something on their side and they say it did not affect consumer side,phoned the consumer and she promised to send the plumbers letter of the underground pipe that was fixed by the insurance company.<div>Journal Done</div><br/><b>Journal Number</b>: [421977]<br/><b>Journal Amount</b>: [-R39,117.70] | 27 | 3 | 2432 | 132 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"18","un":"lindan","dt":"2021-03-26T09:06:10.748Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-05-27T07:50:19.161Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-10-06T13:46:44.129Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-10-14T07:45:27.573Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-11-22T13:21:46.454Z"}] | 1 | 96 | 3 | 4/12/2022 9:42:39 AM | 230 | 3 | ||||||||||||||||||||||
| 2757 | 3/26/2021 9:02:12 AM | 7/2/2022 1:04:59 PM | Leak letter | Affidavit provided by consumer dated 10/08/2020<div><br></div><div>NEED PLUMBERS LETTER</div><div><br></div><div>Affidavit does not refer to leak repairs (copy uploaded as reference).</div><div>Aug 2020 reflects high usage affected with punitive tariffs, but account settled in full. Account status is indigent and received write off in June 2022. Acc up to date and query closed</div> | 27 | 3 | 2431 | 75 | 3 | 23 | 1 | 96 | [{"op":"R","uid":"173","un":"olgad","dt":"2021-03-26T08:58:28.943Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-08-15T06:31:40.715Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T08:18:05.687Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T08:18:55.788Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T08:19:02.389Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-11-14T11:13:34.508Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-11-14T11:23:12.711Z"}] | 1 | 96 | 4 | 7/2/2022 1:04:59 PM | 3 | 3 | ||||||||||||||||||||||
| 2758 | 3/26/2021 9:01:59 AM | 10/28/2022 1:36:21 PM | Leak Credit | Kindly assess a possible water leak. It was inspected on the 26th December 2020.Meter was repaired on the 9th December 2020<div><br></div><div>QRC RESPONSE: Query Closed: 20.10.2022</div><div>Waterworks inspected the property and found the meter turning at 0.100 l/minute indicating an internal leak, nobody was at home at the time of the plumbers visit. Current reading was 1232 on the 20/10/2022.</div><div>Consumer to attend to repairs and log a new query by uploading a signed copy of the plumbers letter stating what was repaired with date of repairs</div> | 27 | 3 | 2430 | 17 | 2 | 23 | 1 | 95 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-03-26T09:02:23.019Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T08:16:06.602Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T08:17:46.863Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-11-14T10:36:43.374Z"}] | 1 | 96 | 18 | 10/28/2022 1:36:21 PM | 119797 | 3 | 3 | |||||||||||||||||||||
| 2756 | 3/26/2021 9:01:57 AM | 3/28/2022 7:25:06 AM | water | <table border="0" cellpadding="0" cellspacing="0" width="770" style="border-collapse: collapse;width:578pt"> <colgroup><col width="770" style="mso-width-source:userset;mso-width-alt:24640;width:578pt"> </colgroup><tbody><tr height="21" style="height:15.75pt"> <td height="21" class="xl65" width="770" style="height:15.75pt;width:578pt">Query is being voided as no details of query were logged, query was logged only as "Log Query" with no category</td> </tr> <tr height="21" style="height:15.75pt"> <td height="21" class="xl66" width="770" style="height:15.75pt;width:578pt">selected . New query to be logged with full information fo query</td> </tr></tbody></table><br/><b>Journal Number</b>: [830302]<br/><b>Journal Amount</b>: [51691.55] | 27 | 3 | 2429 | 17 | 4 | 23 | 1 | 95 | 1240 | [{"op":"R","uid":"182","un":"zimbiniz","dt":"2021-03-26T09:02:01.265Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-22T07:32:41.417Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-22T07:33:33.032Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T08:13:33.788Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T08:14:52.323Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-12-03T10:07:20.029Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2021-12-03T11:06:51.131Z"}] | 1 | 101 | 2 | 3/28/2022 7:25:06 AM | 17 | 2 | |||||||||||||||||||||
| 2755 | 3/26/2021 8:56:46 AM | 11/11/2022 12:51:34 PM | Leak letter | Plumber's letter provided by consumer dated 04/05/2018<div><br></div><div>NEED PLUMBERS LETTER</div><div><br></div><div>Duplicate query resolved. Active ref #5282</div> | 27 | 3 | 2428 | 17 | 3 | 23 | 1 | 96 | [{"op":"R","uid":"173","un":"olgad","dt":"2021-03-26T08:53:39.270Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-08-18T12:36:20.980Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T08:12:12.323Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T08:12:31.784Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-11-14T11:12:01.724Z"}] | 1 | 96 | 4 | 11/11/2022 12:51:34 PM | 3 | 3 |