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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2923 | 3/31/2021 9:57:41 AM | 7/21/2021 10:57:20 AM | No valid query details submitted | No valid query detail submitted | 27 | 3 | 2551 | 10 | 2 | 23 | 1 | 44 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T10:51:59.441Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T10:55:35.809Z"}] | 1 | 44 | 7/21/2021 10:57:20 AM | 10 | 14 | |||||||||||||||||||||||
| 2922 | 3/31/2021 9:42:20 AM | 5/11/2022 9:08:45 AM | water | <table border="0" cellpadding="0" cellspacing="0" width="770" style="border-collapse: collapse;width:578pt"> <colgroup><col width="770" style="mso-width-source:userset;mso-width-alt:24640;width:578pt"> </colgroup><tbody><tr height="21" style="height:15.75pt"> <td height="21" class="xl65" width="770" style="height:15.75pt;width:578pt">Query is being voided as no details of query were logged, query was logged only as "Log Query" with no category</td> </tr> <tr height="21" style="height:15.75pt"> <td height="21" class="xl66" width="770" style="height:15.75pt;width:578pt">selected . New query to be logged with full information fo query</td> </tr></tbody></table> | 4 | 3 | 2550 | 11 | 4 | 23 | 1 | 96 | [{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-03-31T09:42:37.082Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-05-27T13:19:29.840Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T10:47:12.311Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T10:47:49.289Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2022-05-11T09:08:27.806Z"}] | 9 | 123 | 18 | 5/11/2022 9:08:45 AM | 11 | 18 | ||||||||||||||||||||||
| 2921 | 3/31/2021 9:39:01 AM | 11/12/2021 11:01:13 AM | Leak Credit | Kindly assess a leak that was reported in June 2020 and the repair took place in 04/08/2020<div>100% leak credit adjustment done for 202008</div><b>Journal Number</b>: [937893]<div><br></div><div><b>RESPONSE QRC</b>:100% Lk CR 202008 AV 21KL,Journal {937893}Authorized.</div> | 27 | 3 | 2549 | 74 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-03-31T09:35:12.579Z"},{"op":"R","uid":"172","un":"sesonad","dt":"2021-03-31T09:36:26.574Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-08-22T08:16:03.164Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T10:46:30.654Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-11-12T10:58:38.740Z"}] | 1 | 96 | 230 | 11/12/2021 11:01:13 AM | 172 | 230 | ||||||||||||||||||||||
| 2920 | 3/31/2021 9:35:30 AM | 10/21/2022 12:36:05 PM | 6MONTHS POLICY | <div>There is no unread period that exceeds 06 months.</div><div><br></div><div>reported w.w ref 775757</div><div>most period are lower than 6 month possible leak ,and plumbers letter must be submitted<br><div><br></div><div>Midland Billing to verify readings from 2020/04 and meter inspection requested. Consumer to advise if any leaks were repaired for further assessment </div></div> | 27 | 3 | 2548 | 15 | 4 | 23 | 1 | 67 | 1296 | [{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-03-31T09:35:47.528Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T10:45:48.112Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2022-02-12T07:05:07.501Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2022-02-12T07:13:32.847Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2022-02-12T09:19:06.201Z"}] | 1 | 101 | 4 | 10/21/2022 12:36:05 PM | 123732 | 3 | 3 | ||||||||||||||||||||
| 2919 | 3/31/2021 9:30:51 AM | 3/28/2022 7:10:22 AM | 6MOTHS PLOCY | 6 MONTHS POLICY PROCESSED<br/><b>Journal Number</b>: [undefined]<br/><b>Journal Amount</b>: [1242.05] | 27 | 3 | 2547 | 11 | 4 | 23 | 1 | 96 | [{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-03-31T09:31:08.738Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-05-26T13:40:39.648Z"}] | 1 | 96 | 3/28/2022 7:10:22 AM | 11 | 12 | |||||||||||||||||||||||
| 2918 | 3/31/2021 8:53:51 AM | 10/24/2021 10:45:03 AM | water/leak plumbers letter submitted | water /leak | 30 | 3 | 2546 | 2 | 23 | 77 | 96 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-03-31T08:54:08.324Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T10:44:46.252Z"}] | 1 | 96 | 18 | 18 | |||||||||||||||||||||||||
| 2917 | 3/31/2021 8:18:34 AM | 3/28/2022 7:10:22 AM | WATER QUERY | WATER QUERY<div>to contact consumer for leak letter and request check readings.</div> | 27 | 3 | 2545 | 11 | 3 | 23 | 77 | 67 | [{"op":"R","uid":"18","un":"lindan","dt":"2021-03-31T08:18:51.036Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-10-16T11:40:58.531Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-10-16T11:46:25.258Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-11-10T13:33:25.969Z"},{"op":"R","uid":"13","un":"unathig","dt":"2021-11-20T11:27:00.963Z"}] | 1 | 101 | 12 | 3/28/2022 7:10:22 AM | 11 | 12 | ||||||||||||||||||||||
| 2916 | 3/31/2021 8:17:49 AM | 10/15/2022 10:39:34 AM | Leak Credit | Assess a leak credit for this account.<div><br></div><div>Duplicate query closed. Further assessment on ref #77050</div> | 27 | 3 | 2544 | 17 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-03-31T08:17:52.409Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-08-22T07:44:04.608Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T10:43:59.535Z"}] | 1 | 96 | 18 | 10/15/2022 10:39:33 AM | 3 | 3 | ||||||||||||||||||||||
| 2915 | 3/31/2021 8:10:10 AM | 10/28/2022 1:31:08 PM | Leak Credit | Kindly assess a leak for a swimming pool that had a crack <br><br><div><b>Consumption has not dropped since date of repairs.</b></div><div><b>Requested meter inspection from WW but consumer also to be advised to check for any other leaks or to reduce consumption.</b></div><div><b><br></b></div><div><b>Feedback: 21.10.2022:</b></div><div><b>Waterworks inspected the property and found the meter turning at 0.450 l/minute indicating an internal leak, possible underground, a H/C letter was left at the property. Current reading was 1868 on the 20/10/2022.</b></div><div><b>Query closed </b></div><div><b><br></b></div><div><b>Consumer to log a new query once repairs has been attended to and a new plumbers letter uploaded</b></div> | 27 | 3 | 2543 | 17 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-03-31T08:10:12.146Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-08-15T07:25:15.968Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T10:41:03.615Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T10:43:09.321Z"}] | 1 | 96 | 18 | 10/28/2022 1:31:08 PM | 138517 | 3 | 3 | |||||||||||||||||||||
| 2914 | 3/31/2021 8:06:13 AM | 7/13/2022 9:23:24 AM | water query /leak submitted a plumbers letter | water query<div>need 3 months of consumption for average</div><br><b>Monitoring Reason</b>: [need 3 more months of consumption for average]<div><br></div><div>6MONTHS POLICY DONE FOR PERIOD 2020/10</div><br/><b>Journal Number</b>: [439944]<br/><b>Journal Amount</b>: [4130.21] | 27 | 3 | 2542 | 74 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-03-31T08:06:30.172Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-08-14T09:46:56.427Z"},{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-10-17T10:07:21.461Z"},{"op":"R","uid":"8","un":"mariaanaw","dt":"2021-11-20T12:05:07.236Z"},{"op":"R","uid":"201","un":"nonkosim","dt":"2022-01-28T10:20:02.726Z"},{"op":"R","uid":"201","un":"nonkosim","dt":"2022-02-02T07:30:16.552Z"},{"op":"R","uid":"201","un":"nonkosim","dt":"2022-04-14T10:56:46.437Z"}] | 1 | 101 | 8 | 4/14/2022 11:00:37 AM | 134999 | 172 | 8 | |||||||||||||||||||||
| 2912 | 3/31/2021 8:01:32 AM | 2/2/2022 12:28:44 PM | high water consumption | <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 | 72 | 4 | 23 | 1 | 67 | 1292 | [{"op":"R","uid":"73","un":"nombongof","dt":"2021-03-31T08:01:34.318Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T10:40:33.099Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-29T10:33:53.051Z"}] | 9 | 123 | 14 | 2/2/2022 12:28:44 PM | 73 | 14 | ||||||||||||||||||||||
| 2911 | 3/31/2021 8:00:47 AM | 3/31/2021 8:02:26 AM | water query six month | water query | 3 | 2541 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-03-31T08:01:04.375Z"}] | 77 | 67 | 14 | |||||||||||||||||||||||||||
| 2910 | 3/31/2021 7:56:15 AM | 3/31/2021 7:56:18 AM | 1 | [{"op":"R","uid":"21","un":"heinrichs","dt":"2021-03-31T07:56:32.564Z"}] | 21 | ||||||||||||||||||||||||||||||||||||
| 2909 | 3/31/2021 7:50:07 AM | 10/24/2021 10:38:53 AM | Leak Credit | Kindly assess a leak for this account. | 30 | 3 | 2539 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-03-31T07:50:08.918Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T10:38:45.279Z"}] | 1 | 96 | 18 | 18 | |||||||||||||||||||||||||
| 2908 | 3/31/2021 7:48:20 AM | 3/28/2022 7:08:29 AM | high water consumption | quering for water in JUNE 2020, current reading 0834<br/><b>Journal Number</b>: [445403] | 24 | 3 | 2538 | 4 | 23 | 1 | 67 | 1291 | [{"op":"R","uid":"182","un":"zimbiniz","dt":"2021-03-31T07:48:24.011Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-10-19T13:23:18.168Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-10-19T13:30:28.440Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-10-29T12:45:32.712Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-11-10T10:08:47.560Z"}] | 1 | 96 | 4 | 4 | ||||||||||||||||||||||||
| 2907 | 3/31/2021 7:44:54 AM | 8/7/2021 7:09:05 AM | water query period of 2020-09-24 | water query<div>resolution 202106 write off clear debt, no adjustment due</div> | 27 | 3 | 2537 | 14 | 4 | 23 | 77 | 67 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-03-31T07:45:11.955Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-08-07T07:07:51.490Z"}] | 77 | 67 | 8/7/2021 7:09:05 AM | 14 | 17 | |||||||||||||||||||||||
| 2905 | 3/31/2021 7:33:36 AM | 2/2/2022 12:28:44 PM | high water consumption | <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 | 72 | 4 | 23 | 77 | 67 | [{"op":"R","uid":"73","un":"nombongof","dt":"2021-03-31T07:33:38.283Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T10:38:10.847Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-29T10:35:48.991Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-29T10:36:01.918Z"}] | 9 | 123 | 14 | 2/2/2022 12:28:44 PM | 73 | 14 | |||||||||||||||||||||||
| 2904 | 3/31/2021 7:32:26 AM | 10/13/2021 9:54:49 AM | Leak Credit | Kindly assess a leak that discovered in April 2020 | 27 | 3 | 2536 | 74 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-03-31T07:32:28.587Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-10-13T09:51:53.898Z"}] | 1 | 96 | 17 | 10/13/2021 9:54:49 AM | 172 | 17 | ||||||||||||||||||||||
| 2902 | 3/31/2021 7:31:36 AM | 10/17/2021 9:44:26 AM | water query | water query<div><br></div><div>debt written off</div> | 27 | 3 | 2535 | 14 | 4 | 23 | 77 | 67 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-03-31T07:31:53.277Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-10-17T09:41:45.536Z"}] | 1 | 101 | 6 | 10/17/2021 9:44:26 AM | 14 | 6 | ||||||||||||||||||||||
| 2903 | 3/31/2021 7:30:46 AM | 10/15/2022 10:40:12 AM | WATER LEAK CONSUMER SUBMITTED PLUMBERS LETTER | WATER LEAK CONSUMER SUBMITTED PLUMBERS LETTER<div><br></div><div>Duplicate query closed. Further assessment on ref #77050</div> | 27 | 3 | 2534 | 17 | 2 | 23 | 77 | 96 | [{"op":"R","uid":"18","un":"lindan","dt":"2021-03-31T07:31:03.544Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T10:36:09.841Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T10:36:41.905Z"}] | 1 | 96 | 18 | 10/15/2022 10:40:12 AM | 3 | 3 |