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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 248 | 7/19/2020 10:49:24 AM | 2/26/2022 7:33:50 AM | 6 months policy processed for period, 201603. Journal awaiting authorization.<br/><b>Journal Number</b>: [908344] | 24 | 3 | 366 | 8 | 2 | 23 | 1 | 95 | [{"op":"R","uid":"2","un":"debbiecr","dt":"2021-06-07T09:08:59.884Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2021-06-07T09:09:37.081Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-24T10:28:22.573Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-24T10:29:50.406Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-24T10:38:27.565Z"},{"op":"R","uid":"16","un":"cumilem","dt":"2021-10-29T10:05:33.499Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-11-13T07:34:40.776Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-11-13T08:41:35.405Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-11-13T09:18:57.773Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-11-13T09:22:18.257Z"},{"op":"R","uid":"214","un":"nandipan","dt":"2022-02-26T07:33:50.629Z"}] | 1 | 95 | 8 | 214 | ||||||||||||||||||||||||
| 0 | 247 | 7/19/2020 10:47:08 AM | 11/13/2021 7:45:14 AM | SIX MONTHS POLICY | All un read period were less than six months. | 27 | 3 | 365 | 8 | 8 | 2 | 23 | 1 | 95 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-10-24T10:27:10.953Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-11-13T07:39:39.953Z"}] | 1 | 101 | 12 | 11/13/2021 7:45:14 AM | 8 | 8 | 12 | |||||||||||||||||||
| 0 | 246 | 7/19/2020 10:46:42 AM | 3/28/2022 7:10:22 AM | Leak Rebate | water leak <br/><b>Journal Number</b>: [908394] | 27 | 3 | 364 | 11 | 11 | 2 | 23 | 1 | [{"op":"R","uid":"17","un":"cwayitak","dt":"2021-10-14T08:55:15.176Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-10-14T08:55:32.518Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-11-13T07:36:58.767Z"}] | 1 | 96 | 17 | 3/28/2022 7:10:22 AM | 11 | 11 | 17 | ||||||||||||||||||||
| 0 | 245 | 7/19/2020 10:43:45 AM | 3/28/2022 7:10:22 AM | water | apply a six moths policy<br/><b>Journal Number</b>: [undefined] | 27 | 3 | 363 | 11 | 11 | 2 | 23 | 1 | 51 | [{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-29T10:13:14.687Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-29T10:13:58.723Z"}] | 1 | 51 | 3/28/2022 7:10:22 AM | 11 | 11 | 12 | ||||||||||||||||||||
| 0 | 244 | 7/19/2020 10:43:43 AM | 8/8/2021 6:01:37 AM | Duplicate water charges | Charge duplication for water adjusted: 201712-201805, journal awaiting authorization.<br><b>Journal Number</b>: [908409]<div>Recaptured with journal number: 838258</div><br/><b>Journal Amount</b>: [-R18,564.26] | 27 | 3 | 362 | 8 | 8 | 2 | 23 | 1 | 68 | [{"op":"R","uid":"3","un":"fareezar","dt":"2021-06-07T09:49:55.486Z"}] | 1 | 68 | 8/8/2021 6:01:37 AM | 8 | 8 | 3 | ||||||||||||||||||||
| 0 | 243 | 7/19/2020 10:39:50 AM | 2/22/2023 9:47:17 AM | SIX MONTHS POLICY | 6 Months Policy Journal Processed , Journal awaiting authorisation<br><b>Journal Number</b>: [BJ71826753]<div><br></div><div>QRC Responce: queried period benefited from indigent subsidy write offs</div><div>Query resolved</div> | 27 | 3 | 361 | 8 | 15 | 2 | 23 | 1 | 95 | [{"op":"R","uid":"15","un":"chumab","dt":"2021-08-10T10:03:30.740Z"},{"op":"R","uid":"15","un":"chumab","dt":"2021-08-10T10:04:46.806Z"},{"op":"R","uid":"15","un":"chumab","dt":"2021-08-10T10:04:53.869Z"},{"op":"R","uid":"15","un":"chumab","dt":"2021-08-10T10:20:14.260Z"},{"op":"R","uid":"15","un":"chumab","dt":"2021-08-10T10:20:41.356Z"},{"op":"R","uid":"15","un":"chumab","dt":"2021-08-10T10:20:44.366Z"},{"op":"R","uid":"15","un":"chumab","dt":"2021-08-10T10:23:55.749Z"},{"op":"R","uid":"15","un":"chumab","dt":"2021-08-10T10:23:59.319Z"},{"op":"R","uid":"15","un":"chumab","dt":"2021-08-10T11:52:09.651Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-23T09:53:54.262Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-23T09:54:53.998Z"}] | 1 | 101 | 14 | 2/22/2023 9:47:16 AM | 143035 | 13 | 8 | 13 | ||||||||||||||||||
| 0 | 242 | 7/19/2020 10:34:47 AM | 3/28/2022 7:08:29 AM | ADJUSTMENT DONE | <br><b>Journal Number</b>: [906631]<div><br></div><div>Resolved Sept 2020</div> | 27 | 3 | 360 | 6 | 6 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"3","un":"fareezar","dt":"2021-08-14T09:56:13.585Z"}] | 1 | 96 | 3/28/2022 7:08:29 AM | 6 | 6 | 3 | ||||||||||||||||||||
| 0 | 241 | 7/19/2020 10:32:04 AM | 3/28/2022 7:08:29 AM | ADJUSTMENT DONE | <br/><b>Journal Number</b>: [906629] | 24 | 3 | 359 | 6 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-10-23T09:50:25.283Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-23T10:01:01.395Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-23T10:10:02.702Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-24T10:25:17.248Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-24T10:26:08.817Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-25T09:16:55.139Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-25T09:17:57.142Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-29T07:21:52.657Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-29T07:23:31.810Z"},{"op":"R","uid":"16","un":"cumilem","dt":"2021-10-29T10:05:13.859Z"},{"op":"R","uid":"16","un":"cumilem","dt":"2021-10-29T10:17:31.575Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-30T11:13:22.693Z"},{"op":"R","uid":"214","un":"nandipan","dt":"2022-02-26T07:30:52.593Z"}] | 1 | 96 | 6 | 214 | |||||||||||||||||||||||
| 0 | 240 | 7/19/2020 10:29:03 AM | 3/28/2022 7:08:29 AM | ADJUSTMENT DONE | <br/><b>Journal Number</b>: [906628] | 27 | 3 | 358 | 6 | 6 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"12","un":"thembesas","dt":"2021-05-25T08:42:46.645Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-05-27T13:13:07.871Z"}] | 1 | 96 | 3/28/2022 7:08:29 AM | 6 | 6 | 12 | ||||||||||||||||||||
| 0 | 239 | 7/19/2020 10:25:39 AM | 3/28/2022 7:08:29 AM | ADJUSTMENT DONE | <br><b>Journal Number</b>: [906627]<div><br></div><div><b>RESPONSE QRC</b>: Leak Cr 201901-201909,Journal {906627}Authorized.</div> | 27 | 3 | 357 | 6 | 6 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-10-23T09:44:52.020Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-23T09:49:15.163Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-11-04T10:56:47.380Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-11-04T11:07:46.986Z"}] | 1 | 101 | 230 | 3/28/2022 7:08:29 AM | 6 | 6 | 230 | |||||||||||||||||||
| 0 | 238 | 7/19/2020 10:21:44 AM | 3/28/2022 7:08:29 AM | ADJUSMENT DONE | <br/><b>Journal Number</b>: [906626]<br/><b>Journal Amount</b>: [7314.69] | 27 | 3 | 356 | 6 | 12 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"12","un":"thembesas","dt":"2021-05-21T13:52:02.274Z"}] | 1 | 96 | 3/28/2022 7:08:29 AM | 12 | 6 | 12 | ||||||||||||||||||||
| 0 | 237 | 7/19/2020 10:18:26 AM | 3/28/2022 7:08:29 AM | ADJUSTMENT DONE | <br/><b>Journal Number</b>: [906609]<br/><b>Journal Amount</b>: [3435.44] | 27 | 3 | 355 | 6 | 12 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"12","un":"thembesas","dt":"2021-05-21T13:33:58.672Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-05-21T13:36:53.303Z"}] | 1 | 96 | 3/28/2022 7:08:29 AM | 12 | 6 | 12 | ||||||||||||||||||||
| 0 | 236 | 7/19/2020 10:15:35 AM | 3/28/2022 7:08:29 AM | ADJUSTMENT DONE | <br/><b>Journal Number</b>: [906606] | 27 | 3 | 354 | 6 | 6 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"12","un":"thembesas","dt":"2021-05-29T10:55:01.830Z"},{"op":"R","uid":"214","un":"nandiphan","dt":"2021-08-14T08:54:50.766Z"},{"op":"R","uid":"214","un":"nandiphan","dt":"2021-08-14T08:55:31.635Z"}] | 1 | 96 | 3/28/2022 7:08:29 AM | 6 | 6 | 214 | ||||||||||||||||||||
| 0 | 235 | 7/19/2020 10:00:33 AM | 3/28/2022 7:08:29 AM | late termination | <br><b>Journal Number</b>: [120407] | 24 | 3 | 346 | 6 | 2 | 23 | 6 | 107 | [{"op":"R","uid":"173","un":"olgad","dt":"2021-08-10T08:06:08.063Z"},{"op":"R","uid":"173","un":"olgad","dt":"2021-08-10T11:30:45.531Z"},{"op":"R","uid":"173","un":"olgad","dt":"2021-08-31T11:17:35.660Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-23T09:41:24.707Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-23T09:43:21.556Z"}] | 6 | 122 | 14 | 6 | 14 | ||||||||||||||||||||||
| 0 | 234 | 7/19/2020 9:53:36 AM | 3/28/2022 7:08:29 AM | Water Query | <br/><b>Journal Number</b>: [908293] | 24 | 3 | 345 | 6 | 2 | 23 | 1 | 95 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-10-23T09:22:51.927Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-23T09:36:21.425Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-25T09:16:21.226Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-26T08:22:18.826Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2021-10-26T08:26:05.480Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2021-10-26T08:30:00.294Z"},{"op":"R","uid":"13","un":"unathig","dt":"2021-10-28T13:13:26.617Z"},{"op":"R","uid":"13","un":"unathig","dt":"2021-10-28T13:17:12.517Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-29T07:16:09.517Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-29T07:18:44.947Z"},{"op":"R","uid":"16","un":"cumilem","dt":"2021-10-29T07:28:58.590Z"},{"op":"R","uid":"16","un":"cumilem","dt":"2021-10-29T08:33:21.526Z"},{"op":"R","uid":"16","un":"cumilem","dt":"2021-10-29T10:04:42.564Z"},{"op":"R","uid":"13","un":"unathig","dt":"2021-10-29T10:21:00.975Z"},{"op":"R","uid":"13","un":"unathig","dt":"2021-10-29T10:26:52.114Z"},{"op":"R","uid":"13","un":"unathig","dt":"2021-10-29T12:00:31.158Z"},{"op":"R","uid":"13","un":"unathig","dt":"2021-11-03T07:05:31.036Z"},{"op":"R","uid":"13","un":"unathig","dt":"2021-11-03T07:18:53.416Z"},{"op":"R","uid":"13","un":"unathig","dt":"2021-11-03T07:24:12.109Z"},{"op":"R","uid":"13","un":"unathig","dt":"2021-11-03T07:26:21.978Z"},{"op":"R","uid":"13","un":"unathig","dt":"2021-11-03T07:29:24.026Z"},{"op":"R","uid":"13","un":"unathig","dt":"2021-11-04T07:31:42.642Z"},{"op":"R","uid":"13","un":"unathig","dt":"2021-11-04T07:32:30.243Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2021-11-09T12:49:08.421Z"},{"op":"R","uid":"214","un":"nandipan","dt":"2022-02-21T09:36:07.682Z"},{"op":"R","uid":"214","un":"nandipan","dt":"2022-02-21T09:39:07.510Z"},{"op":"R","uid":"214","un":"nandipan","dt":"2022-02-21T09:42:33.835Z"},{"op":"R","uid":"214","un":"nandipan","dt":"2022-02-21T09:55:21.903Z"},{"op":"R","uid":"214","un":"nandipan","dt":"2022-02-21T09:56:13.380Z"},{"op":"R","uid":"214","un":"nandipan","dt":"2022-02-21T09:56:32.581Z"},{"op":"R","uid":"214","un":"nandipan","dt":"2022-02-21T09:58:39.319Z"},{"op":"R","uid":"214","un":"nandipan","dt":"2022-02-21T10:00:16.375Z"},{"op":"R","uid":"214","un":"nandipan","dt":"2022-02-21T10:01:02.786Z"},{"op":"R","uid":"56","un":"entlet","dt":"2022-02-21T10:02:16.491Z"},{"op":"R","uid":"56","un":"entlet","dt":"2022-02-21T10:03:06.002Z"},{"op":"R","uid":"56","un":"entlet","dt":"2022-02-21T10:05:24.425Z"},{"op":"R","uid":"214","un":"nandipan","dt":"2022-02-21T10:06:15.783Z"},{"op":"R","uid":"214","un":"nandipan","dt":"2022-02-26T07:30:22.249Z"}] | 1 | 111 | 56 | 6 | 56 | ||||||||||||||||||||||
| 0 | 233 | 7/19/2020 9:51:19 AM | 3/28/2022 7:25:06 AM | WATER | LEAK CREDIT 2017/10 invoice<br/><b>Journal Amount</b>: [-R1704.45] | 27 | 3 | 344 | 17 | 17 | 3 | 23 | 1 | 96 | [{"op":"R","uid":"3","un":"fareezar","dt":"2021-07-14T14:47:45.855Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-15T13:24:50.691Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-16T11:38:39.809Z"}] | 1 | 96 | 3/28/2022 7:25:06 AM | 17 | 17 | 20 | ||||||||||||||||||||
| 0 | 232 | 7/19/2020 9:49:16 AM | 3/28/2022 7:08:29 AM | ADJUSTMENT DONE | <br/><b>Journal Number</b>: [908345]<br/><b>Journal Amount</b>: [617.79] | 27 | 3 | 343 | 6 | 12 | 2 | 23 | 1 | 95 | [{"op":"R","uid":"12","un":"thembesas","dt":"2021-05-21T13:49:51.845Z"}] | 1 | 95 | 3/28/2022 7:08:29 AM | 12 | 6 | 12 | ||||||||||||||||||||
| 0 | 231 | 7/17/2020 1:53:38 PM | 3/28/2022 7:10:22 AM | water | water meter covered and not read since 2017 consumer is charged interim<br/><b>Journal Amount</b>: [4653.15] | 27 | 3 | 342 | 11 | 11 | 2 | 23 | 1 | 49 | [{"op":"R","uid":"12","un":"thembesas","dt":"2021-05-26T13:43:29.933Z"}] | 1 | 49 | 3/28/2022 7:10:22 AM | 11 | 11 | 12 | ||||||||||||||||||||
| 0 | 71372 | 230 | 7/15/2020 1:55:14 PM | 1/11/2023 7:12:21 AM | WATER Query | CONSUMER HAVE AN OUTSTANDING WATER QUERY AND SHE WAS OVER AVERAGED OVER A PERIOD OF SIX MONTHS<div><br></div><div><b><u>QRC RESPONSE</u></b></div><div>Customer needs to advise if they had any repairs in 2020 resulting in the drop of consumption from July 2020. The 6 months policy request will be based on High consumption, query pending.<br></div> | 30 | 3 | 341 | 23 | 2 | 23 | 1 | 67 | [{"op":"R","uid":"16","un":"cumilem","dt":"2021-09-03T07:16:55.919Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-23T09:18:55.053Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-23T09:21:28.684Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-23T09:22:00.451Z"}] | 1 | 101 | 14 | 134850 | 23 | 15 | ||||||||||||||||||||
| 0 | 229 | 7/15/2020 1:00:27 PM | 12/7/2022 7:46:29 AM | water leak | Plumber letter received, consumption needs to monitor for 3 months in order to do leak credit.<div><br></div> | 30 | 3 | 340 | 8 | 8 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-10-23T09:15:18.071Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-11-13T12:14:53.517Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2022-02-19T07:39:59.452Z"}] | 1 | 96 | 4 | 140790 | 8 | 201 |