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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2553 | 3/23/2021 8:54:32 AM | 7/2/2022 10:48:20 AM | consumer is being billed for electricity. has installed prepaid meter. | prepaid electricity meter installed,being billed for electricity.<div><br></div><div>2021/07/14 - Requested removal/installation report for meters from Wayne Beckman<br></div><div><br></div><div>Resolved May 2022 with credit adjustment and refund issued - query resolved</div> | 27 | 3 | 2254 | 132 | 2 | 23 | 77 | 104 | [{"op":"R","uid":"16","un":"cumilem","dt":"2021-03-23T08:54:39.911Z"},{"op":"R","uid":"5","un":"ivanh","dt":"2021-07-14T13:27:37.940Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T09:44:21.342Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T09:47:28.271Z"}] | 2 | 103 | 18 | 7/2/2022 10:48:20 AM | 3 | 3 | ||||||||||||||||||||||
| 2554 | 3/23/2021 8:52:38 AM | 3/28/2022 7:25:06 AM | Assess Six Months Policy | Please assess six months policy for the period 2020/11/21<div>6 months policy journal done</div><br/><b>Journal Number</b>: [826769] | 27 | 3 | 2252 | 17 | 4 | 23 | 1 | 95 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-03-23T08:53:08.538Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-08-07T09:17:58.049Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-08-30T11:29:09.336Z"}] | 1 | 95 | 3/28/2022 7:25:06 AM | 17 | 3 | |||||||||||||||||||||||
| 2555 | 3/23/2021 8:52:36 AM | 10/14/2021 7:48:13 AM | Leak letter | Affidavit provided by consumer<div>JOurnal Done</div> | 27 | 3 | 2253 | 75 | 3 | 23 | 1 | 96 | [{"op":"R","uid":"173","un":"olgad","dt":"2021-03-23T08:52:42.905Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-10-14T07:47:50.729Z"}] | 1 | 96 | 17 | 10/14/2021 7:48:13 AM | 173 | 17 | ||||||||||||||||||||||
| 2552 | 3/23/2021 8:48:25 AM | 7/21/2021 9:49:12 AM | no valid query details submitted | no valid query details submitted | 27 | 3 | 15 | 2 | 23 | 1 | 44 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-03-23T08:48:56.107Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-15T13:04:27.884Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T09:49:12.736Z"}] | 1 | 44 | 7/21/2021 9:49:12 AM | 15 | 14 | ||||||||||||||||||||||||
| 2551 | 3/23/2021 8:48:05 AM | 5/19/2022 7:53:10 AM | WATER QUERY | <div>Query is being voided as no details of query were logged, query was logged only as "Log Query" with no category</div><div>selected . New query to be logged with full information fo query</div><div><br></div> | 27 | 3 | 2251 | 18 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"18","un":"lindan","dt":"2021-03-23T08:48:20.246Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-03-23T08:48:37.174Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T09:42:02.756Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T09:42:48.689Z"},{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-11-03T07:33:43.427Z"}] | 9 | 123 | 11 | 5/19/2022 7:53:10 AM | 18 | 11 | ||||||||||||||||||||||
| 2550 | 3/23/2021 8:45:49 AM | 2/24/2022 12:27:27 PM | Water query - overcharge | Water query - overcharge<div>Journal Done</div> | 27 | 3 | 2250 | 31 | 2 | 23 | 1 | 46 | [{"op":"R","uid":"31","un":"xolanit","dt":"2021-03-23T08:45:51.245Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2021-06-07T09:58:42.377Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-10-13T10:43:05.905Z"},{"op":"R","uid":"13","un":"unathig","dt":"2021-11-14T10:27:40.698Z"}] | 1 | 101 | 17 | 2/24/2022 12:27:27 PM | 31 | 17 | ||||||||||||||||||||||
| 2549 | 3/23/2021 8:39:26 AM | 5/19/2022 7:53:10 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.<br><p class="MsoNormal"><span lang="EN-ZA">• Query Closed as there is no identifiable query or information provided to assess further.<o:p></o:p></span></p> <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> <p class="MsoNormal"><span lang="EN-ZA"> </span></p></td> </tr></tbody></table> | 27 | 3 | 2249 | 18 | 2 | 23 | 1 | 67 | 1180 | [{"op":"R","uid":"18","un":"lindan","dt":"2021-03-23T08:39:45.444Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-03T09:33:18.824Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T09:39:26.346Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-11-14T07:26:30.300Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-11-14T07:26:34.697Z"}] | 9 | 123 | 17 | 5/19/2022 7:53:10 AM | 18 | 17 | |||||||||||||||||||||
| 2546 | 3/23/2021 8:32:03 AM | 5/19/2022 7:53:10 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> | 27 | 3 | 2248 | 18 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"18","un":"lindan","dt":"2021-03-23T08:32:14.139Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-03T09:25:39.403Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T09:36:47.036Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T09:37:22.434Z"},{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-11-03T07:15:10.883Z"}] | 9 | 123 | 11 | 5/19/2022 7:53:10 AM | 18 | 11 | ||||||||||||||||||||||
| 2547 | 3/23/2021 8:31:59 AM | 2/24/2022 12:27:27 PM | water query | water query.<div><b>Response from QRC</b></div><div>Journal Number [826765]</div><div>Journal Authorised.</div><div><b>Evaluate Six Month Policy adjustment </b>-<b>201910-202107</b></div><div><b>Response QRC: </b></div><div>Query resolved</div> | 27 | 3 | 2247 | 31 | 2 | 23 | 77 | 101 | [{"op":"R","uid":"31","un":"xolanit","dt":"2021-03-23T08:32:14.077Z"},{"op":"R","uid":"31","un":"xolanit","dt":"2021-03-23T08:37:36.791Z"},{"op":"R","uid":"196","un":"lazolaw","dt":"2021-08-13T06:35:59.908Z"},{"op":"R","uid":"196","un":"lazolaw","dt":"2021-08-13T06:36:23.783Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-08-16T10:28:21.412Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-08-16T10:29:52.686Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-09-01T09:51:23.225Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-09-30T09:09:57.642Z"}] | 1 | 101 | 2/24/2022 12:27:27 PM | 31 | 230 | |||||||||||||||||||||||
| 2545 | 3/23/2021 8:27:29 AM | 3/28/2022 7:23:36 AM | Leak letters | Leak letter provided by consumer<br><b>Journal Number</b>: [880204]<div>Response From QRC: <b>Query Resolved</b></div><div><b><br></b></div><div><b>RESPONSE QRC:</b>LEAK CR ,JOURNAL{880204} AUTHORISED.</div><div><br></div> | 27 | 3 | 2246 | 13 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"173","un":"olgad","dt":"2021-03-23T08:27:30.966Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-08-14T07:22:08.180Z"},{"op":"R","uid":"13","un":"unathig","dt":"2021-08-15T07:29:08.968Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-09-30T11:54:34.307Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-10-14T07:16:59.714Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-11-03T09:08:29.572Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-11-03T09:11:02.795Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-11-05T08:16:51.279Z"}] | 1 | 96 | 230 | 3/28/2022 7:23:36 AM | 13 | 230 | ||||||||||||||||||||||
| 2543 | 3/23/2021 8:21:23 AM | 5/19/2022 7:53:10 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 | 2245 | 18 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"18","un":"lindan","dt":"2021-03-23T08:21:25.245Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-03T09:16:04.294Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T09:33:05.178Z"}] | 9 | 123 | 18 | 5/19/2022 7:53:10 AM | 18 | 18 | ||||||||||||||||||||||
| 2542 | 3/23/2021 8:15:41 AM | 6/7/2022 12:15:32 PM | LATE TRMINATION | LATE TERMINATION<br/><b>Journal Amount</b>: [65379.75] | 27 | 3 | 2244 | 74 | 2 | 23 | 77 | 107 | [{"op":"R","uid":"18","un":"lindan","dt":"2021-03-23T08:15:43.117Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-05-25T08:43:40.680Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T09:28:22.081Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T09:32:28.287Z"}] | 6 | 122 | 18 | 6/7/2022 12:15:13 PM | 2 | 2 | ||||||||||||||||||||||
| 2541 | 3/23/2021 8:04:07 AM | 5/19/2022 7:53:10 AM | WATER QUERY | WATER QUERY<div><br></div><div>- Account closed</div> | 27 | 3 | 2243 | 18 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"18","un":"lindan","dt":"2021-03-23T08:04:09.663Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-03T10:45:04.454Z"},{"op":"R","uid":"13","un":"unathig","dt":"2021-10-17T10:17:49.214Z"}] | 1 | 50 | 13 | 5/19/2022 7:53:10 AM | 18 | 13 | ||||||||||||||||||||||
| 2540 | 3/23/2021 7:58:23 AM | 5/19/2022 7:53:10 AM | WATER QUERY | WATER QUERY | 4 | 3 | 2242 | 18 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"18","un":"lindan","dt":"2021-03-23T07:58:26.147Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-03T10:51:21.458Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T09:25:35.630Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T09:26:42.403Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T09:27:54.565Z"}] | 9 | 123 | 18 | 5/19/2022 7:53:10 AM | 18 | 18 | ||||||||||||||||||||||
| 2538 | 3/23/2021 7:53:28 AM | 2/24/2022 12:27:27 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 <br><br><p class="MsoNormal"><span lang="EN-ZA">• Query Closed as there is no identifiable query or information provided to assess further.<o:p></o:p></span></p> <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> <p class="MsoNormal"><span lang="EN-ZA"> </span></p></td> </tr></tbody></table> | 27 | 3 | 2241 | 31 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"31","un":"xolanit","dt":"2021-03-23T07:53:30.161Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-05-20T10:47:37.675Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-03T10:55:08.284Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-03T11:57:36.715Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T09:23:19.787Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-11-14T07:22:05.622Z"}] | 9 | 123 | 17 | 2/24/2022 12:27:27 PM | 31 | 17 | ||||||||||||||||||||||
| 2539 | 3/23/2021 7:48:12 AM | 5/19/2022 7:53:10 AM | WATER QUERY | WATER QUERY | 27 | 3 | 2240 | 18 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"18","un":"lindan","dt":"2021-03-23T07:48:14.447Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-03T11:54:47.206Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-10-17T06:30:18.039Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-10-17T07:26:13.828Z"}] | 1 | 96 | 6 | 5/19/2022 7:53:10 AM | 18 | 6 | ||||||||||||||||||||||
| 2537 | 3/23/2021 7:36:20 AM | 11/15/2022 9:53: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> | 4 | 3 | 2239 | 5 | 2 | 23 | 1 | 67 | 1171 | [{"op":"R","uid":"31","un":"xolanit","dt":"2021-03-23T07:36:22.622Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-03T11:51:27.294Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-03T12:30:37.238Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-03T12:31:42.998Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T09:18:33.707Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T09:22:54.835Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-11-14T07:10:54.224Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-11-14T07:10:59.871Z"}] | 1 | 96 | 18 | 2/24/2022 12:27:27 PM | 139506 | 31 | 201 | ||||||||||||||||||||
| 2535 | 3/23/2021 7:29:44 AM | 11/14/2021 10:29:35 AM | Six Months Policy | Please assess 6 Months Policy for the Period 2020/09/27 | 27 | 3 | 2238 | 74 | 4 | 23 | 1 | 95 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-03-23T07:30:12.586Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-10-13T10:48:41.186Z"},{"op":"R","uid":"13","un":"unathig","dt":"2021-11-14T10:28:20.750Z"}] | 1 | 101 | 17 | 11/14/2021 10:29:35 AM | 172 | 17 | ||||||||||||||||||||||
| 2534 | 3/23/2021 7:22:28 AM | 7/21/2021 9:48:37 AM | no valid query details submitted | no valid query details submitted | 27 | 3 | 12 | 2 | 23 | 1 | 44 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-03-23T07:22:55.621Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-15T13:04:54.022Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T09:48:37.891Z"}] | 1 | 44 | 7/21/2021 9:48:37 AM | 12 | 14 | ||||||||||||||||||||||||
| 2533 | 3/23/2021 7:22:01 AM | 7/21/2021 9:47:55 AM | no valid query details submitted | no valid query details submitted | 27 | 3 | 7 | 2 | 23 | 1 | 44 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-03-23T07:22:29.770Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-15T13:05:25.376Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T09:47:54.630Z"}] | 1 | 44 | 7/21/2021 9:47:55 AM | 7 | 14 |