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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 412585 | 5516 | 6/7/2021 9:36:52 AM | 6/7/2021 9:36:53 AM | IVR call: balance | Received call for balance for account 10418187 undefined | 7 | 2 | 4682 | 78 | 78 | 6/7/2021 9:36:53 AM | ||||||||||||||||||||||||||||||
| 5515 | 6/7/2021 9:33:39 AM | 4/12/2022 9:39:10 AM | WATER QUERY | WATER QUERY | 3 | 4681 | 2 | 23 | 1 | 67 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-06-07T09:33:41.586Z"}] | 1 | 67 | 14 | |||||||||||||||||||||||||||
| 5514 | 6/7/2021 9:27:16 AM | 6/7/2021 9:27:18 AM | 1 | [{"op":"R","uid":"21","un":"heinrichs","dt":"2021-06-07T09:29:22.836Z"}] | 21 | ||||||||||||||||||||||||||||||||||||
| 5513 | 6/7/2021 9:22:38 AM | 10/30/2022 10:05:59 AM | Leak credit | Kindly assess leak that was reported on 06/04/2021<div><b><u><br></u></b></div><div><b><u>QRC RESPONSE:</u></b> There are no reports on front desk of water leaks attended to, customer needs to log a new query by attaching a plumbers letter if any internal leaks have been repaired to assess for leak credit.</div> | 27 | 3 | 4678 | 17 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-06-07T09:21:58.835Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2022-02-12T06:37:37.095Z"},{"op":"R","uid":"18","un":"lindan","dt":"2022-02-12T07:01:14.994Z"}] | 1 | 96 | 10/30/2022 10:05:59 AM | 138632 | 8 | 8 | ||||||||||||||||||||||
| 5512 | 6/7/2021 9:21:23 AM | 11/13/2022 11:51:03 AM | WATER QUERY | WATER QUERY<div><br></div><div>reading were changed in 2020.03 from 218 to 122 before the smart meter installed in 2020.08</div><div><br></div><div><b><u>QRC RESPONSE:</u></b> High Consumption Reported and report back from water works found internal leak. Customer needs to provide the department with plumbing invoice/affidavit if the internal leaks has been repaired to assess the account for a leak credit rebate. Query close and customer needs to log a new query and attach supporting plumbing documents.</div> | 27 | 3 | 4677 | 5 | 2 | 23 | 1 | 67 | [{"op":"R","uid":"18","un":"lindan","dt":"2021-06-07T09:20:43.176Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-06-07T09:30:43.502Z"}] | 1 | 67 | 11/13/2022 11:51:03 AM | 134270 | 8 | 8 | ||||||||||||||||||||||
| 5511 | 6/7/2021 9:15:17 AM | 3/28/2022 7:07:05 AM | Water query | Water query - high consumption | 3 | 4675 | 2 | 23 | 1 | 67 | [{"op":"R","uid":"20","un":"nzwanam","dt":"2021-06-07T09:15:19.201Z"},{"op":"R","uid":"173","un":"olgad","dt":"2021-06-11T06:40:01.414Z"}] | 1 | 67 | 173 | |||||||||||||||||||||||||||
| 5510 | 6/7/2021 9:15:15 AM | 6/7/2021 9:15:17 AM | 2 | [{"op":"R","uid":"26","un":"nobulalim","dt":"2021-06-07T09:14:35.739Z"}] | 26 | ||||||||||||||||||||||||||||||||||||
| 5509 | 6/7/2021 9:14:23 AM | 3/28/2022 7:23:36 AM | Water query | Water query - high consumption .<div><br></div><div>Journal processed and approved. Query resolved.</div> | 27 | 3 | 4674 | 13 | 2 | 23 | 1 | 67 | [{"op":"R","uid":"20","un":"nzwanam","dt":"2021-06-07T09:14:25.568Z"},{"op":"R","uid":"214","un":"nandipan","dt":"2022-02-13T11:14:22.794Z"}] | 1 | 111 | 214 | 3/28/2022 7:23:36 AM | 13 | 214 | ||||||||||||||||||||||
| 5506 | 6/7/2021 9:13:48 AM | 3/8/2023 1:07:14 PM | Leak credit | Kindly assess a leak where a pipe had burst and was replaced on 05 January 2021<br><b>Journal Number</b>: [923673] Consumer will submitt a plumbers letter | 30 | 3 | 4673 | 17 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-06-07T09:13:08.346Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2022-02-20T06:10:13.866Z"}] | 1 | 96 | 4 | 124252 | 14 | |||||||||||||||||||||||
| 5508 | 6/7/2021 9:13:11 AM | 8/24/2021 12:00:21 PM | Reversal on interest | Interest reversal on late term journal corrections<br/><b>Journal Number</b>: [bj71337716] | 27 | 3 | 4672 | 12 | 2 | 23 | 6 | 107 | [{"op":"R","uid":"173","un":"olgad","dt":"2021-06-07T09:12:31.359Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-24T11:58:21.194Z"}] | 6 | 107 | 8/24/2021 12:00:21 PM | 12 | 12 | |||||||||||||||||||||||
| 5507 | 6/7/2021 9:13:05 AM | 3/28/2022 7:10:22 AM | Water query | Water query - high consumption | 10 | 2 | 4671 | 23 | 77 | [{"op":"R","uid":"20","un":"nzwanam","dt":"2021-06-07T09:13:06.924Z"}] | 77 | 20 | |||||||||||||||||||||||||||||
| 5505 | 6/7/2021 9:12:36 AM | 6/7/2021 9:12:38 AM | 2 | [{"op":"R","uid":"20","un":"nzwanam","dt":"2021-06-07T09:12:38.880Z"}] | 20 | ||||||||||||||||||||||||||||||||||||
| 5504 | 6/7/2021 9:11:57 AM | 2/27/2023 7:18:39 AM | WATER QUERY | WATER QUERY/LEAK<div><b><u><br></u></b></div><div><b><u>QRC RESPONSE:</u></b> Customer needs to log a new query and advise if they had any internal leaks and the period queried. Query closed and sent for a six months policy assessment for 202203 billing.</div><div><br></div><div>6 month policy processed 202101/202202</div><div><br></div><div>QRC RESPONSE: 6 MONTH POLICY - 202101/202202</div><div>Credit due of R 55316.41, Including vat @ 15%</div><div>Journal processed pending authorization done - 25.10.22</div><br><b>Journal Number</b>: [888826]<div><br></div><div>QRC RESPONSE: Email sent to W/W to report high consumption.</div><div>Waiting for response back.</div><br/><b>Journal Amount</b>: [-R35,558.72] | 27 | 3 | 4669 | 12 | 2 | 23 | 1 | 67 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-06-07T09:11:59.520Z"}] | 1 | 67 | 2/27/2023 7:18:34 AM | 139999 | 3 | 3 | ||||||||||||||||||||||
| 412538 | 5503 | 6/7/2021 9:09:18 AM | 6/7/2021 9:09:20 AM | IVR call: balance | Received call for balance for account 10007628 undefined | 7 | 2 | 4668 | 78 | 78 | 6/7/2021 9:09:20 AM | ||||||||||||||||||||||||||||||
| 5501 | 6/7/2021 9:05:50 AM | 4/12/2022 9:47:18 AM | Water query | Water query - high consumption<div><br></div><div>Journal processed and approved. Query resolved.</div> | 27 | 3 | 4666 | 10 | 3 | 23 | 1 | 67 | [{"op":"R","uid":"20","un":"nzwanam","dt":"2021-06-07T09:05:51.996Z"},{"op":"R","uid":"214","un":"nandipan","dt":"2022-02-14T12:59:32.053Z"}] | 1 | 111 | 214 | 4/12/2022 9:47:18 AM | 10 | 214 | ||||||||||||||||||||||
| 412532 | 5502 | 6/7/2021 9:05:42 AM | 6/7/2021 9:05:43 AM | IVR call: balance | Received call for balance for account 10178642 undefined | 7 | 2 | 4665 | 78 | 78 | 6/7/2021 9:05:43 AM | ||||||||||||||||||||||||||||||
| 5500 | 6/7/2021 9:04:48 AM | 8/8/2021 6:01:37 AM | Water query | Water query - High consumption | 3 | 4664 | 2 | 23 | 1 | 67 | [{"op":"R","uid":"20","un":"nzwanam","dt":"2021-06-07T09:04:50.438Z"}] | 1 | 67 | 20 | |||||||||||||||||||||||||||
| 5499 | 6/7/2021 9:03:48 AM | 3/28/2022 7:08:29 AM | Late termination | Late termination | 3 | 4663 | 2 | 23 | 6 | 107 | [{"op":"R","uid":"20","un":"nzwanam","dt":"2021-06-07T09:03:50.141Z"},{"op":"R","uid":"172","un":"sesonad","dt":"2021-09-14T13:03:04.238Z"},{"op":"R","uid":"172","un":"sesonad","dt":"2021-09-14T13:04:15.819Z"}] | 6 | 107 | 172 | |||||||||||||||||||||||||||
| 5496 | 6/7/2021 9:02:54 AM | 4/12/2022 9:43:30 AM | WATER QUERY | WATER QUERY /LEAK | 3 | 4661 | 2 | 23 | 1 | 67 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-06-07T09:02:56.137Z"}] | 1 | 67 | 14 | |||||||||||||||||||||||||||
| 5498 | 6/7/2021 9:02:46 AM | 3/28/2022 6:35:04 AM | Water query | Water query - high consumption<div>consumption normal but there was no readings for five months .</div> | 27 | 3 | 4662 | 5 | 2 | 23 | 1 | 67 | [{"op":"R","uid":"20","un":"nzwanam","dt":"2021-06-07T09:02:48.563Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-10-16T11:43:58.842Z"}] | 1 | 101 | 12 | 3/28/2022 6:35:04 AM | 5 | 12 |