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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1105 | 1/30/2021 10:02:10 AM | 4/29/2023 10:50:57 AM | water query | water query<br><b>Journal Number</b>: [BJ71826726]<div><b><u>QRC RESPONSE</u></b>;</div><div>6 MONTHS POLICY DONE FOR 20200927 PERIOD.</div><div>JNL NO: 499091<br><div><br></div></div> | 24 | 3 | 1176 | 17 | 4 | 23 | 1 | 67 | 329 | [{"op":"R","uid":"13","un":"unathig","dt":"2021-01-30T09:59:02.794Z"},{"op":"R","uid":"56","un":"mihlet","dt":"2021-02-02T10:40:49.958Z"},{"op":"R","uid":"56","un":"mihlet","dt":"2021-02-02T10:42:26.530Z"},{"op":"R","uid":"22","un":"asandam","dt":"2021-02-02T11:55:21.731Z"},{"op":"R","uid":"15","un":"chumab","dt":"2021-08-10T11:01:45.034Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-27T08:48:17.872Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-27T08:48:43.691Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-27T08:49:55.007Z"}] | 1 | 111 | 18 | 6 | |||||||||||||||||||||||
| 1104 | 1/30/2021 9:56:51 AM | 6/16/2022 8:57:08 AM | flag water query | water query plus flag | 30 | 3 | 1175 | 3 | 23 | 1 | 67 | 237 | [{"op":"R","uid":"13","un":"unathig","dt":"2021-01-30T09:53:44.892Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2021-02-02T06:18:20.064Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2021-02-02T07:06:45.073Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-27T08:22:47.809Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-27T08:24:22.295Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-27T08:45:52.116Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-27T08:47:23.286Z"}] | 1 | 111 | 18 | 133417 | 18 | |||||||||||||||||||||||
| 1103 | 1/30/2021 9:47:57 AM | 10/17/2021 11:29:35 AM | 6 month policy water query | 6 month policy water query<div>6 months policy journal done for 20200927 period</div><br/><b>Journal Number</b>: [071806]<br/><b>Journal Amount</b>: [-R4,117.36] | 27 | 3 | 1174 | 74 | 3 | 23 | 1 | 67 | 316 | [{"op":"R","uid":"13","un":"unathig","dt":"2021-01-30T09:44:50.258Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2021-02-02T06:13:05.801Z"},{"op":"R","uid":"56","un":"mihlet","dt":"2021-02-02T10:40:14.423Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-08-28T08:37:25.371Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-08-28T08:59:03.242Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-10-17T11:29:10.226Z"}] | 1 | 101 | 3 | 10/17/2021 11:29:35 AM | 172 | 3 | |||||||||||||||||||||
| 1102 | 1/30/2021 9:40:07 AM | 2/2/2021 7:09:10 AM | 5 | 1173 | 23 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-01-30T09:37:00.896Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2021-02-02T06:16:51.157Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2021-02-02T07:05:58.912Z"}] | 2 | ||||||||||||||||||||||||||||||||||
| 1094 | 1/29/2021 1:52:26 PM | 3/28/2022 6:35:04 AM | water | journal captured<br><b>Journal Number</b>: [447409]<br/><b>Journal Amount</b>: [-R3,197.18] | 27 | 3 | 1172 | 5 | 2 | 23 | 1 | 51 | 186 | [{"op":"R","uid":"12","un":"thembesas","dt":"2021-01-29T13:49:20.309Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-27T09:57:32.377Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-27T09:58:16.716Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-11-12T12:04:39.238Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-11-12T12:04:51.729Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-11-12T12:05:43.074Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-11-13T07:00:58.572Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-11-16T11:09:40.323Z"}] | 1 | 96 | 3 | 3/28/2022 6:35:04 AM | 5 | 3 | |||||||||||||||||||||
| 1094 | 1/29/2021 1:50:11 PM | 11/16/2021 11:11:40 AM | water | journal captured<br><b>Journal Number</b>: [172886]<div><br></div><div>Close duplicate query. Resolved on ref 1052<br></div> | 27 | 3 | 1172 | 12 | 2 | 23 | 1 | 51 | 185 | [{"op":"R","uid":"12","un":"thembesas","dt":"2021-01-29T13:47:05.519Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-27T09:55:11.972Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-11-12T12:05:16.295Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-11-16T11:11:28.652Z"}] | 1 | 111 | 3 | 11/16/2021 11:11:40 AM | 12 | 3 | |||||||||||||||||||||
| 1094 | 1/29/2021 1:48:15 PM | 5/27/2021 4:24:21 AM | water | check reading sent | 27 | 3 | 1172 | 12 | 2 | 23 | 1 | 51 | [{"op":"R","uid":"12","un":"thembesas","dt":"2021-01-29T13:45:08.702Z"}] | 1 | 51 | 5/27/2021 4:24:21 AM | 12 | 12 | |||||||||||||||||||||||
| 1094 | 1/29/2021 1:46:14 PM | 5/27/2021 4:24:21 AM | water | six months policy applied<br/><b>Journal Number</b>: [172767] | 24 | 3 | 1172 | 2 | 23 | 1 | 51 | 184 | [{"op":"R","uid":"12","un":"thembesas","dt":"2021-01-29T13:43:07.386Z"}] | 1 | 51 | 12 | |||||||||||||||||||||||||
| 1094 | 1/29/2021 1:43:44 PM | 11/16/2021 1:10:49 PM | water | monitor account for 60 days<br><b>Monitoring Reason</b>: [monitor for 60 days]<div><br></div><div>Close duplicate query. Resolved on ref 1052<br></div> | 27 | 3 | 1172 | 12 | 2 | 23 | 1 | 48 | 183 | [{"op":"R","uid":"12","un":"thembesas","dt":"2021-01-29T13:40:37.847Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-27T08:16:11.720Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-27T08:17:18.342Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-27T08:19:46.179Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-11-12T12:05:21.705Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-11-16T11:11:09.696Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-11-16T13:10:49.688Z"}] | 1 | 111 | 3 | 11/16/2021 1:10:49 PM | 12 | 3 | |||||||||||||||||||||
| 1094 | 1/29/2021 1:40:25 PM | 11/16/2021 11:11:02 AM | to monitor account for 60 days | to monitor account for 60 days<br><b>Monitoring Reason</b>: [monitor for60days]<div><br></div><div>Close duplicate query. Resolved on ref 1052</div> | 27 | 3 | 1172 | 12 | 2 | 23 | 1 | 51 | 182 | [{"op":"R","uid":"12","un":"thembesas","dt":"2021-01-29T13:37:18.824Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-27T08:14:21.896Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-11-12T12:05:30.779Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-11-16T11:10:34.040Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-11-16T11:11:02.835Z"}] | 1 | 111 | 3 | 11/16/2021 11:11:02 AM | 12 | 3 | |||||||||||||||||||||
| 1094 | 1/29/2021 1:34:45 PM | 11/16/2021 11:10:27 AM | pending journal | pending journal<br><b>Journal Number</b>: [906079]<div><br></div><div>CLOSE DUPLICATE QUERY REF 1052</div> | 27 | 3 | 1172 | 12 | 2 | 23 | 1 | 58 | 181 | [{"op":"R","uid":"12","un":"thembesas","dt":"2021-01-29T13:31:38.529Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-27T07:50:31.023Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-27T07:53:51.679Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-11-12T12:05:36.440Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-11-12T12:06:11.260Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-11-16T11:10:02.801Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-11-16T11:10:11.433Z"}] | 1 | 111 | 3 | 11/16/2021 11:10:27 AM | 12 | 3 | |||||||||||||||||||||
| 1094 | 1/29/2021 1:30:31 PM | 5/27/2021 4:24:21 AM | check reading sent | check reading sent to meter readings | 27 | 3 | 1172 | 12 | 4 | 23 | 1 | 48 | [{"op":"R","uid":"12","un":"thembesas","dt":"2021-01-29T13:27:24.830Z"}] | 1 | 48 | 5/27/2021 4:24:21 AM | 12 | 12 | |||||||||||||||||||||||
| 1094 | 1/29/2021 1:24:08 PM | 5/27/2021 4:24:21 AM | CHANGE OF POSTAL ADDRESS | QUERY SENT TO COUNTER SERVICES. | 27 | 3 | 1172 | 12 | 2 | 23 | 12 | 75 | [{"op":"R","uid":"12","un":"thembesas","dt":"2021-01-29T13:21:02.347Z"}] | 12 | 75 | 5/27/2021 4:24:21 AM | 12 | 12 | |||||||||||||||||||||||
| 1101 | 1/29/2021 1:09:36 PM | 1/29/2021 1:09:38 PM | 2 | 1171 | [{"op":"R","uid":"21","un":"heinrichs","dt":"2021-01-29T13:09:38.510Z"}] | 21 | |||||||||||||||||||||||||||||||||||
| 1097 | 1/29/2021 1:00:08 PM | 7/21/2021 9:34:25 AM | no valid query details submitted | no valid query details submitted | 27 | 3 | 6 | 2 | 23 | 1 | 44 | [{"op":"R","uid":"8","un":"mariaanaw","dt":"2021-01-29T13:00:14.435Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-15T13:14:04.302Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T09:34:06.082Z"}] | 1 | 44 | 7/21/2021 9:34:25 AM | 6 | 14 | ||||||||||||||||||||||||
| 1099 | 1/29/2021 12:58:40 PM | 3/28/2022 7:25:06 AM | leak credit | <table border="0" cellpadding="0" cellspacing="0" width="668" style="border-collapse: collapse;width:501pt"><tbody><tr height="26" style="height:19.5pt"> <td height="26" class="xl65" width="668" style="height:19.5pt;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 | 17 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"17","un":"cwayitak","dt":"2021-01-29T12:55:32.400Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-29T10:01:37.028Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-29T10:01:51.152Z"}] | 9 | 123 | 14 | 3/28/2022 7:25:06 AM | 17 | 14 | |||||||||||||||||||||||
| 1098 | 1/29/2021 12:55:54 PM | 3/28/2022 7:25:06 AM | Leak Credit | <table border="0" cellpadding="0" cellspacing="0" width="668" style="border-collapse: collapse;width:501pt"><tbody><tr height="26" style="height:19.5pt"> <td height="26" class="xl65" width="668" style="height:19.5pt;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 | 17 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"17","un":"cwayitak","dt":"2021-01-29T12:52:47.171Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-29T09:55:48.579Z"}] | 9 | 123 | 14 | 3/28/2022 7:25:06 AM | 17 | 14 | |||||||||||||||||||||||
| 1096 | 1/29/2021 12:54:03 PM | 3/28/2022 7:25:06 AM | leak credit | <table border="0" cellpadding="0" cellspacing="0" width="668" style="border-collapse: collapse;width:501pt"><tbody><tr height="26" style="height:19.5pt"> <td height="26" class="xl65" width="668" style="height:19.5pt;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 | 17 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"17","un":"cwayitak","dt":"2021-01-29T12:50:55.326Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-29T09:54:46.873Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-29T09:55:20.239Z"}] | 9 | 123 | 14 | 3/28/2022 7:25:06 AM | 17 | 14 | |||||||||||||||||||||||
| 1093 | 1/29/2021 12:06:24 PM | 10/8/2022 9:05:21 AM | Leak Credit Due | Consumption still high. No average available<div><br></div><div>Resolved with no adjustment due as consumption has not dropped. Consumer advised in Aug 2021 to appoint a plumber to re-assess the premises for any other undetected leaks</div> | 27 | 3 | 1170 | 8 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"8","un":"mariaanaw","dt":"2021-01-29T12:06:30.848Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-08-14T11:14:17.596Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-08-15T07:04:20.992Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-11-02T12:46:56.916Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-11-02T12:56:29.144Z"}] | 1 | 96 | 11/2/2021 12:56:28 PM | 8 | 3 | |||||||||||||||||||||||
| 1092 | 1/29/2021 11:52:56 AM | 3/28/2022 6:35:04 AM | ACCOUNT CLOSED | TRANSFER WATER TO NEW OWNER<div>NEW OWNERS ACCOUNT NOT OPENED YET ,BILLING WILL TRANSFER THE SERVICES.</div> | 27 | 3 | 1169 | 5 | 2 | 23 | 1 | 58 | 1943 | [{"op":"R","uid":"5","un":"ivanh","dt":"2021-01-29T11:52:59.105Z"},{"op":"R","uid":"5","un":"ivanh","dt":"2021-05-11T10:37:16.988Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-10-16T07:55:01.292Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-10-17T09:25:16.208Z"}] | 6 | 122 | 12 | 3/28/2022 6:35:04 AM | 5 | 12 |