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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2574 | 3/23/2021 10:00:28 AM | 5/19/2022 7:53:10 AM | WATER QUERY TEN MONTHS POLICY | WATER QUERY TEN MONTHS POLICY<div>Journal Done</div> | 27 | 3 | 2269 | 18 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"18","un":"lindan","dt":"2021-03-23T10:00:30.746Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-03T12:52:19.983Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-04T06:41:13.383Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-10-14T11:42:24.814Z"}] | 1 | 101 | 17 | 5/19/2022 7:53:10 AM | 18 | 17 | ||||||||||||||||||||||
| 2572 | 3/23/2021 10:00:19 AM | 4/4/2022 1:28:53 PM | Leak credit | <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> | 27 | 3 | 2268 | 75 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"173","un":"olgad","dt":"2021-03-23T10:00:21.247Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T10:26:48.442Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-11-14T06:56:44.427Z"},{"op":"R","uid":"13","un":"unathig","dt":"2022-04-04T13:28:53.653Z"}] | 1 | 96 | 17 | 4/4/2022 1:28:53 PM | 173 | 17 | ||||||||||||||||||||||
| 2573 | 3/23/2021 9:58:58 AM | 7/21/2021 9:51:38 AM | no valid query details submitted | no valid query details submitted | 27 | 3 | 10 | 2 | 23 | 1 | 44 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-03-23T09:59:26.293Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-15T13:01:44.449Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-16T08:26:48.301Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-16T09:48:54.354Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T09:51:39.540Z"}] | 1 | 44 | 7/21/2021 9:51:38 AM | 10 | 14 | ||||||||||||||||||||||||
| 2573 | 3/23/2021 9:58:22 AM | 7/21/2021 9:52:01 AM | no valid query details submitted | no valid query details submitted | 27 | 3 | 13 | 2 | 23 | 1 | 44 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-03-23T09:58:50.386Z"},{"op":"R","uid":"172","un":"sesonad","dt":"2021-03-23T09:59:01.154Z"},{"op":"R","uid":"172","un":"sesonad","dt":"2021-03-23T09:59:17.601Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-15T13:02:02.468Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T09:51:59.704Z"}] | 1 | 44 | 7/21/2021 9:52:01 AM | 13 | 14 | ||||||||||||||||||||||||
| 2571 | 3/23/2021 9:49:49 AM | 10/8/2022 6:39:53 AM | Leak letter | Leak letter provided by consumer, leak letter dated 30/09/2018<div><br></div><div>Debt written off June 2022, cleared debt. Query closed</div> | 27 | 3 | 2267 | 75 | 4 | 23 | 1 | 96 | [{"op":"R","uid":"173","un":"olgad","dt":"2021-03-23T09:49:51.655Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T10:25:53.310Z"},{"op":"R","uid":"13","un":"unathig","dt":"2021-11-14T10:31:31.127Z"}] | 1 | 96 | 18 | 7/2/2022 11:43:22 AM | 137578 | 3 | 11 | |||||||||||||||||||||
| 2570 | 3/23/2021 9:49:13 AM | 4/12/2022 9:43:30 AM | Six Months Policy | Please assess Six Months Policy for the period 202010<br/><b>Journal Number</b>: [BJ71121281] | 24 | 3 | 2266 | 4 | 23 | 1 | 95 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-03-23T09:49:40.680Z"},{"op":"R","uid":"15","un":"chumab","dt":"2021-09-22T12:16:55.232Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T10:24:55.914Z"}] | 1 | 101 | 18 | 18 | |||||||||||||||||||||||||
| 2569 | 3/23/2021 9:41:18 AM | 7/21/2021 9:51:00 AM | no valid query details submitted | no valid query details submitted | 27 | 3 | 11 | 2 | 23 | 1 | 44 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-03-23T09:41:45.964Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2021-06-07T08:24:18.053Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-15T13:03:27.092Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T09:51:00.841Z"}] | 1 | 44 | 7/21/2021 9:51:00 AM | 11 | 14 | ||||||||||||||||||||||||
| 2568 | 3/23/2021 9:41:04 AM | 3/28/2022 7:08:29 AM | WATER QUERY SIX MONTHS POLICY | WATER QUERY SIX MONTHS POLICY<br/><b>Journal Number</b>: [BJ71830816] | 24 | 3 | 2265 | 2 | 23 | 77 | 95 | [{"op":"R","uid":"18","un":"lindan","dt":"2021-03-23T09:41:06.356Z"},{"op":"R","uid":"15","un":"chumab","dt":"2021-08-11T13:19:06.114Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T10:19:41.827Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T10:23:23.735Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T10:23:44.676Z"}] | 1 | 101 | 18 | 18 | |||||||||||||||||||||||||
| 2566 | 3/23/2021 9:34:30 AM | 8/30/2021 11:31:31 AM | Leak letter | Leak letter provided by consumer, leak was repaired on 15/06/2020<div><br></div><div>Journal Processed with Journal number BJ71826827</div><div>Duplicate query with ref# 11985 closed</div> | 27 | 3 | 2264 | 75 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"173","un":"olgad","dt":"2021-03-23T09:34:32.666Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-08-16T12:47:35.208Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-08-30T11:29:25.404Z"}] | 1 | 96 | 8/30/2021 11:31:31 AM | 173 | 3 | |||||||||||||||||||||||
| 2567 | 3/23/2021 9:33:39 AM | 3/28/2022 7:23:36 AM | LEAK ON METER | 100% CR LEAKING IN THE METER FOR LONG TIME<div><br></div><br/><b>Journal Number</b>: [459895] | 24 | 3 | 2263 | 4 | 23 | 1 | 49 | [{"op":"R","uid":"18","un":"lindan","dt":"2021-03-23T09:33:41.974Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-06-18T12:40:20.082Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-07-01T13:44:55.095Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-07-05T10:27:12.949Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-07-05T10:27:48.787Z"}] | 1 | 49 | 4 | ||||||||||||||||||||||||||
| 2565 | 3/23/2021 9:21:59 AM | 11/14/2021 8:08:01 AM | Leak letter | <p class="MsoNormal"><span lang="EN-ZA">• The account is affected with stage 3 water restriction tariffs as the current consumption exceeds 21+kl<o:p></o:p></span></p> | 27 | 3 | 2261 | 75 | 3 | 23 | 1 | 96 | [{"op":"R","uid":"173","un":"olgad","dt":"2021-03-23T09:22:02.049Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T10:00:47.134Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T10:01:37.742Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-11-14T07:49:25.519Z"}] | 1 | 96 | 17 | 11/14/2021 8:08:01 AM | 173 | 17 | ||||||||||||||||||||||
| 2564 | 3/23/2021 9:19:13 AM | 11/14/2021 6:54:53 AM | Leak letter | <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> | 27 | 3 | 2260 | 75 | 3 | 23 | 1 | 96 | [{"op":"R","uid":"173","un":"olgad","dt":"2021-03-23T09:19:15.612Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T09:54:52.741Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T10:00:18.867Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-11-14T06:53:07.729Z"}] | 1 | 96 | 17 | 11/14/2021 6:54:53 AM | 173 | 17 | ||||||||||||||||||||||
| 2557 | 3/23/2021 9:13:07 AM | 7/21/2021 9:50:24 AM | Leak letter | Affidavit provided by consumer | 27 | 3 | 2256 | 75 | 3 | 23 | 1 | 96 | [{"op":"R","uid":"173","un":"olgad","dt":"2021-03-23T09:13:09.227Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T09:50:16.463Z"}] | 1 | 96 | 7/21/2021 9:50:24 AM | 173 | 14 | |||||||||||||||||||||||
| 2560 | 3/23/2021 9:11:20 AM | 8/30/2021 10:24:21 AM | high water consumption | There was high water consumption in 2020/12/24<div>debt written off</div> | 27 | 3 | 2259 | 101 | 4 | 23 | 1 | 67 | 1189 | [{"op":"R","uid":"199","un":"siphokazin","dt":"2021-03-23T09:11:23.623Z"},{"op":"R","uid":"199","un":"siphokazin","dt":"2021-03-23T09:18:42.197Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-03T10:23:45.768Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-08-30T10:22:02.847Z"}] | 1 | 67 | 8/30/2021 10:24:21 AM | 199 | 6 | ||||||||||||||||||||||
| 2562 | 3/23/2021 9:10:06 AM | 3/28/2022 7:07:05 AM | WATER QUERY CONSUMER SUBMITTED PLUMBERS LETTER | WATER QUERY CONSUMER SUBMITTED PLUMBERS LETTER<div><br></div><div>LEAK PASSED </div><br/><b>Journal Number</b>: [439920]<br/><b>Journal Amount</b>: [6413.46] | 27 | 3 | 2258 | 15 | 2 | 23 | 1 | 67 | 1188 | [{"op":"R","uid":"18","un":"lindan","dt":"2021-03-23T09:10:08.867Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-03-23T09:35:27.349Z"},{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-10-16T12:31:07.004Z"},{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-10-17T08:59:55.847Z"},{"op":"R","uid":"8","un":"mariaanaw","dt":"2021-11-21T08:54:49.642Z"}] | 1 | 96 | 8 | 3/28/2022 7:07:05 AM | 15 | 8 | |||||||||||||||||||||
| 2556 | 3/23/2021 9:05:00 AM | 2/24/2022 12:27:27 PM | 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> | 4 | 3 | 2257 | 31 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"31","un":"xolanit","dt":"2021-03-23T09:05:02.550Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-03T10:13:12.821Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T09:52:51.044Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T09:53:50.271Z"}] | 9 | 123 | 18 | 2/24/2022 12:27:27 PM | 31 | 18 | ||||||||||||||||||||||
| 2559 | 3/23/2021 9:04:38 AM | 2/27/2023 6:58:03 AM | Six Months Policy | Please assess six months policy for the period 202009<div>Thanks</div><div><br></div><div><b>QRC RESPONSE: SIX MONTHS POLICY ADJUSTMENT DONE.</b></div><br/><b>Journal Number</b>: [755907] | 24 | 3 | 2262 | 15 | 4 | 23 | 1 | 95 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-03-23T09:05:19.611Z"},{"op":"R","uid":"172","un":"sesonad","dt":"2021-03-23T09:17:53.279Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T09:50:39.920Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T09:52:02.824Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-29T12:22:01.630Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-29T12:22:35.976Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-29T12:22:39.462Z"}] | 1 | 101 | 14 | 143273 | 15 | |||||||||||||||||||||||
| 2556 | 3/23/2021 9:02:52 AM | 8/3/2021 10:12:59 AM | No query info given | No query info given | 4 | 2 | 2257 | 77 | [{"op":"R","uid":"31","un":"xolanit","dt":"2021-03-23T09:04:28.979Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-03T10:12:19.285Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-03T10:12:27.483Z"}] | 77 | 8/3/2021 10:12:59 AM | 20 | |||||||||||||||||||||||||||||
| 2557 | 3/23/2021 9:02:20 AM | 7/21/2021 9:49:47 AM | no valid query details submitted | no valid query details submitted | 27 | 3 | 2256 | 6 | 2 | 23 | 1 | 44 | [{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-15T13:03:56.789Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T09:49:47.467Z"}] | 1 | 44 | 7/21/2021 9:49:47 AM | 6 | 14 | |||||||||||||||||||||||
| 2558 | 3/23/2021 8:57:13 AM | 5/19/2022 7:53:10 AM | Consumer is disputing her high water charge | <div><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></div> | 4 | 3 | 2255 | 18 | 2 | 23 | 1 | 67 | [{"op":"R","uid":"18","un":"lindan","dt":"2021-03-23T08:57:15.271Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-03T09:54:15.872Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-03T09:58:21.734Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-03T10:11:01.005Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T09:47:47.988Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T09:48:55.456Z"},{"op":"R","uid":"904","un":"vuyelwamx","dt":"2022-03-17T12:13:20.329Z"},{"op":"R","uid":"904","un":"vuyelwamx","dt":"2022-03-17T12:16:33.229Z"}] | 9 | 123 | 18 | 5/19/2022 7:53:10 AM | 18 | 18 |