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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7009 | 6/29/2021 8:33:03 AM | 2/12/2022 7:03:27 AM | Leak letter | No query found | 27 | 3 | 6107 | 11 | 4 | 23 | 1 | 96 | [{"op":"R","uid":"173","un":"olgad","dt":"2021-06-29T08:32:06.839Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2022-02-12T07:02:55.572Z"}] | 1 | 96 | 17 | 2/12/2022 7:03:27 AM | 11 | 17 | ||||||||||||||||||||||
| 7008 | 6/29/2021 8:30:46 AM | 10/8/2022 7:01:29 AM | Leak letter | Affidavit submitted by consumer and filed.<div>water debt written off on 202106</div> | 27 | 3 | 6106 | 17 | 4 | 23 | 1 | 96 | [{"op":"R","uid":"173","un":"olgad","dt":"2021-06-29T08:29:49.761Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2022-02-12T06:45:43.380Z"},{"op":"R","uid":"18","un":"lindan","dt":"2022-02-12T07:02:10.626Z"}] | 1 | 96 | 10/8/2022 7:01:29 AM | 6 | 6 | |||||||||||||||||||||||
| 435091 | 5263 | 6/29/2021 8:30:15 AM | 6/29/2021 8:30:36 AM | IVR call: statement | Received call for statement for account 20177294 sent message: 554 | 8 | 2 | 4438 | 79 | 79 | 6/29/2021 8:30:36 AM | 116283 | |||||||||||||||||||||||||||||
| 435086 | 5532 | 6/29/2021 8:29:28 AM | 6/29/2021 8:30:12 AM | IVR call: statement | Received call for statement for account 10043442 sent message: 553 | 8 | 2 | 4700 | 79 | 79 | 6/29/2021 8:30:12 AM | 116282 | |||||||||||||||||||||||||||||
| 435085 | 5263 | 6/29/2021 8:29:15 AM | 6/29/2021 8:29:16 AM | IVR call: balance | Received call for balance for account 20177294 undefined | 7 | 2 | 4438 | 78 | 78 | 6/29/2021 8:29:16 AM | ||||||||||||||||||||||||||||||
| 435081 | 5263 | 6/29/2021 8:28:34 AM | 6/29/2021 8:28:35 AM | IVR call: balance | Received call for balance for account 20177294 undefined | 7 | 2 | 4438 | 78 | 78 | 6/29/2021 8:28:35 AM | ||||||||||||||||||||||||||||||
| 435080 | 7007 | 6/29/2021 8:28:03 AM | 6/29/2021 8:28:21 AM | IVR call: statement | Received call for statement for account 10292464 sent message: 552 | 8 | 2 | 6105 | 79 | 79 | 6/29/2021 8:28:21 AM | 116281 | |||||||||||||||||||||||||||||
| 7006 | 6/29/2021 8:27:52 AM | 11/13/2022 11:23:32 AM | Leak letter | Plumber's report submitted by consumer and filed.<div><br></div><div>monitor consumption, need two more readings for adjustment</div><div><br></div><div>100% credit on water done 2022/10</div><div><br></div><div><br></div> | 27 | 3 | 6104 | 17 | 4 | 23 | 1 | 96 | [{"op":"R","uid":"173","un":"olgad","dt":"2021-06-29T08:26:56.393Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-08-15T06:52:29.343Z"}] | 1 | 96 | 11/13/2022 11:23:31 AM | 13 | 13 | |||||||||||||||||||||||
| 435075 | 7004 | 6/29/2021 8:25:27 AM | 6/29/2021 8:25:28 AM | IVR call: balance | Received call for balance for account 10178093 undefined | 7 | 2 | 6102 | 78 | 78 | 6/29/2021 8:25:28 AM | ||||||||||||||||||||||||||||||
| 435073 | 6833 | 6/29/2021 8:24:58 AM | 6/29/2021 8:25:31 AM | IVR call: statement | Received call for statement for account 10177226 sent message: 551 | 8 | 2 | 5945 | 79 | 79 | 6/29/2021 8:25:31 AM | 116280 | |||||||||||||||||||||||||||||
| 7003 | 6/29/2021 8:24:46 AM | 2/12/2022 6:42:47 AM | leak letter | Affidavit submitted by consumer and filed.<div>New meter not installed so readings are not up to date.</div><div><br></div> | 27 | 3 | 6101 | 12 | 4 | 23 | 1 | 96 | [{"op":"R","uid":"173","un":"olgad","dt":"2021-06-29T08:23:50.006Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2022-02-12T06:39:59.823Z"}] | 1 | 96 | 17 | 2/12/2022 6:42:47 AM | 12 | 17 | ||||||||||||||||||||||
| 6999 | 6/29/2021 8:24:36 AM | 11/14/2022 1:57:36 PM | WATER QUERY SINCE 2020 | WATER QUERY SINCE 2020<div><br></div><div>QRC RESPONSE: Query Closed due to insufficient information.</div><div>Consumption was charged based on usage.</div><div>Consumer to log a new query if any leaks were repaired and to upload a signed copy of the plumbers letter<br></div> | 27 | 3 | 6100 | 5 | 2 | 23 | 1 | 67 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-06-29T08:23:41.072Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-06-29T08:28:37.285Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2022-02-27T08:54:16.980Z"}] | 1 | 67 | 11/14/2022 1:57:35 PM | 3 | 3 | |||||||||||||||||||||||
| 435071 | 6820 | 6/29/2021 8:24:28 AM | 6/29/2021 8:24:52 AM | IVR call: statement | Received call for statement for account 10007611 sent message: 550 | 8 | 2 | 5933 | 79 | 79 | 6/29/2021 8:24:52 AM | 116279 | |||||||||||||||||||||||||||||
| 435068 | 7001 | 6/29/2021 8:23:42 AM | 6/29/2021 8:23:43 AM | IVR call: balance | Received call for balance for account 10024880 undefined | 7 | 2 | 6098 | 78 | 78 | 6/29/2021 8:23:43 AM | ||||||||||||||||||||||||||||||
| 435066 | 7002 | 6/29/2021 8:23:14 AM | 6/29/2021 8:23:33 AM | IVR call: statement | Received call for statement for account 10268509 sent message: 549 | 8 | 2 | 6099 | 79 | 79 | 6/29/2021 8:23:33 AM | 116278 | |||||||||||||||||||||||||||||
| 435064 | 7001 | 6/29/2021 8:22:46 AM | 6/29/2021 8:22:47 AM | IVR call: balance | Received call for balance for account 10024880 undefined | 7 | 2 | 6098 | 78 | 78 | 6/29/2021 8:22:47 AM | ||||||||||||||||||||||||||||||
| 435065 | 7000 | 6/29/2021 8:22:41 AM | 6/29/2021 8:22:42 AM | IVR call: balance | Received call for balance for account 10114393 undefined | 7 | 2 | 6097 | 78 | 78 | 6/29/2021 8:22:42 AM | ||||||||||||||||||||||||||||||
| 435060 | 6/29/2021 8:22:14 AM | 6/29/2021 8:22:14 AM | IVR call:$554 | Received call for $1248 for account undefined | 6/29/2021 8:22:14 AM | ||||||||||||||||||||||||||||||||||||
| 435056 | 6998 | 6/29/2021 8:21:17 AM | 6/29/2021 8:21:19 AM | IVR call: balance | Received call for balance for account 10407479 undefined | 7 | 2 | 6096 | 78 | 78 | 6/29/2021 8:21:19 AM | ||||||||||||||||||||||||||||||
| 435055 | 6/29/2021 8:20:50 AM | 6/29/2021 8:20:51 AM | IVR call:$553 | Received call for $1247 for account undefined | 6/29/2021 8:20:51 AM |