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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1474 | 2/11/2021 9:09:29 AM | 2/24/2022 11:08:12 AM | incorrect readings | readings up-to-date | 27 | 3 | 1453 | 22 | 2 | 23 | 1 | 48 | 524 | [{"op":"R","uid":"22","un":"asandam","dt":"2021-02-11T09:09:31.265Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-30T07:30:44.808Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-15T08:32:21.029Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-15T08:32:42.521Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-10-16T06:48:58.410Z"}] | 1 | 111 | 6 | 2/24/2022 11:08:12 AM | 22 | 6 | |||||||||||||||||||||
| 1482 | 2/11/2021 9:07:12 AM | 10/17/2021 10:47:20 AM | High consumption - Water query | High consumption - Water query | 27 | 3 | 1452 | 33 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"33","un":"luxolon","dt":"2021-02-11T09:07:34.827Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-10-17T10:43:19.997Z"}] | 1 | 111 | 4 | 10/17/2021 10:47:20 AM | 33 | 4 | ||||||||||||||||||||||
| 1481 | 2/11/2021 8:58:22 AM | 10/28/2021 7:37:40 AM | Water Query | 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. | 4 | 3 | 1451 | 33 | 2 | 23 | 1 | 67 | 522 | [{"op":"R","uid":"33","un":"luxolon","dt":"2021-02-11T08:58:45.440Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-28T07:37:29.838Z"}] | 9 | 123 | 20 | 10/28/2021 7:37:40 AM | 33 | 20 | |||||||||||||||||||||
| 1479 | 2/11/2021 8:52:39 AM | 11/13/2021 7:57:33 AM | Water query (high consumption) | 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. | 27 | 3 | 1450 | 33 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"33","un":"luxolon","dt":"2021-02-11T08:53:02.379Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-28T07:37:06.142Z"},{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-11-13T07:56:13.766Z"}] | 9 | 123 | 11 | 11/13/2021 7:57:33 AM | 33 | 11 | ||||||||||||||||||||||
| 1480 | 2/11/2021 8:51:13 AM | 4/12/2022 9:42:39 AM | ELECTRICITY QUERY SIX MONTHS POLICY | ELECTRICITY QUERY SIX MONTHS POLICY<div>6 month policy processed for 201309/202009</div><br/><b>Journal Number</b>: [877810] | 24 | 3 | 1449 | 2 | 23 | 77 | 101 | [{"op":"R","uid":"37","un":"sokanan","dt":"2021-02-11T08:47:58.195Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-28T07:36:39.059Z"},{"op":"R","uid":"15","un":"chumab","dt":"2021-11-13T09:03:32.006Z"},{"op":"R","uid":"10","un":"mellozanef","dt":"2021-11-21T08:37:11.550Z"}] | 2 | 101 | 10 | 10 | |||||||||||||||||||||||||
| 1478 | 2/11/2021 8:45:05 AM | 3/2/2022 8:22:38 AM | WATER QUERY | 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. | 4 | 3 | 1448 | 37 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"37","un":"sokanan","dt":"2021-02-11T08:41:50.786Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-28T07:36:18.181Z"}] | 9 | 123 | 20 | 3/2/2022 8:22:38 AM | 37 | 20 | ||||||||||||||||||||||
| 1477 | 2/11/2021 8:44:08 AM | 4/11/2023 8:43:44 AM | Water ( high consumption) | six months policy applied <br><b>Journal Number</b>: [682243]<div><b><u>QRC -Response 2023/04/05</u></b></div><div>Six Months policy done.</div><div>WA has been Adjusted accordingly in terms of the adjustment policy (Inclusive of Vat)</div><div><b>Journal number :</b>(755270)has been submitted for review and authorization.</div><br/><b>Journal Amount</b>: [1981,38] | 27 | 3 | 1447 | 5 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"33","un":"luxolon","dt":"2021-02-11T08:44:31.122Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-30T07:27:16.494Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-30T07:40:37.859Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-30T10:13:20.023Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-30T12:00:12.497Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-28T07:35:53.575Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-11-08T11:35:41.343Z"}] | 9 | 123 | 12 | 4/11/2023 8:43:38 AM | 8 | 8 | ||||||||||||||||||||||
| 1476 | 2/11/2021 8:40:44 AM | 8/29/2021 10:11:52 AM | Water query | High consumption | 27 | 3 | 1446 | 33 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"33","un":"luxolon","dt":"2021-02-11T08:41:07.319Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-30T07:35:03.917Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-29T10:11:46.233Z"}] | 77 | 67 | 8/29/2021 10:11:52 AM | 33 | 12 | |||||||||||||||||||||||
| 1475 | 2/11/2021 8:31:44 AM | 3/2/2022 8:22:38 AM | water query | water query<div><br></div><div>2021/08/14- account consumption still high, unable to adjust leak credit. High consumption reported. Consumer to check for more leaks.</div> | 27 | 3 | 1445 | 37 | 3 | 23 | 1 | 67 | 515 | [{"op":"R","uid":"37","un":"sokanan","dt":"2021-02-11T08:28:29.676Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-30T07:00:22.150Z"},{"op":"R","uid":"13","un":"unathig","dt":"2021-08-14T06:30:06.602Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-28T07:34:56.535Z"},{"op":"R","uid":"15","un":"chumab","dt":"2021-11-13T10:21:01.193Z"},{"op":"R","uid":"15","un":"chumab","dt":"2021-11-13T10:21:20.369Z"}] | 1 | 96 | 15 | 3/2/2022 8:22:38 AM | 37 | 15 | |||||||||||||||||||||
| 1466 | 2/11/2021 8:31:13 AM | 10/28/2021 7:34:33 AM | Water query ( High consumption) | Water - High consumption<div>account inorder<br><div><br></div></div> | 27 | 3 | 1444 | 33 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"33","un":"luxolon","dt":"2021-02-11T08:31:36.258Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-29T06:42:11.778Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-10-23T12:23:22.483Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-28T07:34:02.409Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-28T07:34:33.765Z"}] | 1 | 101 | 6 | 10/28/2021 7:34:33 AM | 33 | 6 | ||||||||||||||||||||||
| 1473 | 2/11/2021 8:24:33 AM | 2/24/2022 11:08:12 AM | no meter is linked | no meter linked. | 27 | 3 | 1443 | 22 | 2 | 23 | 77 | 85 | [{"op":"R","uid":"22","un":"asandam","dt":"2021-02-11T08:24:36.115Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2021-08-02T08:08:18.630Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-10-23T07:24:19.655Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-28T07:33:23.501Z"}] | 1 | 113 | 20 | 2/24/2022 11:08:12 AM | 22 | 20 | ||||||||||||||||||||||
| 1471 | 2/11/2021 8:19:01 AM | 6/30/2022 1:11:07 PM | water query 6 month policy | water query <div><br></div><div>6months policy done for period 2019/09</div><br/><b>Journal Number</b>: [777730] | 27 | 3 | 1442 | 17 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"22","un":"asandam","dt":"2021-02-11T08:19:03.513Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-29T06:41:26.169Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-28T07:32:57.431Z"},{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-11-03T06:56:29.821Z"},{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-11-17T08:53:45.593Z"}] | 1 | 101 | 11 | 6/30/2022 1:11:07 PM | 134152 | 7 | 7 | |||||||||||||||||||||
| 1472 | 2/11/2021 8:16:19 AM | 3/2/2022 8:22:38 AM | SEWERAGE QUERY | SEWERAGE QUERY<div><br></div><div><b><u>QRC RESPONSE:</u></b></div><div>Charges are correct there is no duplication. Property is registerred on business and is therefore charged for the size of the land on one tariff (BS07) and for the number of pans on another (SE07).<br></div><div><br></div> | 27 | 3 | 1441 | 37 | 2 | 23 | 93 | 105 | [{"op":"R","uid":"37","un":"sokanan","dt":"2021-02-11T08:13:04.129Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2021-08-02T07:58:23.078Z"},{"op":"R","uid":"8","un":"mariaanaw","dt":"2021-08-07T08:06:48.427Z"},{"op":"R","uid":"8","un":"mariaanaw","dt":"2021-08-07T09:13:24.951Z"},{"op":"R","uid":"8","un":"mariaanaw","dt":"2021-08-07T09:14:47.689Z"}] | 93 | 105 | 3/2/2022 8:22:38 AM | 37 | 8 | |||||||||||||||||||||||
| 1470 | 2/11/2021 8:09:40 AM | 2/24/2022 11:08:12 AM | water query 6 month policy | water query | 27 | 3 | 1440 | 22 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"22","un":"asandam","dt":"2021-02-11T08:09:42.487Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-10-13T09:37:02.788Z"},{"op":"R","uid":"15","un":"chumab","dt":"2021-11-13T09:15:02.536Z"}] | 1 | 101 | 17 | 2/24/2022 11:08:12 AM | 22 | 17 | ||||||||||||||||||||||
| 1469 | 2/11/2021 8:07:25 AM | 3/2/2022 8:22:38 AM | LATE TERMINATION QUERY | LATE TERMINATION QUERY DONE | 27 | 3 | 1439 | 37 | 2 | 23 | 77 | 107 | [{"op":"R","uid":"37","un":"sokanan","dt":"2021-02-11T08:04:10.717Z"},{"op":"R","uid":"173","un":"olgad","dt":"2021-08-10T08:42:51.052Z"},{"op":"R","uid":"172","un":"sesonad","dt":"2021-09-14T12:53:58.060Z"},{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-10-13T09:57:22.740Z"},{"op":"R","uid":"15","un":"chumab","dt":"2021-11-13T10:19:03.543Z"}] | 4 | 119 | 15 | 3/2/2022 8:22:38 AM | 37 | 15 | ||||||||||||||||||||||
| 1468 | 2/11/2021 8:05:38 AM | 10/30/2022 10:17:58 AM | HIGH CONSUMPTION | water query<div>RESPONSE: POSSIBLE LEAK,TO REQUEST LEAK LETTER IF AVAILABLE FOR ADJUSTMENT</div><div><br></div><div><b><u>QRC RESPONSE: </u></b>Customer needs to log a new query and submit a plumbers if they had any repairs done, there is no report on front desk of any repairs done on BCM side.</div> | 27 | 3 | 1438 | 17 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"22","un":"asandam","dt":"2021-02-11T08:05:41.872Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-28T07:32:25.774Z"},{"op":"R","uid":"15","un":"chumab","dt":"2021-11-13T09:00:03.630Z"},{"op":"R","uid":"10","un":"mellozanef","dt":"2021-11-20T12:44:02.197Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2022-02-17T06:37:10.062Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2022-02-17T06:45:43.950Z"}] | 1 | 96 | 10 | 10/30/2022 10:17:58 AM | 138641 | 8 | 8 | |||||||||||||||||||||
| 1467 | 2/11/2021 8:00:44 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 | 2 | 23 | 1 | 67 | 510 | [{"op":"R","uid":"73","un":"nombongof","dt":"2021-02-11T08:01:07.642Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-29T06:20:47.399Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-28T07:31:40.830Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-30T10:34:00.456Z"}] | 9 | 123 | 14 | 2/2/2022 12:28:44 PM | 73 | 14 | ||||||||||||||||||||||
| 1465 | 2/11/2021 7:57:08 AM | 3/2/2022 8:22:38 AM | LATE TERMINATION QUERY | LATE TERMINATION QUERY | 27 | 3 | 1437 | 37 | 2 | 23 | 77 | 107 | [{"op":"R","uid":"37","un":"sokanan","dt":"2021-02-11T07:53:53.721Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-07T08:57:21.898Z"}] | 77 | 107 | 3/2/2022 8:22:38 AM | 37 | 12 | |||||||||||||||||||||||
| 1464 | 2/11/2021 7:48:26 AM | 3/2/2022 8:22:38 AM | LATE TERMINATION QUERY | LATE TERMINATION QUERY | 27 | 3 | 1436 | 37 | 2 | 23 | 77 | 107 | [{"op":"R","uid":"37","un":"sokanan","dt":"2021-02-11T07:45:11.406Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-07T08:59:18.032Z"},{"op":"R","uid":"173","un":"olgad","dt":"2021-08-10T10:50:27.427Z"}] | 77 | 107 | 3/2/2022 8:22:38 AM | 37 | 173 | |||||||||||||||||||||||
| 1463 | 2/11/2021 7:41:33 AM | 3/2/2022 8:22:38 AM | LATE TERMINATION QUERY | LATE TERMINATION QUERY | 27 | 3 | 1435 | 37 | 2 | 23 | 77 | 107 | [{"op":"R","uid":"37","un":"sokanan","dt":"2021-02-11T07:38:18.978Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-07T09:11:40.249Z"}] | 77 | 107 | 3/2/2022 8:22:38 AM | 37 | 12 |