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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2615 | 3/23/2021 1:37:21 PM | 10/23/2021 11:38:49 AM | water query | <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> | 4 | 3 | 2307 | 14 | 4 | 23 | 1 | 67 | 1209 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-03-23T13:37:23.622Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-02T10:11:03.808Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-02T10:15:26.359Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T11:38:17.328Z"}] | 9 | 123 | 18 | 10/23/2021 11:38:49 AM | 14 | 18 | |||||||||||||||||||||
| 2614 | 3/23/2021 1:34:20 PM | 11/2/2021 12:03:40 PM | water query | water query<div><br></div><div>ACCOUNT IN ODER</div> | 27 | 3 | 2306 | 14 | 4 | 23 | 77 | 67 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-03-23T13:34:24.470Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-02T10:25:47.484Z"},{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-10-17T11:27:21.976Z"},{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-11-02T12:02:34.024Z"}] | 1 | 96 | 11 | 11/2/2021 12:03:40 PM | 14 | 11 | ||||||||||||||||||||||
| 2613 | 3/23/2021 1:32:44 PM | 7/21/2021 9:58:16 AM | no valid query details submitted | no valid query details submitted | 27 | 3 | 2305 | 17 | 2 | 23 | 1 | 44 | [{"op":"R","uid":"12","un":"thembesas","dt":"2021-03-23T13:32:47.702Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-15T13:00:12.439Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T09:58:16.900Z"}] | 1 | 44 | 7/21/2021 9:58:16 AM | 17 | 14 | |||||||||||||||||||||||
| 2610 | 3/23/2021 1:19:09 PM | 1/19/2023 10:50:41 AM | Leak letter | BCMM water works fixed the leak so an e-mail is provided as proof<div><br></div><div>There is no record on repairs done by Waterworks on Emis and no e-mail as referred to above has been received.</div><div>No contact number on the system either.</div><div><br></div><div>Query closed as consumer to provide more information for further assessment<br><div><br></div><div><br></div></div> | 27 | 3 | 2304 | 75 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"173","un":"olgad","dt":"2021-03-23T13:19:37.277Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T11:37:16.004Z"},{"op":"R","uid":"13","un":"unathig","dt":"2021-11-14T10:26:29.839Z"}] | 1 | 96 | 18 | 7/2/2022 10:42:48 AM | 141642 | 3 | 3 | |||||||||||||||||||||
| 2611 | 3/23/2021 1:19:00 PM | 8/19/2022 8:24:15 AM | water query 6 month policy | water query 6 month policy<div>Duplicate query no 29956<br><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></tbody></table></div> | 27 | 3 | 2303 | 4 | 4 | 23 | 77 | 67 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-03-23T13:19:02.500Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-02T10:39:35.950Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-02T10:44:26.963Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T11:34:18.693Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T11:35:03.295Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-13T08:27:29.764Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-13T08:27:56.335Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-11-14T07:12:48.922Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-11-14T07:13:08.234Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-11-14T07:13:10.901Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-11-14T07:13:21.495Z"}] | 1 | 101 | 14 | 8/19/2022 8:24:15 AM | 12 | 12 | ||||||||||||||||||||||
| 2609 | 3/23/2021 1:15:29 PM | 11/14/2021 7:00:56 AM | water query | <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> | 4 | 3 | 2301 | 14 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-03-23T13:15:32.546Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-02T10:49:19.484Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T11:32:32.056Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T11:33:46.044Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-11-14T07:00:54.223Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-11-14T07:00:57.172Z"}] | 9 | 123 | 18 | 11/14/2021 7:00:56 AM | 14 | 18 | ||||||||||||||||||||||
| 2608 | 3/23/2021 1:15:12 PM | 11/14/2021 10:27:06 AM | Leak letter | Plumber's letter provided by consumer dated 05/02/2020 and filed | 30 | 3 | 2300 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"173","un":"olgad","dt":"2021-03-23T13:15:40.675Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T11:29:52.047Z"},{"op":"R","uid":"13","un":"unathig","dt":"2021-11-14T10:25:51.731Z"}] | 1 | 96 | 18 | 18 | |||||||||||||||||||||||||
| 2607 | 3/23/2021 1:14:00 PM | 11/20/2021 7:48:58 AM | 6 Months Policy | Please assess 6 Months Policy from 201803 to 201910 and 202008 to 202011<div><br></div><div>-water journal done 2021/10<br><div>Thanks </div></div> | 27 | 3 | 2302 | 74 | 4 | 23 | 1 | 95 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-03-23T13:14:29.676Z"},{"op":"R","uid":"172","un":"sesonad","dt":"2021-03-23T13:17:19.994Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T11:28:31.376Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T11:29:14.246Z"},{"op":"R","uid":"13","un":"unathig","dt":"2021-11-14T10:32:02.429Z"},{"op":"R","uid":"13","un":"unathig","dt":"2021-11-20T07:48:59.063Z"}] | 1 | 101 | 13 | 11/20/2021 7:48:58 AM | 172 | 13 | ||||||||||||||||||||||
| 2606 | 3/23/2021 1:12:14 PM | 10/23/2021 11:26:59 AM | water query | <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> | 4 | 3 | 2299 | 14 | 4 | 23 | 77 | 67 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-03-23T13:12:16.196Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-02T10:54:21.850Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-02T11:12:16.111Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T11:26:23.212Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T11:26:54.951Z"}] | 9 | 123 | 18 | 10/23/2021 11:26:59 AM | 14 | 18 | ||||||||||||||||||||||
| 2605 | 3/23/2021 1:08:35 PM | 2/19/2023 10:55:25 AM | water query | water query<div><br></div><div>QRC RESPONSE: 6 month policy processed and pending authorization 201602/201705.</div><div>Credit due of R 1559.36 including vat.</div><div>Journal done 19.11.22</div><br/><b>Journal Number</b>: [018178]<br/><b>Journal Amount</b>: [-R1,559.36] | 27 | 3 | 2298 | 15 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-03-23T13:08:37.744Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-03-23T13:08:45.475Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-02T11:12:59.144Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-10-17T11:07:11.677Z"}] | 1 | 101 | 4 | 2/19/2023 10:55:21 AM | 133425 | 3 | 3 | |||||||||||||||||||||
| 2604 | 3/23/2021 1:07:00 PM | 8/30/2021 11:34:18 AM | Leak letter | Leak affidavit provided by consumer dated 03/03/2021 and filed<div><br></div><div>Journal Processed with journal number BJ71726822</div><div><br></div><div>Duplicate query on ref #11984 closed</div> | 27 | 3 | 2297 | 75 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"173","un":"olgad","dt":"2021-03-23T13:07:28.087Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-08-07T11:17:53.224Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-08-16T12:43:21.501Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-08-30T11:32:10.773Z"}] | 1 | 96 | 8/30/2021 11:34:18 AM | 173 | 3 | |||||||||||||||||||||||
| 2603 | 3/23/2021 1:04:09 PM | 4/12/2022 9:47:18 AM | water query | water query<br/><b>Journal Number</b>: [447540] | 24 | 3 | 2296 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-03-23T13:04:12.065Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-03T07:17:37.359Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-10-20T12:23:28.279Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-11-02T12:28:27.232Z"}] | 1 | 101 | 4 | 4 | |||||||||||||||||||||||||
| 2602 | 3/23/2021 1:01:01 PM | 3/24/2022 8:42:18 AM | Leak letter | Leak affidavit provided by consumer dated 16/03/2021 and filed<div><br></div><div>Six Month policy adjustment processed :<b>Journal Number</b>: [466007]</div><div><br></div><div><b>RESPONSE QRC</b>: Six month policy, Journal {466007}Authorized.</div><br> | 27 | 3 | 2295 | 8 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"173","un":"olgad","dt":"2021-03-23T13:01:28.410Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T11:24:09.595Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T11:24:45.977Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-11-04T11:00:44.717Z"},{"op":"R","uid":"202","un":"buyiswam","dt":"2022-03-24T08:42:19.187Z"}] | 1 | 96 | 230 | 3/24/2022 8:42:18 AM | 8 | 230 | ||||||||||||||||||||||
| 2599 | 3/23/2021 12:50:32 PM | 10/23/2021 11:23:04 AM | water query | <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> | 4 | 3 | 2294 | 14 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-03-23T12:50:34.348Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-03-23T12:50:43.512Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-02T11:35:55.007Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-03T07:22:04.551Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-03T07:27:22.673Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T11:22:26.863Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T11:22:59.331Z"}] | 9 | 123 | 18 | 10/23/2021 11:23:04 AM | 14 | 18 | ||||||||||||||||||||||
| 2601 | 3/23/2021 12:50:26 PM | 11/14/2021 7:08:12 AM | 6 Months Policy | w/off | 27 | 3 | 2293 | 74 | 3 | 23 | 1 | 95 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-03-23T12:50:55.168Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T11:21:22.317Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T11:22:10.609Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-11-14T07:01:25.541Z"}] | 1 | 101 | 17 | 11/14/2021 7:08:12 AM | 172 | 17 | ||||||||||||||||||||||
| 2600 | 3/23/2021 12:47:12 PM | 11/14/2021 7:43:05 AM | Leak letter | <p class="MsoNormal"><span lang="EN-ZA">• The account is affected with stage 3 water restriction tariffs as the current consumption exceeds 21+kl<o:p></o:p></span></p> | 27 | 3 | 2292 | 75 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"173","un":"olgad","dt":"2021-03-23T12:47:39.527Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T11:20:20.216Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-11-14T07:38:11.217Z"}] | 1 | 96 | 17 | 11/14/2021 7:43:05 AM | 173 | 17 | ||||||||||||||||||||||
| 2598 | 3/23/2021 12:41:56 PM | 11/12/2021 10:41:24 AM | water query 6 month policy | water query | 27 | 3 | 2291 | 14 | 4 | 23 | 77 | 67 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-03-23T12:42:00.004Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-03T07:28:36.556Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-10-17T11:49:20.525Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-11-12T10:41:24.460Z"}] | 1 | 113 | 4 | 11/12/2021 10:41:24 AM | 14 | 4 | ||||||||||||||||||||||
| 2597 | 3/23/2021 12:40:43 PM | 7/2/2022 10:54:40 AM | Leak letter | Leak affidavit provided by consumer dated 19/11/2020 | 30 | 3 | 2290 | 4 | 23 | 1 | 96 | [{"op":"R","uid":"173","un":"olgad","dt":"2021-03-23T12:41:10.580Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T11:19:14.064Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T11:19:34.362Z"},{"op":"R","uid":"13","un":"unathig","dt":"2021-11-14T10:27:52.692Z"}] | 1 | 96 | 18 | 18 | |||||||||||||||||||||||||
| 2594 | 3/23/2021 12:30:51 PM | 8/21/2021 7:13:38 AM | Leak letter | Leak affidavit provided by consumer dated 11/08/2020<div><br></div><div>water w/off paid the debit</div> | 27 | 3 | 2289 | 75 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"173","un":"olgad","dt":"2021-03-23T12:31:19.809Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-08-14T07:42:30.445Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-08-21T07:17:43.553Z"}] | 1 | 96 | 8/21/2021 7:13:38 AM | 173 | 6 | |||||||||||||||||||||||
| 2595 | 3/23/2021 12:22:16 PM | 2/17/2022 9:54:41 AM | 6 Months | Kindly apply a six months policy for the following period <div><br></div><div>SIX MONTHS POLICY ADJUSTED</div><br/><b>Journal Number</b>: [815489] | 24 | 3 | 2288 | 4 | 23 | 1 | 95 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-03-23T12:22:44.566Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T11:17:40.613Z"},{"op":"R","uid":"15","un":"chumab","dt":"2022-02-17T09:52:28.893Z"}] | 1 | 101 | 15 | 124110 | 15 |