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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2707 | 3/25/2021 8:56:44 AM | 2/23/2023 10:33:37 AM | 6 Months Policy | Assess a Six Months Policy for the Period 201905-202004<div><br></div><div>Debt Write Off 202206</div> | 27 | 3 | 2386 | 15 | 2 | 23 | 1 | 95 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-03-25T08:57:10.508Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T07:33:23.354Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T07:33:39.458Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T07:34:17.803Z"}] | 1 | 101 | 18 | 2/23/2023 10:33:37 AM | 17 | 17 | ||||||||||||||||||||||
| 2709 | 3/25/2021 8:56:31 AM | 3/28/2022 6:33:19 AM | leak credit adjustment done | leak credit adjustment done<br><b>Journal Number</b>: [704471]<div><br></div><div>Query Resolved with leak credit</div> | 27 | 3 | 2385 | 3 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"6","un":"lusandad","dt":"2021-03-25T08:56:36.204Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-03-26T11:39:14.639Z"}] | 1 | 96 | 3/28/2022 6:33:19 AM | 3 | 3 | |||||||||||||||||||||||
| 2708 | 3/25/2021 8:56:24 AM | 11/15/2022 12:44:50 PM | Leak letter | Plumbers letter attached <div><br></div><div>QRC RESPONSE: Query Closed</div><div>No letter traced</div><div>Consumer to log a new query and upload a signed copy of the plumbers letter</div> | 27 | 3 | 2384 | 17 | 3 | 23 | 1 | 96 | [{"op":"R","uid":"173","un":"olgad","dt":"2021-03-25T08:56:26.256Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-08-15T07:08:40.561Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T07:32:18.349Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T07:32:52.412Z"}] | 1 | 96 | 18 | 11/15/2022 12:44:50 PM | 3 | 3 | ||||||||||||||||||||||
| 2705 | 3/25/2021 8:29:58 AM | 11/27/2021 9:11:31 AM | 6 Months Policy | Kindly assess a Six Months Policy for the period 201708-202009 | 27 | 3 | 2383 | 74 | 2 | 23 | 1 | 95 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-03-25T08:30:22.851Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T07:17:51.793Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T07:18:06.412Z"},{"op":"R","uid":"10","un":"mellozanef","dt":"2021-11-27T09:07:14.253Z"},{"op":"R","uid":"10","un":"mellozanef","dt":"2021-11-27T09:08:11.441Z"},{"op":"R","uid":"10","un":"mellozanef","dt":"2021-11-27T09:09:48.674Z"}] | 1 | 101 | 10 | 11/27/2021 9:11:31 AM | 172 | 10 | ||||||||||||||||||||||
| 2700 | 3/25/2021 8:26:38 AM | 2/23/2023 10:29:11 AM | Six months policy | Please assess account for six months policy<br><b>Journal Number</b>: [BJ71127649]<div>Debt write off</div> | 27 | 3 | 2382 | 15 | 3 | 23 | 1 | 95 | [{"op":"R","uid":"173","un":"olgad","dt":"2021-03-25T08:26:40.181Z"},{"op":"R","uid":"15","un":"chumab","dt":"2021-08-23T07:36:39.732Z"},{"op":"R","uid":"15","un":"chumab","dt":"2021-09-22T12:12:23.496Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T07:16:10.924Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T07:16:48.016Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T07:17:27.913Z"}] | 1 | 101 | 18 | 2/23/2023 10:29:11 AM | 17 | 17 | ||||||||||||||||||||||
| 2704 | 3/25/2021 8:23:19 AM | 2/17/2023 12:17:46 PM | WATER QUERY COSUMER SUBMITTED PLUMBERS LETTER | WATER QUERY CONSUMER SUBMITTED PLUMBERS LETTER<div>QRC Response : DATE 17/02/2023</div><div>Account adjusted 02/2021</div> | 27 | 3 | 2381 | 5 | 2 | 23 | 77 | 96 | [{"op":"R","uid":"18","un":"lindan","dt":"2021-03-25T08:23:44.979Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-06-06T10:15:49.843Z"}] | 77 | 96 | 2/17/2023 12:17:46 PM | 12 | 12 | |||||||||||||||||||||||
| 2703 | 3/25/2021 8:15:30 AM | 5/19/2022 7:53:10 AM | WATER QUERY SIX MONTHS POLICY | WATER QUERY SIX MONTHS POLICY | 27 | 3 | 2380 | 18 | 2 | 23 | 77 | 95 | [{"op":"R","uid":"18","un":"lindan","dt":"2021-03-25T08:15:55.396Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-10-06T11:41:15.397Z"},{"op":"R","uid":"13","un":"unathig","dt":"2021-10-17T08:52:57.688Z"}] | 1 | 101 | 13 | 5/19/2022 7:53:10 AM | 18 | 13 | ||||||||||||||||||||||
| 2702 | 3/25/2021 8:12:49 AM | 5/19/2022 7:51:12 AM | high consumption of 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="xl63" 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="xl64" 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 | 2379 | 16 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"16","un":"cumilem","dt":"2021-03-25T08:12:51.886Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-23T08:16:49.489Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T07:12:43.942Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T07:14:30.866Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T07:15:47.788Z"}] | 9 | 123 | 18 | 5/19/2022 7:51:12 AM | 16 | 18 | ||||||||||||||||||||||
| 2701 | 3/25/2021 8:09:01 AM | 2/23/2023 10:10:40 AM | 6 Months Policy | Kindly assess a Six Months Policy for the period 201901/202008<div>6 month policy processed</div><br><b>Journal Number</b>: [156909]<div><br></div><div>Debt Write Off</div> | 27 | 3 | 2378 | 15 | 2 | 23 | 1 | 95 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-03-25T08:09:26.167Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T07:11:12.366Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T07:11:56.364Z"},{"op":"R","uid":"10","un":"mellozanef","dt":"2021-11-27T09:07:45.375Z"},{"op":"R","uid":"10","un":"mellozanef","dt":"2021-11-27T09:08:35.586Z"},{"op":"R","uid":"10","un":"mellozanef","dt":"2021-11-27T09:10:22.333Z"},{"op":"R","uid":"10","un":"mellozanef","dt":"2022-04-11T12:24:07.050Z"}] | 1 | 101 | 10 | 2/23/2023 10:10:39 AM | 17 | 17 | ||||||||||||||||||||||
| 2696 | 3/25/2021 7:57:47 AM | 2/23/2023 10:03:01 AM | Six months policy | Please assess account for six months policy<div><br></div><div>Debt write off </div> | 27 | 3 | 2374 | 15 | 4 | 23 | 1 | 95 | [{"op":"R","uid":"173","un":"olgad","dt":"2021-03-25T07:57:49.941Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T07:09:41.910Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T07:10:04.981Z"}] | 1 | 101 | 18 | 2/23/2023 10:03:01 AM | 17 | 17 | ||||||||||||||||||||||
| 2697 | 3/25/2021 7:56:36 AM | 11/2/2021 6:31:49 AM | high consumption - plumbers letter submitted | A Pool And Spa Specialist fixed leak in pool on December 2020. The supporting document was submitted.<br/><b>Journal Number</b>: [880207]<br/><b>Journal Amount</b>: [-R10,734.56] | 27 | 3 | 2376 | 12 | 2 | 23 | 77 | 96 | [{"op":"R","uid":"16","un":"cumilem","dt":"2021-03-25T07:56:38.027Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-08-15T07:51:51.671Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T07:07:56.767Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T07:09:19.969Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-10-31T07:59:34.843Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-11-02T06:31:21.906Z"}] | 1 | 96 | 3 | 11/2/2021 6:31:49 AM | 12 | 3 | ||||||||||||||||||||||
| 2698 | 3/25/2021 7:54:46 AM | 3/28/2022 7:10:22 AM | 6 Months Policy | Kindly assess a Six Months Policy for the period 201903 - 202102<div><br></div><div>6 months policy journal done </div><br/><b>Journal Number</b>: [826823] | 24 | 3 | 2375 | 2 | 23 | 1 | 95 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-03-25T07:55:11.150Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-08-08T09:23:00.078Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T07:06:16.821Z"}] | 1 | 101 | 18 | 18 | |||||||||||||||||||||||||
| 2693 | 3/25/2021 7:37:54 AM | 5/19/2022 7:53:10 AM | WATER QUERY | <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 | 2373 | 18 | 2 | 23 | 77 | 95 | [{"op":"R","uid":"18","un":"lindan","dt":"2021-03-25T07:38:37.779Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T12:49:05.546Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T07:04:29.271Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T07:04:46.339Z"}] | 9 | 123 | 18 | 5/19/2022 7:53:10 AM | 18 | 18 | ||||||||||||||||||||||
| 2694 | 3/25/2021 7:36:16 AM | 7/21/2021 10:04:45 AM | no valid query details submitted | no valid query details submitted | 27 | 3 | 2372 | 7 | 2 | 23 | 1 | 44 | [{"op":"R","uid":"173","un":"olgad","dt":"2021-03-25T07:36:17.955Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-15T12:57:40.074Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T10:04:46.142Z"}] | 1 | 44 | 7/21/2021 10:04:45 AM | 7 | 14 | |||||||||||||||||||||||
| 2692 | 3/25/2021 7:30:09 AM | 8/30/2021 11:53:40 AM | Six months policy | Please assess account for six months policy<div><br></div><div>6 months policy journal done </div> | 27 | 3 | 2371 | 75 | 4 | 23 | 1 | 95 | [{"op":"R","uid":"173","un":"olgad","dt":"2021-03-25T07:30:10.999Z"},{"op":"R","uid":"196","un":"lazolaw","dt":"2021-08-03T11:20:59.142Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-08-07T07:12:37.210Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-08-07T07:13:43.353Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-08-30T11:51:28.747Z"}] | 1 | 95 | 8/30/2021 11:53:40 AM | 173 | 3 | |||||||||||||||||||||||
| 2691 | 3/25/2021 7:26:18 AM | 10/23/2021 12:48:28 PM | WATER QUERY SIX MONTHS POLICY | WATER QUERY SIX MONTHS POLICY<br/><b>Journal Number</b>: [BJ71127659] | 24 | 3 | 2370 | 3 | 23 | 1 | 95 | [{"op":"R","uid":"18","un":"lindan","dt":"2021-03-25T07:26:55.821Z"},{"op":"R","uid":"15","un":"chumab","dt":"2021-08-23T07:35:46.621Z"},{"op":"R","uid":"15","un":"chumab","dt":"2021-09-22T12:15:15.083Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T12:48:08.874Z"}] | 1 | 101 | 18 | 18 | |||||||||||||||||||||||||
| 2689 | 3/24/2021 3:49:01 PM | 2/24/2022 11:12:21 AM | water query | no water meter billed on account<div>account in order</div> | 27 | 3 | 2369 | 25 | 2 | 23 | 1 | 58 | [{"op":"R","uid":"25","un":"ernelizef","dt":"2021-03-24T15:49:27.531Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2021-08-02T08:56:21.913Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-10-17T09:35:37.869Z"}] | 1 | 113 | 12 | 2/24/2022 11:12:21 AM | 25 | 12 | ||||||||||||||||||||||
| 2688 | 3/24/2021 1:50:32 PM | 7/21/2021 10:04:00 AM | no valid query details submitted | no valid query details submitted | 27 | 3 | 2368 | 75 | 2 | 23 | 1 | 44 | [{"op":"R","uid":"173","un":"olgad","dt":"2021-03-24T13:50:58.783Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-15T12:58:04.283Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T10:03:56.281Z"}] | 1 | 44 | 7/21/2021 10:04:00 AM | 173 | 14 | |||||||||||||||||||||||
| 2687 | 3/24/2021 1:46:38 PM | 2/17/2023 12:26:57 PM | Possible leak | possible leak but need to monitor consumption for 3 months<br><b>Monitoring Reason</b>: [consumption still high]<div>Debt written off 2021/06</div> | 27 | 3 | 2367 | 17 | 4 | 23 | 1 | 95 | [{"op":"R","uid":"173","un":"olgad","dt":"2021-03-24T13:47:04.492Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T12:47:16.883Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-11-14T10:09:32.167Z"}] | 1 | 96 | 17 | 2/17/2023 12:26:57 PM | 12 | 12 | ||||||||||||||||||||||
| 2686 | 3/24/2021 1:39:33 PM | 10/30/2021 10:14:22 AM | Six months policy | Please assess account for six months policy<br/><b>Journal Number</b>: [BJ71439570] | 24 | 3 | 2366 | 4 | 23 | 1 | 95 | [{"op":"R","uid":"173","un":"olgad","dt":"2021-03-24T13:39:59.185Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-23T12:46:14.728Z"},{"op":"R","uid":"15","un":"chumab","dt":"2021-10-30T10:14:04.767Z"}] | 1 | 101 | 15 | 15 |