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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9148 | 8/14/2021 9:13:48 AM | 7/9/2022 10:18:11 AM | Water | Query resolved | 27 | 3 | 8087 | 17 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-08-14T09:12:01.658Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-08-20T10:03:07.973Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-23T11:57:21.393Z"}] | 1 | 96 | 14 | 7/9/2022 10:18:10 AM | 17 | 17 | ||||||||||||||||||||||
| 483806 | 6146 | 8/14/2021 9:13:04 AM | 8/14/2021 9:13:06 AM | IVR call: balance | Received call for balance for account 10245390 undefined | 7 | 2 | 5275 | 78 | 78 | 8/14/2021 9:13:06 AM | ||||||||||||||||||||||||||||||
| 9147 | 8/14/2021 9:07:57 AM | 11/23/2021 11:56:56 AM | Water | Plumber's Letter received. | 30 | 3 | 8086 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-08-14T09:06:11.116Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-23T11:56:45.498Z"}] | 1 | 96 | 14 | 14 | |||||||||||||||||||||||||
| 4973 | 8/14/2021 9:06:18 AM | 8/14/2021 9:10:00 AM | WATER, REFUSE & FIRE LEVY TARIFF CHANGE | Adjustments done.<div><br></div><div>Query resolved.</div> | 30 | 2 | 3695 | 77 | [{"op":"R","uid":"214","un":"nandiphan","dt":"2021-08-14T09:04:32.462Z"},{"op":"R","uid":"214","un":"nandiphan","dt":"2021-08-14T09:06:14.571Z"},{"op":"R","uid":"214","un":"nandiphan","dt":"2021-08-14T09:08:13.017Z"}] | 77 | 214 | ||||||||||||||||||||||||||||||
| 483780 | 9146 | 8/14/2021 8:59:43 AM | 8/14/2021 9:00:05 AM | IVR call: statement | Received call for statement for account 10027965 sent message: 1688 | 8 | 2 | 8085 | 79 | 79 | 8/14/2021 9:00:05 AM | 117417 | |||||||||||||||||||||||||||||
| 9145 | 8/14/2021 8:59:22 AM | 4/12/2022 9:43:30 AM | Water | Plumber's Letter received.<br/><b>Journal Number</b>: [741997]<br/><b>Journal Amount</b>: [159967.68] | 27 | 3 | 8084 | 7 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-08-14T08:57:35.855Z"},{"op":"R","uid":"58","un":"dorelld","dt":"2021-11-15T12:01:33.051Z"},{"op":"R","uid":"58","un":"dorelld","dt":"2021-11-15T12:03:29.513Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-23T11:56:07.814Z"},{"op":"R","uid":"203","un":"babalwas","dt":"2022-01-27T13:04:11.548Z"},{"op":"R","uid":"203","un":"babalwas","dt":"2022-01-27T13:06:16.051Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2022-02-18T07:47:18.635Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2022-02-21T13:29:15.604Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2022-03-01T07:58:48.567Z"},{"op":"R","uid":"58","un":"dorelld","dt":"2022-03-03T08:20:22.070Z"}] | 1 | 96 | 2 | 4/12/2022 9:43:30 AM | 119824 | 7 | 2 | |||||||||||||||||||||
| 9145 | 8/14/2021 8:56:56 AM | 3/3/2022 8:21:57 AM | LOG | <table border="0" cellpadding="0" cellspacing="0" width="864" style="border-collapse: collapse;width:648pt"><tbody><tr height="20" style="height:15.0pt"> <td height="20" class="xl65" width="864" style="height:15.0pt;width:648pt">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 | 8084 | 11 | 2 | 23 | [{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-08-14T08:55:10.202Z"},{"op":"R","uid":"58","un":"dorelld","dt":"2021-11-15T12:01:22.349Z"},{"op":"R","uid":"58","un":"dorelld","dt":"2021-11-15T12:01:54.192Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-23T11:53:51.538Z"},{"op":"R","uid":"203","un":"babalwas","dt":"2022-01-27T13:06:06.499Z"},{"op":"R","uid":"58","un":"dorelld","dt":"2022-03-03T08:21:57.991Z"}] | 9 | 123 | 14 | 3/3/2022 8:21:57 AM | 11 | 14 | ||||||||||||||||||||||||
| 9143 | 8/14/2021 8:49:21 AM | 11/17/2022 2:00:03 PM | Termination done | Termination Done all services transferred to the owner. | 27 | 3 | 8083 | 5 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-08-14T08:47:35.540Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-23T11:55:23.092Z"}] | 6 | 76 | 14 | 11/17/2022 2:00:02 PM | 8 | 8 | ||||||||||||||||||||||
| 9144 | 8/14/2021 8:47:42 AM | 8/14/2021 8:52:29 AM | BLOCKING OF METER | Query resolved | 30 | 2 | 8082 | 77 | [{"op":"R","uid":"214","un":"nandiphan","dt":"2021-08-14T08:45:56.257Z"}] | 77 | 214 | ||||||||||||||||||||||||||||||
| 483743 | 9142 | 8/14/2021 8:42:23 AM | 5/10/2022 10:28:26 AM | IVR call: balance | Received call for balance for account 10359134 undefined | 7 | 2 | 8081 | 78 | [{"op":"R","uid":"205","un":"zovuyod","dt":"2022-05-10T10:27:48.452Z"},{"op":"R","uid":"205","un":"zovuyod","dt":"2022-05-10T10:28:13.366Z"}] | 78 | 5/10/2022 10:28:26 AM | 205 | ||||||||||||||||||||||||||||
| 9141 | 8/14/2021 8:41:10 AM | 11/23/2021 10:57:25 AM | plumbers letter submitted. | account protected till 20210818 , consumption still high. | 30 | 3 | 8080 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"6","un":"lusandad","dt":"2021-08-14T08:41:11.957Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-23T10:56:59.767Z"}] | 1 | 96 | 14 | 14 | |||||||||||||||||||||||||
| 9140 | 8/14/2021 8:40:49 AM | 2/26/2023 8:16:06 AM | Water | Plumbers letter received /Affidavit. | 30 | 3 | 8079 | 17 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-08-14T08:39:03.337Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-23T10:56:14.058Z"}] | 1 | 96 | 14 | 14 | ||||||||||||||||||||||||
| 9137 | 8/14/2021 8:37:32 AM | 8/14/2021 8:43:54 AM | INCORRECT METER LINKED- INTERIM CHARGED ON SMART METER | New meter linked to account, consumer charged actual reading from May 2021. Interim reversed.<div><br></div><div>Query resolved.</div> | 30 | 2 | 8077 | 77 | [{"op":"R","uid":"214","un":"nandiphan","dt":"2021-08-14T08:35:46.523Z"}] | 77 | 214 | ||||||||||||||||||||||||||||||
| 9139 | 8/14/2021 8:27:32 AM | 7/9/2022 10:23:02 AM | WATER | query resolved | 27 | 3 | 8076 | 7 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-08-14T08:25:45.779Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-23T10:55:40.945Z"}] | 1 | 96 | 14 | 7/9/2022 10:23:02 AM | 17 | 17 | ||||||||||||||||||||||
| 483727 | 9138 | 8/14/2021 8:22:28 AM | 8/14/2021 8:22:29 AM | IVR call: balance | Received call for balance for account 10260087 undefined | 7 | 2 | 8075 | 78 | 78 | 8/14/2021 8:22:29 AM | ||||||||||||||||||||||||||||||
| 9136 | 8/14/2021 8:21:59 AM | 4/12/2022 9:47:18 AM | Leak Adjustment | Journal Done<br/><b>Journal Number</b>: [880173] | 24 | 3 | 8074 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"17","un":"cwayitak","dt":"2021-08-14T08:20:13.608Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-23T10:55:11.148Z"}] | 1 | 96 | 14 | 14 | |||||||||||||||||||||||||
| 9134 | 8/14/2021 8:20:57 AM | 11/23/2021 10:54:23 AM | LOG | <table border="0" cellpadding="0" cellspacing="0" width="864" style="border-collapse: collapse;width:648pt"><tbody><tr height="20" style="height:15.0pt"> <td height="20" class="xl65" width="864" style="height:15.0pt;width:648pt">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 | 8073 | 75 | 2 | 23 | [{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-08-14T08:19:11.423Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-23T10:53:36.808Z"}] | 9 | 123 | 14 | 11/23/2021 10:54:23 AM | 173 | 14 | ||||||||||||||||||||||||
| 9135 | 8/14/2021 8:20:26 AM | 3/28/2022 7:08:29 AM | Late termination | Late termination 201906-201910<br><b>Journal Number</b>: [880172]<div><b>Response from QRC:</b></div><div>Journal Authorised.</div><div>Query Resolved.</div> | 27 | 3 | 8072 | 6 | 2 | 23 | 6 | 107 | [{"op":"R","uid":"172","un":"sesonad","dt":"2021-08-14T08:18:40.433Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-08-16T09:52:24.549Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-08-16T10:07:45.402Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-08-16T10:08:13.410Z"},{"op":"R","uid":"172","un":"sesonad","dt":"2021-09-08T09:28:08.735Z"},{"op":"R","uid":"172","un":"sesonad","dt":"2021-09-08T09:29:13.862Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-09-30T11:37:55.547Z"}] | 6 | 122 | 3/28/2022 7:08:29 AM | 6 | 230 | |||||||||||||||||||||||
| 8440 | 8/14/2021 8:18:39 AM | 8/14/2021 8:20:26 AM | Unprocessed pmt | Query was related to unprocessed pmt.<div><br></div><div>Query resolved.</div> | 30 | 2 | 7442 | 77 | [{"op":"R","uid":"214","un":"nandiphan","dt":"2021-08-14T08:20:10.438Z"}] | 77 | 214 | ||||||||||||||||||||||||||||||
| 9129 | 8/14/2021 7:58:54 AM | 8/14/2021 8:01:49 AM | UNPROCESSED PMT | Tariff has been corrected, query was related to interest and interest was reversed. 27/05.<div><br></div><div>Query resolved.</div> | 30 | 2 | 8071 | 77 | [{"op":"R","uid":"214","un":"nandiphan","dt":"2021-08-14T08:00:27.370Z"}] | 77 | 214 |