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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1244 | 2/4/2021 8:52:02 AM | 3/28/2022 7:10:22 AM | high consumption of water | <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 | 1258 | 11 | 2 | 23 | 1 | 67 | 348 | [{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-02-04T08:48:52.768Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-27T10:02:24.952Z"},{"op":"R","uid":"201","un":"nonkosim","dt":"2022-03-25T08:11:43.605Z"}] | 9 | 123 | 20 | 3/28/2022 7:10:22 AM | 11 | 20 | |||||||||||||||||||||
| 1242 | 2/4/2021 8:30:00 AM | 2/4/2021 8:30:03 AM | 2 | [{"op":"R","uid":"21","un":"heinrichs","dt":"2021-02-04T08:26:51.023Z"}] | 21 | ||||||||||||||||||||||||||||||||||||
| 1241 | 2/4/2021 8:24:23 AM | 6/16/2022 12:12:08 PM | 6 months policy processed for 20200424 | SIX MONTHS POLICY ADJUSTMENT DONE<div>JNL NO: 113500<br><div><br></div></div> | 24 | 3 | 1256 | 4 | 23 | 1 | 95 | [{"op":"R","uid":"6","un":"lusandad","dt":"2021-02-04T08:21:13.408Z"},{"op":"R","uid":"28","un":"samanthaj","dt":"2021-02-04T11:13:31.077Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-06-18T06:33:41.737Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-27T10:01:52.212Z"}] | 1 | 95 | 15 | ||||||||||||||||||||||||||
| 1240 | 2/4/2021 8:17:35 AM | 4/12/2022 9:43:30 AM | water query - interims billed on the account | six months policy applied <br/><b>Journal Number</b>: [566601] | 24 | 3 | 1255 | 2 | 23 | 80 | 47 | [{"op":"R","uid":"28","un":"samanthaj","dt":"2021-02-04T08:14:24.880Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-10-24T08:42:14.122Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-27T09:59:57.843Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-11-08T11:32:50.357Z"}] | 1 | 101 | 12 | 12 | |||||||||||||||||||||||||
| 1238 | 2/4/2021 7:43:45 AM | 2/24/2022 10:34:50 AM | Water | The is high water consumption | 27 | 3 | 1254 | 26 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"26","un":"nobulalim","dt":"2021-02-04T07:40:35.839Z"},{"op":"R","uid":"13","un":"unathig","dt":"2021-10-16T11:00:11.849Z"},{"op":"R","uid":"13","un":"unathig","dt":"2021-10-16T11:30:45.147Z"}] | 1 | 50 | 13 | 2/24/2022 10:34:50 AM | 26 | 13 | ||||||||||||||||||||||
| 1074 | 2/4/2021 7:32:55 AM | 2/4/2021 7:33:45 AM | 2 | 1156 | [{"op":"R","uid":"26","un":"nobulalim","dt":"2021-02-04T07:29:44.997Z"},{"op":"R","uid":"26","un":"nobulalim","dt":"2021-02-04T07:30:30.054Z"}] | 26 | |||||||||||||||||||||||||||||||||||
| 1229 | 2/3/2021 12:41:31 PM | 2/24/2022 10:44:24 AM | water query | consumer is querying the huge outstanding water bill.<div>duplicate query</div> | 27 | 3 | 1253 | 28 | 2 | 23 | 78 | 67 | [{"op":"R","uid":"28","un":"samanthaj","dt":"2021-02-03T12:38:22.013Z"},{"op":"R","uid":"28","un":"samanthaj","dt":"2021-02-03T12:44:56.503Z"},{"op":"R","uid":"28","un":"samanthaj","dt":"2021-02-03T12:45:03.152Z"},{"op":"R","uid":"28","un":"samanthaj","dt":"2021-02-03T12:46:14.521Z"},{"op":"R","uid":"28","un":"samanthaj","dt":"2021-02-03T12:51:41.553Z"},{"op":"R","uid":"28","un":"samanthaj","dt":"2021-02-04T06:45:30.082Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-06-11T10:24:50.309Z"}] | 78 | 67 | 2/24/2022 10:44:24 AM | 28 | 3 | |||||||||||||||||||||||
| 1230 | 2/3/2021 12:37:52 PM | 2/24/2022 11:08:12 AM | water query 6 month policy | water query | 27 | 3 | 1252 | 22 | 3 | 23 | 77 | 67 | [{"op":"R","uid":"22","un":"asandam","dt":"2021-02-03T12:38:25.973Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-08-30T10:16:45.431Z"}] | 77 | 67 | 2/24/2022 11:08:12 AM | 22 | 6 | |||||||||||||||||||||||
| 1228 | 2/3/2021 12:28:16 PM | 4/12/2022 9:39:10 AM | duplicate fire levy | duplicate fire levy<br/><b>Journal Number</b>: [141762]<br/><b>Journal Amount</b>: [-R3528.84] | 27 | 3 | 1251 | 4 | 2 | 23 | 3 | 105 | [{"op":"R","uid":"22","un":"asandam","dt":"2021-02-03T12:28:49.859Z"},{"op":"R","uid":"172","un":"sesonad","dt":"2021-05-25T06:51:00.186Z"},{"op":"R","uid":"172","un":"sesonad","dt":"2021-05-28T08:41:54.339Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-05-31T08:08:05.969Z"}] | 3 | 105 | 4/12/2022 9:39:10 AM | 4 | 3 | |||||||||||||||||||||||
| 1225 | 2/3/2021 11:58:35 AM | 2/24/2022 10:44:24 AM | water query - high consumption | property was vandalised and as a result the tap outside was stolen thus leaving the water running for two days<div>2021/01/10</div> | 27 | 3 | 1250 | 28 | 2 | 23 | 80 | 67 | [{"op":"R","uid":"28","un":"samanthaj","dt":"2021-02-03T11:55:26.341Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-10-13T09:50:41.313Z"}] | 1 | 101 | 17 | 2/24/2022 10:44:24 AM | 28 | 17 | ||||||||||||||||||||||
| 1224 | 2/3/2021 11:50:18 AM | 5/27/2021 4:24:21 AM | 6 moths policy journal processed 20201023 | 6 moths policy journal processed 20201023<br/><b>Journal Number</b>: [202475]<br/><b>Journal Amount</b>: [5204.27] | 27 | 3 | 1249 | 12 | 4 | 23 | 1 | 95 | [{"op":"R","uid":"6","un":"lusandad","dt":"2021-02-03T11:47:09.049Z"},{"op":"R","uid":"28","un":"samanthaj","dt":"2021-02-04T09:51:21.460Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-05-21T13:51:00.476Z"}] | 1 | 95 | 5/27/2021 4:24:21 AM | 12 | 12 | |||||||||||||||||||||||
| 1221 | 2/3/2021 11:33:13 AM | 2/24/2022 11:08:12 AM | water query | high water consumption | 4 | 3 | 1248 | 22 | 3 | 23 | 77 | 67 | [{"op":"R","uid":"22","un":"asandam","dt":"2021-02-03T11:33:15.243Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-27T09:08:19.519Z"}] | 9 | 123 | 20 | 2/24/2022 11:08:12 AM | 22 | 20 | ||||||||||||||||||||||
| 1220 | 2/3/2021 11:02:28 AM | 3/28/2022 6:35:04 AM | request for reversal of dog tax | consumer requested reversal of dog tax that was billed on the account.<br/><b>Journal Number</b>: [256681]<br/><b>Journal Amount</b>: [-R131.00] | 27 | 3 | 1247 | 5 | 2 | 23 | 109 | 75 | [{"op":"R","uid":"28","un":"samanthaj","dt":"2021-02-03T10:59:18.910Z"},{"op":"R","uid":"5","un":"ivanh","dt":"2021-04-21T13:41:16.183Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-05-31T08:38:31.484Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-05-31T08:38:41.862Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-05-31T08:40:22.158Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-05-31T08:40:32.726Z"},{"op":"R","uid":"5","un":"ivanh","dt":"2021-06-04T11:59:49.011Z"}] | 109 | 75 | 3/28/2022 6:35:04 AM | 5 | 5 | |||||||||||||||||||||||
| 1218 | 2/3/2021 10:44:08 AM | 2/24/2022 10:44:24 AM | dog tax cancellation | consumer has submitted documents for cancellation of dog tax for dogs she no longer has. | 27 | 3 | 1246 | 28 | 2 | 23 | 80 | 75 | [{"op":"R","uid":"28","un":"samanthaj","dt":"2021-02-03T10:40:58.804Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2021-08-02T08:55:41.077Z"},{"op":"R","uid":"8","un":"mariaanaw","dt":"2021-08-06T08:53:05.067Z"}] | 80 | 75 | 2/24/2022 10:44:24 AM | 28 | 8 | |||||||||||||||||||||||
| 1217 | 2/3/2021 10:37:38 AM | 2/24/2022 11:08:12 AM | water query | high water consumption | 4 | 3 | 1245 | 22 | 3 | 23 | 77 | 67 | [{"op":"R","uid":"22","un":"asandam","dt":"2021-02-03T10:37:41.830Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-27T09:07:41.485Z"}] | 9 | 123 | 20 | 2/24/2022 11:08:12 AM | 22 | 20 | ||||||||||||||||||||||
| 1216 | 2/3/2021 8:39:32 AM | 8/6/2021 9:01:19 AM | 2 | 1244 | [{"op":"R","uid":"28","un":"samanthaj","dt":"2021-02-03T08:36:22.247Z"},{"op":"R","uid":"8","un":"mariaanaw","dt":"2021-08-06T08:59:33.571Z"}] | 8 | |||||||||||||||||||||||||||||||||||
| 1216 | 2/3/2021 8:33:35 AM | 3/28/2022 6:35:04 AM | dog tax | consumer is wrongfully being billed for dog tax.<div><br></div><div>2021-07-13 -- Sent to Shanaaz for site investigation<br></div><div><br></div><div>2021-08-24 - Followed up on investigation<br></div><div>dog tax removed</div><br/><b>Journal Number</b>: [476 276]<br/><b>Journal Amount</b>: [-R262.00] | 27 | 3 | 1244 | 5 | 2 | 23 | 77 | 75 | [{"op":"R","uid":"28","un":"samanthaj","dt":"2021-02-03T08:30:26.295Z"},{"op":"R","uid":"5","un":"ivanh","dt":"2021-07-13T06:59:07.911Z"},{"op":"R","uid":"5","un":"ivanh","dt":"2021-07-13T07:58:44.604Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2021-08-02T07:36:16.903Z"},{"op":"R","uid":"8","un":"mariaanaw","dt":"2021-08-06T08:59:18.901Z"},{"op":"R","uid":"8","un":"mariaanaw","dt":"2021-08-06T08:59:57.833Z"},{"op":"R","uid":"5","un":"ivanh","dt":"2021-08-27T07:49:53.409Z"},{"op":"R","uid":"5","un":"ivanh","dt":"2021-09-29T09:53:08.641Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-27T09:03:08.405Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-11-13T07:06:54.022Z"},{"op":"R","uid":"5","un":"ivanh","dt":"2022-01-14T09:50:51.941Z"},{"op":"R","uid":"5","un":"ivanh","dt":"2022-01-14T13:05:40.142Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2022-01-26T08:23:20.268Z"}] | 9 | 123 | 3 | 3/28/2022 6:35:04 AM | 5 | 3 | ||||||||||||||||||||||
| 1214 | 2/3/2021 8:22:31 AM | 8/20/2022 11:57:06 AM | 6 months policy journal processed. | 6 months policy journal processed.<br><b>Journal Number113501</b><br/><b>Journal Number</b>: [BJ71113501 ]<br/><b>Journal Amount</b>: [-R30,653.00] | 27 | 3 | 1243 | 13 | 2 | 23 | 1 | 95 | [{"op":"R","uid":"6","un":"lusandad","dt":"2021-02-03T08:19:21.972Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-27T09:02:34.888Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-11-13T07:08:10.130Z"},{"op":"R","uid":"13","un":"unathig","dt":"2022-02-19T08:03:37.730Z"}] | 1 | 101 | 20 | 8/20/2022 11:57:02 AM | 3 | 3 | ||||||||||||||||||||||
| 1213 | 2/3/2021 7:49:45 AM | 2/24/2022 10:44:24 AM | dog tax billed for two dogs instead of one. | billed dog tax for two dogs instead of one on 26/12/2020.<div><br></div><div>2021-07-13 -- Sent to Shanaaz for site investigation<br></div><div><br></div><div>2021-08-24 - Followed up on investigation<br></div> | 27 | 3 | 1242 | 28 | 2 | 23 | 77 | 75 | [{"op":"R","uid":"28","un":"samanthaj","dt":"2021-02-03T07:46:35.231Z"},{"op":"R","uid":"28","un":"samanthaj","dt":"2021-02-03T07:47:25.633Z"},{"op":"R","uid":"28","un":"samanthaj","dt":"2021-02-03T07:47:41.520Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2021-07-05T19:07:54.784Z"},{"op":"R","uid":"5","un":"ivanh","dt":"2021-07-13T06:53:41.012Z"},{"op":"R","uid":"5","un":"ivanh","dt":"2021-07-13T07:59:06.829Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2021-08-02T07:35:48.227Z"},{"op":"R","uid":"8","un":"mariaanaw","dt":"2021-08-06T08:54:35.264Z"},{"op":"R","uid":"5","un":"ivanh","dt":"2021-08-24T09:10:42.030Z"},{"op":"R","uid":"5","un":"ivanh","dt":"2021-08-27T07:47:59.622Z"},{"op":"R","uid":"5","un":"ivanh","dt":"2021-08-27T07:53:34.905Z"},{"op":"R","uid":"5","un":"ivanh","dt":"2021-09-09T10:58:15.330Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-27T08:55:15.033Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-11-13T07:04:14.184Z"}] | 9 | 123 | 17 | 2/24/2022 10:44:24 AM | 28 | 17 | ||||||||||||||||||||||
| 1202 | 2/3/2021 7:25:56 AM | 2/24/2022 10:44:24 AM | water query | consumption normal | 27 | 3 | 1235 | 28 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"28","un":"samanthaj","dt":"2021-02-03T07:22:54.037Z"},{"op":"R","uid":"28","un":"samanthaj","dt":"2021-02-03T07:23:15.155Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-29T10:09:53.294Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-29T10:10:23.974Z"}] | 77 | 67 | 2/24/2022 10:44:24 AM | 28 | 12 |