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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1091 | 1/29/2021 9:32:40 AM | 3/28/2022 6:33:19 AM | Meter Replaced 2020/06 | Allocated to Billing (JM) to update Solar and possible 100% credit<div><br></div><div>credit of R12795.88 processed. Account up to date.</div><div>Query resolved</div> | 27 | 3 | 1168 | 3 | 2 | 23 | 1 | 45 | 179 | [{"op":"R","uid":"3","un":"fareezar","dt":"2021-01-29T09:32:50.685Z"},{"op":"R","uid":"214","un":"nandiphan","dt":"2021-08-07T11:12:27.360Z"}] | 1 | 45 | 3/28/2022 6:33:19 AM | 3 | 214 | ||||||||||||||||||||||
| 1090 | 1/29/2021 7:49:59 AM | 3/28/2022 7:08:29 AM | readings to be sent to meter reading to captured | readings to be sent to meter reading to captured. | 27 | 3 | 6 | 2 | 23 | 1 | 51 | [{"op":"R","uid":"6","un":"lusandad","dt":"2021-01-29T07:50:01.409Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2021-01-29T11:56:23.291Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2021-01-29T11:56:53.783Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-02-02T13:39:58.964Z"}] | 1 | 51 | 3/28/2022 7:08:29 AM | 6 | 6 | ||||||||||||||||||||||||
| 1089 | 1/29/2021 7:25:18 AM | 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-29T07:25:25.841Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-29T09:54:00.408Z"}] | 9 | 123 | 14 | 3/28/2022 7:25:06 AM | 17 | 14 | |||||||||||||||||||||||
| 1088 | 1/28/2021 1:53:12 PM | 11/13/2021 11:18:59 AM | leak credit journal done | leak credit journal done<br><b>Journal Number</b>: [143781]<div>.</div><div><br></div> | 27 | 3 | 1167 | 74 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"6","un":"lusandad","dt":"2021-01-28T13:50:05.841Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-08-16T12:57:12.114Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-08-16T13:10:13.861Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-08-16T13:10:53.363Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-27T09:47:37.963Z"},{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-11-13T11:17:38.997Z"}] | 1 | 96 | 11 | 11/13/2021 11:18:59 AM | 172 | 11 | ||||||||||||||||||||||
| 1087 | 1/28/2021 1:52:11 PM | 4/12/2022 9:47:18 AM | 6 MONTH POLICY | 6 MONTH POLICY TO BE ADJUSTED FOR 201801/201810 AND 201901/201910 | 30 | 2 | 1166 | 77 | [{"op":"R","uid":"10","un":"mellozanef","dt":"2021-01-28T13:52:13.215Z"},{"op":"R","uid":"10","un":"mellozanef","dt":"2021-03-05T07:09:45.123Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-06-06T10:49:25.698Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-06-06T10:51:00.132Z"}] | 77 | 12 | ||||||||||||||||||||||||||||||
| 1086 | 1/28/2021 1:01: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-28T13:01:05.299Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-27T07:26:34.195Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-29T09:53:01.637Z"}] | 9 | 123 | 14 | 3/28/2022 7:25:06 AM | 17 | 14 | |||||||||||||||||||||||
| 1085 | 1/28/2021 12:51:02 PM | 4/1/2022 10:30:45 AM | 100% lk cr done | 100% lk cr done<br/><b>Journal Number</b>: [145875] | 30 | 3 | 2 | 23 | 1 | 49 | 178 | [{"op":"R","uid":"6","un":"lusandad","dt":"2021-01-28T12:47:57.053Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-27T07:24:56.607Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-29T09:52:03.561Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-29T09:52:47.307Z"},{"op":"R","uid":"56","un":"entlet","dt":"2022-04-01T10:30:44.818Z"}] | 1 | 101 | 14 | 14 | |||||||||||||||||||||||||
| 1084 | 1/28/2021 12:22:21 PM | 10/27/2022 8:15:37 AM | TRANSFER WATER CHARGE | TRANSFER WATER<div><b><u><br></u></b></div><div><b><u>QRC RESPONSE: </u></b>Request on meter location sent to service department. In order to transfer meter verification needed on where it serve.</div><div><br></div><div>2022.10.27 CLOSED WATER METER AS PER WATER WORKS</div> | 27 | 3 | 1165 | 4 | 2 | 23 | 1 | 45 | 177 | [{"op":"R","uid":"5","un":"ivanh","dt":"2021-01-28T12:22:29.396Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-10-17T08:40:05.010Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-27T07:07:28.466Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-27T07:20:30.547Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-27T07:23:28.110Z"}] | 1 | 112 | 18 | 10/27/2022 8:14:41 AM | 4 | 4 | |||||||||||||||||||||
| 1083 | 1/28/2021 11:23:21 AM | 3/28/2022 6:33:19 AM | Fire Levy Tariff to be Amended | Allocated to Billing (JM) to assess and amend Fire levy Tariff. Dog Tax to be reversed by QRC<div><b><u><br></u></b></div><div><b><u>RESPONSE FROM QRC</u></b>: Tariff amended accordingly in 202102 and dog tax reversed, 202103 BJ71426867 journal approved.</div><div>Query Resolved</div> | 27 | 3 | 1164 | 3 | 2 | 23 | 3 | 53 | 176 | [{"op":"R","uid":"3","un":"fareezar","dt":"2021-01-28T11:20:14.567Z"},{"op":"R","uid":"8","un":"mariaanaw","dt":"2021-08-06T09:49:37.355Z"},{"op":"R","uid":"8","un":"mariaanaw","dt":"2021-08-06T09:53:07.459Z"}] | 3 | 53 | 3/28/2022 6:33:19 AM | 3 | 8 | ||||||||||||||||||||||
| 1082 | 1/28/2021 10:55:28 AM | 3/28/2022 7:08:29 AM | 6 MONTH POLICY | 6 MONTH POLICY TO BE ASSESSED AND ADJUSTED | 27 | 3 | 1163 | 6 | 2 | 23 | 1 | 67 | [{"op":"R","uid":"10","un":"mellozanef","dt":"2021-01-28T10:55:30.237Z"},{"op":"R","uid":"10","un":"mellozanef","dt":"2021-03-05T07:09:37.509Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T09:30:14.182Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T09:30:46.423Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T09:32:05.533Z"}] | 1 | 67 | 3/28/2022 7:08:29 AM | 6 | 14 | |||||||||||||||||||||||
| 1082 | 1/28/2021 10:53:06 AM | 7/21/2021 9:29:54 AM | no valid query details submitted | no valid query details submitted | 27 | 3 | 1163 | 15 | 2 | 23 | 1 | 44 | [{"op":"R","uid":"3","un":"fareezar","dt":"2021-01-28T10:49:59.356Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-15T13:14:31.808Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T09:29:53.353Z"}] | 1 | 44 | 7/21/2021 9:29:54 AM | 15 | 14 | |||||||||||||||||||||||
| 1081 | 1/28/2021 10:46:07 AM | 3/28/2022 6:33:19 AM | Reading Assessment and Meter Change | Allocated to Billing (JM) - readings to be assessed and possible meter changed | 27 | 3 | 1162 | 3 | 2 | 23 | 1 | 66 | 174 | [{"op":"R","uid":"3","un":"fareezar","dt":"2021-01-28T10:43:00.492Z"},{"op":"R","uid":"214","un":"nandiphan","dt":"2021-08-14T08:03:55.834Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-27T06:57:06.368Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-27T07:05:55.173Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-27T07:06:28.763Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-27T07:08:25.310Z"},{"op":"R","uid":"13","un":"unathig","dt":"2021-10-28T13:09:42.483Z"}] | 1 | 111 | 13 | 3/28/2022 6:33:19 AM | 3 | 13 | |||||||||||||||||||||
| 1080 | 1/28/2021 10:35:24 AM | 1/28/2021 10:35:27 AM | 2 | [{"op":"R","uid":"32","un":"andisiwem","dt":"2021-01-28T10:35:26.970Z"}] | 32 | ||||||||||||||||||||||||||||||||||||
| 1079 | 1/28/2021 10:25:42 AM | 3/28/2022 6:33:19 AM | Water | Account had a high water consumption that needed to be resolved<div><b>Investigate and evaluate six month policy-Period 201805-202011</b></div><div><b><br></b></div><div><b>WATER WRITE OFFS ON ACCOUNT</b></div> | 27 | 3 | 1161 | 3 | 4 | 23 | 1 | 67 | 175 | [{"op":"R","uid":"15","un":"chumab","dt":"2021-01-28T10:25:49.474Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-01-28T10:51:48.454Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-27T06:52:52.478Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-27T06:56:03.685Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-27T06:56:49.610Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-10-31T07:24:37.502Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-10-31T07:27:03.561Z"},{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-11-13T11:51:26.355Z"}] | 1 | 101 | 11 | 3/28/2022 6:33:19 AM | 3 | 11 | |||||||||||||||||||||
| 1077 | 1/28/2021 10:23:53 AM | 5/27/2021 4:24:21 AM | water readings not taken for seven months | does not qualify for six months policy. | 27 | 3 | 1160 | 12 | 4 | 23 | 1 | 50 | [{"op":"R","uid":"12","un":"thembesas","dt":"2021-01-28T10:23:55.902Z"}] | 1 | 50 | 5/27/2021 4:24:21 AM | 12 | 12 | |||||||||||||||||||||||
| 1078 | 1/28/2021 10:23:07 AM | 3/28/2022 7:07:05 AM | Water | Account had a high water consumption that needed to be resolved | 27 | 3 | 1159 | 15 | 4 | 23 | 1 | 67 | [{"op":"R","uid":"15","un":"chumab","dt":"2021-01-28T10:23:14.889Z"}] | 1 | 67 | 3/28/2022 7:07:05 AM | 15 | 15 | |||||||||||||||||||||||
| 1076 | 1/28/2021 10:19:54 AM | 3/28/2022 7:07:05 AM | water | Account had a high consumption that needed to be resolved | 27 | 3 | 1158 | 15 | 4 | 23 | 1 | 67 | [{"op":"R","uid":"15","un":"chumab","dt":"2021-01-28T10:20:01.817Z"}] | 1 | 67 | 3/28/2022 7:07:05 AM | 15 | 15 | |||||||||||||||||||||||
| 1075 | 1/28/2021 10:11:28 AM | 11/12/2021 8:38:15 AM | Water | There was a high consumption that needed to be resolved<br><b>Journal Number</b>: [143643]<div><br></div><div><b>Response QRC</b>: Six Month Policy ,Journal {143643}Authorized.</div> | 27 | 3 | 1157 | 74 | 4 | 23 | 1 | 67 | 172 | [{"op":"R","uid":"15","un":"chumab","dt":"2021-01-28T10:11:36.641Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-10-13T09:57:26.906Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-11-12T08:35:12.604Z"}] | 1 | 101 | 230 | 11/12/2021 8:38:15 AM | 172 | 230 | |||||||||||||||||||||
| 1074 | 1/28/2021 9:58:45 AM | 2/24/2022 10:34:50 AM | water query | water query | 27 | 3 | 1156 | 26 | 2 | 23 | 1 | 67 | 345 | [{"op":"R","uid":"13","un":"unathig","dt":"2021-01-28T09:58:52.825Z"},{"op":"R","uid":"26","un":"nobulalim","dt":"2021-02-04T07:24:57.591Z"},{"op":"R","uid":"26","un":"nobulalim","dt":"2021-02-04T07:25:50.457Z"},{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-10-16T12:42:45.694Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-27T06:49:57.158Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-10-27T06:50:44.820Z"},{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-11-02T11:00:57.311Z"}] | 1 | 111 | 11 | 2/24/2022 10:34:50 AM | 26 | 11 | |||||||||||||||||||||
| 1073 | 1/28/2021 8:29:47 AM | 7/21/2021 9:29:20 AM | no valid query details submitted | no valid query details submitted | 27 | 3 | 12 | 2 | 23 | 1 | 44 | [{"op":"R","uid":"12","un":"thembesas","dt":"2021-01-28T08:29:50.402Z"},{"op":"R","uid":"32","un":"andisiwem","dt":"2021-01-28T10:30:03.869Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-01-28T10:48:58.383Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-07-15T13:14:56.570Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-07-21T09:29:19.182Z"}] | 1 | 44 | 7/21/2021 9:29:20 AM | 12 | 14 |