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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1211 | 2/3/2021 7:21:01 AM | 2/24/2022 11:08:12 AM | water query | high water consumption | 27 | 3 | 1241 | 22 | 3 | 23 | 77 | 67 | [{"op":"R","uid":"22","un":"asandam","dt":"2021-02-03T07:21:00.667Z"},{"op":"R","uid":"13","un":"unathig","dt":"2021-10-23T10:25:41.299Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-27T08:54:37.672Z"}] | 1 | 101 | 13 | 2/24/2022 11:08:12 AM | 22 | 13 | ||||||||||||||||||||||
| 1210 | 2/3/2021 7:16:02 AM | 2/24/2022 11:08:12 AM | water query | high water consumption<div><br></div><div>account in order no cr due</div> | 27 | 3 | 1240 | 22 | 3 | 23 | 77 | 67 | [{"op":"R","uid":"22","un":"asandam","dt":"2021-02-03T07:16:01.548Z"},{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-10-17T06:26:56.174Z"}] | 1 | 96 | 11 | 2/24/2022 11:08:12 AM | 22 | 11 | ||||||||||||||||||||||
| 1209 | 2/3/2021 6:57:31 AM | 3/28/2022 7:25:06 AM | water query | <div><br></div><div>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. </div> | 4 | 3 | 1239 | 17 | 3 | 23 | 77 | 67 | [{"op":"R","uid":"22","un":"asandam","dt":"2021-02-03T06:57:30.838Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-09-02T07:09:18.912Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-27T08:53:09.412Z"}] | 9 | 123 | 20 | 3/28/2022 7:25:06 AM | 17 | 20 | ||||||||||||||||||||||
| 1208 | 2/2/2021 1:54:32 PM | 3/28/2022 6:33:19 AM | WATER | INCORRECT TARRIF CHANGED. WA0100-WA0200<br><b>Journal Number</b>: [201807]<div><br></div><div>Journal returned to amend end totals. </div><div>Journal Done</div> | 27 | 3 | 1238 | 3 | 2 | 23 | 1 | 50 | 2006 | [{"op":"R","uid":"6","un":"lusandad","dt":"2021-02-02T13:51:23.905Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-02-13T07:36:30.349Z"},{"op":"R","uid":"5","un":"ivanh","dt":"2021-05-12T10:19:41.301Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-10-14T09:50:03.920Z"}] | 1 | 111 | 17 | 3/28/2022 6:33:19 AM | 3 | 17 | |||||||||||||||||||||
| 1206 | 2/2/2021 1:05:49 PM | 3/28/2022 7:25:06 AM | leak credit | Journal done<br/><b>Journal Number</b>: [201886] | 27 | 3 | 1237 | 17 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"17","un":"cwayitak","dt":"2021-02-02T13:05:52.309Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-02-02T13:08:53.145Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-08-16T13:13:28.472Z"}] | 1 | 96 | 3/28/2022 7:25:06 AM | 17 | 3 | |||||||||||||||||||||||
| 1185 | 2/2/2021 11:58:39 AM | 2/24/2022 11:08:12 AM | Refund | consumer requests refund as he is no longer property owner and reversal of dog tax.<br/><b>Refund Type</b>: [nompumleLop@buffalocity.gov.za] | 11 | 2 | 1226 | 22 | 77 | [{"op":"R","uid":"22","un":"asandam","dt":"2021-02-02T11:58:41.169Z"},{"op":"R","uid":"22","un":"asandam","dt":"2021-02-02T12:00:06.815Z"}] | 77 | 2/24/2022 11:08:12 AM | 22 | 22 | |||||||||||||||||||||||||||
| 1204 | 2/2/2021 11:36:32 AM | 2/2/2021 11:36:34 AM | 2 | [{"op":"R","uid":"21","un":"heinrichs","dt":"2021-02-02T11:36:34.701Z"}] | 21 | ||||||||||||||||||||||||||||||||||||
| 1199 | 2/2/2021 10:08:33 AM | 2/24/2022 10:44:24 AM | water query | <div><br></div><div>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.</div><div><p class="MsoNormal"><b><u><span lang="EN-ZA">RECOMMENDED: Customer is advised to</span></u></b><span lang="EN-ZA">:<o:p></o:p></span></p> <p class="MsoNormal"><span lang="EN-ZA">1. Have the premises assessed for any undetected leaks (if leaks are repaired, to log a new query with a signed copy of the plumbers letter stating what was repaired, date of repairs and account information; or<o:p></o:p></span></p> <p class="MsoNormal"><span lang="EN-ZA">2. If no leaks found, try and reduce the monthly usage to 20kl or less to avoid penalty charges; or<o:p></o:p></span></p> <p class="MsoNormal"><span lang="EN-ZA">3. (if possible) take a picture of the meter with reading, compare with current statement and forward it to <a href="mailto:meterreading@buffalocity.gov.za">meterreading@buffalocity.gov.za</a> <o:p></o:p></span></p></div><div> </div> | 27 | 3 | 1234 | 28 | 2 | 23 | 80 | 67 | [{"op":"R","uid":"28","un":"samanthaj","dt":"2021-02-02T10:05:24.186Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-27T08:32:23.518Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-27T08:40:36.780Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-27T08:52:23.163Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-27T08:54:10.999Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-11-13T06:55:26.626Z"}] | 9 | 123 | 17 | 2/24/2022 10:44:24 AM | 28 | 17 | ||||||||||||||||||||||
| 1198 | 2/2/2021 10:02:17 AM | 2/5/2022 8:25:28 AM | 2 | 1233 | [{"op":"R","uid":"21","un":"heinrichs","dt":"2021-02-02T10:02:18.976Z"},{"op":"R","uid":"18","un":"lindan","dt":"2022-02-05T08:25:28.442Z"}] | 18 | |||||||||||||||||||||||||||||||||||
| 1197 | 2/2/2021 9:48:56 AM | 2/24/2022 10:44:24 AM | propery sold,request for refund by consumer still pending | property sold,request for refund by consumer still pending.<br/><b>Refund Type</b>: [nompumleLop@buffalocity.gov.za] | 11 | 2 | 1232 | 28 | 82 | [{"op":"R","uid":"28","un":"samanthaj","dt":"2021-02-02T09:45:47.676Z"},{"op":"R","uid":"28","un":"samanthaj","dt":"2021-02-02T09:47:59.732Z"},{"op":"R","uid":"28","un":"samanthaj","dt":"2021-02-02T09:49:08.156Z"}] | 82 | 2/24/2022 10:44:24 AM | 28 | 28 | |||||||||||||||||||||||||||
| 1196 | 2/2/2021 8:59:24 AM | 2/2/2021 9:04:07 AM | 2 | [{"op":"R","uid":"26","un":"nobulalim","dt":"2021-02-02T08:56:16.153Z"},{"op":"R","uid":"26","un":"nobulalim","dt":"2021-02-02T08:59:42.125Z"},{"op":"R","uid":"26","un":"nobulalim","dt":"2021-02-02T09:00:13.112Z"},{"op":"R","uid":"26","un":"nobulalim","dt":"2021-02-02T09:00:42.803Z"},{"op":"R","uid":"26","un":"nobulalim","dt":"2021-02-02T09:00:52.144Z"},{"op":"R","uid":"26","un":"nobulalim","dt":"2021-02-02T09:00:56.443Z"}] | 26 | ||||||||||||||||||||||||||||||||||||
| 1194 | 2/2/2021 8:29:50 AM | 2/2/2021 8:38:08 AM | 2 | [{"op":"R","uid":"28","un":"samanthaj","dt":"2021-02-02T08:26:41.234Z"},{"op":"R","uid":"22","un":"asandam","dt":"2021-02-02T08:38:03.110Z"}] | 22 | ||||||||||||||||||||||||||||||||||||
| 1193 | 2/2/2021 8:00:54 AM | 1/12/2023 9:28:27 AM | High water consumption | Consumer is querying high bill as only 2 people live in the house . <div>water consumption is above 21kl, consumer needs to find a plumber to check for leaks.</div><div><br></div><div><b><u>RESPONSE FROM QRC: </u></b>High Consumption logged Ref: 795566</div><div>Meter change update requested.</div><div><br></div> | 30 | 3 | 1231 | 17 | 3 | 23 | 77 | 67 | [{"op":"R","uid":"41","un":"andilek","dt":"2021-02-02T07:57:45.326Z"},{"op":"R","uid":"22","un":"asandam","dt":"2021-02-02T08:38:19.039Z"},{"op":"R","uid":"26","un":"nobulalim","dt":"2021-02-02T09:16:23.078Z"},{"op":"R","uid":"41","un":"andilek","dt":"2021-02-02T09:52:16.048Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-10-23T08:48:28.557Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-27T08:31:42.982Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-11-10T12:54:52.916Z"}] | 1 | 96 | 20 | 141547 | 8 | |||||||||||||||||||||||
| 1191 | 2/2/2021 7:03:13 AM | 2/25/2022 9:22:48 AM | Water | high water consumption<div>JOurnal Done</div> | 27 | 3 | 1230 | 41 | 3 | 23 | 77 | 67 | [{"op":"R","uid":"41","un":"andilek","dt":"2021-02-02T07:00:04.390Z"},{"op":"R","uid":"41","un":"andilek","dt":"2021-02-02T07:03:33.852Z"},{"op":"R","uid":"41","un":"andilek","dt":"2021-02-02T07:31:54.326Z"},{"op":"R","uid":"22","un":"asandam","dt":"2021-02-02T08:38:53.259Z"},{"op":"R","uid":"26","un":"nobulalim","dt":"2021-02-02T09:16:51.560Z"},{"op":"R","uid":"28","un":"samanthaj","dt":"2021-02-03T11:45:29.523Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-06-08T08:09:31.376Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-10-14T10:10:47.879Z"}] | 1 | 96 | 17 | 2/25/2022 9:22:48 AM | 41 | 17 | ||||||||||||||||||||||
| 1190 | 2/2/2021 6:57:06 AM | 2/24/2022 10:34:50 AM | log query | account being charged for 2 meters | 27 | 3 | 1229 | 26 | 2 | 23 | 77 | 99 | [{"op":"R","uid":"26","un":"nobulalim","dt":"2021-02-02T06:53:57.970Z"},{"op":"R","uid":"22","un":"asandam","dt":"2021-02-02T08:39:14.379Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-10-25T09:23:47.422Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-27T08:30:40.210Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-27T08:30:59.322Z"}] | 1 | 112 | 4 | 2/24/2022 10:34:50 AM | 118809 | 26 | 4 | |||||||||||||||||||||
| 1187 | 2/1/2021 1:36:39 PM | 2/2/2021 7:37:21 AM | 2 | [{"op":"R","uid":"28","un":"samanthaj","dt":"2021-02-01T13:33:29.046Z"},{"op":"R","uid":"28","un":"samanthaj","dt":"2021-02-01T13:34:53.321Z"},{"op":"R","uid":"28","un":"samanthaj","dt":"2021-02-01T13:35:10.429Z"},{"op":"R","uid":"41","un":"andilek","dt":"2021-02-02T07:34:09.900Z"}] | 41 | ||||||||||||||||||||||||||||||||||||
| 1188 | 2/1/2021 1:32:51 PM | 3/22/2022 7:09:10 AM | water query 6 month policy | water query<div><br></div><div>ACCOUNT DOES NOT QUALIFY FOR SIX MONTHS POLICY ADJUSTMENT</div> | 27 | 3 | 1228 | 2 | 2 | 23 | 1 | 67 | 247 | [{"op":"R","uid":"29","un":"thendekam","dt":"2021-02-01T13:32:53.337Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2021-02-02T08:18:44.620Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2021-02-02T08:20:16.166Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2021-02-02T08:23:06.462Z"},{"op":"R","uid":"22","un":"asandam","dt":"2021-02-02T08:39:34.332Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-27T08:30:14.560Z"},{"op":"R","uid":"15","un":"chumab","dt":"2022-02-19T06:49:28.924Z"}] | 1 | 101 | 15 | 3/22/2022 7:09:10 AM | 124223 | 2 | 15 | ||||||||||||||||||||
| 1186 | 2/1/2021 1:24:15 PM | 2/25/2022 9:01:52 AM | water query 6 month policy | water query<div>ACCOUNT DOES NOT QUALIFY FOR 6 MONTHS POLICY POLICY</div> | 27 | 3 | 1227 | 29 | 3 | 23 | 1 | 67 | 314 | [{"op":"R","uid":"29","un":"thendekam","dt":"2021-02-01T13:24:17.224Z"},{"op":"R","uid":"22","un":"asandam","dt":"2021-02-02T08:39:49.985Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-02-02T10:34:47.187Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-27T08:29:24.548Z"},{"op":"R","uid":"15","un":"chumab","dt":"2022-02-19T06:33:43.624Z"}] | 1 | 101 | 15 | 2/25/2022 9:01:52 AM | 124221 | 29 | 15 | ||||||||||||||||||||
| 1185 | 2/1/2021 1:22:08 PM | 2/24/2022 11:08:12 AM | consumer no longer property owner,dog tax also charged in error. | consumer requests refund as he is no longer property owner and reversal of dog tax. | 4 | 3 | 1226 | 22 | 2 | 23 | 12 | 75 | [{"op":"R","uid":"28","un":"samanthaj","dt":"2021-02-01T13:18:57.895Z"},{"op":"R","uid":"22","un":"asandam","dt":"2021-02-02T08:40:23.559Z"},{"op":"R","uid":"22","un":"asandam","dt":"2021-02-02T08:41:11.466Z"},{"op":"R","uid":"22","un":"asandam","dt":"2021-02-02T08:43:09.899Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-02-02T10:31:45.233Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-02-02T10:32:08.680Z"},{"op":"R","uid":"22","un":"asandam","dt":"2021-02-02T11:58:12.294Z"},{"op":"R","uid":"22","un":"asandam","dt":"2021-02-02T12:00:35.421Z"}] | 12 | 75 | 2/24/2022 11:08:12 AM | 22 | 22 | |||||||||||||||||||||||
| 1184 | 2/1/2021 1:13:12 PM | 6/30/2022 1:12:05 PM | WATER QUERY 6 MONTH POLICY | WATER QUERY<div><br></div><div>6months adjustment done</div><br/><b>Journal Number</b>: [710528] | 27 | 3 | 1225 | 17 | 4 | 23 | 1 | 67 | 313 | [{"op":"R","uid":"29","un":"thendekam","dt":"2021-02-01T13:13:14.402Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-02-02T10:31:22.056Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-27T08:27:09.194Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-27T08:27:48.481Z"},{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-11-14T06:52:11.431Z"}] | 1 | 101 | 11 | 6/30/2022 1:12:05 PM | 134153 | 7 | 7 |