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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1126 | 1/30/2021 11:56:02 AM | 1/22/2022 4:47:38 PM | water query 6 month policy | water query | 27 | 3 | 1196 | 55 | 2 | 23 | 1 | 67 | 275 | [{"op":"R","uid":"13","un":"unathig","dt":"2021-01-30T11:52:55.057Z"},{"op":"R","uid":"56","un":"mihlet","dt":"2021-02-02T09:18:25.132Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-27T07:48:18.156Z"},{"op":"R","uid":"13","un":"unathig","dt":"2021-10-28T13:07:26.945Z"}] | 1 | 101 | 13 | 1/22/2022 4:47:38 PM | 56 | 13 | |||||||||||||||||||||
| 1125 | 1/30/2021 11:52:05 AM | 1/22/2022 4:47:38 PM | high water consumption | water query <div><br></div><div>6 MONTHS POLICY DONE</div> | 27 | 3 | 1195 | 55 | 3 | 23 | 1 | 67 | 1245 | [{"op":"R","uid":"13","un":"unathig","dt":"2021-01-30T11:48:57.595Z"},{"op":"R","uid":"56","un":"mihlet","dt":"2021-02-02T09:17:09.965Z"},{"op":"R","uid":"173","un":"olgad","dt":"2021-03-26T10:04:34.895Z"},{"op":"R","uid":"173","un":"olgad","dt":"2021-03-26T10:04:54.643Z"},{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-10-14T07:13:13.798Z"},{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-11-13T07:35:54.558Z"}] | 1 | 101 | 11 | 1/22/2022 4:47:38 PM | 56 | 11 | |||||||||||||||||||||
| 1124 | 1/30/2021 11:49:08 AM | 4/20/2022 12:15:16 PM | water query | water query 6 month policy | 27 | 3 | 1194 | 55 | 2 | 23 | 1 | 67 | 271 | [{"op":"R","uid":"13","un":"unathig","dt":"2021-01-30T11:46:01.543Z"},{"op":"R","uid":"13","un":"unathig","dt":"2021-02-01T07:44:42.849Z"},{"op":"R","uid":"56","un":"mihlet","dt":"2021-02-02T09:16:22.581Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-27T07:46:30.833Z"},{"op":"R","uid":"13","un":"unathig","dt":"2021-11-20T09:54:10.591Z"},{"op":"R","uid":"13","un":"unathig","dt":"2021-11-20T09:55:12.378Z"},{"op":"R","uid":"201","un":"nonkosim","dt":"2022-02-21T12:35:12.113Z"},{"op":"R","uid":"201","un":"nonkosim","dt":"2022-02-21T12:45:59.016Z"},{"op":"R","uid":"201","un":"nonkosim","dt":"2022-03-19T09:43:59.894Z"},{"op":"R","uid":"203","un":"babalwas","dt":"2022-04-20T12:15:16.870Z"}] | 1 | 101 | 13 | 4/20/2022 12:15:16 PM | 56 | 13 | |||||||||||||||||||||
| 1123 | 1/30/2021 11:39:39 AM | 2/24/2022 11:08:12 AM | high water consumption | water query | 4 | 3 | 1193 | 22 | 2 | 23 | 1 | 67 | 328 | [{"op":"R","uid":"13","un":"unathig","dt":"2021-01-30T11:36:32.341Z"},{"op":"R","uid":"56","un":"mihlet","dt":"2021-02-02T09:15:41.491Z"},{"op":"R","uid":"22","un":"asandam","dt":"2021-02-02T11:53:48.304Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-27T07:43:43.531Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-27T07:44:25.686Z"}] | 9 | 123 | 20 | 2/24/2022 11:08:12 AM | 22 | 20 | |||||||||||||||||||||
| 1122 | 1/30/2021 11:32:43 AM | 1/22/2022 4:47:38 PM | ACCOUNT QUERY | ACCOUNT QUERY<div>Journal Done</div> | 27 | 3 | 1192 | 55 | 4 | 23 | 1 | 67 | 268 | [{"op":"R","uid":"13","un":"unathig","dt":"2021-01-30T11:29:36.305Z"},{"op":"R","uid":"56","un":"mihlet","dt":"2021-02-02T09:15:07.596Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-10-14T06:56:16.300Z"},{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-11-15T06:33:35.805Z"}] | 1 | 101 | 17 | 1/22/2022 4:47:38 PM | 56 | 17 | |||||||||||||||||||||
| 1121 | 1/30/2021 11:28:51 AM | 1/22/2022 4:47:38 PM | WATER QUERY | WATER QUERY | 27 | 3 | 1191 | 55 | 4 | 23 | 1 | 67 | 266 | [{"op":"R","uid":"13","un":"unathig","dt":"2021-01-30T11:25:44.852Z"},{"op":"R","uid":"56","un":"mihlet","dt":"2021-02-02T09:14:37.895Z"},{"op":"R","uid":"13","un":"unathig","dt":"2021-10-23T09:21:39.528Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-27T07:41:02.580Z"}] | 1 | 101 | 13 | 1/22/2022 4:47:38 PM | 56 | 13 | |||||||||||||||||||||
| 1119 | 1/30/2021 11:20:33 AM | 3/28/2022 7:23:36 AM | water query 6 month policy | SIX MONTHS POLICY ADJUSTED<div>JRNL NO: 851279</div><br/><b>Journal Number</b>: [BJ71851279] | 24 | 3 | 1190 | 3 | 23 | 1 | 67 | 264 | [{"op":"R","uid":"13","un":"unathig","dt":"2021-01-30T11:17:26.511Z"},{"op":"R","uid":"56","un":"mihlet","dt":"2021-02-02T09:14:13.344Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-27T07:39:38.810Z"},{"op":"R","uid":"15","un":"chumab","dt":"2021-11-20T11:16:27.880Z"}] | 1 | 101 | 15 | 15 | ||||||||||||||||||||||||
| 1118 | 1/30/2021 11:15:52 AM | 1/22/2022 4:47:38 PM | water query | water query plus flag<div>W/Off cleared debt as at 2021/06</div> | 27 | 3 | 1189 | 55 | 3 | 23 | 1 | 67 | 262 | [{"op":"R","uid":"13","un":"unathig","dt":"2021-01-30T11:12:45.524Z"},{"op":"R","uid":"56","un":"mihlet","dt":"2021-02-02T09:13:38.710Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-10-17T09:32:01.607Z"}] | 1 | 101 | 3 | 1/22/2022 4:47:38 PM | 56 | 3 | |||||||||||||||||||||
| 1117 | 1/30/2021 11:11:36 AM | 6/17/2022 10:45:26 AM | high consumption 6 month policy | 6 month policy water query<div><br></div><div>SIX MONTHS POLICY ADJUSTMENT DONE</div><div>call consumer need proof of water meter ,send the email to w. to check which meter serve the erf</div><br/><b>Journal Number</b>: [113585] | 24 | 3 | 1188 | 3 | 23 | 1 | 67 | 260 | [{"op":"R","uid":"13","un":"unathig","dt":"2021-01-30T11:08:30.085Z"},{"op":"R","uid":"56","un":"mihlet","dt":"2021-02-02T09:13:15.482Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-10-16T07:00:17.403Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-10-29T08:12:30.806Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-10-29T09:21:38.577Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-10-29T09:22:37.795Z"}] | 1 | 101 | 4 | 119147 | 15 | |||||||||||||||||||||||
| 1116 | 1/30/2021 11:07:32 AM | 3/15/2022 10:37:09 AM | water query | <div><br></div><div><table border="0" cellpadding="0" cellspacing="0" width="668" style="border-collapse: collapse; width: 501pt;"><tbody><tr height="31" style="height: 23.45pt;"><td height="31" class="xl63" width="668" style="height: 23.45pt; 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></div> | 4 | 3 | 1187 | 55 | 3 | 23 | 1 | 67 | 258 | [{"op":"R","uid":"13","un":"unathig","dt":"2021-01-30T11:04:25.451Z"},{"op":"R","uid":"56","un":"mihlet","dt":"2021-02-02T09:12:51.436Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-06-17T08:50:52.931Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-08-03T10:46:05.584Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-08-03T10:47:12.654Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-08-05T10:16:58.602Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-10-16T11:11:42.261Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-27T07:15:23.612Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-27T07:21:55.565Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-11-10T10:23:59.765Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2022-02-11T12:42:16.005Z"},{"op":"R","uid":"192","un":"busisiwemr","dt":"2022-03-15T10:37:09.505Z"}] | 9 | 123 | 20 | 3/15/2022 10:37:09 AM | 56 | 20 | |||||||||||||||||||||
| 1115 | 1/30/2021 11:03:04 AM | 7/2/2022 12:04:02 PM | water query 6 month policy | water query<div><br></div><div>SIX MONTHS POLICY ADJUSTMENT DONE</div><br><b>Journal Number</b>: [10105433]<div><br></div><div><b><u><br></u></b></div><div><b><u>QRC RESPONSE:</u></b> Write offs settled arrear debt. Query Resolved.</div> | 27 | 3 | 1186 | 55 | 3 | 23 | 1 | 67 | 256 | [{"op":"R","uid":"13","un":"unathig","dt":"2021-01-30T10:59:57.549Z"},{"op":"R","uid":"56","un":"mihlet","dt":"2021-02-02T09:12:27.863Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-27T09:16:38.574Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-10-31T07:10:57.731Z"}] | 1 | 101 | 18 | 7/2/2022 12:04:02 PM | 8 | 8 | |||||||||||||||||||||
| 1114 | 1/30/2021 10:59:30 AM | 4/12/2022 9:43:30 AM | water query | water query 6 month policy<div><br></div><div>SIX MONTHS POLICY ADJUSTMENT DONE<br></div><br/><b>Journal Number</b>: [994314] | 24 | 3 | 1185 | 3 | 23 | 1 | 67 | 254 | [{"op":"R","uid":"13","un":"unathig","dt":"2021-01-30T10:56:23.276Z"},{"op":"R","uid":"56","un":"mihlet","dt":"2021-02-02T09:12:03.559Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-27T09:12:39.547Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-27T09:16:16.242Z"},{"op":"R","uid":"15","un":"chumab","dt":"2022-02-19T09:57:42.420Z"},{"op":"R","uid":"15","un":"chumab","dt":"2022-02-21T12:25:34.605Z"}] | 1 | 101 | 15 | 124333 | 15 | |||||||||||||||||||||||
| 1113 | 1/30/2021 10:49:15 AM | 7/2/2022 12:06:25 PM | water query 6 month policy | debt written off 06/2021 <div><b><u><br></u></b></div><div><b><u>QRC RESPONSE:</u></b> Query closed, write offs cleared the debt on water charges.</div> | 27 | 3 | 1184 | 75 | 3 | 23 | 1 | 98 | [{"op":"R","uid":"13","un":"unathig","dt":"2021-01-30T10:46:08.635Z"},{"op":"R","uid":"56","un":"mihlet","dt":"2021-02-02T09:10:53.631Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-10-23T07:04:00.230Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-27T08:58:08.352Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-27T09:12:24.801Z"}] | 1 | 50 | 18 | 7/2/2022 12:06:25 PM | 8 | 8 | ||||||||||||||||||||||
| 1112 | 1/30/2021 10:43:04 AM | 1/22/2022 4:47:38 PM | water query 6 month policy | water query<div><br></div><div>WRITE OFFS</div> | 27 | 3 | 1183 | 55 | 3 | 23 | 1 | 67 | 326 | [{"op":"R","uid":"13","un":"unathig","dt":"2021-01-30T10:39:57.214Z"},{"op":"R","uid":"56","un":"mihlet","dt":"2021-02-02T10:47:54.859Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-27T08:56:31.060Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-27T08:56:57.806Z"},{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-11-13T12:08:52.647Z"}] | 1 | 101 | 11 | 1/22/2022 4:47:38 PM | 56 | 11 | |||||||||||||||||||||
| 1111 | 1/30/2021 10:38:05 AM | 10/27/2021 8:56:51 AM | high water consumption | Six months Policy done<br/><b>Journal Number</b>: [826768] | 24 | 3 | 1182 | 2 | 23 | 1 | 67 | 324 | [{"op":"R","uid":"13","un":"unathig","dt":"2021-01-30T10:35:01.992Z"},{"op":"R","uid":"56","un":"mihlet","dt":"2021-02-02T10:47:17.350Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-08-07T09:34:19.218Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-27T08:54:40.417Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-27T08:55:48.907Z"}] | 1 | 111 | 18 | 18 | ||||||||||||||||||||||||
| 1110 | 1/30/2021 10:32:32 AM | 7/6/2022 10:34:24 AM | high water consumption | consumer submitted a plumbers letter<div><br></div><div>INVESTIGATE </div><br/><b>Journal Number</b>: [710341] | 24 | 3 | 1181 | 3 | 23 | 1 | 67 | 322 | [{"op":"R","uid":"13","un":"unathig","dt":"2021-01-30T10:29:25.606Z"},{"op":"R","uid":"56","un":"mihlet","dt":"2021-02-02T10:46:39.300Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-10-17T09:39:01.094Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-11-03T06:32:09.906Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-11-03T08:32:37.868Z"}] | 1 | 111 | 4 | 4 | ||||||||||||||||||||||||
| 1109 | 1/30/2021 10:27:40 AM | 1/22/2022 4:47:38 PM | 6 month policy water query | 6 month policy water query<div>debt written off</div> | 27 | 3 | 1180 | 55 | 3 | 23 | 1 | 67 | 320 | [{"op":"R","uid":"13","un":"unathig","dt":"2021-01-30T10:24:33.326Z"},{"op":"R","uid":"56","un":"mihlet","dt":"2021-02-02T10:46:03.223Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-10-16T10:32:05.024Z"}] | 1 | 101 | 6 | 1/22/2022 4:47:38 PM | 56 | 6 | |||||||||||||||||||||
| 1108 | 1/30/2021 10:20:14 AM | 2/24/2022 11:08:12 AM | water query | the is a high water consumption | 30 | 3 | 1179 | 3 | 23 | 1 | 67 | 330 | [{"op":"R","uid":"13","un":"unathig","dt":"2021-01-30T10:17:07.523Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2021-02-02T06:20:32.159Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2021-02-02T06:53:33.743Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2021-02-02T08:23:35.328Z"},{"op":"R","uid":"56","un":"mihlet","dt":"2021-02-02T10:45:04.842Z"},{"op":"R","uid":"22","un":"asandam","dt":"2021-02-02T12:02:54.098Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-27T08:51:57.649Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-27T08:52:20.700Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-27T08:53:12.393Z"}] | 1 | 111 | 18 | 18 | ||||||||||||||||||||||||
| 1107 | 1/30/2021 10:15:00 AM | 3/28/2022 6:33:19 AM | leak | Leak | 27 | 3 | 1178 | 3 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"13","un":"unathig","dt":"2021-01-30T10:11:53.535Z"},{"op":"R","uid":"56","un":"mihlet","dt":"2021-02-02T10:44:41.847Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-04-06T09:36:46.985Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-04-06T09:37:01.936Z"}] | 1 | 96 | 3/28/2022 6:33:19 AM | 3 | 3 | |||||||||||||||||||||||
| 1106 | 1/30/2021 10:07:06 AM | 1/22/2022 4:47:38 PM | 6 month policy water query | high water consumption<div><br></div><div><b>RESPONSE QRC</b>:6 Month policy ,Journal {071 803} Authorized.</div> | 27 | 3 | 1177 | 55 | 3 | 23 | 1 | 67 | 318 | [{"op":"R","uid":"13","un":"unathig","dt":"2021-01-30T10:03:59.390Z"},{"op":"R","uid":"56","un":"mihlet","dt":"2021-02-02T10:44:15.467Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-27T08:50:48.371Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-27T08:51:06.634Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-27T08:51:43.814Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-11-03T11:09:53.373Z"}] | 1 | 101 | 230 | 1/22/2022 4:47:38 PM | 56 | 230 |