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 | 465 | 9/2/2020 6:53:54 AM | 2/24/2022 10:34:50 AM | Log Query | <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 | 689 | 26 | 26 | 2 | 23 | 1 | 67 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-10-27T07:44:34.410Z"}] | 9 | 123 | 14 | 2/24/2022 10:34:50 AM | 26 | 26 | 14 | |||||||||||||||||||
| 0 | 464 | 9/1/2020 5:00:52 PM | 4/12/2022 9:39:10 AM | Log Query | water<br/><b>Journal Number</b>: [460070] | 27 | 3 | 686 | 33 | 4 | 2 | 23 | 1 | 67 | [{"op":"R","uid":"12","un":"thembesas","dt":"2021-09-03T08:32:23.451Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-09-03T08:34:27.100Z"},{"op":"R","uid":"203","un":"babalwas","dt":"2021-10-28T08:26:43.914Z"},{"op":"R","uid":"203","un":"babalwas","dt":"2022-03-26T07:21:06.941Z"}] | 1 | 67 | 4/12/2022 9:39:10 AM | 4 | 33 | 203 | ||||||||||||||||||||
| 0 | 463 | 9/1/2020 10:30:48 AM | 2/24/2022 11:21:35 AM | Water Query | Consumer is querying high consumption for the month June <div><br></div><div>- <b>QRC RESPONSE</b>: UNREAD PERIOD DOES NOT QUALIFY FOR 6 MONTHS POLICY </div> | 27 | 3 | 685 | 9 | 9 | 2 | 23 | 1 | 67 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-10-27T07:43:29.336Z"},{"op":"R","uid":"13","un":"unathig","dt":"2021-11-13T10:01:39.174Z"}] | 1 | 101 | 13 | 2/24/2022 11:21:35 AM | 9 | 9 | 13 | |||||||||||||||||||
| 0 | 462 | 9/1/2020 9:32:40 AM | 4/12/2022 9:47:18 AM | 6 month policy | Consumer reported high water consumption, to investigate and assess.<br/><b>Journal Number</b>: [BJ71931529] | 27 | 3 | 684 | 10 | 10 | 2 | 23 | 1 | 95 | [{"op":"R","uid":"17","un":"cwayitak","dt":"2021-10-14T07:35:14.400Z"},{"op":"R","uid":"13","un":"unathig","dt":"2021-11-13T10:04:31.991Z"}] | 1 | 101 | 17 | 4/12/2022 9:47:18 AM | 10 | 10 | 17 | |||||||||||||||||||
| 0 | 461 | 8/31/2020 2:34:48 PM | 10/16/2021 10:53:18 AM | Log Query | All un -read period are less than six months. | 27 | 3 | 683 | 33 | 33 | 2 | 23 | 1 | 67 | [{"op":"R","uid":"12","un":"thembesas","dt":"2021-10-16T10:45:16.261Z"}] | 1 | 101 | 12 | 10/16/2021 10:53:18 AM | 33 | 33 | 12 | |||||||||||||||||||
| 0 | 115860 | 460 | 8/30/2020 3:27:58 PM | 10/27/2021 7:42:23 AM | Log Query | <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 | 682 | 39 | 39 | 2 | 23 | 1 | 67 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-10-27T07:41:51.465Z"}] | 9 | 123 | 14 | 10/27/2021 7:42:23 AM | 39 | 39 | 14 | ||||||||||||||||||
| 0 | 459 | 8/28/2020 2:01:00 PM | 2/24/2022 11:21:35 AM | Water Query | Consumer is querying high consumption for the month June. | 30 | 3 | 677 | 9 | 2 | 23 | 1 | 67 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-10-27T07:40:50.812Z"},{"op":"R","uid":"212","un":"nozukon","dt":"2021-12-08T10:39:32.938Z"},{"op":"R","uid":"212","un":"nozukon","dt":"2021-12-08T10:40:12.806Z"}] | 1 | 101 | 14 | 9 | 14 | ||||||||||||||||||||||
| 0 | 458 | 8/28/2020 1:26:34 PM | 2/24/2022 10:34:50 AM | Log Query | Journal Done | 27 | 3 | 676 | 26 | 26 | 2 | 23 | 1 | 67 | [{"op":"R","uid":"17","un":"cwayitak","dt":"2021-10-14T11:46:21.185Z"},{"op":"R","uid":"13","un":"unathig","dt":"2021-11-13T09:58:50.564Z"}] | 1 | 101 | 17 | 2/24/2022 10:34:50 AM | 26 | 26 | 17 | |||||||||||||||||||
| 0 | 114744 | 457 | 8/28/2020 1:01:21 PM | 2/25/2022 9:22:48 AM | log query | <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 | 675 | 41 | 41 | 2 | 23 | 1 | 67 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-10-27T07:39:37.811Z"}] | 9 | 123 | 14 | 2/25/2022 9:22:48 AM | 41 | 41 | 14 | ||||||||||||||||||
| 0 | 113698 | 456 | 8/28/2020 6:14:23 AM | 10/30/2021 10:48:38 AM | Log Query | <table border="0" cellpadding="0" cellspacing="0" width="668" style="border-collapse: collapse;width:501pt"><tbody><tr height="26" style="height:19.5pt"> <td height="26" class="xl65" width="668" style="height:19.5pt;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 | 674 | 39 | 39 | 2 | 23 | 1 | 67 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-10-30T10:47:23.098Z"}] | 9 | 123 | 14 | 10/30/2021 10:48:38 AM | 39 | 39 | 14 | ||||||||||||||||||
| 0 | 455 | 8/27/2020 2:23:25 PM | 2/24/2022 10:34:50 AM | Late Termination | terminated | 27 | 3 | 673 | 26 | 26 | 2 | 23 | 6 | 107 | [{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-07T09:05:51.789Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-07T09:06:48.905Z"},{"op":"R","uid":"173","un":"olgad","dt":"2021-08-10T09:23:53.278Z"},{"op":"R","uid":"173","un":"olgad","dt":"2021-08-10T11:58:12.931Z"}] | 6 | 107 | 2/24/2022 10:34:50 AM | 26 | 26 | 173 | ||||||||||||||||||||
| 0 | 454 | 8/27/2020 1:52:28 PM | 2/24/2022 10:34:50 AM | kindly transfer water from the old meter 10361758 to the new meter 10421732. | kindly transfer water from the old meter 10361758 to the new meter 10421732.<div>water meter transferred to new owner.</div> | 27 | 3 | 672 | 26 | 26 | 3 | 23 | 1 | 45 | [{"op":"R","uid":"2","un":"debbiecr","dt":"2021-06-07T09:35:35.530Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2021-07-13T08:44:13.147Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2021-07-13T09:00:25.301Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-10-16T07:43:38.790Z"}] | 1 | 112 | 12 | 2/24/2022 10:34:50 AM | 26 | 26 | 12 | |||||||||||||||||||
| 0 | 453 | 8/27/2020 1:47:45 PM | 10/9/2022 7:30:03 AM | Water Query | <div>customer queries August high water charge</div><b><u><div><b><u><br></u></b></div><div><b><u>RESPONSE FROM QRC: </u></b><br></div></u></b><div><div>Customer need to advise if they had any repairs done in 2020/2021 that resulted in high consumption.</div></div><div><br></div><div>Query closed. Account is up to date with Indigent Status. Consumption averaging above 25kl.</div><div>Consumer to be advised to appoint a plumber to check property for leaks if they feel consumption is too high.</div> | 27 | 3 | 671 | 9 | 12 | 2 | 23 | 1 | 67 | [{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-10-16T10:29:28.517Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-27T07:19:38.945Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-30T10:49:58.896Z"},{"op":"R","uid":"214","un":"nandipan","dt":"2022-02-26T08:47:18.148Z"},{"op":"R","uid":"214","un":"nandipan","dt":"2022-02-26T08:50:18.578Z"},{"op":"R","uid":"214","un":"nandipan","dt":"2022-02-26T09:01:28.601Z"},{"op":"R","uid":"214","un":"nandipan","dt":"2022-02-26T09:14:34.228Z"},{"op":"R","uid":"214","un":"nandipan","dt":"2022-02-26T09:35:49.324Z"}] | 1 | 67 | 10/9/2022 7:30:03 AM | 3 | 9 | 3 | ||||||||||||||||||||
| 0 | 452 | 8/27/2020 1:25:08 PM | 2/24/2022 10:34:50 AM | Log Query | <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 | 670 | 26 | 26 | 3 | 23 | 1 | 67 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-10-27T07:17:34.880Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-27T07:18:19.429Z"}] | 9 | 123 | 14 | 2/24/2022 10:34:50 AM | 26 | 26 | 14 | |||||||||||||||||||
| 0 | 451 | 8/27/2020 1:02:53 PM | 2/24/2022 11:21:35 AM | Water Query, Consumer is querying high consumption for the month June | journal done | 27 | 3 | 667 | 9 | 9 | 2 | 23 | 1 | 67 | [{"op":"R","uid":"6","un":"lusandad","dt":"2021-10-14T10:15:37.623Z"},{"op":"R","uid":"13","un":"unathig","dt":"2021-11-13T09:58:10.884Z"}] | 1 | 101 | 6 | 2/24/2022 11:21:35 AM | 9 | 9 | 6 | |||||||||||||||||||
| 0 | 450 | 8/27/2020 12:51:03 PM | 9/7/2022 12:21:22 PM | Late Termination | more info from rates sectional title | 23 | 3 | 663 | 9 | 2 | 26 | 6 | 107 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-10-27T07:15:15.866Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-11-10T12:46:07.770Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2021-11-23T07:36:33.369Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2021-11-23T07:38:40.938Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2021-11-23T07:39:10.878Z"}] | 6 | 122 | 12 | 136779 | 9 | 23 | |||||||||||||||||||||
| 0 | 449 | 8/27/2020 12:23:49 PM | 10/9/2022 7:41:24 AM | Log Query | 2021/07/14 - Requested removal/installation report for meters from Wayne Beckman<div><br></div><div><b><u>RESPONSE FROM QRC:</u></b> <br></div><div>Query Closed. There's no credit/ conventional electricity meter linked with this account. No adjustment due</div> | 27 | 3 | 662 | 26 | 5 | 3 | 23 | 2 | 104 | [{"op":"R","uid":"5","un":"ivanh","dt":"2021-07-14T09:31:31.670Z"},{"op":"R","uid":"5","un":"ivanh","dt":"2021-07-14T13:19:48.471Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-10-23T07:15:27.826Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-27T07:11:28.072Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-27T07:13:21.642Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-30T10:50:49.746Z"},{"op":"R","uid":"214","un":"nandipan","dt":"2022-02-26T08:39:19.484Z"},{"op":"R","uid":"214","un":"nandipan","dt":"2022-02-26T08:40:56.154Z"}] | 2 | 104 | 10/9/2022 7:41:24 AM | 3 | 26 | 3 | ||||||||||||||||||||
| 0 | 448 | 8/27/2020 8:50:41 AM | 10/27/2021 7:10:42 AM | Log Query | <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 | 661 | 39 | 39 | 3 | 23 | 1 | 67 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-10-27T07:09:27.223Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-27T07:10:42.764Z"}] | 9 | 123 | 14 | 10/27/2021 7:10:42 AM | 39 | 39 | 14 | |||||||||||||||||||
| 0 | 112155 | 447 | 8/26/2020 2:28:38 PM | 2/24/2022 10:34:50 AM | Log Query | <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 | 646 | 26 | 26 | 3 | 23 | 1 | 95 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-10-27T07:06:11.912Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-27T07:08:28.569Z"}] | 9 | 123 | 14 | 2/24/2022 10:34:50 AM | 26 | 26 | 14 | ||||||||||||||||||
| 0 | 112155 | 446 | 8/26/2020 2:25:16 PM | 2/24/2022 10:34:50 AM | 4 | 2 | 645 | 26 | 26 | 2/24/2022 10:34:50 AM | 26 | 26 |