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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2036 | 3/4/2021 10:22:20 AM | 2/2/2022 12:28:44 PM | Account consolidation | <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 | 72 | 2 | 23 | 77 | 76 | [{"op":"R","uid":"73","un":"nombongof","dt":"2021-03-04T10:22:14.751Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-29T10:10:42.407Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-30T07:43:14.823Z"}] | 9 | 123 | 14 | 2/2/2022 12:28:44 PM | 73 | 14 | |||||||||||||||||||||||
| 2035 | 3/4/2021 10:20:21 AM | 2/2/2022 12:28:44 PM | high electricity charge query | 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. | 4 | 3 | 72 | 2 | 23 | 2 | 44 | 895 | [{"op":"R","uid":"73","un":"nombongof","dt":"2021-03-04T10:20:16.651Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-29T10:11:06.190Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-30T07:42:57.614Z"}] | 9 | 123 | 20 | 2/2/2022 12:28:44 PM | 73 | 20 | ||||||||||||||||||||||
| 2034 | 3/4/2021 10:18:45 AM | 2/2/2022 12:28:44 PM | high electricity consumption query | <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="xl63" 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 | 72 | 2 | 23 | 77 | 44 | [{"op":"R","uid":"73","un":"nombongof","dt":"2021-03-04T10:18:39.354Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-29T10:41:59.795Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-30T07:40:57.709Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-30T07:41:55.134Z"}] | 9 | 123 | 14 | 2/2/2022 12:28:44 PM | 73 | 14 | |||||||||||||||||||||||
| 2033 | 3/4/2021 10:17:09 AM | 2/2/2022 12:28:44 PM | high water consumption query | kindly investigate high water charges raised on this account.<div>No account details</div> | 27 | 3 | 72 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"73","un":"nombongof","dt":"2021-03-04T10:17:03.695Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2021-07-21T07:37:52.889Z"}] | 77 | 67 | 2/2/2022 12:28:44 PM | 73 | 2 | ||||||||||||||||||||||||
| 2032 | 3/4/2021 9:58:34 AM | 3/28/2022 7:25:06 AM | water query | water query<div><br></div><div>journal done</div><br/><b>Journal Number</b>: [095715] | 27 | 3 | 1878 | 17 | 4 | 23 | 77 | 67 | [{"op":"R","uid":"26","un":"nobulalim","dt":"2021-03-04T09:58:36.140Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-08-30T10:19:53.265Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-29T10:40:59.118Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-30T07:40:27.674Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-10-31T07:01:48.541Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-11-02T06:32:06.329Z"}] | 1 | 101 | 3 | 3/28/2022 7:25:06 AM | 17 | 3 | ||||||||||||||||||||||
| 2031 | 3/4/2021 9:55:27 AM | 2/24/2022 10:34:50 AM | water query | 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. | 4 | 3 | 1877 | 26 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"26","un":"nobulalim","dt":"2021-03-04T09:55:30.097Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-29T10:40:40.730Z"},{"op":"R","uid":"201","un":"nonkosim","dt":"2021-12-29T14:15:25.022Z"}] | 9 | 123 | 20 | 2/24/2022 10:34:50 AM | 26 | 20 | ||||||||||||||||||||||
| 2029 | 3/4/2021 9:09:27 AM | 10/16/2021 12:25:02 PM | apply 6mths policy | b/c was with billing in 2020/09/28<br/><b>Journal Number</b>: [BJ71095826]<br/><b>Journal Amount</b>: [-R1821.54] | 27 | 3 | 1876 | 75 | 2 | 23 | 1 | 95 | [{"op":"R","uid":"25","un":"ernelizef","dt":"2021-03-04T09:09:29.776Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-10-16T12:24:16.718Z"}] | 1 | 101 | 3 | 10/16/2021 12:25:02 PM | 173 | 3 | ||||||||||||||||||||||
| 2027 | 3/4/2021 9:02:25 AM | 2/24/2022 10:34:50 AM | late termination query | water and rates billed on previous owner account<br/><b>Journal Amount</b>: [462417] | 27 | 3 | 1875 | 26 | 2 | 23 | 77 | 107 | [{"op":"R","uid":"26","un":"nobulalim","dt":"2021-03-04T08:58:56.766Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-07T08:58:03.458Z"},{"op":"R","uid":"173","un":"olgad","dt":"2021-08-10T08:40:59.459Z"},{"op":"R","uid":"173","un":"olgad","dt":"2021-08-10T08:41:04.019Z"},{"op":"R","uid":"173","un":"olgad","dt":"2021-08-10T10:20:29.883Z"},{"op":"R","uid":"172","un":"sesonad","dt":"2021-09-14T12:53:22.315Z"},{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-10-13T09:52:30.606Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-29T10:38:14.142Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-29T10:38:49.675Z"}] | 6 | 122 | 20 | 2/24/2022 10:34:50 AM | 26 | 20 | ||||||||||||||||||||||
| 2028 | 3/4/2021 8:50:51 AM | 3/28/2022 6:33:19 AM | Plumbers Letter | Plumbers Letter received for repairs dated Feb 2021. Consumption to be monitored for 03 months to determine average usage<div><br></div><div>Journal Processed 08.08.2021. Journal Number BJ71826816</div><div>Duplicate query resolved on ref #11983</div><br/><b>Journal Amount</b>: [45498.85] | 27 | 3 | 1874 | 3 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"3","un":"fareezar","dt":"2021-03-04T08:50:53.052Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-08-16T12:40:56.305Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2021-10-13T06:00:22.276Z"}] | 1 | 96 | 2 | 3/28/2022 6:33:19 AM | 3 | 2 | ||||||||||||||||||||||
| 2026 | 3/4/2021 8:46:50 AM | 5/15/2022 10:52:54 AM | internal leak | consumer had two leaks internally and was fixed by leak finder<br/><b>Journal Amount</b>: [-R26,168.03]<br/><b>Journal Number</b>: [156991] | 27 | 3 | 1873 | 17 | 2 | 23 | 77 | 100 | [{"op":"R","uid":"25","un":"ernelizef","dt":"2021-03-04T08:46:52.716Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-29T10:40:15.136Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-30T07:39:50.027Z"},{"op":"R","uid":"23","un":"bevins","dt":"2022-03-22T18:44:18.468Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2022-05-15T10:46:25.727Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2022-05-15T10:46:46.733Z"}] | 1 | 96 | 3 | 5/15/2022 10:52:54 AM | 17 | 3 | ||||||||||||||||||||||
| 2026 | 3/4/2021 8:46:35 AM | 3/4/2021 8:46:43 AM | 2 | 1873 | [{"op":"R","uid":"25","un":"ernelizef","dt":"2021-03-04T08:46:37.526Z"}] | 25 | |||||||||||||||||||||||||||||||||||
| 2024 | 3/4/2021 7:32:51 AM | 2/16/2022 9:04:39 AM | HIGH WATER CONSUMPTION | HIGH WATER CONSUMPTION IN FEBRUARY 2021 AFTER SMART METER INSTALLED INSTALLED. DEBTOR SAYS THERE'S A SMART METER. ALSO THERE WAS A LEAK IN 2019 AND WATERWORKS FIXED IT<div><br></div><div><b>RESPONSE QRC</b>: Six month policy ,Journal {071808} Authorized.</div> | 27 | 3 | 1872 | 82 | 4 | 23 | 77 | 67 | [{"op":"R","uid":"194","un":"nomalungisaw","dt":"2021-03-04T07:29:40.501Z"},{"op":"R","uid":"194","un":"nomalungisaw","dt":"2021-03-04T07:35:26.813Z"},{"op":"R","uid":"194","un":"nomalungisaw","dt":"2021-03-04T07:35:48.572Z"},{"op":"R","uid":"194","un":"nomalungisaw","dt":"2021-04-20T09:12:24.297Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-29T10:39:41.508Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-30T07:39:29.877Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-11-03T13:32:34.700Z"}] | 1 | 96 | 230 | 2/16/2022 9:04:39 AM | 194 | 230 | ||||||||||||||||||||||
| 2023 | 3/4/2021 7:11:16 AM | 11/19/2022 7:28:43 AM | water | pending journal<br><b>Journal Number</b>: [005299]<div><br></div><div>QRC RESPONSE: Query resolved March 2022 with an O/R adjustment</div> | 27 | 3 | 1871 | 15 | 4 | 23 | 77 | 67 | [{"op":"R","uid":"194","un":"nomalungisaw","dt":"2021-03-04T07:08:05.460Z"},{"op":"R","uid":"194","un":"nomalungisaw","dt":"2021-04-20T09:10:46.092Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-29T10:39:13.269Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-11-14T10:56:59.760Z"}] | 1 | 101 | 12 | 11/19/2022 7:28:43 AM | 3 | 3 | ||||||||||||||||||||||
| 2022 | 3/3/2021 1:40:09 PM | 2/25/2022 9:01:52 AM | water query | water query | 27 | 3 | 1870 | 29 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"29","un":"thendekam","dt":"2021-03-03T13:40:11.816Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-29T10:05:30.620Z"}] | 77 | 67 | 2/25/2022 9:01:52 AM | 29 | 12 | |||||||||||||||||||||||
| 2020 | 3/3/2021 1:20:48 PM | 2/25/2022 9:01:52 AM | water query | 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. | 4 | 3 | 1869 | 29 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"29","un":"thendekam","dt":"2021-03-03T13:20:50.700Z"},{"op":"R","uid":"29","un":"thendekam","dt":"2021-03-03T13:21:03.935Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-29T10:37:52.108Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-11-14T08:51:59.363Z"}] | 9 | 123 | 20 | 2/25/2022 9:01:52 AM | 29 | 20 | ||||||||||||||||||||||
| 2019 | 3/3/2021 1:10:03 PM | 2/25/2022 9:01:52 AM | water query | account in order | 27 | 3 | 1868 | 29 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"29","un":"thendekam","dt":"2021-03-03T13:10:06.091Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-29T10:37:32.812Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-11-14T10:31:59.592Z"}] | 1 | 96 | 12 | 2/25/2022 9:01:52 AM | 29 | 12 | ||||||||||||||||||||||
| 2018 | 3/3/2021 12:46:14 PM | 3/28/2022 7:10:22 AM | water query -6 month policy | water query<div>six months policy applied.</div><br/><b>Journal Number</b>: [439933] | 24 | 3 | 1867 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"29","un":"thendekam","dt":"2021-03-03T12:46:16.610Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-10-17T09:43:50.163Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-29T10:37:03.808Z"}] | 1 | 101 | 12 | 12 | |||||||||||||||||||||||||
| 2017 | 3/3/2021 12:41:14 PM | 2/27/2023 7:11:29 AM | water query- 6 month policy | water query<div><br></div><div><b>qrc response</b></div><div><b>six months policy adjustment done for 2022/03 period, processed on 17/02/2023 and journal waiting to be authorized</b></div><br/><b>Journal Number</b>: [755379]<br/><b>Journal Amount</b>: [-R3981.86] | 27 | 3 | 1866 | 15 | 4 | 23 | 77 | 67 | [{"op":"R","uid":"29","un":"thendekam","dt":"2021-03-03T12:41:16.511Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-29T10:36:37.897Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-30T07:37:58.410Z"}] | 1 | 101 | 20 | 2/27/2023 7:11:25 AM | 142847 | 3 | 3 | |||||||||||||||||||||
| 2016 | 3/3/2021 12:40:29 PM | 3/22/2022 7:09:10 AM | journal done 424385 | journal done 424385<br/><b>Journal Number</b>: [424385]<br/><b>Journal Amount</b>: [93215.13] | 27 | 3 | 1865 | 2 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"6","un":"lusandad","dt":"2021-03-03T12:40:24.725Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2021-05-19T14:21:23.175Z"}] | 1 | 96 | 3/22/2022 7:09:10 AM | 2 | 2 | |||||||||||||||||||||||
| 2015 | 3/3/2021 12:34:24 PM | 2/25/2022 9:01:52 AM | water query | water query<div><br></div><div>RESOLVED</div> | 27 | 3 | 1864 | 29 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"29","un":"thendekam","dt":"2021-03-03T12:34:26.973Z"},{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-10-16T10:27:54.592Z"}] | 1 | 50 | 11 | 2/25/2022 9:01:52 AM | 29 | 11 |