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 | 148 | 6/27/2020 7:10:00 AM | 3/28/2022 7:25:06 AM | Late termination | Property was sold but never transferred to new owner. | 27 | 3 | 201 | 17 | 17 | 2 | 23 | 6 | 107 | [{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-15T13:29:11.841Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-16T11:36:18.414Z"}] | 6 | 107 | 3/28/2022 7:25:06 AM | 17 | 17 | 20 | ||||||||||||||||||||
| 0 | 147 | 6/26/2020 11:38:08 AM | 4/12/2022 9:42:39 AM | 06 Month Policy Adjustment | Please assess 2019/12 billing om water and process a 06 month policy adjustment<div>6 MONTHS JOURNAL DONE 20191220 PERIOD</div><br/><b>Journal Number</b>: [747676] | 24 | 3 | 200 | 3 | 2 | 23 | 1 | 95 | [{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-08-22T09:24:45.922Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-22T12:00:25.709Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-22T12:06:51.013Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-11-13T07:45:41.460Z"}] | 1 | 101 | 6 | 3 | 6 | ||||||||||||||||||||||
| 0 | 146 | 6/26/2020 8:04:52 AM | 2/24/2022 10:34:50 AM | water query | <font face="Courier New, Helvetica, sans-serif"><span style="font-size: 11px; letter-spacing: 1px; white-space: pre;"> </span></font><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 | 183 | 26 | 26 | 3 | 23 | 1 | 67 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-10-22T11:54:37.020Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-22T11:58:56.954Z"}] | 9 | 123 | 14 | 2/24/2022 10:34:50 AM | 26 | 26 | 14 | |||||||||||||||||||
| 0 | 6/25/2020 9:53:46 AM | 3/28/2022 7:10:22 AM | 4 | 3 | 11 | 11 | 2 | 23 | 1 | 95 | 1 | 95 | 3/28/2022 7:10:22 AM | 11 | 11 | ||||||||||||||||||||||||||
| 0 | 145 | 6/25/2020 9:41:14 AM | 4/12/2022 9:43:30 AM | SIX MONTHS POLICY | SIX MONTHS POLICY ADJUSTED<br/><b>Journal Number</b>: [BJ71834423] | 27 | 3 | 180 | 7 | 15 | 2 | 23 | 1 | 95 | [{"op":"R","uid":"22","un":"asandam","dt":"2021-02-03T12:23:14.370Z"},{"op":"R","uid":"15","un":"chumab","dt":"2021-05-31T11:56:52.079Z"},{"op":"R","uid":"15","un":"chumab","dt":"2021-05-31T11:57:25.188Z"},{"op":"R","uid":"15","un":"chumab","dt":"2021-05-31T11:57:28.178Z"},{"op":"R","uid":"15","un":"chumab","dt":"2021-05-31T11:58:11.145Z"},{"op":"R","uid":"15","un":"chumab","dt":"2021-05-31T11:58:16.282Z"},{"op":"R","uid":"15","un":"chumab","dt":"2021-05-31T11:58:28.022Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-07-14T10:19:22.265Z"}] | 1 | 95 | 4/12/2022 9:43:30 AM | 15 | 7 | 12 | ||||||||||||||||||||
| 0 | 6/25/2020 9:16:25 AM | 3/28/2022 7:08:29 AM | 4 | 3 | 6 | 6 | 23 | 12 | 12 | 3/28/2022 7:08:29 AM | 6 | 6 | |||||||||||||||||||||||||||||
| 0 | 144 | 6/25/2020 9:12:22 AM | 3/28/2022 7:08:29 AM | no account number - query closed | No acc no. Query therefore closed. | 4 | 3 | 179 | 6 | 6 | 3 | 23 | 3 | 52 | [{"op":"R","uid":"2","un":"debbiecr","dt":"2021-03-23T10:42:34.973Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2021-07-13T08:36:56.792Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2021-07-13T09:05:14.237Z"}] | 3 | 52 | 3/28/2022 7:08:29 AM | 6 | 6 | 2 | ||||||||||||||||||||
| 6/25/2020 9:10:36 AM | 3/28/2022 7:08:29 AM | 4 | 3 | 6 | 3 | 23 | 3 | 3 | 6 | ||||||||||||||||||||||||||||||||
| 0 | 143 | 6/24/2020 11:02:31 AM | 2/24/2022 10:34:50 AM | water qury | Query resolved Dec 2020 with leak rebate | 27 | 3 | 170 | 26 | 26 | 3 | 23 | 1 | 100 | [{"op":"R","uid":"3","un":"fareezar","dt":"2021-06-12T09:09:41.765Z"}] | 1 | 100 | 2/24/2022 10:34:50 AM | 26 | 26 | 3 | ||||||||||||||||||||
| 0 | 142 | 6/23/2020 1:46:22 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 | 167 | 34 | 34 | 2 | 23 | 1 | 67 | [{"op":"R","uid":"12","un":"thembesas","dt":"2021-10-21T11:58:01.503Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-22T11:50:49.855Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-22T11:52:52.338Z"}] | 9 | 123 | 14 | 3/2/2022 7:53:56 AM | 34 | 34 | 14 | |||||||||||||||||||
| 0 | 141 | 6/23/2020 11:45:05 AM | 3/28/2022 7:07:05 AM | Log Query high consumption | consumer complaining about excessive water bill caused by the readings increase in consumption since sep 2019 to date<br/><b>Journal Number</b>: [967366]<br/><b>Journal Amount</b>: [-R27,511.39] | 27 | 3 | 164 | 25 | 15 | 2 | 23 | 1 | 45 | [{"op":"R","uid":"6","un":"lusandad","dt":"2021-06-25T11:14:05.346Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-06-29T10:41:32.646Z"}] | 1 | 45 | 3/28/2022 7:07:05 AM | 15 | 25 | 3 | ||||||||||||||||||||
| 0 | 140 | 6/23/2020 10:02:39 AM | 2/14/2023 9:39:47 AM | 6 month policy adjustment | account back charged 201912, account to be assessed.<div><br></div><div>QRC Response- adjustment done 202007</div> | 27 | 3 | 163 | 10 | 15 | 4 | 23 | 1 | 95 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-10-22T11:49:12.537Z"}] | 1 | 101 | 14 | 2/14/2023 9:39:47 AM | 13 | 10 | 13 | |||||||||||||||||||
| 0 | 139 | 6/22/2020 1:44:10 PM | 3/2/2022 7:22:45 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 | 162 | 41 | 41 | 2 | 23 | 1 | 67 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-10-22T11:27:57.890Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-22T11:48:06.199Z"},{"op":"R","uid":"201","un":"nonkosim","dt":"2022-03-02T07:22:44.189Z"}] | 9 | 123 | 14 | 3/2/2022 7:22:45 AM | 41 | 41 | 14 | |||||||||||||||||||
| 0 | 138 | 6/22/2020 12:53:32 PM | 5/19/2022 7:51:12 AM | high consumption | Water query | 27 | 3 | 161 | 16 | 16 | 2 | 23 | 1 | 67 | [{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-15T12:23:42.815Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-16T07:50:02.560Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-16T07:51:03.587Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-16T11:35:18.257Z"}] | 1 | 67 | 5/19/2022 7:51:12 AM | 16 | 16 | 20 | ||||||||||||||||||||
| 0 | 137 | 6/22/2020 8:42:38 AM | 4/12/2022 9:39:10 AM | LATE TERMINATION | Reversal of interest and rates.<br/><b>Journal Number</b>: [830313] | 27 | 3 | 160 | 4 | 13 | 2 | 23 | 8 | 61 | [{"op":"R","uid":"173","un":"olgad","dt":"2021-08-10T08:47:06.224Z"},{"op":"R","uid":"173","un":"olgad","dt":"2021-08-10T11:49:37.915Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-22T09:59:47.619Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-22T10:27:40.712Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-11-13T07:40:05.301Z"}] | 6 | 122 | 6 | 4/12/2022 9:39:10 AM | 13 | 4 | 6 | |||||||||||||||||||
| 0 | 136 | 6/22/2020 8:08:03 AM | 2/24/2022 10:34:50 AM | water 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 | 159 | 26 | 26 | 3 | 23 | 1 | 44 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-10-22T09:27:01.769Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-22T09:29:30.512Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-22T09:31:38.849Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-22T09:57:32.448Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-22T09:58:48.703Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-11-13T07:43:13.500Z"}] | 9 | 123 | 14 | 2/24/2022 10:34:50 AM | 26 | 26 | 14 | |||||||||||||||||||
| 0 | 135 | 6/21/2020 6:39:40 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 | 158 | 34 | 34 | 2 | 1 | 1 | 67 | [{"op":"R","uid":"16","un":"cumilem","dt":"2021-08-02T07:42:45.315Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-22T09:24:51.789Z"}] | 9 | 123 | 14 | 3/2/2022 7:53:56 AM | 34 | 34 | 14 | |||||||||||||||||||
| 0 | 134 | 6/21/2020 1:03:08 PM | 3/2/2022 7:53:56 AM | Log Query | ACCOUNT IN ORDER | 27 | 3 | 157 | 34 | 34 | 4 | 23 | 1 | 67 | [{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-10-16T10:28:36.622Z"}] | 1 | 111 | 11 | 3/2/2022 7:53:56 AM | 34 | 34 | 11 | |||||||||||||||||||
| 0 | 133 | 6/21/2020 9:56:21 AM | 3/28/2022 7:25:06 AM | water query | leak credit to be done | 27 | 3 | 156 | 17 | 17 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-15T12:08:05.835Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-16T11:16:50.779Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T08:21:43.414Z"}] | 1 | 96 | 3/28/2022 7:25:06 AM | 17 | 17 | 14 | ||||||||||||||||||||
| 0 | 132 | 6/21/2020 8:47:49 AM | 3/28/2022 7:25:06 AM | Late termination | Transfer of ownership | 27 | 3 | 155 | 17 | 17 | 2 | 23 | 6 | 107 | [{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-15T07:58:20.886Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-16T09:50:34.325Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T07:48:37.917Z"}] | 6 | 107 | 3/28/2022 7:25:06 AM | 17 | 17 | 14 |