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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2876 | 3/30/2021 8:17:44 AM | 5/19/2022 7:53:10 AM | ELECTRICITY QUERY | account is in order | 27 | 3 | 2513 | 18 | 2 | 23 | 77 | 44 | [{"op":"R","uid":"18","un":"lindan","dt":"2021-03-30T08:13:56.976Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-15T09:23:44.231Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-15T09:24:39.274Z"}] | 77 | 44 | 5/19/2022 7:53:10 AM | 18 | 12 | |||||||||||||||||||||||
| 2874 | 3/30/2021 7:44:26 AM | 3/30/2021 7:44:28 AM | 2 | 2512 | [{"op":"R","uid":"21","un":"heinrichs","dt":"2021-03-30T07:44:28.191Z"}] | 21 | |||||||||||||||||||||||||||||||||||
| 2873 | 3/30/2021 7:41:24 AM | 3/2/2022 8:22:38 AM | Water query - overcharge | Consumer is disputing her December water charge, she claims to have not been around East London during the December period, which should have resulted in a less than normal water charge. | 27 | 3 | 2511 | 37 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"37","un":"sokanan","dt":"2021-03-30T07:41:47.986Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-10-16T11:33:21.965Z"}] | 1 | 112 | 4 | 3/2/2022 8:22:38 AM | 37 | 4 | ||||||||||||||||||||||
| 2872 | 3/30/2021 7:40:24 AM | 10/16/2022 6:44:17 AM | WATER /LEAK SUBMITTED A PLUMBERS LETTER | WATER/LEAK QUERY<div><br></div><div>Resolved 2021/10 as meter transfer and termination </div> | 27 | 3 | 2510 | 4 | 3 | 23 | 77 | 96 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-03-30T07:41:05.011Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2021-08-02T08:20:46.974Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T09:38:08.097Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T09:39:04.470Z"}] | 6 | 122 | 18 | 10/16/2022 6:44:16 AM | 3 | 3 | ||||||||||||||||||||||
| 2871 | 3/30/2021 7:39:06 AM | 5/19/2022 7:51:12 AM | Indigent Consumer Debt | Consumer is Querying the High debt on her account as a Pensioner/Indigent Consumer.<div>debt write off June 2021</div> | 27 | 3 | 2509 | 16 | 2 | 23 | 77 | 108 | [{"op":"R","uid":"16","un":"cumilem","dt":"2021-03-30T07:39:24.260Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2021-08-02T08:21:13.402Z"}] | 77 | 108 | 5/19/2022 7:51:12 AM | 16 | 2 | |||||||||||||||||||||||
| 2869 | 3/30/2021 7:30:19 AM | 3/18/2022 12:28:40 PM | 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 | 2508 | 14 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-03-30T07:30:37.706Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-07-16T09:44:51.478Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T09:36:10.168Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T09:36:42.829Z"},{"op":"R","uid":"201","un":"nonkosim","dt":"2022-03-18T12:28:40.842Z"}] | 9 | 123 | 18 | 3/18/2022 12:28:40 PM | 14 | 18 | ||||||||||||||||||||||
| 2868 | 3/30/2021 7:20:22 AM | 11/14/2021 11:48:09 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 | 2507 | 14 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-03-30T07:20:41.198Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-07-16T07:33:46.096Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T09:30:04.564Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T09:30:38.255Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-11-14T11:48:09.824Z"}] | 9 | 123 | 18 | 11/14/2021 11:48:09 AM | 14 | 18 | ||||||||||||||||||||||
| 2866 | 3/30/2021 7:14:57 AM | 2/10/2022 6:59:30 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 | 2506 | 14 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-03-30T07:15:16.311Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-07-16T09:33:39.269Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T09:28:32.579Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T09:29:07.626Z"},{"op":"R","uid":"18","un":"lindan","dt":"2022-02-10T06:59:30.975Z"}] | 9 | 123 | 18 | 2/10/2022 6:59:30 AM | 14 | 18 | ||||||||||||||||||||||
| 2865 | 3/30/2021 7:10:42 AM | 5/19/2022 7:51:12 AM | Duplicate Water Charge | <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 | 2505 | 16 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"16","un":"cumilem","dt":"2021-03-30T07:11:01.224Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-07-16T09:30:10.526Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T09:26:51.182Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T09:27:30.374Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-11-14T11:47:48.518Z"}] | 9 | 123 | 18 | 5/19/2022 7:51:12 AM | 16 | 18 | ||||||||||||||||||||||
| 2864 | 3/30/2021 7:07:35 AM | 11/18/2021 1:03:28 PM | 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> | 27 | 3 | 2504 | 14 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-03-30T07:07:53.373Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T09:25:08.129Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T09:25:39.153Z"},{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-11-18T13:01:17.442Z"}] | 9 | 123 | 11 | 11/18/2021 1:03:28 PM | 14 | 11 | ||||||||||||||||||||||
| 2863 | 3/30/2021 6:56:35 AM | 10/24/2021 9:24:11 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 | 2503 | 14 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-03-30T06:56:54.571Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-07-16T09:09:17.119Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T09:23:44.248Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T09:24:12.116Z"}] | 9 | 123 | 18 | 10/24/2021 9:24:11 AM | 14 | 18 | ||||||||||||||||||||||
| 2862 | 3/29/2021 1:20:15 PM | 3/28/2022 6:35:04 AM | water | billing to close old meter ,new meter must continue to charge as business like in the old meter. | 27 | 3 | 2502 | 5 | 2 | 1 | 1 | 50 | 1970 | [{"op":"R","uid":"12","un":"thembesas","dt":"2021-03-29T13:20:17.945Z"},{"op":"R","uid":"5","un":"ivanh","dt":"2021-05-11T13:18:15.802Z"}] | 1 | 50 | 3/28/2022 6:35:04 AM | 5 | 5 | ||||||||||||||||||||||
| 2861 | 3/29/2021 1:01:10 PM | 8/11/2021 6:56:53 AM | water | to monitoer one more month to adjust.<br><b>Monitoring Reason</b>: [monitor 30 days to get an average]<div>Jrnl no. 518055 processed and authorized. Query resolved</div> | 27 | 3 | 2501 | 12 | 2 | 23 | 1 | 51 | 1269 | [{"op":"R","uid":"12","un":"thembesas","dt":"2021-03-29T13:01:12.287Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2021-08-11T06:56:25.826Z"}] | 1 | 51 | 8/11/2021 6:56:53 AM | 12 | 2 | ||||||||||||||||||||||
| 2860 | 3/29/2021 12:58:23 PM | 10/16/2021 7:48:10 AM | water | Billing to close old water meter .<div>old meter closed .</div> | 27 | 3 | 2500 | 12 | 2 | 23 | 1 | 45 | 1268 | [{"op":"R","uid":"12","un":"thembesas","dt":"2021-03-29T12:58:25.551Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-10-16T07:47:21.761Z"}] | 1 | 112 | 12 | 10/16/2021 7:48:10 AM | 12 | 12 | |||||||||||||||||||||
| 2859 | 3/29/2021 12:54:59 PM | 5/27/2021 4:24:21 AM | water | old water meter closed | 27 | 3 | 2499 | 12 | 2 | 23 | 1 | 45 | [{"op":"R","uid":"12","un":"thembesas","dt":"2021-03-29T12:55:01.470Z"}] | 1 | 45 | 5/27/2021 4:24:21 AM | 12 | 12 | |||||||||||||||||||||||
| 2858 | 3/29/2021 12:52:35 PM | 8/16/2021 12:01:23 PM | water | old water meter closed. | 27 | 3 | 2498 | 12 | 2 | 23 | 1 | 45 | [{"op":"R","uid":"12","un":"thembesas","dt":"2021-03-29T12:52:37.003Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-08-16T12:03:50.288Z"}] | 1 | 45 | 8/16/2021 12:01:23 PM | 12 | 3 | |||||||||||||||||||||||
| 2856 | 3/29/2021 12:48:40 PM | 5/27/2021 4:24:21 AM | water | old water meter closed. | 27 | 3 | 2497 | 12 | 2 | 23 | 1 | 45 | [{"op":"R","uid":"12","un":"thembesas","dt":"2021-03-29T12:48:48.703Z"}] | 1 | 45 | 5/27/2021 4:24:21 AM | 12 | 12 | |||||||||||||||||||||||
| 2857 | 3/29/2021 12:48:03 PM | 4/11/2022 11:48:40 AM | Water query - Overcharged | Water query - Overcharged<div><br></div><div>Invoice received dated July 2021 states no leaks found. Consumer needs to stipulate what exactly is being queried and possibly to revert to Billing regarding readings</div> | 27 | 3 | 2496 | 22 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"22","un":"asandam","dt":"2021-03-29T12:48:10.478Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-07-16T07:07:33.228Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-23T08:11:54.636Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-08-14T08:04:51.039Z"},{"op":"R","uid":"204","un":"lulamamv","dt":"2022-03-10T10:22:18.425Z"},{"op":"R","uid":"204","un":"lulamamv","dt":"2022-03-10T11:28:13.569Z"},{"op":"R","uid":"204","un":"lulamamv","dt":"2022-03-11T12:57:29.215Z"},{"op":"R","uid":"201","un":"nonkosim","dt":"2022-04-11T11:48:40.892Z"}] | 77 | 67 | 4/11/2022 11:48:40 AM | 125820 | 22 | 201 | ||||||||||||||||||||||
| 2855 | 3/29/2021 12:44:05 PM | 5/27/2021 4:24:21 AM | water | old water meter closed. | 27 | 3 | 2495 | 12 | 2 | 23 | 1 | 45 | [{"op":"R","uid":"12","un":"thembesas","dt":"2021-03-29T12:44:07.866Z"}] | 1 | 45 | 5/27/2021 4:24:21 AM | 12 | 12 | |||||||||||||||||||||||
| 2854 | 3/29/2021 12:36:09 PM | 5/27/2021 4:24:21 AM | water | old water meter closed. | 27 | 3 | 2494 | 12 | 2 | 23 | 1 | 45 | [{"op":"R","uid":"12","un":"thembesas","dt":"2021-03-29T12:36:13.162Z"}] | 1 | 45 | 5/27/2021 4:24:21 AM | 12 | 12 |