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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3217 | 4/12/2021 11:20:23 AM | 4/12/2021 11:20:25 AM | 2 | 2770 | [{"op":"R","uid":"20","un":"nzwanam","dt":"2021-04-12T11:20:25.141Z"}] | 20 | |||||||||||||||||||||||||||||||||||
| 3216 | 4/12/2021 10:51:22 AM | 4/12/2022 9:47:18 AM | Leak Credit | Kindly assess a leak credit <div><br></div><div>leak credit adjustment done </div><br/><b>Journal Number</b>: [880216]<br/><b>Journal Amount</b>: [50038.82] | 27 | 3 | 2769 | 10 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-04-12T10:51:24.866Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-08-15T10:07:45.129Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-02T08:56:57.813Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-11-14T08:39:51.938Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-11-14T08:39:55.033Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2021-11-17T06:06:48.849Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2021-11-17T06:09:39.674Z"}] | 1 | 96 | 2 | 4/12/2022 9:47:18 AM | 10 | 2 | ||||||||||||||||||||||
| 3214 | 4/12/2021 10:34:22 AM | 5/19/2022 7:53:10 AM | WATER QUERY | WATER QUERY<div>Journal Already done </div> | 27 | 3 | 2767 | 18 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"18","un":"lindan","dt":"2021-04-12T10:34:24.619Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-10-30T11:44:01.817Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-02T08:56:29.013Z"}] | 1 | 96 | 17 | 5/19/2022 7:53:10 AM | 18 | 17 | ||||||||||||||||||||||
| 3213 | 4/12/2021 10:26:16 AM | 2/19/2023 8:15:40 AM | Six months policy | Please assess account for six months policy for period 2019/03-2020/<div><br></div><div>6 month policy processed for 201903/202003</div><br/><b>Journal Number</b>: [881973] | 27 | 3 | 2766 | 15 | 2 | 23 | 1 | 95 | [{"op":"R","uid":"173","un":"olgad","dt":"2021-04-12T10:22:16.253Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-10-30T07:27:55.894Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-02T08:55:52.904Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-11-10T08:52:25.235Z"},{"op":"R","uid":"10","un":"mellozanef","dt":"2021-11-21T09:42:45.268Z"}] | 1 | 101 | 10 | 2/19/2023 8:15:40 AM | 6 | 6 | ||||||||||||||||||||||
| 3212 | 4/12/2021 10:14:19 AM | 11/2/2021 8:55:25 AM | Leak credit | Kindly assess a leak credit for that was reported in December 2018.<table border="0" cellpadding="0" cellspacing="0" width="864" style="border-collapse: collapse;width:648pt"><tbody><tr height="20" style="height:15.0pt"> <td height="20" class="xl65" width="864" style="height:15.0pt;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> | 4 | 3 | 74 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-04-12T10:14:21.571Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-02T08:54:51.139Z"}] | 9 | 123 | 14 | 11/2/2021 8:55:25 AM | 172 | 14 | |||||||||||||||||||||||
| 3211 | 4/12/2021 10:03:08 AM | 2/19/2023 8:07:59 AM | water query | water query<div><br></div><div><b><u>QRC RESPONSE: </u></b>Six months policy due for period 202111 in process.</div><div><br></div><div>Journal processed by billing department, currently awaiting authorization.</div> | 27 | 3 | 2765 | 15 | 4 | 23 | 77 | 67 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-04-12T09:59:11.965Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-04-12T10:03:35.315Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-04-12T10:04:29.397Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-04-12T10:04:56.222Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2021-07-13T08:34:57.873Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-02T08:53:55.550Z"}] | 1 | 101 | 14 | 2/19/2023 8:07:59 AM | 6 | 6 | ||||||||||||||||||||||
| 3210 | 4/12/2021 9:57:32 AM | 11/10/2021 10:49:31 AM | Leak Credit | <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> | 27 | 3 | 2764 | 74 | 3 | 23 | 1 | 96 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-04-12T09:57:34.590Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-02T08:53:20.820Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-11-10T10:48:59.438Z"}] | 1 | 96 | 17 | 11/10/2021 10:49:31 AM | 172 | 17 | ||||||||||||||||||||||
| 3209 | 4/12/2021 9:56:12 AM | 11/10/2021 10:38:25 AM | Leak | water query<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><br></div></div> | 27 | 3 | 2763 | 14 | 4 | 23 | 77 | 67 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-04-12T09:52:17.065Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-02T08:52:45.067Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-11-10T10:35:41.564Z"}] | 1 | 96 | 17 | 11/10/2021 10:38:25 AM | 14 | 17 | ||||||||||||||||||||||
| 3206 | 4/12/2021 9:45:00 AM | 5/16/2023 9:31:40 AM | Leak credit | Kindly assess a leak for this account, for an invoice dated 21/07/2019 <br/><b>Journal Number</b>: [506166]<br/><b>Journal Amount</b>: [12237,21] | 27 | 3 | 2762 | 17 | 2 | 23 | 1 | 95 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-04-12T09:45:02.645Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-08-04T13:08:33.578Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-08-04T13:09:11.051Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-02T08:52:10.858Z"},{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-11-04T09:03:47.565Z"},{"op":"R","uid":"201","un":"nonkosim","dt":"2022-02-02T07:55:36.257Z"},{"op":"R","uid":"201","un":"nonkosim","dt":"2022-03-03T06:54:15.339Z"}] | 1 | 96 | 11 | 5/16/2023 9:31:34 AM | 8 | 8 | ||||||||||||||||||||||
| 3205 | 4/12/2021 9:44:48 AM | 2/19/2023 8:01:01 AM | Leak letter | Affidavit submitted by consumer and filed.<div>QRC RESPONSE : 6 MONTHS POLICY DONE FOR 20191220</div><br/><b>Journal Number</b>: [755909] | 24 | 3 | 2761 | 17 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"173","un":"olgad","dt":"2021-04-12T09:40:48.523Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-02T08:51:26.795Z"}] | 1 | 96 | 14 | 6 | ||||||||||||||||||||||||
| 3204 | 4/12/2021 9:40:43 AM | 10/16/2022 10:45:14 AM | water query | water query<div>need 3 more months to monitor consumption </div><br><b>Monitoring Reason</b>: [need 3 months to monitor consumption]<div><b>Response from QRC</b> :Plumber's Letter received.</div><div>Journal Done</div><br><b>Does not qualify for a leak rebate </b> | 27 | 3 | 2760 | 17 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-04-12T09:36:46.944Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-08-14T10:08:19.719Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-10-31T11:14:36.103Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-10-31T11:27:24.307Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-02T08:43:48.832Z"},{"op":"R","uid":"23","un":"bevins","dt":"2021-12-18T13:11:09.804Z"}] | 1 | 96 | 230 | 10/16/2022 10:45:13 AM | 137659 | 17 | 17 | |||||||||||||||||||||
| 3203 | 4/12/2021 9:38:37 AM | 11/10/2021 10:55:19 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 | 2759 | 75 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"173","un":"olgad","dt":"2021-04-12T09:34:37.679Z"},{"op":"R","uid":"172","un":"sesonad","dt":"2021-05-13T10:25:24.524Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-02T08:28:53.811Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-11-10T10:54:58.816Z"}] | 1 | 96 | 17 | 11/10/2021 10:55:19 AM | 173 | 17 | ||||||||||||||||||||||
| 3202 | 4/12/2021 9:35:27 AM | 9/7/2022 12:10:22 PM | water query | water query<div>SIX MONTHS POLICY ADJUSTMENT DONE</div><br/><b>Journal Number</b>: [113853]<br/><b>Journal Amount</b>: [-R12,210.61] | 27 | 3 | 2758 | 17 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-04-12T09:31:30.965Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-10-31T10:06:22.674Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-02T08:28:11.493Z"}] | 1 | 101 | 14 | 9/7/2022 12:10:18 PM | 3 | 3 | ||||||||||||||||||||||
| 3201 | 4/12/2021 9:34:30 AM | 8/11/2021 10:43:19 AM | Leak letter | Affidavit submitted by consumer and filed.<div>journal no. 514189 processed and authorized. Query resolved.</div> | 27 | 3 | 2757 | 75 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"173","un":"olgad","dt":"2021-04-12T09:30:29.757Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2021-08-11T10:42:41.455Z"}] | 1 | 96 | 8/11/2021 10:43:19 AM | 173 | 2 | |||||||||||||||||||||||
| 3200 | 4/12/2021 9:33:46 AM | 3/24/2022 8:41:09 AM | Leak credit | Kindly assess a leak for this account that was reported in 2018 | 27 | 3 | 2756 | 74 | 2 | 23 | 1 | 95 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-04-12T09:33:48.111Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-05-27T13:11:48.493Z"},{"op":"R","uid":"202","un":"buyiswam","dt":"2022-03-24T08:41:09.401Z"}] | 1 | 95 | 3/24/2022 8:41:09 AM | 172 | 202 | |||||||||||||||||||||||
| 3199 | 4/12/2021 9:31:34 AM | 7/26/2021 12:36:34 PM | Leak letter | Plumber's report submitted by consumer and filed.<br/><b>Journal Amount</b>: [114390.09] | 27 | 3 | 2755 | 75 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"173","un":"olgad","dt":"2021-04-12T09:27:34.342Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2021-07-26T12:36:10.892Z"}] | 1 | 96 | 7/26/2021 12:36:34 PM | 173 | 2 | |||||||||||||||||||||||
| 3197 | 4/12/2021 9:28:48 AM | 10/16/2022 8:12:07 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><br><b>Journal Number</b>: [674273] LEAK CR | 24 | 3 | 2754 | 75 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"173","un":"olgad","dt":"2021-04-12T09:24:47.726Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-10-31T07:24:12.042Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-10-31T07:24:41.765Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-10-31T07:25:06.096Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-02T08:27:29.445Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-11-10T10:42:54.219Z"}] | 1 | 96 | 17 | 4 | ||||||||||||||||||||||||
| 3198 | 4/12/2021 9:28:06 AM | 11/2/2021 8:26:59 AM | Leak Credit | Kindly assess a leak for this account <table border="0" cellpadding="0" cellspacing="0" width="864" style="border-collapse: collapse;width:648pt"><tbody><tr height="20" style="height:15.0pt"> <td height="20" class="xl65" width="864" style="height:15.0pt;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> | 4 | 3 | 74 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-04-12T09:28:08.758Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-02T08:25:51.558Z"}] | 9 | 123 | 14 | 11/2/2021 8:26:59 AM | 172 | 14 | |||||||||||||||||||||||
| 3194 | 4/12/2021 8:56:13 AM | 11/2/2021 8:24:41 AM | Leak letter | Affidavit submitted by consumer and filed.<div>duplicate query closed</div> | 27 | 3 | 2753 | 75 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"173","un":"olgad","dt":"2021-04-12T08:52:13.953Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-10-29T09:29:59.256Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-10-29T11:44:25.871Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-10-29T11:47:38.523Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-02T08:24:42.154Z"}] | 1 | 96 | 17 | 11/2/2021 8:24:41 AM | 173 | 17 | ||||||||||||||||||||||
| 3195 | 4/12/2021 8:52:23 AM | 3/28/2022 6:33:19 AM | 06 Month policy | Apply 06 month policy for the 2020/03 back charged period<br/><b>Journal Number</b>: [244253]<br/><b>Journal Amount</b>: [R2107.05] | 27 | 3 | 2752 | 3 | 4 | 23 | 1 | 95 | [{"op":"R","uid":"6","un":"lusandad","dt":"2021-04-12T08:52:24.610Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-04-19T06:31:49.252Z"}] | 1 | 95 | 3/28/2022 6:33:19 AM | 3 | 3 |