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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2638 | 3/24/2021 8:50:34 AM | 3/28/2022 7:23:36 AM | Six months policy | Please assess account for six months policy <div><br></div><div>6 months policy journal done </div><br/><b>Journal Number</b>: [826766] | 27 | 3 | 2327 | 13 | 4 | 23 | 1 | 95 | [{"op":"R","uid":"173","un":"olgad","dt":"2021-03-24T08:51:00.542Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-08-07T08:43:54.790Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-08-07T09:03:28.565Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-08-30T11:28:54.468Z"}] | 1 | 95 | 3/28/2022 7:23:36 AM | 13 | 3 | |||||||||||||||||||||||
| 2636 | 3/24/2021 8:45:38 AM | 10/14/2021 11:40:47 AM | High consumption | High consumption billed in October 2020<div>Journal Done</div> | 27 | 3 | 2326 | 75 | 4 | 23 | 1 | 67 | 1214 | [{"op":"R","uid":"173","un":"olgad","dt":"2021-03-24T08:46:04.840Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-02T09:24:44.265Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-02T09:31:38.706Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-02T09:58:35.306Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-10-14T11:40:18.508Z"}] | 1 | 101 | 17 | 10/14/2021 11:40:47 AM | 173 | 17 | |||||||||||||||||||||
| 2637 | 3/24/2021 8:45:11 AM | 3/28/2022 6:33:19 AM | leak credit adjustment done | leak credit adjustment done<br/><b>Journal Number</b>: [471320]<br/><b>Journal Amount</b>: [R59,134.55] | 27 | 3 | 2325 | 3 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"6","un":"lusandad","dt":"2021-03-24T08:45:37.276Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-04-20T10:49:35.847Z"}] | 1 | 96 | 3/28/2022 6:33:19 AM | 3 | 3 | |||||||||||||||||||||||
| 2635 | 3/24/2021 8:42:27 AM | 7/21/2021 10:02:22 AM | no valid query details submitted | no valid query details submitted | 27 | 3 | 2324 | 4 | 2 | 23 | 1 | 44 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-03-24T08:43:07.055Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-15T12:59:03.544Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T10:02:21.262Z"}] | 1 | 44 | 7/21/2021 10:02:22 AM | 4 | 14 | |||||||||||||||||||||||
| 2633 | 3/24/2021 8:29:36 AM | 4/12/2022 9:42:39 AM | 6 Months Policy | Kindly assess a 6 Months Policy for the Period 201911 - 202008<br><b>Journal Number</b>: [015519]<div><br></div><div><b>RESPONSE QRC</b> :Six month policy, Journal {015519}Authorized.</div> | 27 | 3 | 2323 | 132 | 3 | 23 | 1 | 95 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-03-24T08:30:02.949Z"},{"op":"R","uid":"15","un":"chumab","dt":"2021-08-24T10:10:03.432Z"},{"op":"R","uid":"15","un":"chumab","dt":"2021-09-22T12:07:16.065Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T12:02:49.635Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T12:03:08.066Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-11-12T10:35:39.020Z"}] | 1 | 101 | 230 | 4/12/2022 9:42:39 AM | 230 | 230 | ||||||||||||||||||||||
| 2632 | 3/24/2021 8:28:22 AM | 1/22/2023 6:10:52 AM | Leak letter | Leak affidavit provided by consumer dated 02/12/2020<div></div><div><br></div><div>Query Re-opened. Affidavit with date of repairs May 2018 uploaded for assessment and resolution</div><br/><b>Journal Amount</b>: [-R20,483.39] | 27 | 3 | 2322 | 4 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"173","un":"olgad","dt":"2021-03-24T08:28:48.866Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-08-15T07:33:40.304Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T12:01:35.895Z"}] | 1 | 96 | 18 | 1/22/2023 6:10:29 AM | 134119 | 3 | 3 | |||||||||||||||||||||
| 2630 | 3/24/2021 8:09:37 AM | 7/2/2022 11:52:46 AM | 6Months Policy | Kindly assess a Six Months Policy for the period 202002 - 202009<div><br></div><div>Debt written off June 2021 and June 2022. Acc up to date, query closed</div> | 27 | 3 | 2321 | 74 | 4 | 23 | 1 | 95 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-03-24T08:10:04.610Z"},{"op":"R","uid":"172","un":"sesonad","dt":"2021-03-24T08:12:45.828Z"},{"op":"R","uid":"172","un":"sesonad","dt":"2021-03-24T08:13:04.628Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T12:00:13.801Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T12:01:09.246Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-11-14T10:50:38.952Z"}] | 1 | 101 | 18 | 7/2/2022 11:52:46 AM | 3 | 3 | ||||||||||||||||||||||
| 2628 | 3/24/2021 8:08:04 AM | 8/22/2021 8:54:58 AM | Leak letter | Leak affidavit provided by consumer dated June 2020<div><br></div><div>acc written off</div> | 27 | 3 | 2320 | 75 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"173","un":"olgad","dt":"2021-03-24T08:08:30.629Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-08-22T08:52:45.290Z"}] | 1 | 96 | 8/22/2021 8:54:58 AM | 173 | 6 | |||||||||||||||||||||||
| 2631 | 3/24/2021 8:06:46 AM | 11/14/2021 10:03:03 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.<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></td> </tr></tbody></table> | 27 | 3 | 2319 | 96 | 2 | 23 | 77 | 96 | [{"op":"R","uid":"180","un":"khanyan","dt":"2021-03-24T08:07:13.270Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T11:55:43.721Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-11-14T10:02:46.683Z"}] | 9 | 123 | 17 | 11/14/2021 10:03:03 AM | 180 | 17 | ||||||||||||||||||||||
| 2627 | 3/24/2021 7:56:37 AM | 10/17/2021 10:09:34 AM | water | high water consumption <div><br></div><div>ACCOUNT IN ORDER</div> | 27 | 3 | 2318 | 96 | 2 | 23 | 1 | 67 | 1212 | [{"op":"R","uid":"180","un":"khanyan","dt":"2021-03-24T07:57:03.183Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-02T10:04:29.874Z"},{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-10-17T10:09:16.432Z"}] | 1 | 96 | 11 | 10/17/2021 10:09:34 AM | 180 | 11 | |||||||||||||||||||||
| 2626 | 3/24/2021 7:54:05 AM | 4/12/2022 11:26:30 AM | 6 Months Policy | Kindly assess a six months Policy for the period 201805-202009<div>6 month policy processed</div><br/><b>Journal Number</b>: [156987] | 24 | 3 | 2317 | 4 | 23 | 1 | 95 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-03-24T07:54:32.881Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T11:53:35.707Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T11:54:25.854Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-11-14T09:24:05.083Z"},{"op":"R","uid":"10","un":"mellozanef","dt":"2021-11-28T07:28:06.702Z"},{"op":"R","uid":"10","un":"mellozanef","dt":"2022-04-12T11:25:55.708Z"},{"op":"R","uid":"10","un":"mellozanef","dt":"2022-04-12T11:26:30.972Z"}] | 1 | 101 | 10 | 10 | |||||||||||||||||||||||||
| 2625 | 3/24/2021 7:51:50 AM | 11/11/2022 12:01:55 PM | Leak letter | Plumbers letter provided by consumer dated 15/11/2020 and filed<div><br></div><div>Reported on w.w 749460</div><div><br></div><br> | 30 | 3 | 2316 | 17 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"173","un":"olgad","dt":"2021-03-24T07:52:18.288Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-08-14T10:42:55.875Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-08-21T10:03:26.193Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T11:52:42.846Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T11:53:22.937Z"}] | 1 | 96 | 18 | 3 | ||||||||||||||||||||||||
| 2623 | 3/24/2021 7:44:10 AM | 11/14/2021 8:19:18 AM | Leak letter | Leak affidavit provided by consumer dated 01/12/2020<div><br></div><div>need new reading send to wayne ,</div><div><br></div><div>need current reading to do adjustment.</div> | 27 | 3 | 2314 | 75 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"173","un":"olgad","dt":"2021-03-24T07:44:36.232Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-08-14T07:51:18.365Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-08-21T07:22:26.329Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T11:51:04.202Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T11:52:19.735Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-11-14T08:18:59.956Z"}] | 1 | 96 | 17 | 11/14/2021 8:19:18 AM | 173 | 17 | ||||||||||||||||||||||
| 2624 | 3/24/2021 7:44:07 AM | 4/26/2022 11:50:08 AM | Plumbers letter | Plumbers letter received for repairs dated Jan 2021. Consumption to be monitored for 03 months<br/><b>Journal Number</b>: [880174]<br/><b>Journal Amount</b>: [-R1,649.32] | 27 | 3 | 2315 | 75 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"3","un":"fareezar","dt":"2021-03-24T07:44:35.081Z"},{"op":"R","uid":"13","un":"unathig","dt":"2021-08-14T08:29:56.382Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T11:49:54.315Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T11:50:47.511Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2022-04-26T11:49:39.730Z"}] | 1 | 96 | 3 | 4/26/2022 11:50:08 AM | 173 | 3 | ||||||||||||||||||||||
| 2622 | 3/24/2021 7:37:55 AM | 10/14/2021 7:12:16 AM | 6 Months Policy | Please assess a Six Months Policy for the Period 201910 to 202007<div>Journal Done</div> | 27 | 3 | 2313 | 74 | 3 | 23 | 1 | 95 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-03-24T07:38:21.894Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-10-14T07:11:52.135Z"}] | 1 | 101 | 17 | 10/14/2021 7:12:16 AM | 172 | 17 | ||||||||||||||||||||||
| 2621 | 3/24/2021 7:36:27 AM | 4/1/2022 11:24:08 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 | 2312 | 14 | 2 | 23 | 1 | 67 | 1211 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-03-24T07:36:30.154Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-02T10:10:31.014Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T11:43:38.346Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T11:45:31.771Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T11:46:25.248Z"},{"op":"R","uid":"204","un":"lulamamv","dt":"2022-04-01T07:06:33.005Z"},{"op":"R","uid":"205","un":"zovuyod","dt":"2022-04-01T11:24:09.034Z"}] | 9 | 123 | 18 | 4/1/2022 11:24:08 AM | 14 | 18 | |||||||||||||||||||||
| 2620 | 3/24/2021 7:32:01 AM | 3/22/2022 10:52:54 AM | last reading in 2020 | sent for check reading | 27 | 3 | 2311 | 75 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"173","un":"olgad","dt":"2021-03-24T07:32:28.805Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T11:42:08.137Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T11:43:07.641Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-11-14T08:10:24.219Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-11-14T08:14:19.620Z"},{"op":"R","uid":"203","un":"babalwas","dt":"2022-03-22T10:49:17.374Z"}] | 1 | 113 | 17 | 3/22/2022 10:52:54 AM | 173 | 17 | ||||||||||||||||||||||
| 2618 | 3/23/2021 1:49:13 PM | 10/13/2021 10:55:49 AM | 6 Months Policy | Kindly assess a 6 Months Policy for the period 201903-201909<div>Journal Done</div> | 27 | 3 | 2310 | 74 | 4 | 23 | 1 | 95 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-03-23T13:47:23.837Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-10-13T10:52:53.482Z"}] | 1 | 101 | 17 | 10/13/2021 10:55:49 AM | 172 | 17 | ||||||||||||||||||||||
| 2617 | 3/23/2021 1:43:23 PM | 10/23/2021 11:41:03 AM | water query | water query<div><br></div><div>H/C Call logged with WW on 27.05.2021. Control number: 739596</div><div>Consumer to assess premises for leaks as well as consumption is averaging above 35kl and affected with stage 3 tariffs</div> | 30 | 3 | 2309 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-03-23T13:43:26.163Z"},{"op":"R","uid":"5","un":"ivanh","dt":"2021-05-24T13:28:33.544Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-05-27T14:19:14.257Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-05-27T14:21:15.759Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T11:40:14.566Z"}] | 1 | 96 | 18 | 18 | |||||||||||||||||||||||||
| 2616 | 3/23/2021 1:39:12 PM | 7/21/2021 10:00:05 AM | no valid query details submitted | no valid query details submitted | 27 | 3 | 2308 | 5 | 2 | 23 | 1 | 44 | [{"op":"R","uid":"173","un":"olgad","dt":"2021-03-23T13:39:40.241Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2021-06-07T08:19:15.609Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-15T12:59:46.497Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T09:59:58.808Z"}] | 1 | 44 | 7/21/2021 10:00:05 AM | 5 | 14 |