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 | 307 | 7/27/2020 10:49:34 AM | 3/28/2022 7:10:22 AM | LOG QUERY | <br><b>Account terminated</b> | 27 | 3 | 431 | 11 | 11 | 2 | 23 | 3 | [{"op":"R","uid":"2","un":"debbiecr","dt":"2021-06-07T09:27:13.140Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-06-08T12:22:35.820Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2021-08-02T09:36:24.497Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-24T08:31:02.612Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-24T08:34:52.189Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-11-13T10:27:23.087Z"}] | 6 | 76 | 12 | 3/28/2022 7:10:22 AM | 11 | 11 | 12 | ||||||||||||||||||||
| 0 | 306 | 7/27/2020 7:33:40 AM | 4/11/2022 6:02:16 AM | 27 | 3 | 430 | 11 | 11 | 2 | 23 | [{"op":"R","uid":"201","un":"nonkosim","dt":"2022-04-05T11:30:24.322Z"},{"op":"R","uid":"201","un":"nonkosim","dt":"2022-04-11T06:12:36.143Z"}] | 201 | 4/11/2022 6:02:16 AM | 11 | 11 | 201 | |||||||||||||||||||||||||
| 0 | 305 | 7/27/2020 7:29:40 AM | 3/28/2022 7:10:22 AM | 27 | 3 | 429 | 11 | 11 | 2 | 23 | 1 | 1 | 3/28/2022 7:10:22 AM | 11 | 11 | ||||||||||||||||||||||||||
| 0 | 304 | 7/27/2020 7:24:49 AM | 3/28/2022 7:10:22 AM | 27 | 3 | 428 | 11 | 11 | 2 | 23 | 1 | [{"op":"R","uid":"756","un":"nontandazos","dt":"2022-01-28T11:09:41.107Z"}] | 1 | 3/28/2022 7:10:22 AM | 11 | 11 | 756 | ||||||||||||||||||||||||
| 0 | 303 | 7/26/2020 11:10:03 AM | 3/2/2022 7:53:56 AM | water | <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">Account adjusted 05/2021</td></tr></tbody></table> | 27 | 3 | 427 | 34 | 34 | 2 | 23 | 1 | 67 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-10-24T08:28:50.582Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-24T08:29:35.552Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-11-13T10:21:31.499Z"}] | 1 | 111 | 12 | 3/2/2022 7:53:56 AM | 34 | 34 | 12 | |||||||||||||||||||
| 0 | 302 | 7/25/2020 5:27:51 PM | 3/2/2022 7:53:56 AM | Log Query | <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 | 425 | 34 | 34 | 2 | 23 | 1 | 67 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-10-24T08:27:21.091Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-24T08:28:13.856Z"}] | 9 | 123 | 14 | 3/2/2022 7:53:56 AM | 34 | 34 | 14 | |||||||||||||||||||
| 0 | 301 | 7/24/2020 3:11:49 PM | 3/2/2022 7:53:56 AM | Log Query | <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 | 424 | 34 | 34 | 2 | 23 | 1 | 67 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-10-24T08:25:32.256Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-24T08:26:33.692Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-11-13T10:00:23.173Z"}] | 9 | 123 | 14 | 3/2/2022 7:53:56 AM | 34 | 34 | 14 | |||||||||||||||||||
| 0 | 300 | 7/24/2020 1:51:16 PM | 3/2/2022 7:53:56 AM | Log Query | <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 | 423 | 34 | 34 | 2 | 23 | 1 | 67 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-10-24T08:24:01.590Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-24T08:24:49.016Z"}] | 9 | 123 | 14 | 3/2/2022 7:53:56 AM | 34 | 34 | 14 | |||||||||||||||||||
| 0 | 299 | 7/24/2020 1:44:48 PM | 3/28/2022 6:35:04 AM | water query | Journal Done | 27 | 3 | 422 | 5 | 5 | 2 | 23 | 1 | 67 | [{"op":"R","uid":"17","un":"cwayitak","dt":"2021-10-13T10:59:13.231Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-10-22T10:39:51.197Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-11-13T09:58:02.533Z"}] | 1 | 101 | 17 | 3/28/2022 6:35:04 AM | 5 | 5 | 17 | |||||||||||||||||||
| 0 | 298 | 7/24/2020 1:35:12 PM | 3/28/2022 6:35:04 AM | leak | Journal Done | 27 | 3 | 421 | 5 | 5 | 2 | 23 | 1 | 67 | [{"op":"R","uid":"17","un":"cwayitak","dt":"2021-10-14T09:29:32.918Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-11-13T10:07:03.538Z"}] | 1 | 96 | 17 | 3/28/2022 6:35:04 AM | 5 | 5 | 17 | |||||||||||||||||||
| 0 | 297 | 7/24/2020 1:29:13 PM | 3/28/2022 6:35:04 AM | High Consumption | Write Off due to Indigent Subsidy | 27 | 3 | 419 | 5 | 5 | 2 | 23 | 1 | 95 | [{"op":"R","uid":"17","un":"cwayitak","dt":"2021-08-07T10:42:04.564Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-08-07T11:41:48.399Z"}] | 1 | 95 | 3/28/2022 6:35:04 AM | 5 | 5 | 3 | ||||||||||||||||||||
| 0 | 296 | 7/24/2020 1:13:41 PM | 3/2/2022 7:53:56 AM | Log Query | <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 | 418 | 34 | 34 | 2 | 23 | 1 | 67 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-10-23T10:23:01.563Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-23T10:23:53.324Z"}] | 9 | 123 | 14 | 3/2/2022 7:53:56 AM | 34 | 34 | 14 | |||||||||||||||||||
| 0 | 295 | 7/24/2020 1:08:52 PM | 3/28/2022 6:35:04 AM | water query | Journal Done | 27 | 3 | 417 | 5 | 5 | 2 | 23 | 1 | 67 | [{"op":"R","uid":"17","un":"cwayitak","dt":"2021-10-14T10:04:07.436Z"}] | 1 | 101 | 17 | 3/28/2022 6:35:04 AM | 5 | 5 | 17 | |||||||||||||||||||
| 0 | 294 | 7/24/2020 1:06:33 PM | 3/2/2022 7:53:56 AM | leak | leak, plumbers letter or affidavit to be submitted.<div><br></div><div>NO CONTACT ,NO PLUMBERS LETTER SUBMITTED</div> | 27 | 3 | 416 | 34 | 34 | 4 | 23 | 1 | 67 | [{"op":"R","uid":"192","un":"busisiwem","dt":"2021-10-06T08:19:28.939Z"},{"op":"R","uid":"192","un":"busisiwem","dt":"2021-10-06T10:02:00.285Z"},{"op":"R","uid":"192","un":"busisiwem","dt":"2021-10-06T10:02:25.000Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-10-16T07:23:02.432Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-10-16T07:44:42.617Z"}] | 1 | 96 | 4 | 3/2/2022 7:53:56 AM | 34 | 34 | 4 | |||||||||||||||||||
| 0 | 293 | 7/24/2020 1:01:32 PM | 3/28/2022 6:35:04 AM | Finalize account | <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">account terminated</td></tr></tbody></table> | 27 | 3 | 415 | 5 | 5 | 2 | 23 | 1 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-10-23T10:24:35.645Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-23T10:25:55.038Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-11-13T10:03:36.594Z"}] | 6 | 76 | 12 | 3/28/2022 6:35:04 AM | 5 | 5 | 12 | ||||||||||||||||||||
| 0 | 292 | 7/24/2020 11:23:16 AM | 2/24/2022 11:19:26 AM | Log Query H/C | Please report H/C | 27 | 3 | 414 | 30 | 30 | 2 | 23 | 1 | 67 | [{"op":"R","uid":"4","un":"babalwam","dt":"2021-10-17T11:13:07.928Z"}] | 1 | 101 | 4 | 2/24/2022 11:19:26 AM | 30 | 30 | 4 | |||||||||||||||||||
| 0 | 291 | 7/24/2020 11:13:27 AM | 2/24/2022 11:19:26 AM | 4 | 2 | 413 | 30 | 30 | 2/24/2022 11:19:26 AM | 30 | 30 | ||||||||||||||||||||||||||||||
| 0 | 7/24/2020 10:52:50 AM | 4/12/2022 9:43:30 AM | 4 | 3 | 7 | 7 | 23 | 1 | 1 | 4/12/2022 9:43:30 AM | 7 | 7 | |||||||||||||||||||||||||||||
| 0 | 290 | 7/24/2020 9:50:35 AM | 6/29/2022 12:55:37 PM | Plumbers letter submitted | consumer to re-submit the Plumbers letter.<div><br></div><div>JOURNAL DONE</div><br/><b>Journal Number</b>: [997430 ]<br/><b>Journal Amount</b>: [84600.15] | 27 | 3 | 412 | 5 | 132 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-10-23T10:26:34.161Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-11-13T10:13:05.588Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2022-02-20T10:10:15.555Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2022-02-20T10:48:08.051Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2022-05-16T07:40:02.669Z"}] | 1 | 96 | 4 | 6/29/2022 12:55:31 PM | 2 | 5 | 2 | |||||||||||||||||||
| 0 | 289 | 7/24/2020 9:41:31 AM | 3/28/2022 6:35:04 AM | no valid query details submitted | no valid query details submitted | 27 | 3 | 411 | 5 | 5 | 2 | 23 | 1 | 44 | [{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-15T12:15:45.232Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T08:26:51.081Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-11-13T07:34:58.689Z"}] | 1 | 44 | 3/28/2022 6:35:04 AM | 5 | 5 | 6 |