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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1953 | 3/1/2021 10:31:47 AM | 5/27/2021 4:24:21 AM | LEAK CR DUE WAITING FOR MARCH READING | LEAK CR DUE WAITING FOR MARCH READING | 27 | 3 | 1815 | 12 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-03-01T10:31:49.925Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-05-21T13:48:54.005Z"}] | 1 | 96 | 5/27/2021 4:24:21 AM | 12 | 12 | |||||||||||||||||||||||
| 1954 | 3/1/2021 10:29:25 AM | 2/2/2022 12:28:44 PM | high 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 | 72 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"73","un":"nombongof","dt":"2021-03-01T10:25:59.735Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-29T10:25:07.135Z"}] | 9 | 123 | 20 | 2/2/2022 12:28:44 PM | 73 | 20 | |||||||||||||||||||||||
| 1952 | 3/1/2021 10:22:22 AM | 7/21/2021 9:36:46 AM | no valid query details submitted | no valid query details submitted | 27 | 3 | 10 | 2 | 23 | 1 | 44 | [{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-03-01T10:22:24.483Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-15T13:12:13.414Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T09:36:38.062Z"}] | 1 | 44 | 7/21/2021 9:36:46 AM | 10 | 14 | ||||||||||||||||||||||||
| 1950 | 3/1/2021 9:19:03 AM | 3/1/2021 9:19:05 AM | 2 | 1814 | [{"op":"R","uid":"21","un":"heinrichs","dt":"2021-03-01T09:19:01.716Z"}] | 21 | |||||||||||||||||||||||||||||||||||
| 1949 | 3/1/2021 9:03:40 AM | 3/1/2021 9:03:43 AM | 2 | 1813 | [{"op":"R","uid":"21","un":"heinrichs","dt":"2021-03-01T09:03:38.886Z"}] | 21 | |||||||||||||||||||||||||||||||||||
| 1948 | 3/1/2021 8:37:37 AM | 3/1/2021 8:37:46 AM | 2 | [{"op":"R","uid":"21","un":"heinrichs","dt":"2021-03-01T08:37:36.207Z"}] | 21 | ||||||||||||||||||||||||||||||||||||
| 1947 | 3/1/2021 8:32:18 AM | 2/24/2022 11:12:21 AM | incorrect readings billed on account | consumer took readings and does not correspond with readings on system.<div>15/12/2020 reading 0140</div><div>15/01/2021 reading 0151</div><div>15/02/2021 reading 0170 reading was send by consumer to meterreading@buffalocity.gov.za</div><div> billed consumer in feb reading of 189 reading taken on 02/01/2021 according to reading captured on system.</div><br/><b>Meter Reading:</b> [17]<br/><b>Meter Reading Date:</b> [] | 27 | 3 | 1811 | 25 | 2 | 23 | 1 | 46 | 845 | [{"op":"R","uid":"25","un":"ernelizef","dt":"2021-03-01T08:32:16.400Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-29T10:24:36.487Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-30T07:30:15.688Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-11-10T12:59:57.491Z"}] | 1 | 111 | 12 | 2/24/2022 11:12:21 AM | 25 | 12 | |||||||||||||||||||||
| 1946 | 3/1/2021 7:39:03 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 | 77 | 67 | [{"op":"R","uid":"73","un":"nombongof","dt":"2021-03-01T07:35:49.018Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-29T10:24:16.989Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-30T09:51:17.506Z"}] | 9 | 123 | 14 | 2/2/2022 12:28:44 PM | 73 | 14 | |||||||||||||||||||||||
| 1945 | 3/1/2021 7:26:44 AM | 3/1/2021 7:26:46 AM | 2 | [{"op":"R","uid":"21","un":"heinrichs","dt":"2021-03-01T07:26:45.849Z"}] | 21 | ||||||||||||||||||||||||||||||||||||
| 1944 | 3/1/2021 7:20:08 AM | 2/2/2022 12:28:44 PM | high water 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. | 4 | 3 | 72 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"73","un":"nombongof","dt":"2021-03-01T07:17:50.276Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-29T10:23:52.337Z"}] | 9 | 123 | 20 | 2/2/2022 12:28:44 PM | 73 | 20 | |||||||||||||||||||||||
| 1941 | 2/27/2021 11:16:13 AM | 2/27/2021 11:16:20 AM | 2 | [{"op":"R","uid":"175","un":"zukiswat","dt":"2021-02-27T11:12:49.780Z"}] | 175 | ||||||||||||||||||||||||||||||||||||
| 1940 | 2/27/2021 11:11:37 AM | 2/17/2023 9:08:14 AM | water query | Can you please apply 6 months policy<br><b>Journal Number</b>: [830814]<div><br></div><div><b>qrc response</b></div><div><b>six months policy adjustment done for 2020/09 period, date processed 16/02/23, journal waiting to be authorized</b></div> | 24 | 3 | 1809 | 15 | 4 | 23 | 77 | 95 | [{"op":"R","uid":"175","un":"zukiswat","dt":"2021-02-27T11:08:12.976Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-08-11T10:39:19.813Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-29T10:23:30.796Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-30T07:29:49.711Z"}] | 1 | 101 | 20 | 142833 | 11 | |||||||||||||||||||||||
| 1939 | 2/27/2021 10:56:55 AM | 3/2/2022 8:22:38 AM | SEWERAGE 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. | 27 | 3 | 1808 | 37 | 2 | 23 | 93 | 105 | [{"op":"R","uid":"37","un":"sokanan","dt":"2021-02-27T10:56:57.369Z"},{"op":"R","uid":"5","un":"ivanh","dt":"2021-06-09T09:14:25.078Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-29T10:22:54.922Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-11-10T11:47:52.823Z"}] | 9 | 123 | 6 | 3/2/2022 8:22:38 AM | 37 | 6 | ||||||||||||||||||||||
| 1938 | 2/27/2021 10:46:23 AM | 11/12/2021 10:01:13 AM | LATE TERMINATION | LATE TERMINATION-2015/10-2016/10<br><b>Journal Number</b>: [522044]<div><br></div><div><b>RESPONSE QRC</b>: Late termination ,Journal {522044} Authorized.</div> | 27 | 3 | 1807 | 75 | 2 | 23 | 77 | 107 | [{"op":"R","uid":"37","un":"sokanan","dt":"2021-02-27T10:46:25.345Z"},{"op":"R","uid":"173","un":"olgad","dt":"2021-07-20T12:49:10.372Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-30T07:26:29.317Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-11-12T09:58:38.879Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-11-12T10:01:07.276Z"}] | 6 | 76 | 230 | 11/12/2021 10:01:13 AM | 173 | 230 | ||||||||||||||||||||||
| 1937 | 2/27/2021 10:39:01 AM | 3/2/2022 8:22:38 AM | ELECTRICITY QUERY | ELECTRICITY QUERY<div>Journal Done</div> | 27 | 3 | 1806 | 37 | 2 | 23 | 77 | 44 | [{"op":"R","uid":"37","un":"sokanan","dt":"2021-02-27T10:39:04.383Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-15T10:45:11.132Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-10-14T11:28:06.473Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-29T10:22:39.563Z"}] | 2 | 50 | 17 | 3/2/2022 8:22:38 AM | 37 | 17 | ||||||||||||||||||||||
| 1936 | 2/27/2021 10:20:32 AM | 3/2/2022 8:22:38 AM | WATER AND ELECTRICITY QUERY | WATER AND ELECTRICITY QUERY | 27 | 3 | 1805 | 37 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"37","un":"sokanan","dt":"2021-02-27T10:20:34.512Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-07-14T10:09:50.928Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2021-07-26T10:37:40.031Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-11-02T09:18:27.856Z"}] | 77 | 67 | 3/2/2022 8:22:38 AM | 37 | 230 | |||||||||||||||||||||||
| 1935 | 2/27/2021 10:13:30 AM | 3/2/2022 8:22:38 AM | ELECTRICITY QUERY | <span style="background-color: rgb(255, 255, 255);">readings updated</span> | 27 | 3 | 1804 | 37 | 3 | 23 | 77 | 44 | [{"op":"R","uid":"37","un":"sokanan","dt":"2021-02-27T10:13:32.994Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-21T07:47:12.226Z"}] | 77 | 44 | 3/2/2022 8:22:38 AM | 37 | 12 | |||||||||||||||||||||||
| 1934 | 2/27/2021 9:05:49 AM | 4/10/2023 11:00:32 AM | WATER LEAK QUERY,CONSUMER SUBMITTED PLUMBERS LETTER | <b>QRC RESPONSE: There seems to be no plumbers letter attached.</b><div><b> Can the consumer kindly re-submit plumbers letter.</b></div><div><br></div>2022/10 identified as back charged period and adjusted with a 06 month policy assessment<br><b>Journal Number</b>: [754678]<br><b>Journal Amount</b>: [-R20338.62] | 27 | 3 | 1803 | 17 | 2 | 23 | 77 | 96 | [{"op":"R","uid":"37","un":"sokanan","dt":"2021-02-27T09:05:52.002Z"},{"op":"R","uid":"37","un":"sokanan","dt":"2021-02-27T09:08:19.324Z"},{"op":"R","uid":"37","un":"sokanan","dt":"2021-02-27T09:08:31.955Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-29T10:21:55.887Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-11-14T07:49:29.159Z"}] | 1 | 96 | 12 | 4/10/2023 10:59:37 AM | 141555 | 3 | 3 | |||||||||||||||||||||
| 1933 | 2/27/2021 8:49:13 AM | 3/2/2022 8:22:38 AM | RATES QUERY | RATES QUERY<div><br></div><div>From Rates Dpt:</div><div><table border="0" cellpadding="0" cellspacing="0" width="547" style="border-collapse: collapse;width:410pt"><tbody><tr height="20" style="height:15.0pt"> <td height="20" class="xl65" width="547" style="height:15.0pt;width:410pt">No records for rezoning, Town Planning has confirmed </td></tr></tbody></table></div> | 27 | 3 | 1802 | 37 | 2 | 23 | 77 | 64 | [{"op":"R","uid":"37","un":"sokanan","dt":"2021-02-27T08:49:15.103Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-05-28T09:28:55.166Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2022-01-28T08:37:04.347Z"}] | 77 | 64 | 3/2/2022 8:22:38 AM | 37 | 3 | |||||||||||||||||||||||
| 1932 | 2/27/2021 8:43:22 AM | 3/2/2022 8:22:38 AM | WATER QUERY | WATER QUERY<div>JOurnal Done</div> | 27 | 3 | 1801 | 37 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"37","un":"sokanan","dt":"2021-02-27T08:43:24.813Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-10-14T08:49:00.673Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-10-14T08:49:13.795Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-11-14T07:57:32.716Z"}] | 1 | 96 | 17 | 3/2/2022 8:22:38 AM | 37 | 17 |