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 | 268 | 7/20/2020 1:28:40 PM | 6/16/2022 6:53:07 AM | leak credit | need current reading to do adjustment | 27 | 3 | 386 | 5 | 17 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"3","un":"fareezar","dt":"2021-08-14T06:43:13.026Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-08-14T10:49:22.547Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-08-22T06:43:26.421Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-24T06:44:21.032Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-11-13T07:54:13.104Z"}] | 1 | 111 | 14 | 6/16/2022 6:53:07 AM | 133391 | 13 | 5 | 13 | ||||||||||||||||||
| 0 | 267 | 7/20/2020 1:10:28 PM | 10/30/2021 10:58:43 AM | six months policy | <br><b> </b><table border="0" cellpadding="0" cellspacing="0" width="668" style="border-collapse: collapse;width:501pt"><tbody><tr height="31" style="mso-height-source:userset;height:23.45pt"> <td height="31" class="xl65" width="668" style="height:23.45pt;width:501pt">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 | 385 | 12 | 12 | 2 | 23 | 1 | 95 | [{"op":"R","uid":"17","un":"cwayitak","dt":"2021-08-07T08:01:38.011Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-24T06:43:19.855Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-30T10:58:05.696Z"}] | 9 | 123 | 14 | 10/30/2021 10:58:43 AM | 12 | 12 | 14 | |||||||||||||||||||
| 0 | 266 | 7/20/2020 1:09:38 PM | 11/13/2021 8:13:19 AM | SIX MONTHS POLICY | <br/><b>Journal Number</b>: [908645] | 27 | 3 | 384 | 12 | 12 | 2 | 23 | 1 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-10-23T12:44:51.567Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-23T12:47:03.303Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-11-13T08:09:57.370Z"}] | 1 | 101 | 12 | 11/13/2021 8:13:19 AM | 12 | 12 | 12 | ||||||||||||||||||||
| 0 | 265 | 7/20/2020 1:09:00 PM | 10/23/2021 12:43:43 PM | six months policy EL | <br><b>SIX MONTHS POLICY EL </b><br/><b>Journal Number</b>: [826751] | 24 | 3 | 383 | 12 | 2 | 23 | 2 | 101 | [{"op":"R","uid":"2","un":"debbiecr","dt":"2021-06-07T09:26:02.153Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2021-08-02T09:11:18.428Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2021-08-02T09:33:23.383Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-08-07T08:21:48.358Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-23T12:40:20.894Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-23T12:42:46.467Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-23T12:43:39.203Z"}] | 1 | 101 | 14 | 12 | 14 | ||||||||||||||||||||||
| 0 | 264 | 7/20/2020 1:08:26 PM | 10/30/2021 11:01:46 AM | SIX MONTHS POLICY | <br/><b>Journal Number</b>: [BJ71826704] | 24 | 3 | 382 | 12 | 2 | 23 | 1 | 95 | [{"op":"R","uid":"15","un":"chumab","dt":"2021-08-10T11:50:55.284Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-23T12:39:55.886Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-30T10:59:34.029Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-30T11:01:17.180Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-30T11:01:37.974Z"}] | 1 | 101 | 14 | 12 | 14 | ||||||||||||||||||||||
| 0 | 263 | 7/20/2020 1:07:52 PM | 11/13/2021 7:57:10 AM | six months pol | <br/><b>Journal Number</b>: [906316] | 27 | 3 | 381 | 12 | 12 | 2 | 23 | 1 | [{"op":"R","uid":"17","un":"cwayitak","dt":"2021-10-14T08:48:07.189Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-10-14T12:36:32.413Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-11-13T07:57:10.857Z"}] | 1 | 101 | 17 | 11/13/2021 7:57:10 AM | 12 | 12 | 17 | ||||||||||||||||||||
| 0 | 262 | 7/20/2020 1:05:54 PM | 11/30/2022 11:18:49 AM | SIX MONTHS POLICY | <br/><b>Journal Number</b>: [906296] | 30 | 3 | 380 | 12 | 12 | 2 | 23 | 1 | [{"op":"R","uid":"17","un":"cwayitak","dt":"2021-10-13T09:15:05.472Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-10-13T09:15:33.490Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-23T12:32:05.451Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-23T12:34:34.786Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-11-13T07:48:39.527Z"}] | 1 | 101 | 12 | 140477 | 12 | 201 | |||||||||||||||||||||
| 0 | 261 | 7/20/2020 1:05:07 PM | 2/14/2023 9:11:40 AM | six months policy | <br><b>Journal Number</b>: [bj71826743]<div>QRC RESPONSE: 6 MONTHS POLICY DONE FOR 20170827.</div><div>JNL NO: 745877</div> | 24 | 3 | 379 | 12 | 15 | 4 | 23 | 1 | 95 | [{"op":"R","uid":"15","un":"chumab","dt":"2021-08-10T11:40:10.466Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-23T12:28:17.135Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-23T12:30:57.041Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-23T12:31:22.720Z"}] | 1 | 101 | 14 | 12 | 6 | |||||||||||||||||||||
| 0 | 260 | 7/20/2020 1:04:12 PM | 2/16/2023 1:01:48 PM | six months policy | <br><b>six months policy </b><br><b>Journal Number</b>: [826762]<div>QRC RESPONSE; 6 months policy done for 20170722</div><div>jnl no: 745952</div><br/><b>Journal Amount</b>: [-R838.22] | 27 | 3 | 378 | 12 | 15 | 2 | 23 | 1 | 95 | [{"op":"R","uid":"17","un":"cwayitak","dt":"2021-08-07T08:45:52.828Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-30T11:02:17.580Z"}] | 1 | 101 | 14 | 2/16/2023 1:01:40 PM | 3 | 12 | 3 | |||||||||||||||||||
| 0 | 259 | 7/20/2020 1:03:29 PM | 2/14/2023 7:39:56 AM | WATER QUERY SIX MONTHS | <br/><b>Journal Number</b>: [906311] | 27 | 3 | 377 | 12 | 15 | 2 | 23 | 1 | [{"op":"R","uid":"6","un":"lusandad","dt":"2021-08-31T13:07:54.881Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-10-13T09:17:35.499Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-30T11:03:10.769Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-30T11:04:32.332Z"},{"op":"R","uid":"15","un":"chumab","dt":"2022-02-12T10:00:33.900Z"}] | 1 | 101 | 14 | 2/14/2023 7:39:56 AM | 6 | 12 | 6 | ||||||||||||||||||||
| 0 | 258 | 7/20/2020 1:02:50 PM | 11/13/2021 7:52:32 AM | six months pol | <br/><b>Journal Number</b>: [906295] | 27 | 3 | 376 | 12 | 12 | 2 | 23 | 1 | [{"op":"R","uid":"17","un":"cwayitak","dt":"2021-10-13T09:48:48.396Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-10-14T12:27:00.640Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-10-14T12:28:03.226Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-11-13T07:52:32.820Z"}] | 1 | 101 | 17 | 11/13/2021 7:52:32 AM | 12 | 12 | 17 | ||||||||||||||||||||
| 0 | 257 | 7/20/2020 1:00:44 PM | 10/9/2022 7:20:39 AM | WATER QUERY | <br><b>Journal Number</b>: [905402]<div><br></div><div>QRC RESPONSE:</div><div>Query closed. Account was closed in July 2020 and there were no meters to warrant a 06 month back charge amendment.</div> | 27 | 3 | 375 | 12 | 15 | 2 | 23 | 1 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-10-23T12:13:50.923Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-25T09:52:12.571Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-30T11:05:25.225Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-30T11:07:20.723Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-30T11:07:49.401Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-11-13T09:40:34.970Z"},{"op":"R","uid":"214","un":"nandipan","dt":"2022-02-21T09:34:53.071Z"}] | 1 | 101 | 14 | 10/9/2022 7:20:38 AM | 3 | 12 | 3 | ||||||||||||||||||||
| 0 | 256 | 7/20/2020 7:38:58 AM | 5/19/2022 7:51:12 AM | termination notice/letter submitted by the consumer in february 2019. | Late termination | 27 | 3 | 374 | 16 | 16 | 2 | 23 | 6 | 107 | [{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-15T12:20:44.026Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-16T11:34:42.522Z"},{"op":"R","uid":"201","un":"nonkosim","dt":"2022-02-10T13:22:17.790Z"},{"op":"R","uid":"201","un":"nonkosim","dt":"2022-02-10T13:22:37.707Z"}] | 6 | 107 | 5/19/2022 7:51:12 AM | 16 | 16 | 201 | ||||||||||||||||||||
| 0 | 255 | 7/19/2020 5:15:48 PM | 10/24/2021 6:41:10 AM | Log Query | <table border="0" cellpadding="0" cellspacing="0" width="609" style="border-collapse: collapse;width:457pt"><tbody><tr height="31" style="mso-height-source:userset;height:23.45pt"> <td height="31" class="xl65" width="609" style="height:23.45pt;width:457pt">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 | 373 | 39 | 39 | 2 | 23 | 1 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-10-23T12:01:06.361Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-23T12:02:00.408Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-23T12:05:32.081Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-24T06:41:10.753Z"}] | 9 | 123 | 14 | 10/24/2021 6:41:10 AM | 39 | 39 | 14 | ||||||||||||||||||||
| 0 | 254 | 7/19/2020 5:05:01 PM | 6/9/2021 6:45:36 AM | Log Query | water adjustment | 27 | 3 | 372 | 39 | 39 | 2 | 23 | 1 | 95 | [{"op":"R","uid":"12","un":"thembesas","dt":"2021-06-09T06:43:34.625Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-06-09T06:44:48.694Z"}] | 1 | 95 | 6/9/2021 6:45:36 AM | 39 | 39 | 12 | ||||||||||||||||||||
| 0 | 253 | 7/19/2020 10:58:00 AM | 2/26/2022 8:02:56 AM | Tariiff changed and adjusted accordingly, journal awaiting authorization.<br/><b>Journal Number</b>: [907654] | 24 | 3 | 371 | 8 | 2 | 23 | 4 | 55 | [{"op":"R","uid":"5","un":"ivanh","dt":"2021-06-09T06:34:38.620Z"},{"op":"R","uid":"5","un":"ivanh","dt":"2021-06-09T06:40:48.718Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-23T12:25:59.321Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-30T11:08:32.372Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-30T11:10:04.957Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-11-13T07:35:59.515Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-11-13T09:04:35.806Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-11-13T09:27:42.916Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-11-14T07:19:37.526Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-11-14T07:40:05.088Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-11-14T07:42:02.198Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-11-14T09:00:59.412Z"},{"op":"R","uid":"214","un":"nandipan","dt":"2022-02-26T08:02:57.087Z"}] | 4 | 55 | 124696 | 8 | 214 | |||||||||||||||||||||||
| 0 | 252 | 7/19/2020 10:55:09 AM | 10/14/2021 10:11:14 AM | termination | Late termination processed 201707-202006, journal awaiting authorization.<br/><b>Journal Number</b>: [908026] | 27 | 3 | 370 | 8 | 8 | 2 | 23 | 6 | 59 | [{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-07T08:54:52.836Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-07T08:55:24.979Z"},{"op":"R","uid":"173","un":"olgad","dt":"2021-08-10T09:13:16.143Z"},{"op":"R","uid":"173","un":"olgad","dt":"2021-08-10T11:54:13.141Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-10-14T10:08:33.668Z"}] | 6 | 59 | 10/14/2021 10:11:14 AM | 8 | 8 | 6 | ||||||||||||||||||||
| 0 | 251 | 7/19/2020 10:53:47 AM | 4/12/2022 9:47:18 AM | SIX MONTHS POLICY | leak repaired<br/><b>Journal Number</b>: [BJ71826738] | 24 | 3 | 369 | 11 | 2 | 23 | 1 | 95 | [{"op":"R","uid":"15","un":"chumab","dt":"2021-08-10T10:58:26.998Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-23T12:24:51.487Z"}] | 1 | 101 | 14 | 11 | 14 | ||||||||||||||||||||||
| 0 | 250 | 7/19/2020 10:52:06 AM | 11/5/2021 6:30:24 AM | 6 months policy processed for period 201702- journal awaiting authorization.<br/><b>Journal Number</b>: [908287] | 24 | 3 | 368 | 8 | 2 | 23 | 1 | 95 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-10-23T12:20:33.926Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-23T12:22:10.504Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-23T12:23:33.941Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-30T11:11:05.228Z"},{"op":"R","uid":"13","un":"unathig","dt":"2021-11-04T07:33:31.918Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-11-04T08:53:56.064Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-11-04T08:56:03.192Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-11-04T09:00:37.000Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-11-04T09:05:23.418Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-11-04T09:10:50.057Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-11-04T09:13:12.625Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-11-04T10:25:17.695Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-11-04T10:32:08.309Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-11-05T06:26:25.506Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-11-05T06:27:38.200Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-11-05T06:27:57.818Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-11-05T06:28:05.228Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-11-05T06:28:41.096Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-11-05T06:29:23.019Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-11-05T06:30:21.179Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-11-05T06:30:25.029Z"}] | 1 | 95 | 8 | 230 | ||||||||||||||||||||||||
| 0 | 249 | 7/19/2020 10:51:14 AM | 4/5/2022 7:46:18 AM | water leak repaired<br/><b>Journal Number</b>: [907242] | 24 | 3 | 367 | 11 | 2 | 23 | 1 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-10-24T10:54:20.131Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-30T11:12:27.688Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2021-11-09T12:51:09.484Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-11-13T07:33:18.214Z"},{"op":"R","uid":"214","un":"nandipan","dt":"2022-02-26T07:43:13.858Z"},{"op":"R","uid":"214","un":"nandipan","dt":"2022-02-26T07:44:42.505Z"},{"op":"R","uid":"201","un":"nonkosim","dt":"2022-03-03T07:24:58.892Z"},{"op":"R","uid":"205","un":"zovuyod","dt":"2022-04-05T07:46:19.120Z"}] | 1 | 11 | 205 |