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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4105 | 5/12/2021 1:19:36 PM | 2/12/2022 10:40:49 AM | 6 Months Policy | Kindly assess a Six Months Policy for the period 201904-202004<div>W/Offs Indigent</div> | 27 | 3 | 3484 | 74 | 4 | 23 | 1 | 95 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-05-12T13:19:16.228Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-23T08:43:35.993Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2022-02-12T10:40:26.652Z"}] | 1 | 101 | 17 | 2/12/2022 10:40:49 AM | 172 | 17 | ||||||||||||||||||||||
| 4104 | 5/12/2021 1:17:43 PM | 10/22/2022 10:10:54 AM | High water consumption | Kindly investigate high water charges raised on this account.<div><br></div><div><b><u>QRC RESPONSE: QUERY CLOSED</u></b></div><div>There is no unread period that exceeds 06 months.</div><div>Waterworks reported an internal leak in Nov 2021.</div><div><b>Consumer to log a new query by uploading a signed copy of the plumbers letter if repairs were done</b></div><div><br></div> | 27 | 3 | 3483 | 15 | 2 | 23 | 1 | 67 | 2036 | [{"op":"R","uid":"73","un":"nombongof","dt":"2021-05-12T13:18:11.555Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-23T08:43:00.519Z"},{"op":"R","uid":"13","un":"unathig","dt":"2022-02-19T08:04:08.831Z"}] | 1 | 101 | 14 | 10/22/2022 10:10:54 AM | 134496 | 3 | 3 | ||||||||||||||||||||
| 4102 | 5/12/2021 1:08:27 PM | 2/25/2023 8:28:17 AM | Six Months Policy | Kindly assess a six Months Policy for the period 201805-202010<div><br></div><div>SIX MONTHS POLICY ADJUSTMENT DONE</div><br><b>Journal Number</b>: [848933]<div><br></div><div>QRC RESPONSE: ADJUSTMENT AUTHORIZED 202203 - QUERY RESOLVED </div> | 27 | 3 | 3482 | 15 | 4 | 23 | 1 | 95 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-05-12T13:08:06.687Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-23T08:42:27.027Z"},{"op":"R","uid":"15","un":"chumab","dt":"2022-02-18T07:52:07.658Z"}] | 1 | 101 | 15 | 2/25/2023 8:28:16 AM | 124158 | 10 | 10 | |||||||||||||||||||||
| 4101 | 5/12/2021 12:59:18 PM | 8/2/2021 8:43:57 AM | Interest reversal | Interest reversal for period 2020/01-2021/04<br><b>Journal Number</b>: [BJ71549100]<div>journal approved may 2021</div> | 27 | 3 | 3481 | 75 | 2 | 23 | 12 | 108 | [{"op":"R","uid":"173","un":"olgad","dt":"2021-05-12T12:59:21.511Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2021-08-02T08:40:46.058Z"}] | 12 | 108 | 8/2/2021 8:43:57 AM | 173 | 2 | |||||||||||||||||||||||
| 4100 | 5/12/2021 12:52:16 PM | 3/22/2022 7:09:10 AM | Late termination | Late termination from 2010/02-2021/04 for services. The property is being sold and consumer requires clearance. The reversal for handed over account was also done from 2018/08/2021/04<br/><b>Journal Number</b>: [BJ71547658]<br/><b>Journal Amount</b>: [100866.15] | 27 | 3 | 3480 | 2 | 2 | 23 | 6 | 107 | [{"op":"R","uid":"173","un":"olgad","dt":"2021-05-12T12:52:18.802Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2021-05-19T14:28:10.262Z"}] | 6 | 107 | 3/22/2022 7:09:10 AM | 2 | 2 | |||||||||||||||||||||||
| 4099 | 5/12/2021 12:51:09 PM | 2/25/2023 9:06:02 AM | Late Termination | Late termination <br>QRC Response :DATE 25/02/2023<div>Account terminated ,Debt written off 01/2023</div> | 27 | 3 | 3479 | 5 | 2 | 23 | 6 | 59 | 2033 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-05-12T12:50:49.100Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2021-11-09T14:00:01.611Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-23T08:41:06.131Z"}] | 6 | 60 | 14 | 2/25/2023 9:06:01 AM | 12 | 12 | |||||||||||||||||||||
| 4096 | 5/12/2021 12:39:29 PM | 5/27/2021 4:26:29 AM | Late termination | The property has been sold and consumer wants clearance. Reversal of services was done from 2010/02-2021/04. Handover interest reversal was also done.<br><b>Journal Number</b>: [BJ71548756]<br/><b>Journal Amount</b>: [49599] | 27 | 3 | 3478 | 75 | 2 | 23 | 6 | 107 | [{"op":"R","uid":"173","un":"olgad","dt":"2021-05-12T12:39:36.919Z"},{"op":"R","uid":"173","un":"olgad","dt":"2021-05-12T12:49:28.139Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-05-25T08:02:18.483Z"}] | 6 | 107 | 5/27/2021 4:26:29 AM | 173 | 12 | |||||||||||||||||||||||
| 4098 | 5/12/2021 12:34:33 PM | 3/28/2022 7:08:29 AM | 2 6 months policy journals done 201809& 202012 | 2 6 months policy journals done 201809& 202012<br/><b>Journal Number</b>: [548829] | 27 | 3 | 3477 | 6 | 2 | 23 | 2 | 101 | [{"op":"R","uid":"6","un":"lusandad","dt":"2021-05-12T12:38:26.635Z"},{"op":"R","uid":"214","un":"nandiphan","dt":"2021-08-14T08:05:15.416Z"},{"op":"R","uid":"13","un":"unathig","dt":"2021-10-28T13:10:46.087Z"}] | 2 | 101 | 3/28/2022 7:08:29 AM | 6 | 13 | |||||||||||||||||||||||
| 4094 | 5/12/2021 12:10:42 PM | 11/23/2021 8:40:39 AM | FIRE LEVY NOT BILLED | CONSUMER NOT BILLED FOR FIRE LEVY ON ACCOUNT. KINDLY INVESTIGATE AND RESOLVE. | 30 | 3 | 3476 | 2 | 23 | 3 | 58 | 2026 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-05-12T12:14:33.480Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-23T08:40:05.801Z"}] | 3 | 115 | 14 | 14 | ||||||||||||||||||||||||
| 4094 | 5/12/2021 12:08:48 PM | 11/23/2021 8:39:08 AM | REFUSE NOT BILLED | CONSUMER NOT BILLED FOR REFUSE. KINDLY INVESTIGATE AND RESOLVE. | 30 | 3 | 3476 | 2 | 23 | 4 | 58 | 2025 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-05-12T12:12:39.196Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-23T08:38:55.767Z"}] | 4 | 116 | 14 | 14 | ||||||||||||||||||||||||
| 4094 | 5/12/2021 12:06:57 PM | 11/23/2021 8:38:16 AM | WATER NOT BILLED | CONSUMER NOT BILLED FOR WATER. KINDLY INVESTIGATE AND RESOLVE. | 30 | 3 | 3476 | 2 | 23 | 1 | 58 | 2024 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-05-12T12:10:48.416Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-23T08:38:02.583Z"}] | 1 | 113 | 14 | 14 | ||||||||||||||||||||||||
| 4094 | 5/12/2021 12:05:03 PM | 2/26/2023 6:39:08 AM | SEWERAGE NOT BILLED | CONSUMER NOT BILLED FOR SEWERAGE. KINDLY INVESTIGATE AND RESOLVE.<div>QRC Response :DATE 26/02/2023</div><div>Email sent to Billing department to investigate and add the charge .</div> | 28 | 3 | 3476 | 5 | 2 | 23 | 93 | 58 | 2023 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-05-12T12:08:54.630Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-23T08:37:17.490Z"}] | 93 | 117 | 14 | 12 | |||||||||||||||||||||||
| 4093 | 5/12/2021 12:00:26 PM | 11/23/2021 8:35:51 AM | FIRE LEVY NOT BILLED | CONSUMER NOT BILLED FOR FIRE LEVY. KINDLY INVESTIGATE AND RESOLVE. | 30 | 3 | 3475 | 2 | 23 | 3 | 58 | 2022 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-05-12T12:04:17.019Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-23T08:35:39.954Z"}] | 3 | 115 | 14 | 14 | ||||||||||||||||||||||||
| 4093 | 5/12/2021 11:57:31 AM | 11/23/2021 8:35:05 AM | REFUSE NOT BILLED | CONSUMER NOT BILLED FOR REFUSE ON ACCOUNT. KINDLY INVESTIGATE AND RESOLVE. | 30 | 3 | 3475 | 2 | 23 | 4 | 58 | 2020 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-05-12T12:01:22.969Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-23T08:34:47.161Z"}] | 4 | 116 | 14 | 14 | ||||||||||||||||||||||||
| 4093 | 5/12/2021 11:55:32 AM | 11/23/2021 8:34:10 AM | WATER NOT BILLED | CONSUMER NOT BILLED FOR WATER ON ACCOUNT. KINDLY INVESTIGATE AND RESOLVE. | 30 | 3 | 3475 | 2 | 23 | 1 | 58 | 2019 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-05-12T11:59:23.589Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-23T08:33:59.670Z"}] | 1 | 113 | 14 | 14 | ||||||||||||||||||||||||
| 4093 | 5/12/2021 11:52:42 AM | 2/26/2023 6:33:58 AM | SEWERAGE NOT BILLED | SEWERAGE NOT BILLED ON ACCOUNT. KINDLY INVESTIGATE AND RESOLVE.<div>QRC Response :DATE 26/02/2023</div><div>Email sent to Billing department to investigate and add the charge .</div> | 30 | 3 | 3475 | 5 | 2 | 23 | 93 | 58 | 2018 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-05-12T11:56:33.028Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-23T08:33:10.226Z"}] | 93 | 117 | 14 | 12 | |||||||||||||||||||||||
| 4092 | 5/12/2021 11:46:58 AM | 11/23/2021 8:32:22 AM | REFUSE NOT BILLED ON ACCOUNT | CONSUMER NOT BILLED FOR REFUSE. KINDLY INVESTIGATE AND RESOLVE. | 30 | 3 | 3474 | 2 | 23 | 4 | 58 | 2017 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-05-12T11:50:48.815Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-23T08:32:09.824Z"}] | 4 | 116 | 14 | 14 | ||||||||||||||||||||||||
| 4092 | 5/12/2021 11:44:56 AM | 11/23/2021 8:31:49 AM | WATER NOT BILLED ON ACCOUNT | CONSUMER NOT BILLED FOR WATER CONSUMPTION. KINDLY INVESTIGATE AND RESOLVE. | 30 | 3 | 3474 | 2 | 23 | 1 | 58 | 2016 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-05-12T11:48:46.769Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-23T08:30:02.133Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-23T08:31:49.742Z"}] | 1 | 113 | 14 | 14 | ||||||||||||||||||||||||
| 4092 | 5/12/2021 11:41:31 AM | 2/25/2023 10:44:51 AM | SEWERAGE NOT BILLED | CONSUMER NOT BILLED FOR SEWERAGE ON ACCOUNT. KINDLY INVESTIGATE AND RESOLVE.<div>QRC Response :DATE 25/02/2023</div><div>Email sent to Billing department to investigate and add the charge .</div> | 30 | 3 | 3474 | 5 | 2 | 23 | 93 | 58 | 2015 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-05-12T11:45:22.646Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-23T08:28:49.506Z"}] | 93 | 117 | 14 | 12 | |||||||||||||||||||||||
| 4091 | 5/12/2021 10:50:42 AM | 11/27/2021 8:46:28 AM | transfer of meter to new owner account | consumer request for meter to be transferred from account 10064918 to account 10423540. | 27 | 3 | 3473 | 14 | 2 | 23 | 1 | 99 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-05-12T10:54:33.248Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-23T08:28:16.818Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-11-27T08:42:47.154Z"}] | 1 | 112 | 12 | 11/27/2021 8:46:28 AM | 14 | 12 |