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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2592 | 3/23/2021 12:18:48 PM | 3/23/2021 12:18:50 PM | 2 | 2287 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-03-23T12:18:50.457Z"}] | 14 | |||||||||||||||||||||||||||||||||||
| 2593 | 3/23/2021 12:10:24 PM | 11/14/2021 10:31:12 AM | Six Months Policy | Kindly assess 6 Months Policy for the period 2018/01 to 2020/08<div>-indigent subsidy write offs</div> | 27 | 3 | 2286 | 74 | 4 | 23 | 1 | 95 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-03-23T12:10:52.107Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T11:15:54.465Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T11:16:28.915Z"},{"op":"R","uid":"13","un":"unathig","dt":"2021-11-14T10:28:40.551Z"}] | 1 | 101 | 13 | 11/14/2021 10:31:12 AM | 172 | 13 | ||||||||||||||||||||||
| 2584 | 3/23/2021 12:04:11 PM | 11/11/2022 10:44:19 AM | Leak letter | Leak letter provided by consumer dated 12/10/2020<div><br></div><div>Affidavit does not state date of repairs. Debt written off June 2021. Query Closed</div> | 27 | 3 | 2285 | 75 | 4 | 23 | 1 | 96 | [{"op":"R","uid":"173","un":"olgad","dt":"2021-03-23T12:04:38.672Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-08-21T09:09:54.259Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T11:12:11.649Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T11:13:43.965Z"},{"op":"R","uid":"13","un":"unathig","dt":"2021-11-14T10:30:39.069Z"}] | 1 | 96 | 18 | 7/2/2022 10:56:33 AM | 3 | 3 | ||||||||||||||||||||||
| 2590 | 3/23/2021 11:45:00 AM | 5/21/2023 10:11:34 AM | incorrect billing of water from 24 October 2020 | <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><b>qrc response<br>leak credit processed on 16/02/2023, journal waiting to be authorized</b></td> </tr></tbody></table><br/><b>Journal Number</b>: [018054]<br/><b>Journal Amount</b>: [24946,44] | 27 | 3 | 2284 | 5 | 2 | 23 | 1 | 50 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-03-23T11:45:02.780Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-03T07:29:01.429Z"},{"op":"R","uid":"13","un":"unathig","dt":"2021-10-16T07:54:09.108Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T10:41:17.625Z"}] | 9 | 123 | 18 | 5/21/2023 10:11:16 AM | 137381 | 8 | 8 | |||||||||||||||||||||
| 2589 | 3/23/2021 11:22:33 AM | 3/23/2021 11:22:42 AM | 2 | [{"op":"R","uid":"16","un":"cumilem","dt":"2021-03-23T11:22:35.488Z"}] | 16 | ||||||||||||||||||||||||||||||||||||
| 2588 | 3/23/2021 11:10:05 AM | 5/19/2022 7:51:12 AM | sewerage charge reversal | consumer paying for septic tank and requests reversal of sewerage charge.<div><br></div><div><b><u>QRC RESPONSE:</u></b></div><div>Account adjusted accordingly 202106 and service removed. Query Resolved.<br></div> | 27 | 3 | 2282 | 16 | 2 | 23 | 77 | 105 | [{"op":"R","uid":"16","un":"cumilem","dt":"2021-03-23T11:10:05.956Z"},{"op":"R","uid":"8","un":"mariaanaw","dt":"2021-08-07T08:14:36.459Z"},{"op":"R","uid":"8","un":"mariaanaw","dt":"2021-08-07T09:20:37.668Z"},{"op":"R","uid":"8","un":"mariaanaw","dt":"2021-08-07T09:21:32.584Z"}] | 77 | 105 | 5/19/2022 7:51:12 AM | 16 | 8 | |||||||||||||||||||||||
| 2587 | 3/23/2021 11:05:42 AM | 3/28/2022 7:08:29 AM | leak CR Journal done | leak CR Journal done <div><br></div><br><b>Journal Number</b>: [471093]<div><br></div><div>Resolved March 2021</div> | 27 | 3 | 2281 | 6 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"6","un":"lusandad","dt":"2021-03-23T11:05:45.614Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-08-14T10:08:01.425Z"}] | 1 | 96 | 3/28/2022 7:08:29 AM | 6 | 3 | |||||||||||||||||||||||
| 2586 | 3/23/2021 11:03:20 AM | 3/28/2022 7:08:29 AM | 100% lk cr journal done | 100% lk cr journal done<br/><b>Journal Number</b>: [471065] | 27 | 3 | 2280 | 6 | 2 | 23 | 1 | 69 | 1199 | [{"op":"R","uid":"6","un":"lusandad","dt":"2021-03-23T11:03:22.134Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-10-14T07:36:34.256Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-11-14T06:52:06.173Z"}] | 1 | 96 | 17 | 3/28/2022 7:08:29 AM | 6 | 17 | |||||||||||||||||||||
| 2585 | 3/23/2021 11:01:05 AM | 4/12/2022 9:43:30 AM | 6 Months Policy | Kindly assess 6 Months Policy for the Period 2019/02 to 2020/09<div><br></div><br><b>Resolved 2020/11</b> | 27 | 3 | 2279 | 7 | 2 | 23 | 1 | 95 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-03-23T11:01:33.600Z"},{"op":"R","uid":"15","un":"chumab","dt":"2021-08-10T12:40:28.979Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-08-30T11:35:12.201Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-08-30T11:47:13.433Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-08-30T11:47:22.400Z"},{"op":"R","uid":"201","un":"nonkosim","dt":"2022-02-21T06:55:07.371Z"},{"op":"R","uid":"201","un":"nonkosim","dt":"2022-02-21T06:56:49.521Z"}] | 1 | 95 | 4/12/2022 9:43:30 AM | 7 | 201 | |||||||||||||||||||||||
| 2583 | 3/23/2021 10:47:24 AM | 5/19/2022 7:51:12 AM | high water consumption | consumer querying high water consumption. kindly investigate and resolve.<div><br></div><div>LATE TERMINATION JOURNAL DONE</div> | 27 | 3 | 2278 | 16 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"16","un":"cumilem","dt":"2021-03-23T10:47:25.725Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-03T12:51:38.016Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-04T06:39:58.596Z"},{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-10-13T10:40:48.840Z"}] | 6 | 76 | 11 | 5/19/2022 7:51:12 AM | 16 | 11 | ||||||||||||||||||||||
| 2582 | 3/23/2021 10:42:11 AM | 11/14/2021 10:28:23 AM | water | leak credit on water<br><b>Journal Number</b>: [359991]<div>journal correction submitted.</div> | 28 | 3 | 2277 | 2 | 23 | 1 | 100 | [{"op":"R","uid":"12","un":"thembesas","dt":"2021-03-23T10:42:13.465Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-03-23T11:04:33.432Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T10:39:51.954Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T10:40:53.838Z"},{"op":"R","uid":"13","un":"unathig","dt":"2021-11-14T10:27:08.268Z"}] | 1 | 96 | 18 | 18 | |||||||||||||||||||||||||
| 2581 | 3/23/2021 10:23:25 AM | 11/10/2021 10:11:48 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 | 2276 | 14 | 2 | 23 | 1 | 67 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-03-23T10:23:27.963Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-03T07:30:26.907Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-03T08:10:02.998Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-08-19T07:34:47.919Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-08-19T07:53:35.253Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T10:31:53.405Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T10:33:05.076Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T10:34:00.060Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-10-29T12:46:39.204Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-11-10T10:10:29.710Z"}] | 9 | 123 | 4 | 11/10/2021 10:11:48 AM | 14 | 4 | ||||||||||||||||||||||
| 2580 | 3/23/2021 10:17:53 AM | 8/7/2021 10:41:49 AM | 6 Months Policy | Kindly assess 6 Months Policy from 2018/10 to 2020/04<div><br></div><div>account written off, no adjustment due</div> | 27 | 3 | 2275 | 74 | 4 | 23 | 1 | 95 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-03-23T10:18:21.385Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-08-07T10:41:28.113Z"}] | 1 | 95 | 8/7/2021 10:41:49 AM | 172 | 6 | |||||||||||||||||||||||
| 2579 | 3/23/2021 10:14:33 AM | 5/19/2022 7:51:12 AM | late termination query | property sold,kindly terminate services on previous owner account.<div>ACCOUNT FINALIZED - REFUND IN PROCESS</div> | 27 | 3 | 2274 | 16 | 2 | 23 | 77 | 107 | [{"op":"R","uid":"16","un":"cumilem","dt":"2021-03-23T10:14:34.349Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2021-07-22T12:16:08.776Z"}] | 77 | 107 | 5/19/2022 7:51:12 AM | 16 | 2 | |||||||||||||||||||||||
| 2578 | 3/23/2021 10:12:11 AM | 11/3/2021 7:14:51 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 | 2273 | 14 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-03-23T10:12:13.917Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-03T07:40:48.637Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-03T07:47:55.077Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-03T08:25:01.032Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T10:30:08.263Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T10:30:45.810Z"},{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-11-03T07:14:34.677Z"}] | 9 | 123 | 11 | 11/3/2021 7:14:51 AM | 14 | 11 | ||||||||||||||||||||||
| 2577 | 3/23/2021 10:06:22 AM | 5/27/2021 4:26:29 AM | Leak letter | Leak letter is not acceptable and consumer has been made aware to provide a proper one. | 4 | 3 | 2272 | 75 | 4 | 23 | 1 | 96 | [{"op":"R","uid":"173","un":"olgad","dt":"2021-03-23T10:06:24.504Z"}] | 1 | 96 | 5/27/2021 4:26:29 AM | 173 | 173 | |||||||||||||||||||||||
| 2576 | 3/23/2021 10:05:39 AM | 10/23/2021 10:29:54 AM | 6 Months Policy | Please assess 6 Months Policy for the term 201904-202004 | 30 | 3 | 2271 | 4 | 23 | 1 | 95 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-03-23T10:06:07.236Z"},{"op":"R","uid":"172","un":"sesonad","dt":"2021-03-23T10:08:41.315Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T10:28:16.760Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T10:29:49.697Z"}] | 1 | 101 | 18 | 18 | |||||||||||||||||||||||||
| 2575 | 3/23/2021 10:04:01 AM | 6/30/2022 1:28:14 PM | water query period on 2020 | water query <div><br></div><div>RESOLVED</div><br/><b>Journal Number</b>: [439567 / 439589] | 27 | 3 | 2270 | 132 | 4 | 23 | 77 | 67 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-03-23T10:04:02.962Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-03T08:08:46.456Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-16T08:06:33.794Z"},{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-10-16T10:26:43.764Z"}] | 1 | 101 | 11 | 6/30/2022 1:28:14 PM | 134177 | 7 | 7 | |||||||||||||||||||||
| 2573 | 3/23/2021 10:03:09 AM | 7/21/2021 9:53:15 AM | no valid query details submitted | no valid query details submitted | 27 | 3 | 8 | 2 | 23 | 1 | 44 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-03-23T10:03:37.345Z"},{"op":"R","uid":"172","un":"sesonad","dt":"2021-03-23T10:03:57.039Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-15T13:00:46.042Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T09:53:11.253Z"}] | 1 | 44 | 7/21/2021 9:53:15 AM | 8 | 14 | ||||||||||||||||||||||||
| 2573 | 3/23/2021 10:01:49 AM | 7/21/2021 9:52:27 AM | no valid query details submitted | no valid query details submitted | 27 | 3 | 132 | 2 | 23 | 1 | 44 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-03-23T10:02:16.968Z"},{"op":"R","uid":"172","un":"sesonad","dt":"2021-03-23T10:02:45.472Z"},{"op":"R","uid":"172","un":"sesonad","dt":"2021-03-23T10:03:07.798Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-15T13:01:26.084Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T09:52:22.342Z"}] | 1 | 44 | 7/21/2021 9:52:27 AM | 230 | 14 |