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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3016 | 4/6/2021 12:48:31 PM | 7/3/2022 6:51:33 AM | HIGH WATER CONSUMPTION | There is a water consumption and they last read in 2020/10/29<div><br></div><div>Readings are up to date and debt written off June 2021 and June 2022. Acc up to date, query closed</div> | 27 | 3 | 2625 | 13 | 4 | 23 | 1 | 67 | 1340 | [{"op":"R","uid":"199","un":"siphokazin","dt":"2021-04-06T12:48:54.894Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-31T08:12:13.940Z"}] | 1 | 101 | 14 | 7/3/2022 6:51:33 AM | 3 | 3 | |||||||||||||||||||||
| 3015 | 4/6/2021 12:43:31 PM | 7/21/2021 10:41:11 AM | no valid query details submitted | no valid query details submitted | 27 | 3 | 2624 | 4 | 2 | 23 | 1 | 44 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-04-06T12:43:33.511Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-15T12:45:33.773Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T10:41:12.574Z"}] | 1 | 44 | 7/21/2021 10:41:11 AM | 4 | 14 | |||||||||||||||||||||||
| 3014 | 4/6/2021 12:09:30 PM | 9/7/2022 12:27:48 PM | 6 Months Policy | Kindly assess a 6 Months policy for the period 2019/09-2020/11<div><br></div><div>SIX MONTHS POLICY ADJUSTMENT DONE</div><br/><b>Journal Number</b>: [994474]<br/><b>Journal Amount</b>: [-R5,523.17] | 27 | 3 | 2623 | 13 | 3 | 23 | 1 | 95 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-04-06T12:09:32.650Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-31T08:11:19.642Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-11-10T09:09:52.755Z"},{"op":"R","uid":"15","un":"chumab","dt":"2022-02-21T12:22:30.534Z"}] | 1 | 101 | 15 | 9/7/2022 12:27:42 PM | 124332 | 3 | 3 | |||||||||||||||||||||
| 3012 | 4/6/2021 11:26:40 AM | 7/21/2021 10:41:45 AM | no valid query details submitted | no valid query details submitted | 27 | 3 | 2622 | 5 | 2 | 23 | 1 | 44 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-04-06T11:26:42.025Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-15T12:46:02.134Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T10:41:50.902Z"}] | 1 | 44 | 7/21/2021 10:41:45 AM | 5 | 14 | |||||||||||||||||||||||
| 3011 | 4/6/2021 11:17:28 AM | 11/10/2021 9:09:13 AM | LOG QUERY | <table border="0" cellpadding="0" cellspacing="0" width="864" style="border-collapse: collapse;width:648pt"><tbody><tr height="20" style="height:15.0pt"> <td height="20" class="xl65" width="864" style="height:15.0pt;width:648pt">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> | 27 | 3 | 2621 | 14 | 2 | 23 | 77 | 107 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-04-06T11:17:37.338Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-05-11T10:04:02.997Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-31T08:09:29.379Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-11-10T09:09:05.413Z"}] | 9 | 123 | 6 | 11/10/2021 9:09:13 AM | 14 | 6 | ||||||||||||||||||||||
| 3010 | 4/6/2021 10:52:34 AM | 3/28/2022 7:07:05 AM | LOG QUERY | 06 Month Policy 2021/03<br/><b>Journal Number</b>: [709373]<br/><b>Journal Amount</b>: [-R8,782.93] | 27 | 3 | 2620 | 15 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"16","un":"cumilem","dt":"2021-04-06T10:52:43.345Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-05-12T07:11:43.977Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-31T08:05:48.885Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-12-15T10:09:25.428Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2022-02-27T10:59:27.544Z"}] | 1 | 101 | 3 | 3/28/2022 7:07:05 AM | 15 | 3 | ||||||||||||||||||||||
| 3009 | 4/6/2021 10:25:25 AM | 11/10/2021 6:51:19 AM | Reverse fire levy chargers | <p class="MsoNormal">Kindly reverse fire levy charges as the erfs have been consolidated into one erf KID02564.The account numbers are as follows 10309604,10309594,10309599</p><p class="MsoNormal"><o:p></o:p></p> | 27 | 3 | 2619 | 74 | 2 | 23 | 3 | 105 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-04-06T10:25:33.055Z"},{"op":"R","uid":"5","un":"ivanh","dt":"2021-06-09T13:33:27.876Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-31T07:54:54.451Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-11-10T06:51:02.639Z"}] | 3 | 105 | 6 | 11/10/2021 6:51:19 AM | 172 | 6 | ||||||||||||||||||||||
| 3007 | 4/6/2021 10:04:12 AM | 3/31/2022 7:15:38 AM | no valid query details submitted | no valid query details submitted | 27 | 3 | 2618 | 17 | 2 | 23 | 1 | 44 | [{"op":"R","uid":"173","un":"olgad","dt":"2021-04-06T10:04:14.505Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-15T12:46:32.226Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T10:42:24.853Z"},{"op":"R","uid":"893","un":"nasiphina","dt":"2022-03-31T07:15:38.315Z"}] | 1 | 44 | 3/31/2022 7:15:38 AM | 17 | 893 | |||||||||||||||||||||||
| 3006 | 4/6/2021 10:03:21 AM | 4/6/2021 10:08:48 AM | high water consumption | There is a high water consumption in 2020/10/08 | 30 | 1 | 18 | 22 | [{"op":"R","uid":"199","un":"siphokazin","dt":"2021-04-06T10:03:30.655Z"},{"op":"R","uid":"199","un":"siphokazin","dt":"2021-04-06T10:08:48.152Z"}] | 22 | 199 | ||||||||||||||||||||||||||||||
| 3005 | 4/6/2021 9:54:31 AM | 2/18/2023 10:40:53 AM | Leak letter | Leak letter provided by consumer and filed.<div><br></div><div>QRC Response:DATE 18/02/2023</div><div><br></div><div>Account adjusted 04/2022</div> | 27 | 3 | 2616 | 17 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"173","un":"olgad","dt":"2021-04-06T09:54:33.881Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-31T07:53:21.598Z"}] | 1 | 96 | 14 | 2/18/2023 10:40:53 AM | 12 | 12 | ||||||||||||||||||||||
| 3004 | 4/6/2021 9:31:56 AM | 3/26/2023 5:58:24 AM | Leak letter | Leak letter provided by consumer and filed.<div>customer needs to re submit leak letter</div><div><br></div><div>Consumer to resubmit a signed copy of the plumbers letter as the one received is in an excel version and unsigned. </div><div>Meter has since been changed, but not updated on Solar. </div><div>Requested meter change with reading update in order to proceed with leak credit - 03.07.2022</div><div><br></div><div><u><b>QRC: Response 2023/01/11</b></u>,Plumber's letter is not uploaded on portal system Aivir ,consumer to submit plumber's letter as to commence with the leak rebate.</div><div><br></div><div>QRC Response :DATE 18/02/2023</div><div>Leak consumption is less than current consumption .</div><div>Reading updated interims will be reversed in Feb Billing.</div> | 30 | 3 | 2615 | 17 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"173","un":"olgad","dt":"2021-04-06T09:31:58.789Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-31T07:51:29.922Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-11-10T09:04:07.849Z"},{"op":"R","uid":"893","un":"nasiphina","dt":"2022-03-30T07:13:37.930Z"}] | 1 | 96 | 6 | 141525 | 3 | |||||||||||||||||||||||
| 3003 | 4/6/2021 9:25:05 AM | 3/30/2023 8:06:36 AM | Leak letter | Leak letter provided by consumer and filed.<div><br></div><div>Plumbers letter uploaded with date of repairs being March 2021.</div><div>Requested audit on meter and check reading as meter is billing zero consumption since May 2021. </div><div>Assessment will continue once readings have been verified in order to assess a fair average - 03.07.2022</div><div><u><i><b>QRC-Response 2023/01/11</b></i></u>,Based on assessment consumption not recorded on solar system,query has been forwarded to billing department for verification of readings and email requesting verification has been forwarded as well.</div><div>QRC RESPONSE: leak credit for 201710-202103 has been processed, average 13kl.</div><br/><b>Journal Number</b>: [011359]<br/><b>Journal Amount</b>: [156830.23] | 27 | 3 | 2614 | 17 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"173","un":"olgad","dt":"2021-04-06T09:25:08.302Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-31T07:50:05.992Z"}] | 1 | 96 | 14 | 3/30/2023 8:06:25 AM | 2 | 2 | ||||||||||||||||||||||
| 3002 | 4/6/2021 9:07:20 AM | 2/19/2023 10:53:29 AM | Plumber's report | Plumbers reports for high consumption is filed.<div>consumer needs to re submit the leak letter</div><div>QRC Response : DATE 19/02/2023</div><div>Account adjusted 03/2022</div> | 27 | 3 | 2613 | 17 | 2 | 23 | 1 | 67 | 1326 | [{"op":"R","uid":"173","un":"olgad","dt":"2021-04-06T09:07:22.051Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-31T07:49:14.098Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-11-10T08:54:49.823Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2022-02-01T12:41:59.704Z"}] | 1 | 96 | 6 | 2/19/2023 10:53:29 AM | 12 | 12 | |||||||||||||||||||||
| 3001 | 4/6/2021 8:56:43 AM | 3/28/2022 7:10:22 AM | Leak letter | Leak letter provided by consumer and filed.<div>leak credit journal done 202005 AV 10KL</div><br/><b>Journal Number</b>: [-R697.99] | 27 | 3 | 2612 | 11 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"173","un":"olgad","dt":"2021-04-06T08:56:52.098Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-10-31T06:50:34.875Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-31T07:48:24.349Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-12-06T12:29:43.084Z"}] | 1 | 96 | 3 | 3/28/2022 7:10:22 AM | 11 | 3 | ||||||||||||||||||||||
| 3000 | 4/6/2021 8:54:18 AM | 6/12/2021 9:14:39 AM | Leak letter | Leak letter provided by consumer and filed.<div>Duplicate query closed</div> | 27 | 3 | 2611 | 75 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"173","un":"olgad","dt":"2021-04-06T08:54:22.252Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-06-12T09:13:33.963Z"}] | 1 | 96 | 6/12/2021 9:14:39 AM | 173 | 3 | |||||||||||||||||||||||
| 2999 | 4/6/2021 8:43:21 AM | 2/18/2023 10:24:39 AM | Leak letter | Leak letter provided by consumer and filed.<div>QRC Response:DATE 18/02/2023</div><div>Current consumption still high .</div> | 30 | 3 | 2610 | 17 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"173","un":"olgad","dt":"2021-04-06T08:43:23.915Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-31T07:47:37.248Z"}] | 1 | 96 | 14 | 12 | ||||||||||||||||||||||||
| 2998 | 4/6/2021 8:38:06 AM | 2/17/2023 1:24:38 PM | Leak letter | Leak letter provided by consumer and filed.<div><br></div><div><b>Monitoring Reason</b>: [Consumption to be monitored based on date of repairs]<br></div><div>QRC Response :DATE17/02/2023</div><div>six months policy applied 02/2022</div> | 27 | 3 | 2609 | 17 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"173","un":"olgad","dt":"2021-04-06T08:38:08.525Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-31T07:43:49.075Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-12-07T08:29:54.240Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2022-02-27T11:07:09.461Z"}] | 1 | 96 | 3 | 2/17/2023 1:24:37 PM | 12 | 12 | ||||||||||||||||||||||
| 2997 | 4/6/2021 8:31:44 AM | 2/19/2023 10:15:25 AM | Leak letter | Leak letter provided by consumer and filed.<div><u><i><b>QRC: Response 2023/01/11</b></i></u> the consumer has been contacted and emailed as to request the consumer to state the date of repairs with the plumber''s letter received,in order to commence with the leak rebate.</div><div><br></div><div><br></div> | 27 | 3 | 2608 | 12 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"173","un":"olgad","dt":"2021-04-06T08:31:47.808Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-31T07:43:07.634Z"}] | 1 | 96 | 14 | 2/18/2023 10:17:00 AM | 141516 | 12 | 12 | |||||||||||||||||||||
| 2996 | 4/6/2021 8:01:38 AM | 2/17/2023 12:51:24 PM | Leak letter | Leak letter provided by consumer and filed.<div>QRC Response : DATE 17/02/2023</div><div>Account adjusted 11/2021</div> | 27 | 3 | 2607 | 17 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"173","un":"olgad","dt":"2021-04-06T08:01:40.791Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-31T07:42:30.145Z"}] | 1 | 96 | 14 | 2/17/2023 12:51:24 PM | 12 | 12 | ||||||||||||||||||||||
| 2995 | 4/6/2021 7:54:10 AM | 2/17/2023 12:42:10 PM | Leak letter | leak credit applied<br><b>Journal Number</b>: [994345]<div>QRC Response : DATE 17/02/2023</div><div>Account adjusted 03/2022</div> | 27 | 3 | 2606 | 17 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"173","un":"olgad","dt":"2021-04-06T07:54:12.254Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-31T07:41:47.935Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-11-10T06:48:50.083Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-11-10T08:56:39.774Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2022-02-21T08:08:52.186Z"}] | 1 | 96 | 12 | 2/17/2023 12:42:09 PM | 12 | 12 |