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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2806 | 3/29/2021 7:55:54 AM | 10/15/2022 10:18:20 AM | Leak Credit | Kindly assess a leak credit for this account<div><br></div><div>Resolved Sept 2021</div> | 27 | 3 | 2464 | 17 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-03-29T07:56:14.345Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T08:56:01.493Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T08:56:25.179Z"}] | 1 | 96 | 18 | 10/15/2022 10:18:20 AM | 3 | 3 | ||||||||||||||||||||||
| 2798 | 3/29/2021 7:52:01 AM | 3/29/2021 7:52:10 AM | 2 | ||||||||||||||||||||||||||||||||||||||
| 2805 | 3/29/2021 7:46:31 AM | 7/21/2021 10:07:00 AM | no valid query details submitted | no valid query details submitted | 27 | 3 | 12 | 2 | 23 | 1 | 44 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-03-29T07:46:50.983Z"},{"op":"R","uid":"1","un":"superuser","dt":"2021-03-29T07:55:22.338Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-15T12:56:46.011Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T10:06:58.259Z"}] | 1 | 44 | 7/21/2021 10:07:00 AM | 12 | 14 | ||||||||||||||||||||||||
| 2800 | 3/29/2021 7:25:55 AM | 11/3/2021 12:14:14 PM | 6 Month Policy | <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<br><br>Six month Policy-2020/08-2021/05 and 2019/11-202007<br><br><b>RESPONSE QRC</b>: Six month Policy ,Journal{827646) Authorized.<br><b>RESPONSE QRC</b>: Six month Policy ,Journal{826825) Authorized.<br><br></td> </tr></tbody></table> | 27 | 3 | 2462 | 14 | 2 | 23 | 1 | 95 | 1250 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-03-29T07:26:14.604Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-22T07:30:04.144Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-22T07:34:42.119Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-23T08:12:18.940Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T08:40:46.910Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T08:47:48.468Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T08:51:55.366Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T08:53:38.260Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T08:53:56.879Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T08:54:21.222Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T08:55:19.968Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-11-03T12:07:13.833Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-11-03T12:10:29.358Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-11-03T12:12:10.930Z"}] | 1 | 101 | 230 | 11/3/2021 12:14:14 PM | 14 | 230 | |||||||||||||||||||||
| 2801 | 3/29/2021 7:23:35 AM | 10/16/2022 8:59:22 AM | Leak credit | Kindly assess a leak credit for a leak that was fixed on the 17th July 2020<div><br></div><div>PLUMBERS LETTER MUST BE SUBMITTED </div><div>Journal processed and approved. Query resolved.</div> | 27 | 3 | 2461 | 74 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-03-29T07:23:56.419Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T08:39:48.815Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T08:40:28.347Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-11-14T11:36:18.875Z"},{"op":"R","uid":"214","un":"nandipan","dt":"2022-02-18T07:45:41.665Z"},{"op":"R","uid":"214","un":"nandipan","dt":"2022-02-18T08:23:27.014Z"}] | 1 | 96 | 214 | 2/18/2022 8:23:26 AM | 172 | 13 | ||||||||||||||||||||||
| 2799 | 3/29/2021 7:17:12 AM | 11/13/2022 8:04:40 AM | LEAK CREDIT | Kindly assess a leak credit that resulted from a geyser burst inspected on 22/12/2020<div>Plumber's letter received.</div><br/><b>Journal Number</b>: [963678] | 24 | 3 | 2459 | 17 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-03-29T07:17:27.643Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-08-07T07:40:58.281Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-08-18T12:13:03.023Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T08:38:09.997Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T08:38:29.832Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T08:39:24.611Z"}] | 1 | 96 | 18 | 13 | ||||||||||||||||||||||||
| 2796 | 3/26/2021 1:32:57 PM | 11/14/2021 9:33:12 AM | Six months policy | Please assess account for six months policy for period 2019/04-2020/05 | 30 | 3 | 2458 | 2 | 23 | 1 | 95 | [{"op":"R","uid":"173","un":"olgad","dt":"2021-03-26T13:29:06.631Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T08:37:06.092Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T08:37:56.163Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-11-14T08:57:00.201Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-11-14T09:33:12.713Z"}] | 1 | 101 | 18 | 119792 | 18 | ||||||||||||||||||||||||
| 2795 | 3/26/2021 1:31:23 PM | 10/29/2021 10:43:47 AM | Leak Credit | <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 | 74 | 2 | 23 | 1 | 95 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-03-26T13:31:27.574Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T08:35:59.538Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-29T10:42:56.411Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-29T10:43:05.431Z"}] | 9 | 123 | 14 | 10/29/2021 10:43:47 AM | 172 | 14 | |||||||||||||||||||||||
| 2790 | 3/26/2021 1:28:25 PM | 3/28/2022 7:10:22 AM | Six months | Please assess account for six months 2019/02-2020/07<br/><b>Journal Number</b>: [830699] | 24 | 3 | 2455 | 4 | 23 | 1 | 95 | [{"op":"R","uid":"173","un":"olgad","dt":"2021-03-26T13:24:35.141Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-08-11T08:57:44.346Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T08:34:53.786Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T08:35:14.691Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-10-31T07:50:53.313Z"}] | 1 | 101 | 18 | 18 | |||||||||||||||||||||||||
| 2793 | 3/26/2021 1:00:38 PM | 3/28/2022 6:35:04 AM | water | sent to billing<div>late termination 09/2021</div> | 27 | 3 | 2457 | 5 | 2 | 23 | 1 | 67 | 2137 | [{"op":"R","uid":"12","un":"thembesas","dt":"2021-03-26T12:56:53.219Z"},{"op":"R","uid":"5","un":"ivanh","dt":"2021-05-17T11:03:30.879Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-23T08:13:13.298Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-10-16T10:21:03.889Z"}] | 6 | 76 | 12 | 3/28/2022 6:35:04 AM | 5 | 12 | |||||||||||||||||||||
| 2791 | 3/26/2021 12:52:06 PM | 3/26/2021 12:52:09 PM | 2 | 2456 | [{"op":"R","uid":"21","un":"heinrichs","dt":"2021-03-26T12:48:21.450Z"}] | 21 | |||||||||||||||||||||||||||||||||||
| 2789 | 3/26/2021 12:39:50 PM | 8/7/2021 6:32:56 AM | Six months | Please assess account for six months policy 2019/06-2020/08<div><br></div><div>resolution write off cleared debt. account up to date no adjustment due</div> | 27 | 3 | 2454 | 75 | 4 | 23 | 1 | 95 | [{"op":"R","uid":"173","un":"olgad","dt":"2021-03-26T12:36:00.769Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-08-07T06:34:22.938Z"}] | 1 | 95 | 8/7/2021 6:32:56 AM | 173 | 6 | |||||||||||||||||||||||
| 2788 | 3/26/2021 12:31:54 PM | 11/3/2021 12:25:25 PM | LEAK CREDIT | Kindly assess a leak that was fixed 29 October 2020<div><b>Response QRC</b>: Plumber's letter received.</div><div><div><br></div><div><b>RESPONSE QRC</b>: Leak CR, Journal {902081}Authorized.</div></div> | 27 | 3 | 2453 | 74 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-03-26T12:32:17.785Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T08:33:51.348Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T08:34:12.476Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-11-03T12:22:13.309Z"}] | 1 | 96 | 230 | 11/3/2021 12:25:25 PM | 172 | 230 | ||||||||||||||||||||||
| 2787 | 3/26/2021 12:16:40 PM | 11/17/2022 9:31:38 AM | LEAK CREDIT | Kindly assess a leak credit 02/11/2020<div><div>consumption high since 2020/06,to contact consumer to check if there's leaks.</div><div>readings were changed twice 10/2020 and 03/2021 but no adjustment ,query will be sent to billing clerk</div></div><div><br></div><div>Consumer to resubmit letter with actual date of repairs for further assessment as letter received does not state the date of repairs (copy uploaded as reference)</div><div><br></div><div>Query Closed: </div><div>Consumer to log a new query and resubmit correct document with required information as per CC Policy. Letter to state date of repairs and what was repaired</div> | 27 | 3 | 2452 | 17 | 4 | 23 | 1 | 100 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-03-26T12:17:03.991Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-08-18T12:25:21.354Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-08-18T12:31:15.416Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-10-16T10:17:57.407Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-10-17T09:38:20.797Z"}] | 1 | 96 | 12 | 11/17/2022 9:31:38 AM | 137949 | 3 | 3 | |||||||||||||||||||||
| 2786 | 3/26/2021 11:52:58 AM | 2/19/2022 6:40:52 AM | Leak credit | no query detected | 27 | 3 | 2451 | 74 | 2 | 23 | 1 | 100 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-03-26T11:53:22.515Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T08:32:29.706Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T08:32:46.887Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T08:33:36.599Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2022-02-19T06:39:27.630Z"}] | 1 | 96 | 17 | 2/19/2022 6:40:52 AM | 172 | 17 | ||||||||||||||||||||||
| 2785 | 3/26/2021 11:39:14 AM | 4/12/2022 9:39:10 AM | Leak Credit | water leak credit applied.<br/><b>Journal Number</b>: [051386] | 30 | 3 | 2450 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-03-26T11:39:38.383Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T08:31:36.996Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T08:31:55.584Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-11-14T09:21:33.506Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-11-14T09:32:41.987Z"},{"op":"R","uid":"971","un":"test_frontline","dt":"2022-02-03T10:49:31.264Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2022-02-19T07:19:38.278Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2022-02-27T08:26:55.866Z"},{"op":"R","uid":"201","un":"nonkosim","dt":"2022-03-10T08:11:43.436Z"}] | 1 | 96 | 201 | 119791 | 201 | ||||||||||||||||||||||||
| 2784 | 3/26/2021 11:10:11 AM | 4/12/2022 9:47:18 AM | Six months | Please assess account for six months policy for period 2018/06-2021/01<div><br></div><div>SIX MONTHS POLICY ADJUSTMENT DONE<br></div><br/><b>Journal Number</b>: [994299] | 24 | 3 | 2449 | 4 | 23 | 1 | 95 | [{"op":"R","uid":"173","un":"olgad","dt":"2021-03-26T11:06:24.027Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-09-27T12:06:21.302Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-09-27T12:37:56.867Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T08:30:42.914Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T08:31:00.167Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-11-14T10:15:12.528Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-11-14T10:26:45.138Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-11-14T10:35:27.544Z"},{"op":"R","uid":"15","un":"chumab","dt":"2022-02-21T12:27:04.156Z"}] | 1 | 101 | 15 | 119795 | 15 | ||||||||||||||||||||||||
| 2783 | 3/26/2021 11:06:40 AM | 8/7/2021 9:16:41 AM | Six months | Please assess for six months policy for two periods (2018/10-2019/09 & 2019/10-2020/07)<div><br></div><div>account written off, no adjustment due</div> | 27 | 3 | 2448 | 75 | 4 | 23 | 1 | 95 | [{"op":"R","uid":"173","un":"olgad","dt":"2021-03-26T11:02:52.981Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-08-07T09:14:05.292Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-08-07T09:17:27.050Z"}] | 1 | 95 | 8/7/2021 9:16:41 AM | 173 | 6 | |||||||||||||||||||||||
| 2782 | 3/26/2021 11:01:26 AM | 8/18/2021 10:07:15 AM | Six months | Please assess account for six months for period 2019/02-2020/08<div><br></div><div>Duplicate query closed. Resolved on ref #12823</div> | 27 | 3 | 2447 | 75 | 2 | 23 | 1 | 95 | [{"op":"R","uid":"173","un":"olgad","dt":"2021-03-26T10:57:39.162Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-08-18T10:05:50.920Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-08-18T10:07:11.498Z"}] | 1 | 95 | 8/18/2021 10:07:15 AM | 173 | 3 | |||||||||||||||||||||||
| 2781 | 3/26/2021 10:49:27 AM | 8/20/2022 8:58:31 AM | Six months policy | SIX MONTHS ADJUSTMENT DONE<div>JNL NO: 113831</div><div><br></div><div>Journal Deleted as duplicate. Query resolved 13/12/2020 with a 06 month policy adjustment credit of -R12,277.99</div> | 27 | 3 | 2446 | 132 | 3 | 23 | 1 | 95 | [{"op":"R","uid":"173","un":"olgad","dt":"2021-03-26T10:45:39.654Z"},{"op":"R","uid":"15","un":"chumab","dt":"2021-08-23T07:37:41.080Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T08:29:43.778Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-24T08:30:01.812Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-11-14T11:26:14.183Z"}] | 1 | 101 | 18 | 8/20/2022 8:58:31 AM | 3 | 3 |