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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2371 | 3/16/2021 7:07:09 AM | 5/13/2022 12:44:05 PM | log query | <table border="0" cellpadding="0" cellspacing="0" width="668" style="border-collapse: collapse;width:501pt"><tbody><tr height="31" style="mso-height-source:userset;height:23.45pt"> <td height="31" class="xl65" 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> | 27 | 3 | 2119 | 32 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"32","un":"andisiwem","dt":"2021-03-16T07:03:30.899Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-05T08:33:16.657Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-24T07:18:31.316Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-09-20T07:41:58.434Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-26T11:39:11.841Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-29T09:23:14.430Z"},{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-11-03T07:29:31.403Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2022-05-13T12:43:49.297Z"}] | 9 | 123 | 11 | 5/13/2022 12:44:05 PM | 32 | 11 | ||||||||||||||||||||||
| 2370 | 3/15/2021 1:08:45 PM | 2/16/2022 9:04:39 AM | water dispute | debtor is disputing high water consumption caused by interim reversal due to readings not taken for a long time | 30 | 3 | 2118 | 4 | 23 | 1 | 67 | 2021 | [{"op":"R","uid":"194","un":"nomalungisaw","dt":"2021-03-15T13:08:23.188Z"},{"op":"R","uid":"194","un":"nomalungisaw","dt":"2021-03-15T13:12:31.371Z"},{"op":"R","uid":"194","un":"nomalungisaw","dt":"2021-03-15T13:16:57.678Z"},{"op":"R","uid":"5","un":"ivanh","dt":"2021-05-12T11:59:50.074Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-26T11:45:46.453Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-26T11:46:46.112Z"},{"op":"R","uid":"15","un":"chumab","dt":"2021-11-13T07:13:22.044Z"}] | 1 | 111 | 14 | 14 | ||||||||||||||||||||||||
| 2369 | 3/15/2021 12:58:24 PM | 10/26/2021 11:47:41 AM | high water consumption | <table border="0" cellpadding="0" cellspacing="0" width="668" style="border-collapse: collapse;width:501pt"><tbody><tr height="31" style="mso-height-source:userset;height:23.45pt"> <td height="31" class="xl65" 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> | 4 | 3 | 2117 | 75 | 4 | 23 | 1 | 67 | 1111 | [{"op":"R","uid":"194","un":"nomalungisaw","dt":"2021-03-15T12:58:01.568Z"},{"op":"R","uid":"194","un":"nomalungisaw","dt":"2021-03-15T13:00:22.330Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-05T10:55:47.547Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-05T10:56:07.233Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-05T11:03:21.597Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-05T11:08:18.995Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-05T11:08:58.411Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-26T11:47:05.687Z"}] | 9 | 123 | 14 | 10/26/2021 11:47:41 AM | 173 | 14 | |||||||||||||||||||||
| 2368 | 3/15/2021 12:49:05 PM | 2/16/2022 9:04:39 AM | smart meter not reading | readings up-to-date | 10 | 2 | 2116 | 82 | 77 | [{"op":"R","uid":"194","un":"nomalungisaw","dt":"2021-03-15T12:48:42.656Z"},{"op":"R","uid":"194","un":"nomalungisaw","dt":"2021-03-15T12:50:28.199Z"},{"op":"R","uid":"194","un":"nomalungisaw","dt":"2021-03-15T12:50:38.660Z"},{"op":"R","uid":"194","un":"nomalungisaw","dt":"2021-04-20T08:48:51.200Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-15T10:05:20.299Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-15T10:05:54.709Z"}] | 77 | 2/16/2022 9:04:39 AM | 194 | 12 | |||||||||||||||||||||||||||
| 2367 | 3/15/2021 12:42:14 PM | 3/15/2021 12:42:16 PM | 2 | 2115 | [{"op":"R","uid":"194","un":"nomalungisaw","dt":"2021-03-15T12:41:51.991Z"}] | 194 | |||||||||||||||||||||||||||||||||||
| 2365 | 3/15/2021 12:35:53 PM | 3/28/2022 6:35:04 AM | water | six months policy applied.<br/><b>Journal Number</b>: [431166] | 24 | 3 | 2114 | 2 | 23 | 1 | 95 | [{"op":"R","uid":"12","un":"thembesas","dt":"2021-03-15T12:35:55.830Z"},{"op":"R","uid":"5","un":"ivanh","dt":"2021-05-17T10:50:42.515Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-26T11:48:40.335Z"}] | 1 | 101 | 14 | 14 | |||||||||||||||||||||||||
| 2365 | 3/15/2021 12:33:46 PM | 4/12/2022 9:43:30 AM | no valid query details submitted | <div style="text-align: justify;">no valid query details submitted<br></div><div style="text-align: justify;">6 MONTH POLICY APPLIED AND PROCESSED FOR 201904/202003 </div><br/><b>Journal Number</b>: [851497] | 24 | 3 | 2114 | 2 | 23 | 1 | 44 | [{"op":"R","uid":"12","un":"thembesas","dt":"2021-03-15T12:33:55.446Z"},{"op":"R","uid":"5","un":"ivanh","dt":"2021-05-17T10:47:21.529Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-15T13:07:45.249Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T09:42:14.062Z"},{"op":"R","uid":"10","un":"mellozanef","dt":"2021-11-20T09:54:43.117Z"},{"op":"R","uid":"10","un":"mellozanef","dt":"2021-11-20T09:54:55.461Z"}] | 1 | 101 | 10 | 10 | |||||||||||||||||||||||||
| 2364 | 3/15/2021 12:26:08 PM | 2/16/2022 9:04:39 AM | HIGH CONSUMPTION | <table border="0" cellpadding="0" cellspacing="0" width="668" style="border-collapse: collapse;width:501pt"><tbody><tr height="31" style="mso-height-source:userset;height:23.45pt"> <td height="31" class="xl65" 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> | 4 | 3 | 2113 | 82 | 4 | 23 | 1 | 67 | 1108 | [{"op":"R","uid":"194","un":"nomalungisaw","dt":"2021-03-15T12:25:46.477Z"},{"op":"R","uid":"194","un":"nomalungisaw","dt":"2021-03-15T12:27:23.031Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-05T11:10:07.598Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-05T11:42:48.782Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-06T06:45:39.313Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-06T10:21:22.200Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-06T10:21:53.837Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-26T11:49:34.831Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-26T11:50:50.614Z"}] | 9 | 123 | 14 | 2/16/2022 9:04:39 AM | 194 | 14 | |||||||||||||||||||||
| 2363 | 3/15/2021 12:11:41 PM | 2/16/2022 9:04:39 AM | SMART METER INSTALLED | readings up-to-date | 27 | 3 | 2112 | 82 | 4 | 23 | 1 | 48 | 1106 | [{"op":"R","uid":"194","un":"nomalungisaw","dt":"2021-03-15T12:11:38.681Z"},{"op":"R","uid":"194","un":"nomalungisaw","dt":"2021-03-15T12:21:14.528Z"},{"op":"R","uid":"194","un":"nomalungisaw","dt":"2021-03-15T12:21:59.197Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-15T08:34:11.959Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-15T08:34:46.636Z"}] | 1 | 48 | 2/16/2022 9:04:39 AM | 194 | 12 | ||||||||||||||||||||||
| 2356 | 3/15/2021 11:38:07 AM | 5/22/2022 10:44:48 AM | SIX MONTHS POLICY | SIX MONTHS POLICY ADJUSTED<div>JRNL NO: 851459</div><br/><b>Journal Number</b>: [BJ71851459]<br/><b>Journal Amount</b>: [-R16,472.92] | 27 | 3 | 2111 | 17 | 4 | 23 | 1 | 95 | [{"op":"R","uid":"194","un":"nomalungisaw","dt":"2021-03-15T11:38:10.596Z"},{"op":"R","uid":"194","un":"nomalungisaw","dt":"2021-03-15T11:50:25.328Z"},{"op":"R","uid":"173","un":"olgad","dt":"2021-06-02T08:41:46.978Z"},{"op":"R","uid":"196","un":"lazolaw","dt":"2021-07-28T07:12:13.757Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-26T11:52:05.253Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-11-14T06:39:35.316Z"},{"op":"R","uid":"15","un":"chumab","dt":"2021-11-20T11:18:53.746Z"},{"op":"R","uid":"15","un":"chumab","dt":"2022-05-17T06:20:01.918Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2022-05-22T10:44:11.428Z"}] | 1 | 101 | 3 | 5/22/2022 10:44:48 AM | 17 | 3 | ||||||||||||||||||||||
| 2360 | 3/15/2021 11:21:06 AM | 2/24/2022 10:44:24 AM | duplicate water charged | consumer water charge duplication. kindly investigate and resolve.<div>old meter has been removed and interim charges reversed.</div> | 27 | 3 | 2110 | 28 | 2 | 23 | 77 | 99 | [{"op":"R","uid":"28","un":"samanthaj","dt":"2021-03-15T11:17:25.824Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2021-07-06T06:48:21.036Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2021-07-06T06:52:11.871Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2021-07-06T06:52:40.790Z"}] | 77 | 99 | 2/24/2022 10:44:24 AM | 28 | 2 | |||||||||||||||||||||||
| 2359 | 3/15/2021 11:11:09 AM | 10/14/2021 7:20:33 AM | WATER QUERY 6 MONTH POLICY | WATER QUERY<div><br></div><div>RESOLVED</div> | 27 | 3 | 2109 | 32 | 3 | 23 | 1 | 67 | 1103 | [{"op":"R","uid":"32","un":"andisiwem","dt":"2021-03-15T11:07:31.483Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-05T12:11:35.585Z"},{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-10-14T07:20:18.932Z"}] | 1 | 101 | 11 | 10/14/2021 7:20:33 AM | 32 | 11 | |||||||||||||||||||||
| 2358 | 3/15/2021 10:58:27 AM | 10/26/2021 11:54:45 AM | log query | <table border="0" cellpadding="0" cellspacing="0" width="668" style="border-collapse: collapse;width:501pt"><tbody><tr height="31" style="mso-height-source:userset;height:23.45pt"> <td height="31" class="xl65" 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> | 4 | 3 | 2108 | 32 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"32","un":"andisiwem","dt":"2021-03-15T10:54:49.038Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-05T12:00:19.041Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-10T07:31:22.274Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-26T11:53:43.778Z"}] | 9 | 123 | 14 | 10/26/2021 11:54:45 AM | 32 | 14 | ||||||||||||||||||||||
| 2357 | 3/15/2021 10:49:05 AM | 10/17/2021 9:06:35 AM | water query | water query<div>journal done</div><br><b>Journal Number</b>: [095707]<div><br></div><div>Journal cancelled. W/off cleared debt as at 2021/06</div> | 27 | 3 | 2107 | 74 | 4 | 23 | 77 | 67 | [{"op":"R","uid":"32","un":"andisiwem","dt":"2021-03-15T10:45:27.263Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-10T08:55:47.859Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-08-30T10:18:22.107Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-10-17T09:06:01.329Z"}] | 1 | 101 | 3 | 10/17/2021 9:06:35 AM | 172 | 3 | ||||||||||||||||||||||
| 2355 | 3/15/2021 10:36:38 AM | 2/24/2022 10:44:24 AM | duplicate water charged | duplication of water billed on account,kindly investigate and resolve.<div>Journal Done</div> | 27 | 3 | 2106 | 28 | 2 | 23 | 77 | 99 | [{"op":"R","uid":"28","un":"samanthaj","dt":"2021-03-15T10:32:59.081Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-10-14T06:49:13.415Z"}] | 1 | 101 | 17 | 2/24/2022 10:44:24 AM | 28 | 17 | ||||||||||||||||||||||
| 2353 | 3/15/2021 10:29:05 AM | 8/7/2021 9:20:59 AM | Late termination | Late termination,ownership not changed indigent account was opened. | 27 | 3 | 2104 | 32 | 4 | 23 | 77 | 107 | [{"op":"R","uid":"32","un":"andisiwem","dt":"2021-03-15T10:25:26.977Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-07T09:18:32.848Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-07T09:19:12.690Z"}] | 77 | 107 | 8/7/2021 9:20:59 AM | 32 | 12 | |||||||||||||||||||||||
| 2352 | 3/15/2021 10:29:05 AM | 2/24/2022 10:34:50 AM | water query | high water consumption on 20201226 account.<br><div><br></div><div>Resolution:</div><div>Back Charged period is 128days and does not exceed 181+days, therefore does not qualify for 06 month policy adjustment</div> | 27 | 3 | 2105 | 26 | 2 | 23 | 77 | 95 | [{"op":"R","uid":"26","un":"nobulalim","dt":"2021-03-15T10:25:26.705Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-08-30T11:33:16.966Z"}] | 77 | 95 | 2/24/2022 10:34:50 AM | 26 | 3 | |||||||||||||||||||||||
| 2350 | 3/15/2021 10:27:47 AM | 7/2/2022 9:24:46 AM | high water consumption | high water consumption in December 2020 and Jabury 2021 six month policy<div><br></div><div>Debt written off June 2022, cleared outstanding debt. Query Closed</div> | 27 | 3 | 2103 | 13 | 4 | 23 | 1 | 67 | 1100 | [{"op":"R","uid":"194","un":"nomalungisaw","dt":"2021-03-15T10:27:49.471Z"},{"op":"R","uid":"194","un":"nomalungisaw","dt":"2021-03-15T10:31:27.237Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-06T08:34:46.103Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-08-06T10:17:02.146Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-26T11:55:48.546Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-11-10T12:27:07.209Z"},{"op":"R","uid":"13","un":"unathig","dt":"2022-02-13T10:28:53.694Z"}] | 1 | 101 | 14 | 7/2/2022 9:24:46 AM | 3 | 3 | |||||||||||||||||||||
| 2349 | 3/15/2021 10:11:03 AM | 2/16/2022 9:04:39 AM | flag account | please flag account , water query pending<div>Journal Done</div> | 27 | 3 | 2102 | 82 | 4 | 23 | 1 | 100 | [{"op":"R","uid":"194","un":"nomalungisaw","dt":"2021-03-15T10:11:05.153Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-10-13T10:45:57.041Z"}] | 1 | 101 | 17 | 2/16/2022 9:04:39 AM | 194 | 17 | ||||||||||||||||||||||
| 2348 | 3/15/2021 10:08:15 AM | 2/24/2022 10:44:24 AM | duplicate water charge | consumer concerned about being billed on two meters for water.kindly investigate and resolve. | 30 | 3 | 2101 | 2 | 23 | 77 | 99 | [{"op":"R","uid":"28","un":"samanthaj","dt":"2021-03-15T10:04:35.814Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-26T11:57:34.144Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-26T11:58:34.974Z"}] | 1 | 101 | 14 | 14 |