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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 168 | 6/27/2020 10:09:38 AM | 10/13/2021 9:55:38 AM | split consumption | Transfer ownership as per registration date May 2020 to new owner 10423596. | 27 | 3 | 235 | 8 | 8 | 2 | 23 | 6 | 59 | [{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-10-13T09:55:10.149Z"}] | 1 | 96 | 11 | 10/13/2021 9:55:38 AM | 8 | 8 | 11 | |||||||||||||||||||
| 0 | 167 | 6/27/2020 9:56:53 AM | 3/28/2022 7:25:06 AM | no valid query details submitted | no valid query details submitted | 27 | 3 | 234 | 17 | 17 | 2 | 23 | 1 | 44 | [{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-15T07:54:19.884Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T07:47:29.826Z"}] | 1 | 44 | 3/28/2022 7:25:06 AM | 17 | 17 | 14 | ||||||||||||||||||||
| 0 | 166 | 6/27/2020 9:44:11 AM | 3/28/2022 7:25:06 AM | Late termination | Services not transferred | 27 | 3 | 233 | 17 | 17 | 2 | 23 | 6 | 107 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-07-13T09:36:50.422Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-15T07:51:48.411Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-16T11:10:51.765Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T07:43:23.620Z"}] | 6 | 107 | 3/28/2022 7:25:06 AM | 17 | 17 | 14 | ||||||||||||||||||||
| 0 | 165 | 6/27/2020 9:43:13 AM | 8/10/2021 10:33:50 AM | late termination | Transfer water meter from account 10157895 to account <span id="baseForm:a4jContentPanel"><span class="" style="width: 128px;">10422948 as per registration date </span></span><span id="baseForm:a4jContentPanel"><span class="" style="width: 232px;">2019/11/19</span></span><div>Regitration date 2019/11 ,billing Mdantsane region to terminate<span><span class="" style="width: 232px;"><br></span></span></div> | 27 | 3 | 232 | 8 | 8 | 4 | 23 | 6 | 59 | [{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-07T09:21:33.902Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-07T09:22:31.649Z"},{"op":"R","uid":"173","un":"olgad","dt":"2021-08-10T08:58:11.938Z"},{"op":"R","uid":"173","un":"olgad","dt":"2021-08-10T10:32:03.881Z"}] | 6 | 59 | 8/10/2021 10:33:50 AM | 8 | 8 | 173 | ||||||||||||||||||||
| 0 | 164 | 6/27/2020 9:27:14 AM | 8/8/2021 6:01:37 AM | high consumption | Write off due to indigent | 27 | 3 | 231 | 8 | 8 | 4 | 23 | 1 | 67 | [{"op":"R","uid":"17","un":"cwayitak","dt":"2021-08-07T10:25:10.401Z"}] | 1 | 67 | 8/8/2021 6:01:37 AM | 8 | 8 | 17 | ||||||||||||||||||||
| 0 | 163 | 6/27/2020 9:25:11 AM | 3/28/2022 7:25:06 AM | Water Query | Plumbers Letter received for a leak credit adjustment | 27 | 3 | 230 | 17 | 17 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-14T13:05:58.907Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-16T11:12:02.564Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T07:46:17.496Z"}] | 1 | 96 | 3/28/2022 7:25:06 AM | 17 | 17 | 14 | ||||||||||||||||||||
| 0 | 162 | 6/27/2020 9:19:00 AM | 3/28/2022 7:25:06 AM | Late termination | services are still charged on previous account. | 27 | 3 | 229 | 17 | 17 | 2 | 23 | 6 | 107 | [{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-15T08:26:32.975Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-16T11:14:49.884Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T08:13:39.662Z"}] | 6 | 107 | 3/28/2022 7:25:06 AM | 17 | 17 | 14 | ||||||||||||||||||||
| 0 | 161 | 6/27/2020 9:13:58 AM | 3/28/2022 7:25:06 AM | Water Query | Plumbers letter submitted for a leak credit. | 27 | 3 | 228 | 17 | 17 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"173","un":"olgad","dt":"2021-04-09T10:57:39.517Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-15T13:27:11.701Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-16T11:37:01.442Z"},{"op":"R","uid":"201","un":"nonkosim","dt":"2022-03-02T06:58:35.677Z"},{"op":"R","uid":"201","un":"nonkosim","dt":"2022-03-02T06:59:08.479Z"},{"op":"R","uid":"201","un":"nonkosim","dt":"2022-03-02T07:01:06.557Z"}] | 1 | 96 | 3/28/2022 7:25:06 AM | 17 | 17 | 201 | ||||||||||||||||||||
| 0 | 160 | 6/27/2020 9:08:07 AM | 2/21/2022 8:49:23 AM | Consumers account has been averaged and resulted in a high bill in 2015 when correct readings were captured. Query forwarded to billing department, midland. | 23 | 3 | 227 | 8 | 4 | 1 | 1 | 44 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-10-22T13:10:06.437Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-23T07:14:10.766Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-23T07:17:50.032Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-27T12:49:08.668Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-27T12:50:26.055Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-27T12:50:57.754Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2021-10-27T12:54:33.012Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2021-10-27T12:57:41.660Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-29T07:05:55.870Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2021-11-09T12:42:44.418Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2022-02-12T07:52:44.272Z"},{"op":"R","uid":"214","un":"nandipan","dt":"2022-02-20T11:52:01.581Z"},{"op":"R","uid":"214","un":"nandipan","dt":"2022-02-21T08:49:23.964Z"}] | 1 | 44 | 8 | 214 | ||||||||||||||||||||||||
| 0 | 159 | 6/27/2020 8:50:38 AM | 3/28/2022 7:08:29 AM | apply six months policy 201903-201911 | apply six months policy for the period 201903-201911 <br/><b>Journal Number</b>: [BJ71826821] | 27 | 3 | 226 | 6 | 8 | 2 | 23 | 1 | 95 | [{"op":"R","uid":"15","un":"chumab","dt":"2021-08-10T12:42:24.349Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-08-30T11:30:15.913Z"}] | 1 | 95 | 3/28/2022 7:08:29 AM | 8 | 6 | 3 | ||||||||||||||||||||
| 0 | 158 | 6/27/2020 8:33:03 AM | 3/28/2022 7:08:29 AM | APPLY SIX MONTHS POLICY 201902-202002 | APPLY SIX MONTHS POLICY 201902-202002.<br/><b>Journal Amount</b>: [70788.91] | 27 | 3 | 225 | 6 | 6 | 2 | 23 | 1 | 95 | [{"op":"R","uid":"2","un":"debbiecr","dt":"2021-05-28T08:45:54.776Z"}] | 1 | 95 | 3/28/2022 7:08:29 AM | 6 | 6 | 2 | ||||||||||||||||||||
| 0 | 157 | 6/27/2020 8:31:35 AM | 10/22/2021 1:07:47 PM | incorrect tariff | Water tariff changed from domestic to business. Account to be adjusted accordingly. | 30 | 3 | 224 | 8 | 2 | 23 | 1 | 50 | 1969 | [{"op":"R","uid":"5","un":"ivanh","dt":"2021-05-11T13:14:37.915Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-22T12:11:50.462Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-22T12:55:21.881Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-22T13:07:00.626Z"}] | 1 | 50 | 14 | 8 | 14 | |||||||||||||||||||||
| 0 | 156 | 6/27/2020 8:28:14 AM | 3/28/2022 7:25:06 AM | Late termination | Late termination | 27 | 3 | 223 | 17 | 17 | 2 | 23 | 6 | 107 | [{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-15T12:24:51.471Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-16T11:35:30.380Z"}] | 6 | 107 | 3/28/2022 7:25:06 AM | 17 | 17 | 20 | ||||||||||||||||||||
| 0 | 155 | 6/27/2020 8:02:29 AM | 3/28/2022 7:25:06 AM | Water Query | Leak Credit, Plumbers letter Submitted | 27 | 3 | 222 | 17 | 17 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-15T12:09:31.320Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-16T11:32:54.081Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T08:21:32.447Z"}] | 1 | 96 | 3/28/2022 7:25:06 AM | 17 | 17 | 14 | ||||||||||||||||||||
| 0 | 154 | 6/27/2020 7:57:00 AM | 3/28/2022 7:25:06 AM | Water Query | Leak Credit | 27 | 3 | 221 | 17 | 17 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-14T13:07:35.260Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-16T07:46:25.985Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-16T11:12:19.490Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T07:46:55.032Z"}] | 1 | 96 | 3/28/2022 7:25:06 AM | 17 | 17 | 14 | ||||||||||||||||||||
| 0 | 153 | 6/27/2020 7:48:52 AM | 5/11/2022 12:05:05 PM | Electricity | <table border="0" cellpadding="0" cellspacing="0" width="609" style="border-collapse: collapse;width:457pt"><tbody><tr height="31" style="mso-height-source:userset;height:23.45pt"> <td height="31" class="xl65" width="609" style="height:23.45pt;width:457pt">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 | 220 | 8 | 8 | 3 | 1 | 2 | 44 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-10-22T12:08:35.308Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-22T12:10:09.650Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2022-05-11T12:05:03.622Z"}] | 9 | 123 | 14 | 5/11/2022 12:05:05 PM | 8 | 8 | 14 | |||||||||||||||||||
| 0 | 152 | 6/27/2020 7:44:26 AM | 3/28/2022 7:25:06 AM | Water Query | Six Months Policy to be applied | 27 | 3 | 219 | 17 | 17 | 2 | 23 | 1 | 95 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-07-13T09:37:44.422Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-15T07:52:23.369Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-16T11:11:12.472Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T07:44:47.321Z"}] | 1 | 95 | 3/28/2022 7:25:06 AM | 17 | 17 | 14 | ||||||||||||||||||||
| 0 | 151 | 6/27/2020 7:38:42 AM | 5/9/2022 7:51:25 AM | water Query | Six Months Policy to be applied-2019-202009<br><b>Journal Number</b>: [421700]<br/><b>Journal Amount</b>: [-R4,474.98] | 27 | 3 | 218 | 17 | 7 | 2 | 23 | 1 | 67 | 1603 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-04-28T08:16:34.893Z"},{"op":"R","uid":"196","un":"lazolaw","dt":"2021-08-13T13:39:26.543Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-22T12:04:38.487Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-10-31T08:42:02.879Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-11-13T10:13:57.199Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-11-14T06:50:13.343Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2022-05-09T07:50:44.651Z"}] | 1 | 101 | 3 | 5/9/2022 7:51:25 AM | 7 | 17 | 3 | ||||||||||||||||||
| 0 | 150 | 6/27/2020 7:34:02 AM | 8/14/2021 6:54:58 AM | water | Leak Credit due for period 201907-202001, plumbers report received. Account to be adjusted.<div><br></div><div>Resolved Jan 2021</div> | 27 | 3 | 217 | 8 | 75 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"12","un":"thembesas","dt":"2021-05-30T10:55:58.946Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-05-30T10:56:58.990Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-08-14T06:52:57.428Z"}] | 1 | 96 | 8/14/2021 6:54:58 AM | 173 | 8 | 3 | ||||||||||||||||||||
| 0 | 149 | 6/27/2020 7:23:40 AM | 3/28/2022 7:25:06 AM | Late termination | property sold but services were not transfered | 27 | 3 | 207 | 17 | 17 | 2 | 23 | 6 | 107 | [{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-15T12:14:32.000Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-16T11:33:44.390Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T08:25:43.339Z"}] | 6 | 107 | 3/28/2022 7:25:06 AM | 17 | 17 | 14 |