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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2347 | 3/15/2021 9:53:42 AM | 3/28/2022 6:35:04 AM | plumbers letter submitted | plumbers letter submitted,kindly investigate and resolve.<div>account adjusted</div><br/><b>Journal Number</b>: [745249]<br/><b>Journal Amount</b>: [-R25,042.49] | 27 | 3 | 2100 | 5 | 2 | 23 | 77 | 96 | [{"op":"R","uid":"28","un":"samanthaj","dt":"2021-03-15T09:50:01.478Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-26T11:59:48.338Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-11-09T13:13:51.092Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-11-15T06:33:41.071Z"}] | 1 | 96 | 3 | 3/28/2022 6:35:04 AM | 5 | 3 | ||||||||||||||||||||||
| 2346 | 3/15/2021 9:51:45 AM | 2/16/2022 9:04:39 AM | high water consumption | high water consumption in September 2020, debtor reported faulty meter | 30 | 3 | 2099 | 4 | 23 | 1 | 67 | 1098 | [{"op":"R","uid":"194","un":"nomalungisaw","dt":"2021-03-15T09:51:48.311Z"},{"op":"R","uid":"194","un":"nomalungisaw","dt":"2021-03-15T09:55:28.435Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-10T08:57:06.911Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-26T12:00:58.307Z"}] | 1 | 112 | 14 | 14 | ||||||||||||||||||||||||
| 2339 | 3/15/2021 9:46:33 AM | 2/24/2022 10:44:24 AM | duplicate water charge | billing duplication for water | 27 | 3 | 2095 | 28 | 2 | 23 | 1 | 99 | [{"op":"R","uid":"28","un":"samanthaj","dt":"2021-03-15T09:43:03.612Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-10-25T09:20:51.345Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-26T12:02:29.315Z"}] | 1 | 112 | 4 | 2/24/2022 10:44:24 AM | 118807 | 28 | 4 | |||||||||||||||||||||
| 2344 | 3/15/2021 9:08:24 AM | 3/2/2022 8:22:38 AM | LOG QUERY | <table border="0" cellpadding="0" cellspacing="0" width="668" style="border-collapse: collapse;width:501pt"><tbody><tr height="31" style="mso-height-source:userset;height:23.45pt"> <td height="31" class="xl65" width="668" style="height:23.45pt;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 | 2098 | 37 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"37","un":"sokanan","dt":"2021-03-15T09:04:46.609Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-06T07:48:26.392Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-26T12:03:12.562Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-26T12:04:51.887Z"}] | 9 | 123 | 14 | 3/2/2022 8:22:38 AM | 37 | 14 | ||||||||||||||||||||||
| 2342 | 3/15/2021 8:56:58 AM | 2/24/2022 11:19:26 AM | Double charge on water and high 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 | 30 | 2 | 23 | 1 | 67 | 1095 | [{"op":"R","uid":"30","un":"thembekilem","dt":"2021-03-15T08:59:22.450Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-29T10:16:34.666Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-29T10:16:47.885Z"},{"op":"R","uid":"16","un":"cumilem","dt":"2021-10-29T10:19:19.336Z"}] | 9 | 123 | 14 | 2/24/2022 11:19:26 AM | 30 | 14 | ||||||||||||||||||||||
| 2341 | 3/15/2021 8:54:11 AM | 3/2/2022 8:22:38 AM | WATER QUERY | WATER QUERY.<div><p class="MsoNormal">. Billing link the meters as per category e.g. if business wa0200 or domestic wa0100 etc. If the business is a NGO relevant documents is submitted to Rates to approve rebate accordingly. They then advise billing of this as of that specific date of approval to NGO. Once this is done we then only change tariff to wa0300 for water.<o:p></o:p></p></div> | 27 | 3 | 2097 | 37 | 2 | 23 | 1 | 67 | 1094 | [{"op":"R","uid":"37","un":"sokanan","dt":"2021-03-15T08:50:34.333Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-05T12:15:29.684Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-10-16T10:43:50.355Z"}] | 1 | 50 | 12 | 3/2/2022 8:22:38 AM | 37 | 12 | |||||||||||||||||||||
| 2340 | 3/15/2021 8:36:32 AM | 10/17/2021 8:52:46 AM | water query 6 month policy | water query<br/><b>Journal Number</b>: [439919] | 24 | 3 | 2096 | 2 | 23 | 1 | 95 | [{"op":"R","uid":"32","un":"andisiwem","dt":"2021-03-15T08:32:54.157Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-05T12:14:55.840Z"},{"op":"R","uid":"13","un":"unathig","dt":"2021-10-17T08:52:22.036Z"}] | 1 | 101 | 13 | 13 | |||||||||||||||||||||||||
| 2338 | 3/15/2021 8:17:05 AM | 5/27/2022 8:45:27 AM | 6 month policy | consumer being charged on two meters for water<div></div><div><br></div><div>Query Resolved in 2017</div><div><br></div><div>Nov 2017 billing was adjusted Dec 2017 with O/R. </div> | 27 | 3 | 2094 | 132 | 2 | 23 | 77 | 99 | [{"op":"R","uid":"28","un":"samanthaj","dt":"2021-03-15T08:13:26.718Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-10-25T08:57:25.714Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-26T12:05:41.480Z"},{"op":"R","uid":"10","un":"mellozanef","dt":"2021-11-27T10:36:45.428Z"},{"op":"R","uid":"10","un":"mellozanef","dt":"2022-04-11T13:39:19.878Z"}] | 1 | 101 | 10 | 5/27/2022 8:45:27 AM | 118804 | 3 | 3 | |||||||||||||||||||||
| 2336 | 3/15/2021 8:14:23 AM | 3/2/2022 8:22:38 AM | INCORRECT WATER READING | check reading requested.15/08/2021 | 27 | 3 | 2093 | 37 | 2 | 23 | 1 | 44 | 1091 | [{"op":"R","uid":"37","un":"sokanan","dt":"2021-03-15T08:10:45.939Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-15T10:52:49.859Z"}] | 1 | 44 | 3/2/2022 8:22:38 AM | 37 | 12 | ||||||||||||||||||||||
| 2337 | 3/15/2021 8:06:55 AM | 3/28/2022 7:23:36 AM | refuse query | consumer querying being billed for refuse on a vacant plot.<div><br></div><div>2021-05-27 - E-Mailed Noleen Bray to confirm vacant land</div><br/><b>Journal Number</b>: [834416]<br/><b>Journal Amount</b>: [-R14,536.95] | 27 | 3 | 2092 | 13 | 3 | 23 | 4 | 55 | [{"op":"R","uid":"28","un":"samanthaj","dt":"2021-03-15T08:03:17.280Z"},{"op":"R","uid":"5","un":"ivanh","dt":"2021-05-27T07:00:31.497Z"},{"op":"R","uid":"5","un":"ivanh","dt":"2021-05-31T11:44:32.398Z"},{"op":"R","uid":"5","un":"ivanh","dt":"2021-05-31T11:56:09.759Z"},{"op":"R","uid":"5","un":"ivanh","dt":"2021-06-04T12:48:10.779Z"},{"op":"R","uid":"5","un":"ivanh","dt":"2021-06-04T12:59:25.398Z"},{"op":"R","uid":"5","un":"ivanh","dt":"2021-06-09T13:19:28.508Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-06-13T10:43:55.618Z"}] | 4 | 55 | 3/28/2022 7:23:36 AM | 13 | 3 | |||||||||||||||||||||||
| 2335 | 3/15/2021 7:36:33 AM | 3/2/2022 8:22:38 AM | LOG QUERY | <table border="0" cellpadding="0" cellspacing="0" width="668" style="border-collapse: collapse;width:501pt"><tbody><tr height="31" style="mso-height-source:userset;height:23.45pt"> <td height="31" class="xl65" width="668" style="height:23.45pt;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 | 2091 | 37 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"37","un":"sokanan","dt":"2021-03-15T07:32:59.492Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-05T12:12:03.422Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-26T12:06:32.092Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-27T06:38:18.771Z"}] | 9 | 123 | 14 | 3/2/2022 8:22:38 AM | 37 | 14 | ||||||||||||||||||||||
| 2334 | 3/15/2021 6:58:53 AM | 2/24/2022 11:21:35 AM | Electricity Query | <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 | 9 | 2 | 23 | 2 | 101 | [{"op":"R","uid":"9","un":"masibuleley","dt":"2021-03-15T07:01:16.489Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-27T06:38:43.493Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-27T12:26:40.482Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-29T10:03:34.196Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-29T10:03:44.493Z"}] | 9 | 123 | 14 | 2/24/2022 11:21:35 AM | 9 | 14 | |||||||||||||||||||||||
| 2333 | 3/15/2021 6:37:38 AM | 2/24/2022 11:19:26 AM | Double charge on water | <table border="0" cellpadding="0" cellspacing="0" width="668" style="border-collapse: collapse;width:501pt"><tbody><tr height="31" style="mso-height-source:userset;height:23.45pt"> <td height="31" class="xl63" width="668" style="height:23.45pt;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 | 30 | 2 | 23 | 1 | 67 | 1089 | [{"op":"R","uid":"30","un":"thembekilem","dt":"2021-03-15T06:39:47.237Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-27T06:39:05.393Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-27T06:40:49.540Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-27T07:17:44.223Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-27T11:54:00.792Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-27T12:17:52.621Z"}] | 9 | 123 | 14 | 2/24/2022 11:19:26 AM | 30 | 14 | ||||||||||||||||||||||
| 2332 | 3/13/2021 7:40:18 AM | 11/3/2021 7:16:02 AM | log query | incorrect readings. Taken on 0047 - 23/02<div><br></div><div>account in order</div> | 27 | 3 | 2090 | 39 | 2 | 23 | 77 | 44 | [{"op":"R","uid":"39","un":"tembekas","dt":"2021-03-13T07:40:20.731Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-29T07:33:36.599Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-30T08:42:30.000Z"},{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-11-03T07:15:43.716Z"}] | 1 | 111 | 11 | 11/3/2021 7:16:02 AM | 39 | 11 | ||||||||||||||||||||||
| 2331 | 3/12/2021 2:00:12 PM | 2/24/2022 10:34:50 AM | water query | 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 | 2089 | 26 | 2 | 23 | 1 | 67 | 1087 | [{"op":"R","uid":"26","un":"nobulalim","dt":"2021-03-12T14:00:15.097Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-29T07:34:54.625Z"}] | 9 | 123 | 20 | 2/24/2022 10:34:50 AM | 26 | 20 | |||||||||||||||||||||
| 2330 | 3/12/2021 11:54:24 AM | 4/12/2022 9:39:10 AM | FIRE LEVY MUST BE REVERSED | PROPERTY SOLD 2009.10.27 REVERSED FIRE LEVY <br/><b>Journal Number</b>: [10340253] | 24 | 3 | 2088 | 3 | 23 | 3 | 52 | 1086 | [{"op":"R","uid":"4","un":"babalwam","dt":"2021-03-12T11:54:27.263Z"},{"op":"R","uid":"8","un":"mariaanaw","dt":"2021-08-06T10:18:48.149Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-29T07:35:42.106Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-30T08:41:36.969Z"}] | 6 | 122 | 20 | 20 | ||||||||||||||||||||||||
| 2329 | 3/12/2021 10:46:14 AM | 4/12/2022 9:39:10 AM | LEAK CREDIT | PLUMBERS LETTER SUBMITTED. TO MONITOR CONSUMPTION FOR 90 DAYS BEFORE ADJUSTMENT<br/><b>Monitoring Reason</b>: [CONSUMPTION STILL HIGH]<br/><b>Journal Number</b>: [839312] | 27 | 3 | 2087 | 4 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"13","un":"unathig","dt":"2021-03-12T10:42:36.984Z"},{"op":"R","uid":"26","un":"nobulalim","dt":"2021-03-12T10:43:21.198Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-29T07:36:34.049Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-30T08:41:16.320Z"},{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-11-03T08:40:57.972Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2022-01-17T13:12:54.967Z"},{"op":"R","uid":"56","un":"mihlet","dt":"2022-01-17T13:13:33.468Z"}] | 1 | 96 | 11 | 4/12/2022 9:39:10 AM | 4 | 11 | ||||||||||||||||||||||
| 2328 | 3/12/2021 10:37:45 AM | 12/6/2022 7:41:38 AM | plumbers letter submitted | plumbers letter submitted by consumer as proof of work done on leak caused by burst pipe. kindly investigate and resolve.<div><br></div><div>QRC RESPONSE: LEAK CREDIT ADJUSTMENT DONE FO 202003-202008, AVERAGE 31KL.</div><br/><b>Journal Number</b>: [963703]<br/><b>Journal Amount</b>: [61094.02] | 27 | 3 | 2086 | 17 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"26","un":"nobulalim","dt":"2021-03-12T10:37:26.788Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-29T07:37:55.174Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-29T07:38:29.155Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-30T08:41:02.293Z"},{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-11-18T13:10:33.053Z"}] | 1 | 96 | 20 | 12/6/2022 7:41:26 AM | 2 | 2 | ||||||||||||||||||||||
| 2327 | 3/12/2021 10:34:01 AM | 3/12/2021 10:34:04 AM | 2 | 2085 | [{"op":"R","uid":"28","un":"samanthaj","dt":"2021-03-12T10:33:44.063Z"}] | 28 | |||||||||||||||||||||||||||||||||||
| 2326 | 3/12/2021 10:10:58 AM | 2/24/2022 10:44:24 AM | WATER QUERY | 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. | 27 | 3 | 2084 | 28 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"28","un":"samanthaj","dt":"2021-03-12T10:10:45.782Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-10T09:00:57.809Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-29T07:39:08.466Z"},{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-11-03T07:26:28.764Z"}] | 9 | 123 | 11 | 2/24/2022 10:44:24 AM | 28 | 11 |