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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2970 | 4/1/2021 7:40:14 AM | 5/19/2022 7:53:10 AM | REFUSE AND SEWERAGE QUERY | REFUSE AND SEWERAGE QUERY<div><br></div><div>ACCOUNT REGISTERED AS BUSINESS - ALL CHARGES CORRECT</div> | 27 | 3 | 2586 | 18 | 2 | 23 | 77 | 52 | [{"op":"R","uid":"18","un":"lindan","dt":"2021-04-01T07:36:25.511Z"},{"op":"R","uid":"5","un":"ivanh","dt":"2021-05-27T13:47:42.734Z"},{"op":"R","uid":"5","un":"ivanh","dt":"2021-05-31T08:33:09.732Z"},{"op":"R","uid":"5","un":"ivanh","dt":"2021-06-09T13:23:26.731Z"}] | 77 | 52 | 5/19/2022 7:53:10 AM | 18 | 5 | |||||||||||||||||||||||
| 2968 | 4/1/2021 7:39:16 AM | 5/19/2022 7:51:12 AM | High Water Consumption | Consumer querying high water consumption on her account,kindly investigate and resolve.<div>According to front desk, it is unable to locate the meter, maybe its inside property or covered by pavement.<br><div><br></div></div> | 27 | 3 | 2585 | 16 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"16","un":"cumilem","dt":"2021-04-01T07:39:32.516Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-10-30T08:56:39.807Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-31T07:21:07.953Z"}] | 1 | 96 | 6 | 5/19/2022 7:51:12 AM | 16 | 6 | ||||||||||||||||||||||
| 2966 | 4/1/2021 7:32:12 AM | 10/31/2021 7:20:35 AM | Six months policy | Please assess account for six months policy for period 2019/02-2020/02<div>interims reversed were more than the actual charge.</div> | 27 | 3 | 2584 | 75 | 4 | 23 | 1 | 95 | [{"op":"R","uid":"173","un":"olgad","dt":"2021-04-01T07:32:28.451Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-10-30T08:01:29.329Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-31T07:20:36.032Z"}] | 1 | 101 | 6 | 10/31/2021 7:20:35 AM | 173 | 6 | ||||||||||||||||||||||
| 2965 | 4/1/2021 7:27:15 AM | 10/31/2021 7:19:03 AM | Six months policy | Please assess account for six months policy for period 2019/11-2020/06<div>no six months policy to be applied, interims reversed were more that the actual charge.</div> | 27 | 3 | 2583 | 75 | 4 | 23 | 1 | 95 | [{"op":"R","uid":"173","un":"olgad","dt":"2021-04-01T07:27:34.711Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-10-30T07:54:19.083Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-31T07:19:03.540Z"}] | 1 | 101 | 6 | 10/31/2021 7:19:03 AM | 173 | 6 | ||||||||||||||||||||||
| 2964 | 4/1/2021 7:20:05 AM | 10/31/2021 7:18:24 AM | Six months policy | Please assess account for six months policy for period 2017/08-2019/11 and 2020/08<div>account debt written off</div> | 27 | 3 | 2582 | 75 | 4 | 23 | 1 | 95 | [{"op":"R","uid":"173","un":"olgad","dt":"2021-04-01T07:20:22.209Z"},{"op":"R","uid":"173","un":"olgad","dt":"2021-04-01T07:24:34.973Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-10-30T06:33:22.376Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-31T07:18:24.131Z"}] | 1 | 101 | 6 | 10/31/2021 7:18:24 AM | 173 | 6 | ||||||||||||||||||||||
| 2963 | 4/1/2021 7:14:36 AM | 5/19/2022 7:51:12 AM | LOG QUERY | <table border="0" cellpadding="0" cellspacing="0" width="864" style="border-collapse: collapse;width:648pt"><tbody><tr height="25" style="mso-height-source:userset;height:18.75pt"> <td height="25" class="xl65" width="864" style="height:18.75pt;width:648pt">Query is being voided as no details of query were logged. Query was logged only as "Log Query" with no category or sub category selected. New query to be logged with full information of query.</td></tr></tbody></table> | 27 | 3 | 2581 | 16 | 3 | 23 | 1 | 67 | 1314 | [{"op":"R","uid":"16","un":"cumilem","dt":"2021-04-01T07:14:52.639Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-31T07:17:07.334Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-11-09T12:24:31.510Z"}] | 9 | 123 | 6 | 5/19/2022 7:51:12 AM | 16 | 6 | |||||||||||||||||||||
| 2190 | 4/1/2021 7:14:04 AM | 2/18/2023 8:23:31 AM | Six months | Please assess account for six months for period 2020/01-2020/11<div><br></div><div>SIX MONTHS POLICY ADJUSTED</div><br><b>Journal Number</b>: [051381]<div>QRC Response :DATE 18/02/2023</div><div>Debt written off 06/2021<br><div><br></div></div> | 27 | 3 | 1994 | 15 | 4 | 23 | 1 | 95 | [{"op":"R","uid":"173","un":"olgad","dt":"2021-04-01T07:14:31.568Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-31T07:16:29.848Z"},{"op":"R","uid":"15","un":"chumab","dt":"2022-02-27T08:27:48.552Z"}] | 1 | 101 | 15 | 2/18/2023 8:23:31 AM | 124719 | 12 | 12 | |||||||||||||||||||||
| 2962 | 4/1/2021 7:02:26 AM | 5/19/2022 7:51:12 AM | High Water Consumption | High Water Consumption Queried by consumer, kindly investigate and resolve.<div><br></div><div>account inorder.</div> | 27 | 3 | 2580 | 16 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"16","un":"cumilem","dt":"2021-04-01T07:02:44.475Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-10-30T06:29:18.655Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-31T07:15:57.619Z"}] | 1 | 101 | 6 | 5/19/2022 7:51:12 AM | 16 | 6 | ||||||||||||||||||||||
| 2961 | 4/1/2021 6:53:35 AM | 3/2/2022 8:22:38 AM | Water query | <table border="0" cellpadding="0" cellspacing="0" width="864" style="border-collapse: collapse;width:648pt"><tbody><tr height="25" style="mso-height-source:userset;height:18.75pt"> <td height="25" class="xl65" width="864" style="height:18.75pt;width:648pt">Query is being voided as no details of query were logged. Query was logged only as "Log Query" with no category or sub category selected. New query to be logged with full information of query.</td></tr></tbody></table> | 27 | 3 | 2578 | 37 | 2 | 23 | 1 | 67 | 1315 | [{"op":"R","uid":"37","un":"sokanan","dt":"2021-04-01T06:53:39.451Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-31T07:14:49.180Z"},{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-11-18T06:45:36.177Z"}] | 9 | 123 | 11 | 3/2/2022 8:22:38 AM | 37 | 11 | |||||||||||||||||||||
| 2960 | 4/1/2021 6:51:41 AM | 5/19/2022 7:51:12 AM | Duplicate water charge | Consumer querying duplicate water charge on his account.<div>water split journal done 20210928.</div> | 27 | 3 | 2579 | 16 | 2 | 23 | 77 | 99 | [{"op":"R","uid":"16","un":"cumilem","dt":"2021-04-01T06:51:59.554Z"},{"op":"R","uid":"16","un":"cumilem","dt":"2021-04-01T06:54:37.865Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-10-30T09:00:52.211Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-31T07:11:30.067Z"}] | 1 | 101 | 6 | 5/19/2022 7:51:12 AM | 16 | 6 | ||||||||||||||||||||||
| 2959 | 4/1/2021 6:36:56 AM | 5/19/2022 7:51:12 AM | High Water Consumption | <table border="0" cellpadding="0" cellspacing="0" width="248" style="border-collapse: collapse;width:186pt"><tbody><tr height="218" style="height:163.5pt"> <td height="218" class="xl63" width="248" style="height:163.5pt;width:186pt">Query is being voided as no details of query were logged. Query was logged only as "Log Query" with no category or sub category selected. New query to be logged with full information of query.</td></tr></tbody></table> | 27 | 3 | 2577 | 16 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"16","un":"cumilem","dt":"2021-04-01T06:37:13.766Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-10-30T10:40:34.087Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-31T06:16:13.977Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-31T07:10:06.487Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-11-10T06:25:15.522Z"}] | 9 | 123 | 6 | 5/19/2022 7:51:12 AM | 16 | 6 | ||||||||||||||||||||||
| 2958 | 3/31/2021 1:27:40 PM | 11/11/2021 8:31:48 AM | high water consumption month of August 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</td> </tr></tbody></table> | 27 | 3 | 2576 | 14 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-03-31T13:28:07.361Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T10:59:46.377Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T11:00:31.799Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T11:01:08.242Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-11-11T08:11:24.572Z"}] | 9 | 123 | 6 | 11/11/2021 8:31:48 AM | 14 | 6 | ||||||||||||||||||||||
| 2957 | 3/31/2021 1:20:55 PM | 3/28/2022 6:35:04 AM | high water consumption month of July 2020 | water query,six months pol applied<div>6 MONTHS POLICY JOURNAL DONE </div><br><b>Journal Number</b>: [096072]. Journal processed and approved. Query resolved. | 27 | 3 | 2575 | 5 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-03-31T13:21:18.734Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-29T09:41:54.885Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-08-30T09:22:56.749Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T10:58:39.268Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T10:59:35.163Z"},{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-11-04T08:57:01.417Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-12-02T12:30:15.259Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-12-05T07:25:35.092Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-12-05T07:26:46.105Z"},{"op":"R","uid":"214","un":"nandipan","dt":"2022-02-13T07:20:30.619Z"}] | 1 | 101 | 214 | 3/28/2022 6:35:04 AM | 5 | 214 | ||||||||||||||||||||||
| 2956 | 3/31/2021 1:20:11 PM | 3/28/2022 6:33:19 AM | SIX MONTHS POLICY | ACCOUNT ADJUSTED<br><b>Journal Number</b>: [071539]<div>Resolved</div><br><b>Journal Amount</b>: [R3490.93]. Query Resolved | 27 | 3 | 2574 | 3 | 4 | 23 | 1 | 67 | 1329 | [{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-03-31T13:20:28.335Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-04-06T09:31:00.229Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2021-05-07T13:02:48.295Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2021-05-07T13:57:32.848Z"}] | 1 | 67 | 3/28/2022 6:33:19 AM | 3 | 2 | ||||||||||||||||||||||
| 2955 | 3/31/2021 1:15:04 PM | 4/12/2022 9:47:18 AM | water | water leak credit<br/><b>Journal Number</b>: [071640]<br/><b>Journal Amount</b>: [52909.45] | 27 | 3 | 2573 | 10 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"12","un":"thembesas","dt":"2021-03-31T13:11:15.868Z"},{"op":"R","uid":"5","un":"ivanh","dt":"2021-05-17T11:43:23.401Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-05-30T08:38:17.551Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2021-05-31T06:50:34.988Z"}] | 1 | 96 | 4/12/2022 9:47:18 AM | 10 | 2 | |||||||||||||||||||||||
| 2954 | 3/31/2021 1:12:19 PM | 3/28/2022 6:35:04 AM | water | leak credit water <br><b>Journal Number</b>: [071404]<div><br></div><div><b>RESPONSE QRC</b>: Leak CR ,Journal {709325} Authorized.</div> | 27 | 3 | 2572 | 5 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"12","un":"thembesas","dt":"2021-03-31T13:08:31.038Z"},{"op":"R","uid":"5","un":"ivanh","dt":"2021-05-17T11:42:31.737Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T10:57:37.788Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T10:58:15.251Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-11-03T12:47:59.117Z"}] | 1 | 96 | 230 | 3/28/2022 6:35:04 AM | 5 | 230 | ||||||||||||||||||||||
| 2953 | 3/31/2021 1:09:03 PM | 2/19/2023 10:08:45 AM | water | leak credit water<br>QRC Response : DATE 19/02/2023<div>DEBT WRITTEN OFF 06/2022</div> | 27 | 3 | 2571 | 17 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"12","un":"thembesas","dt":"2021-03-31T13:05:15.141Z"},{"op":"R","uid":"5","un":"ivanh","dt":"2021-05-17T11:44:09.682Z"},{"op":"R","uid":"15","un":"chumab","dt":"2021-08-13T13:00:10.942Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T10:56:33.227Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T10:57:23.991Z"}] | 1 | 96 | 18 | 2/19/2023 10:08:45 AM | 12 | 12 | ||||||||||||||||||||||
| 2952 | 3/31/2021 12:51:40 PM | 10/16/2021 11:42:15 AM | high water consumption for the month of March | water query | 27 | 3 | 2570 | 14 | 2 | 23 | 1 | 67 | 1305 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-03-31T12:52:09.463Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-10-16T11:35:25.371Z"}] | 1 | 113 | 4 | 10/16/2021 11:42:15 AM | 14 | 4 | |||||||||||||||||||||
| 2951 | 3/31/2021 12:40:30 PM | 10/17/2022 10:41:49 AM | Leak Credit | Kindly assess a leak credit for this account,that was investigated in July 2020 | 27 | 3 | 2569 | 17 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-03-31T12:36:46.533Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T10:55:26.655Z"}] | 1 | 96 | 18 | 10/17/2022 10:41:49 AM | 11 | 11 | ||||||||||||||||||||||
| 2950 | 3/31/2021 12:30:35 PM | 7/21/2021 10:44:36 AM | no valid query details submitted | no valid query details submitted | 27 | 3 | 2568 | 8 | 2 | 23 | 1 | 44 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-03-31T12:26:47.064Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-15T12:47:01.244Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T10:43:30.016Z"}] | 1 | 44 | 7/21/2021 10:44:36 AM | 8 | 14 |