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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1695 | 2/18/2021 8:53:19 AM | 2/24/2022 11:08:12 AM | water query | water query | 27 | 3 | 1630 | 22 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"22","un":"asandam","dt":"2021-02-18T08:50:00.036Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-10-14T06:45:36.058Z"},{"op":"R","uid":"214","un":"nandipan","dt":"2022-02-13T11:00:15.547Z"}] | 1 | 101 | 17 | 2/24/2022 11:08:12 AM | 22 | 17 | ||||||||||||||||||||||
| 1692 | 2/18/2021 8:50:36 AM | 4/12/2022 9:39:10 AM | METER CHANGED | 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. | 4 | 3 | 1628 | 4 | 3 | 23 | 1 | 45 | 683 | [{"op":"R","uid":"4","un":"babalwam","dt":"2021-02-18T08:47:17.674Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-02-18T08:52:58.205Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-28T12:04:26.419Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2022-03-26T08:32:50.926Z"},{"op":"R","uid":"175","un":"zukiswat","dt":"2022-03-26T08:43:46.844Z"}] | 9 | 123 | 20 | 4/12/2022 9:39:10 AM | 4 | 20 | |||||||||||||||||||||
| 1694 | 2/18/2021 8:50:14 AM | 2/24/2022 11:08:12 AM | water query | water query | 27 | 3 | 1629 | 22 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"22","un":"asandam","dt":"2021-02-18T08:46:55.749Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-10-16T11:31:48.713Z"}] | 1 | 112 | 4 | 2/24/2022 11:08:12 AM | 22 | 4 | ||||||||||||||||||||||
| 1693 | 2/18/2021 8:44:21 AM | 2/2/2022 12:28:44 PM | High electricity consumption | 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. | 4 | 3 | 72 | 2 | 23 | 77 | 44 | [{"op":"R","uid":"73","un":"nombongof","dt":"2021-02-18T08:41:02.097Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-28T12:03:42.326Z"}] | 9 | 123 | 20 | 2/2/2022 12:28:44 PM | 73 | 20 | |||||||||||||||||||||||
| 1692 | 2/18/2021 8:44:03 AM | 4/12/2022 9:39:10 AM | NEW WATER METER NOT INSTALL | 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. | 4 | 3 | 1628 | 4 | 3 | 1 | 1 | 45 | 680 | [{"op":"R","uid":"4","un":"babalwam","dt":"2021-02-18T08:40:44.111Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-02-18T08:46:59.108Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-10-21T10:40:23.921Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-28T12:01:13.181Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2022-03-26T08:32:21.422Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2022-03-26T08:32:58.612Z"}] | 9 | 123 | 20 | 4/12/2022 9:39:10 AM | 4 | 20 | |||||||||||||||||||||
| 1690 | 2/18/2021 8:40:30 AM | 2/24/2022 11:08:12 AM | water query | account is in order | 27 | 3 | 1627 | 22 | 2 | 23 | 1 | 67 | 677 | [{"op":"R","uid":"22","un":"asandam","dt":"2021-02-18T08:37:12.184Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-10-16T11:17:18.755Z"}] | 1 | 96 | 12 | 2/24/2022 11:08:12 AM | 22 | 12 | |||||||||||||||||||||
| 1691 | 2/18/2021 8:36:17 AM | 4/12/2022 9:47:18 AM | 6 MONTH POLICY | consumer reported interim charges on account and i checked account is due for a 6 month policy on electricity for <br><div><span style="text-align: right;">201810 /</span><span style="text-align: right;">202012</span><br></div><br/><b>Journal Number</b>: [216506]<br/><b>Journal Amount</b>: [-R35570.70] | 27 | 3 | 1626 | 10 | 2 | 23 | 2 | 101 | [{"op":"R","uid":"10","un":"mellozanef","dt":"2021-02-18T08:32:58.238Z"},{"op":"R","uid":"173","un":"olgad","dt":"2021-06-02T10:17:38.524Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-06-02T11:58:02.174Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-06-02T11:58:43.584Z"}] | 2 | 101 | 4/12/2022 9:47:18 AM | 10 | 3 | |||||||||||||||||||||||
| 1689 | 2/18/2021 6:56:44 AM | 11/17/2022 7:33:53 AM | WATER LEAK TO MONITOR CONSUMPTION | LEAK CR DUE TO MONITOR CONSUMPTION<div><br></div><div>RESPONSE QRC: Leak Cr 201909-201911,Journal {906629}Authorized.</div><div>Duplicate Query with ref 21122</div> | 27 | 3 | 1625 | 17 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-02-18T06:56:46.765Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-28T12:00:46.307Z"}] | 1 | 96 | 20 | 11/17/2022 7:33:53 AM | 12 | 12 | ||||||||||||||||||||||
| 1688 | 2/18/2021 6:50:52 AM | 7/21/2021 9:35:27 AM | no valid query details submitted | no valid query details submitted | 27 | 3 | 11 | 2 | 23 | 1 | 44 | [{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-02-18T06:50:53.977Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-15T13:13:11.159Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T09:35:18.717Z"}] | 1 | 44 | 7/21/2021 9:35:27 AM | 11 | 14 | ||||||||||||||||||||||||
| 1681 | 2/17/2021 1:23:28 PM | 7/2/2022 1:54:11 PM | TARIFF INCORRECT | TWO CHARGES ON SINGLE ERF<div><br></div><div><b>QRC RESPONSE</b>: There are two account one tenant and one owner account. Rates and sewerage is billed on owners account, water, fire and refuse on tenant account. </div><div>There is no duplication of charges. </div><div><br></div><div>More detailed information requested on query, and should be re-logged by customer. Query on this category closed.</div> | 27 | 3 | 1622 | 4 | 4 | 23 | 1 | 50 | 2074 | [{"op":"R","uid":"5","un":"ivanh","dt":"2021-02-17T13:20:10.248Z"},{"op":"R","uid":"58","un":"dorelld","dt":"2021-02-18T04:44:28.944Z"},{"op":"R","uid":"5","un":"ivanh","dt":"2021-05-13T09:41:11.635Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-28T12:00:15.388Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-11-14T07:42:53.487Z"}] | 1 | 50 | 20 | 7/2/2022 1:54:11 PM | 8 | 8 | |||||||||||||||||||||
| 1687 | 2/17/2021 1:23:11 PM | 2/24/2022 11:08:12 AM | consolidated investigate | consolidated <div><br></div><div><b><u><br></u></b></div><div><b><u>QRC RESPONSE:</u></b> Charges are on registerred owners account.</div> | 27 | 3 | 1624 | 22 | 2 | 23 | 77 | 76 | [{"op":"R","uid":"22","un":"asandam","dt":"2021-02-17T13:23:13.802Z"},{"op":"R","uid":"58","un":"dorelld","dt":"2021-02-18T04:51:51.286Z"},{"op":"R","uid":"8","un":"mariaanaw","dt":"2021-08-07T08:35:52.792Z"},{"op":"R","uid":"8","un":"mariaanaw","dt":"2021-08-07T09:23:34.647Z"},{"op":"R","uid":"8","un":"mariaanaw","dt":"2021-08-07T09:24:21.267Z"},{"op":"R","uid":"172","un":"sesonad","dt":"2021-09-14T13:13:19.723Z"}] | 77 | 76 | 2/24/2022 11:08:12 AM | 22 | 172 | |||||||||||||||||||||||
| 1686 | 2/17/2021 1:18:42 PM | 12/15/2021 12:08:20 PM | water query 6 month policy | water query 6 month policy<div><br></div><div>ADJUSTED</div><br/><b>Journal Number</b>: [439909] | 24 | 3 | 1623 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"22","un":"asandam","dt":"2021-02-17T13:18:44.237Z"},{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-10-17T08:59:09.654Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-28T11:59:24.679Z"},{"op":"R","uid":"201","un":"nonkosim","dt":"2021-12-15T12:08:20.812Z"}] | 1 | 101 | 11 | 11 | |||||||||||||||||||||||||
| 1685 | 2/17/2021 1:01:53 PM | 2/17/2021 1:01:55 PM | 2 | [{"op":"R","uid":"73","un":"nombongof","dt":"2021-02-17T12:58:34.834Z"}] | 73 | ||||||||||||||||||||||||||||||||||||
| 1684 | 2/17/2021 12:58:06 PM | 3/28/2022 6:33:19 AM | 06 Month Policy 2019/09 | Please process 06 month policy for the 2019/09 billing | 27 | 3 | 1621 | 3 | 2 | 23 | 1 | 95 | [{"op":"R","uid":"3","un":"fareezar","dt":"2021-02-17T12:54:47.390Z"},{"op":"R","uid":"58","un":"dorelld","dt":"2021-02-18T04:53:08.292Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-05-31T12:05:52.454Z"}] | 1 | 95 | 3/28/2022 6:33:19 AM | 3 | 3 | |||||||||||||||||||||||
| 1683 | 2/17/2021 12:56:48 PM | 2/2/2022 12:28:44 PM | high water consumption | <table border="0" cellpadding="0" cellspacing="0" width="668" style="border-collapse: collapse;width:501pt"><tbody><tr height="26" style="height:19.5pt"> <td height="26" class="xl65" width="668" style="height:19.5pt;width:501pt">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> | 4 | 3 | 72 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"73","un":"nombongof","dt":"2021-02-17T12:53:29.730Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-28T11:59:04.468Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-30T10:13:56.577Z"}] | 9 | 123 | 14 | 2/2/2022 12:28:44 PM | 73 | 14 | |||||||||||||||||||||||
| 1682 | 2/17/2021 12:48:05 PM | 3/28/2022 7:08:29 AM | 6 months policy journal processed | 6 months policy journal processed<br/><b>Journal Number</b>: [211745] | 27 | 3 | 1620 | 6 | 4 | 23 | 1 | 95 | [{"op":"R","uid":"6","un":"lusandad","dt":"2021-02-17T12:48:07.063Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-08-07T09:12:25.934Z"}] | 1 | 95 | 3/28/2022 7:08:29 AM | 6 | 6 | |||||||||||||||||||||||
| 1679 | 2/17/2021 12:44:03 PM | 3/28/2022 7:08:29 AM | 6 months policy journal processed. | 6 months policy journal processed.<br/><b>Journal Number</b>: [211868]<br/><b>Journal Amount</b>: [-R591.96] | 27 | 3 | 1619 | 6 | 4 | 23 | 1 | 95 | [{"op":"R","uid":"6","un":"lusandad","dt":"2021-02-17T12:44:11.705Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-06-07T09:53:00.975Z"}] | 1 | 95 | 3/28/2022 7:08:29 AM | 6 | 3 | |||||||||||||||||||||||
| 1678 | 2/17/2021 12:14:51 PM | 3/28/2022 7:08:29 AM | 6 months policy journal done | 6 months policy journal done<br/><b>Journal Number</b>: [211789]<br/><b>Journal Amount</b>: [-R6,646.20] | 27 | 3 | 1617 | 6 | 4 | 23 | 1 | 95 | [{"op":"R","uid":"6","un":"lusandad","dt":"2021-02-17T12:14:53.171Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-08-07T11:54:33.576Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-08-07T11:55:20.648Z"}] | 1 | 95 | 3/28/2022 7:08:29 AM | 6 | 3 | |||||||||||||||||||||||
| 1677 | 2/17/2021 12:14:32 PM | 2/24/2022 10:44:24 AM | high water consumption on the account | consumer charged for 131kl consumption,statement dated 2020/06/28.Please investigate and resolve.<div>journal done</div> | 27 | 3 | 1616 | 28 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"28","un":"samanthaj","dt":"2021-02-17T12:14:34.579Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-10-14T10:21:13.521Z"}] | 1 | 111 | 6 | 2/24/2022 10:44:24 AM | 28 | 6 | ||||||||||||||||||||||
| 1676 | 2/17/2021 11:57:29 AM | 2/24/2022 11:08:12 AM | incorrect readings | readings up-to-date | 27 | 3 | 1615 | 22 | 2 | 23 | 77 | 48 | [{"op":"R","uid":"22","un":"asandam","dt":"2021-02-17T11:57:31.043Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-15T08:44:39.894Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-15T08:45:38.152Z"}] | 77 | 48 | 2/24/2022 11:08:12 AM | 22 | 12 |