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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1883 | 2/25/2021 10:47:26 AM | 2/24/2022 11:08:12 AM | transfer of services | ownership not changed ,indigent account opened. | 27 | 3 | 1768 | 22 | 4 | 23 | 77 | 107 | [{"op":"R","uid":"22","un":"asandam","dt":"2021-02-25T10:47:29.021Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-10-23T12:40:14.699Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-28T13:32:10.186Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-11-10T12:34:53.845Z"}] | 6 | 122 | 12 | 2/24/2022 11:08:12 AM | 22 | 12 | ||||||||||||||||||||||
| 1882 | 2/25/2021 10:08:33 AM | 2/25/2021 10:08:36 AM | 2 | [{"op":"R","uid":"33","un":"luxolon","dt":"2021-02-25T10:08:37.546Z"}] | 33 | ||||||||||||||||||||||||||||||||||||
| 1881 | 2/25/2021 10:02:57 AM | 10/28/2021 1:32:00 PM | Water query -- Overcharge | 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 | 1767 | 33 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"33","un":"luxolon","dt":"2021-02-25T10:03:01.569Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-28T13:31:46.910Z"}] | 9 | 123 | 20 | 10/28/2021 1:32:00 PM | 33 | 20 | ||||||||||||||||||||||
| 1880 | 2/25/2021 9:57:56 AM | 5/26/2021 1:11:11 PM | 2 | 1766 | [{"op":"R","uid":"36","un":"nomaromad","dt":"2021-02-25T09:58:00.178Z"},{"op":"R","uid":"5","un":"ivanh","dt":"2021-05-26T13:10:37.869Z"}] | 5 | |||||||||||||||||||||||||||||||||||
| 1879 | 2/25/2021 9:24:27 AM | 3/2/2022 9:17:59 AM | WATER QUERY | readings up-to-date | 27 | 3 | 1765 | 36 | 3 | 23 | 77 | 44 | [{"op":"R","uid":"36","un":"nomaromad","dt":"2021-02-25T09:24:31.146Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-15T10:40:32.677Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-15T10:41:11.402Z"}] | 77 | 44 | 3/2/2022 9:17:59 AM | 36 | 12 | |||||||||||||||||||||||
| 1878 | 2/25/2021 9:03:15 AM | 2/24/2022 11:08:12 AM | WATER QUERY | 2106 READING TAKEN 19/02/2021 WATER QUERY<div><br></div> | 27 | 3 | 1764 | 22 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"22","un":"asandam","dt":"2021-02-25T09:03:17.856Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-10-23T07:56:35.409Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-28T13:30:54.331Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-11-10T12:47:02.312Z"}] | 1 | 111 | 6 | 2/24/2022 11:08:12 AM | 22 | 6 | ||||||||||||||||||||||
| 1877 | 2/25/2021 9:00:27 AM | 3/2/2022 9:17:59 AM | WATER QUERY | WATER QUERY<div><br></div><div>NO REPORT ON FRONT DESK</div> | 27 | 3 | 1763 | 36 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"36","un":"nomaromad","dt":"2021-02-25T09:00:30.818Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-10-17T11:29:43.770Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-10-17T11:37:22.790Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-28T13:30:19.534Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-11-10T11:34:01.414Z"}] | 1 | 111 | 4 | 3/2/2022 9:17:59 AM | 36 | 4 | ||||||||||||||||||||||
| 1876 | 2/25/2021 8:47:48 AM | 10/13/2021 10:47:05 AM | WATER QUERY | WATER QUERY<br/><b>Journal Number</b>: [121148] | 27 | 3 | 1762 | 12 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"36","un":"nomaromad","dt":"2021-02-25T08:47:52.207Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-09-02T07:07:14.696Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-10-13T10:44:11.467Z"}] | 1 | 101 | 17 | 10/13/2021 10:47:05 AM | 12 | 17 | ||||||||||||||||||||||
| 1875 | 2/25/2021 8:11:20 AM | 2/23/2023 12:00:35 PM | WATER QUERY SIX MONTHS POLICY | WATER QUERY SIX MONTHS POLICY<div> 6 month policy processed for 201709/202012</div><br><b>Journal Number</b>: [884287]<div><br></div><div>Debt Write Off</div> | 27 | 3 | 1761 | 15 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"36","un":"nomaromad","dt":"2021-02-25T08:11:23.841Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-28T13:29:43.734Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-28T13:29:55.004Z"},{"op":"R","uid":"10","un":"mellozanef","dt":"2021-11-21T11:16:19.224Z"},{"op":"R","uid":"10","un":"mellozanef","dt":"2021-11-21T11:46:54.398Z"}] | 1 | 101 | 10 | 2/23/2023 12:00:34 PM | 17 | 17 | ||||||||||||||||||||||
| 1873 | 2/25/2021 7:25:58 AM | 3/28/2022 6:33:19 AM | Plumbers letter received | Plumbers letter received for repairs dated Nov 2020. Consumption to be monitored for 03 months, consumer also disputes new meter readings. | 27 | 3 | 1760 | 3 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"3","un":"fareezar","dt":"2021-02-25T07:26:02.068Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-07-14T10:08:30.724Z"}] | 1 | 96 | 3/28/2022 6:33:19 AM | 3 | 12 | |||||||||||||||||||||||
| 1871 | 2/25/2021 6:49:38 AM | 3/28/2022 6:33:19 AM | 06 month policy | 06 Month back charge amendment for the 2020/02 billing (CB).<div>Query also referred to Coastal Billing to attend to incorrect reading of Oct 2020</div><br/><b>Journal Amount</b>: [R1,063.40] | 27 | 3 | 1759 | 3 | 2 | 23 | 1 | 95 | [{"op":"R","uid":"3","un":"fareezar","dt":"2021-02-25T06:49:42.326Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-05-04T12:31:33.219Z"},{"op":"R","uid":"15","un":"chumab","dt":"2021-05-04T12:38:33.588Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-10-28T12:27:20.733Z"}] | 1 | 95 | 3/28/2022 6:33:19 AM | 3 | 230 | |||||||||||||||||||||||
| 1869 | 2/24/2021 3:11:07 PM | 2/24/2022 11:16:33 AM | water query and electricity | consumer are being charged water and electricity availability hence they got a bulk meter for both services | 30 | 3 | 1758 | 2 | 23 | 77 | 97 | [{"op":"R","uid":"23","un":"bevins","dt":"2021-02-24T15:07:45.085Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-28T13:28:44.664Z"}] | 1 | 50 | 20 | 20 | |||||||||||||||||||||||||
| 1869 | 2/24/2021 2:35:16 PM | 2/24/2021 2:35:18 PM | 2 | 1758 | [{"op":"R","uid":"21","un":"heinrichs","dt":"2021-02-24T14:35:21.040Z"}] | 21 | |||||||||||||||||||||||||||||||||||
| 1868 | 2/24/2021 1:26:22 PM | 9/22/2021 10:54:51 AM | refuse charged as business | credit incorrec t tariff and debit the correct one<br><b>Journal Number</b>: [234 805]<div><br></div><div><b><u>QRC RESPONSE: </u> </b>Journal authorised in 202011. Query Resolved.<br></div> | 27 | 3 | 1757 | 12 | 2 | 23 | 4 | 53 | 801 | [{"op":"R","uid":"12","un":"thembesas","dt":"2021-02-24T13:22:59.898Z"},{"op":"R","uid":"5","un":"ivanh","dt":"2021-06-18T12:06:43.071Z"},{"op":"R","uid":"8","un":"mariaanaw","dt":"2021-08-07T09:05:55.140Z"},{"op":"R","uid":"8","un":"mariaanaw","dt":"2021-08-07T09:06:39.269Z"},{"op":"R","uid":"5","un":"ivanh","dt":"2021-09-22T10:52:09.391Z"}] | 4 | 53 | 9/22/2021 10:54:51 AM | 12 | 5 | ||||||||||||||||||||||
| 1867 | 2/24/2021 1:23:29 PM | 3/28/2022 6:35:04 AM | water | cr wa 06/2019-06/2020<br><b>Journal Number</b>: [366656]<div>leak credit journal done in 20210226</div> | 27 | 3 | 1756 | 5 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"12","un":"thembesas","dt":"2021-02-24T13:20:07.350Z"},{"op":"R","uid":"5","un":"ivanh","dt":"2021-05-17T10:18:56.440Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-28T13:28:19.961Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-11-14T10:54:57.325Z"}] | 1 | 96 | 6 | 3/28/2022 6:35:04 AM | 5 | 6 | ||||||||||||||||||||||
| 1866 | 2/24/2021 1:21:25 PM | 3/2/2022 8:22:38 AM | WATER QUERY | WATER QUERY RESOLVED | 27 | 3 | 1755 | 37 | 3 | 23 | 77 | 67 | [{"op":"R","uid":"37","un":"sokanan","dt":"2021-02-24T13:18:10.344Z"},{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-10-14T07:08:53.005Z"}] | 1 | 50 | 11 | 3/2/2022 8:22:38 AM | 37 | 11 | ||||||||||||||||||||||
| 1865 | 2/24/2021 1:18:50 PM | 2/25/2022 9:01:52 AM | incorrect readings | readings up-to-date | 27 | 3 | 1754 | 29 | 2 | 23 | 1 | 48 | 798 | [{"op":"R","uid":"29","un":"thendekam","dt":"2021-02-24T13:18:52.093Z"},{"op":"R","uid":"29","un":"thendekam","dt":"2021-02-24T13:18:59.556Z"},{"op":"R","uid":"29","un":"thendekam","dt":"2021-02-24T13:19:27.505Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-15T08:46:15.063Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-15T08:46:58.705Z"}] | 1 | 48 | 2/25/2022 9:01:52 AM | 29 | 12 | ||||||||||||||||||||||
| 1864 | 2/24/2021 1:13:58 PM | 2/25/2022 9:01:52 AM | incorrect readings | account terminated | 27 | 3 | 1753 | 29 | 2 | 23 | 77 | 44 | [{"op":"R","uid":"29","un":"thendekam","dt":"2021-02-24T13:14:01.210Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-21T07:46:32.030Z"}] | 77 | 44 | 2/25/2022 9:01:52 AM | 29 | 12 | |||||||||||||||||||||||
| 1863 | 2/24/2021 1:10:12 PM | 2/25/2022 9:01:52 AM | INCORRECT READINGS | readings up-to-date | 27 | 3 | 1752 | 29 | 2 | 23 | 77 | 44 | [{"op":"R","uid":"29","un":"thendekam","dt":"2021-02-24T13:10:14.398Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-15T10:01:25.068Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-15T10:02:28.814Z"}] | 77 | 44 | 2/25/2022 9:01:52 AM | 29 | 12 | |||||||||||||||||||||||
| 1862 | 2/24/2021 1:01:35 PM | 3/28/2022 7:25:06 AM | SEWERAGE QUERY | SEWERAGE QUERY<div><br></div><div>2021-05-27 - E-Mailed Ntsika Sishuba (Inland investigator) for investigation to be done</div><br/><b>Journal Number</b>: [513229]<br/><b>Journal Amount</b>: [-R36,180.51] | 27 | 3 | 1751 | 17 | 3 | 23 | 93 | 56 | [{"op":"R","uid":"37","un":"sokanan","dt":"2021-02-24T12:58:13.329Z"},{"op":"R","uid":"5","un":"ivanh","dt":"2021-05-27T06:55:27.653Z"},{"op":"R","uid":"5","un":"ivanh","dt":"2021-06-09T08:57:45.200Z"},{"op":"R","uid":"5","un":"ivanh","dt":"2021-07-14T08:16:16.358Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-28T13:26:56.143Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-12-19T11:29:01.390Z"}] | 93 | 56 | 3 | 3/28/2022 7:25:06 AM | 17 | 3 |