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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3604 | 4/28/2021 7:47:43 AM | 5/19/2022 7:53:10 AM | WATER QUERY CONSUMER SUBMITTED PLUMBERS LETTER | WATER QUERY CONSUMER SUBMITTED PLUMBER LETTER | 30 | 3 | 3070 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"18","un":"lindan","dt":"2021-04-28T07:47:45.388Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-22T06:30:45.928Z"},{"op":"R","uid":"756","un":"nontandazos","dt":"2022-01-28T09:36:28.791Z"}] | 1 | 96 | 14 | 14 | |||||||||||||||||||||||||
| 3605 | 4/28/2021 7:46:08 AM | 1/26/2022 10:55:44 AM | 2 | 3069 | [{"op":"R","uid":"21","un":"heinrichs","dt":"2021-04-28T07:45:56.293Z"},{"op":"R","uid":"756","un":"nontandazos","dt":"2022-01-26T09:57:31.459Z"},{"op":"R","uid":"756","un":"nontandazos","dt":"2022-01-26T09:58:34.261Z"},{"op":"R","uid":"756","un":"nontandazos","dt":"2022-01-26T10:54:47.373Z"}] | 756 | |||||||||||||||||||||||||||||||||||
| 3603 | 4/28/2021 7:21:15 AM | 5/19/2022 7:53:10 AM | QUERY | <table border="0" cellpadding="0" cellspacing="0" width="864" style="border-collapse: collapse;width:648pt"><tbody><tr height="20" style="height:15.0pt"> <td height="20" class="xl65" width="864" style="height:15.0pt;width:648pt">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 | 3068 | 18 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"18","un":"lindan","dt":"2021-04-28T07:21:29.499Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-22T06:29:29.752Z"}] | 9 | 123 | 14 | 5/19/2022 7:53:10 AM | 18 | 14 | ||||||||||||||||||||||
| 3602 | 4/28/2021 6:54:39 AM | 4/28/2021 6:54:41 AM | 2 | [{"op":"R","uid":"21","un":"heinrichs","dt":"2021-04-28T06:54:27.656Z"}] | 21 | ||||||||||||||||||||||||||||||||||||
| 3601 | 4/28/2021 6:29:26 AM | 4/28/2021 6:29:29 AM | 2 | 3066 | [{"op":"R","uid":"21","un":"heinrichs","dt":"2021-04-28T06:29:14.529Z"}] | 21 | |||||||||||||||||||||||||||||||||||
| 3598 | 4/26/2021 7:54:19 AM | 10/15/2022 8:29:03 AM | HIGH WATER CONSUMPTION | CONSUMER QUERYING HIGH WATER CONSUMPTION. KINDLY INVESTIGATE AND RESOLVE.<div><br></div><div><b><u>QRC RESPONSE</u></b>: There are no fault reports on water works system, and consumption is on average between 15- 20kl therefore a High Consumption cannot be reported.</div><div>If the customer had any internal faults repaired during the 2020/2021 period a they need to log a new query under the correct Subcategory (Leak Rebate) by attaching the invoice or an affidavit stating the repair date.</div><div>Customer does not qualify for six months policy, query resolved.</div> | 27 | 3 | 3065 | 15 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-04-26T07:54:09.920Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-10-31T12:25:28.932Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-22T06:27:59.375Z"}] | 1 | 101 | 14 | 10/15/2022 8:28:17 AM | 8 | 8 | ||||||||||||||||||||||
| 3596 | 4/26/2021 7:20:16 AM | 3/22/2022 7:09:10 AM | HIGH WATER CONSUMPTION | CONSUMER QUERYING HIGH WATER CONSUMPTION IN JULY 2020 AND MARCH 2021. KINDLY INVESTIGATE AND RESOLVE.<div><br></div><div>account adjusted 08/2021 journal no 888574.</div> | 27 | 3 | 3064 | 2 | 2 | 23 | 1 | 67 | 1592 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-04-26T07:20:06.459Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2021-04-26T07:37:02.840Z"},{"op":"R","uid":"214","un":"nandiphan","dt":"2021-08-15T10:53:36.497Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-10-31T12:28:04.675Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-22T06:27:11.032Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2022-03-08T09:48:54.957Z"}] | 1 | 111 | 12 | 3/22/2022 7:09:10 AM | 2 | 12 | |||||||||||||||||||||
| 3595 | 4/26/2021 7:11:55 AM | 11/22/2021 6:26:32 AM | LOG | <table border="0" cellpadding="0" cellspacing="0" width="864" style="border-collapse: collapse;width:648pt"><tbody><tr height="20" style="height:15.0pt"> <td height="20" class="xl63" width="864" style="height:15.0pt;width:648pt">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 | 3063 | 14 | 2 | 23 | 77 | 107 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-04-26T07:11:45.933Z"},{"op":"R","uid":"172","un":"sesonad","dt":"2021-09-14T12:50:15.402Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-22T06:25:22.754Z"}] | 9 | 123 | 14 | 11/22/2021 6:26:32 AM | 14 | 14 | ||||||||||||||||||||||
| 3594 | 4/23/2021 1:44:22 PM | 4/12/2022 9:47:18 AM | NO DOG TAX | REMOVE DOG TAX FROM ACCOUNT<br/><b>Journal Number</b>: [undefined] | 27 | 3 | 3062 | 10 | 2 | 23 | 109 | 75 | [{"op":"R","uid":"5","un":"ivanh","dt":"2021-04-23T13:44:25.030Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-07-14T10:15:35.283Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-07-30T08:19:42.135Z"}] | 109 | 75 | 4/12/2022 9:47:18 AM | 10 | 12 | |||||||||||||||||||||||
| 3589 | 4/23/2021 1:34:50 PM | 2/13/2022 9:38:54 AM | High water consumption | Kindly assess a high water consumption. Journal processed and approved. Query resolved. | 27 | 3 | 3058 | 74 | 2 | 23 | 1 | 67 | 1590 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-04-23T13:39:08.855Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-22T06:24:30.224Z"},{"op":"R","uid":"214","un":"nandipan","dt":"2022-02-13T09:37:01.291Z"}] | 1 | 101 | 214 | 2/13/2022 9:38:54 AM | 172 | 214 | |||||||||||||||||||||
| 3592 | 4/23/2021 1:30:53 PM | 11/22/2021 6:23:48 AM | High water consumption | Kindly assess a high water consumption for the period 202003-202007<div>account adjusted 2020/09 journal number 343081</div> | 27 | 3 | 3061 | 74 | 2 | 23 | 1 | 67 | 1589 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-04-23T13:35:09.100Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-10-31T11:37:40.192Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-22T06:23:48.898Z"}] | 1 | 111 | 12 | 11/22/2021 6:23:48 AM | 172 | 12 | |||||||||||||||||||||
| 3591 | 4/23/2021 1:25:47 PM | 3/4/2022 1:17:43 PM | High consumption | account adjusted Journal no 710816<div><br></div><div>Consumer to check for leaks as consumption is averaging above 30kl</div> | 27 | 3 | 3060 | 74 | 2 | 23 | 1 | 67 | 1588 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-04-23T13:30:02.922Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-10-31T12:18:50.288Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-11-10T07:34:17.854Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-11-13T07:49:06.026Z"},{"op":"R","uid":"5","un":"ivanh","dt":"2021-11-18T12:12:39.722Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-22T06:23:08.459Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2022-03-04T13:17:27.329Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2022-03-04T13:17:40.476Z"}] | 1 | 50 | 3 | 3/4/2022 1:17:43 PM | 172 | 3 | |||||||||||||||||||||
| 3590 | 4/23/2021 1:21:26 PM | 10/23/2022 12:38:56 PM | High water consumption | Kindly assess a high water consumption for the period 202006<div><br></div><div>QRC RESPONSE: Customer does not qualify for six months policy,<br><div><br></div><div><br></div></div> | 27 | 3 | 3059 | 15 | 2 | 23 | 1 | 67 | 1587 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-04-23T13:25:41.603Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-10-31T12:01:16.197Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-22T06:22:21.521Z"}] | 1 | 101 | 14 | 10/23/2022 12:38:56 PM | 10 | 10 | |||||||||||||||||||||
| 3589 | 4/23/2021 1:06:49 PM | 2/13/2022 9:40:22 AM | High water consumption | Kindly assess a high water consumption for the period 202004. Journal processed and approved. Query resolved. | 27 | 3 | 3058 | 74 | 2 | 23 | 1 | 67 | 1585 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-04-23T13:11:04.844Z"},{"op":"R","uid":"172","un":"sesonad","dt":"2021-04-23T13:18:57.906Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-22T06:21:36.660Z"},{"op":"R","uid":"214","un":"nandipan","dt":"2022-02-13T09:38:33.283Z"}] | 1 | 101 | 214 | 2/13/2022 9:40:22 AM | 172 | 214 | |||||||||||||||||||||
| 3588 | 4/23/2021 12:52:27 PM | 6/16/2022 12:19:12 PM | High water consumption | Kindly assess a high water consumption for the month 202004 and correct readings need to be updated <div><br></div><div>adjustments done by billing 202203 and 202205</div> | 27 | 3 | 3057 | 74 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-04-23T12:56:43.024Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-22T06:20:51.146Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2022-02-03T07:55:25.972Z"}] | 1 | 111 | 14 | 6/16/2022 12:19:12 PM | 13 | 13 | ||||||||||||||||||||||
| 3587 | 4/23/2021 12:47:35 PM | 7/21/2021 12:19:17 PM | no valid query details submitted | no valid query details submitted | 27 | 3 | 3056 | 11 | 2 | 23 | 1 | 44 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-04-23T12:51:51.400Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-14T09:52:37.535Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T12:19:29.432Z"}] | 1 | 44 | 7/21/2021 12:19:17 PM | 11 | 14 | |||||||||||||||||||||||
| 3586 | 4/23/2021 12:40:13 PM | 8/29/2021 10:11:30 AM | High consumption | Kindly assess a high consumption for this account for the period 202007 | 27 | 3 | 3055 | 74 | 2 | 23 | 1 | 67 | 1583 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-04-23T12:44:29.272Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-29T10:11:26.537Z"}] | 1 | 67 | 8/29/2021 10:11:30 AM | 172 | 12 | ||||||||||||||||||||||
| 3585 | 4/23/2021 12:33:49 PM | 7/14/2021 9:52:08 AM | no valid query details submitted | no valid query details submitted | 4 | 3 | 6 | 2 | 23 | 1 | 44 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-04-23T12:38:08.913Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-14T09:51:51.934Z"}] | 1 | 44 | 7/14/2021 9:52:08 AM | 6 | 20 | ||||||||||||||||||||||||
| 3583 | 4/23/2021 12:24:25 PM | 7/21/2021 12:18:36 PM | no valid query details submitted | no valid query details submitted | 27 | 3 | 3054 | 15 | 2 | 23 | 1 | 44 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-04-23T12:28:41.185Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-14T09:50:55.659Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T12:18:49.584Z"}] | 1 | 44 | 7/21/2021 12:18:36 PM | 15 | 14 | |||||||||||||||||||||||
| 3582 | 4/23/2021 12:14:11 PM | 2/13/2022 8:26:08 AM | High water consumption | Kindly assess a high water consumption for the period 202008<div>THERE IS NO 6 MONTHS POLICY TO BE APPLIED.</div> | 27 | 3 | 3053 | 74 | 2 | 23 | 1 | 67 | 1582 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-04-23T12:18:26.949Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-22T06:19:51.117Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2022-02-13T08:25:40.299Z"}] | 1 | 101 | 6 | 2/13/2022 8:26:08 AM | 172 | 6 |