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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1930 | 2/27/2021 7:54:54 AM | 3/2/2022 8:22:38 AM | WATER QUERY | WATER QUERY<div>JOURNAL APPROVED - JRNL NO. 447767 (DUPLICATE QUERY)</div> | 27 | 3 | 1800 | 37 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"37","un":"sokanan","dt":"2021-02-27T07:54:56.583Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-10-21T09:36:46.799Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2021-10-27T13:46:30.477Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-29T10:21:35.279Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-30T07:13:32.838Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-30T07:14:03.148Z"}] | 1 | 96 | 2 | 3/2/2022 8:22:38 AM | 37 | 2 | ||||||||||||||||||||||
| 1924 | 2/27/2021 7:27:44 AM | 2/16/2022 9:04:39 AM | Smart Meter not reading | 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 | 1799 | 82 | 4 | 23 | 1 | 47 | 833 | [{"op":"R","uid":"194","un":"nomalungisaw","dt":"2021-02-27T07:27:45.423Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-29T10:20:59.793Z"}] | 9 | 123 | 20 | 2/16/2022 9:04:39 AM | 194 | 20 | |||||||||||||||||||||
| 1929 | 2/27/2021 7:25:41 AM | 11/14/2021 7:09:18 AM | REFUSE QUERY | REFUSE QUERY<br/><b>Journal Number</b>: [71298] | 24 | 3 | 1798 | 2 | 23 | 4 | 106 | [{"op":"R","uid":"37","un":"sokanan","dt":"2021-02-27T07:25:43.260Z"},{"op":"R","uid":"5","un":"ivanh","dt":"2021-05-26T13:34:54.409Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-08-27T08:25:00.361Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-29T10:20:05.110Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-30T07:08:32.197Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-30T07:11:37.892Z"},{"op":"R","uid":"8","un":"mariaanaw","dt":"2021-11-14T07:09:18.802Z"}] | 4 | 50 | 14 | 14 | |||||||||||||||||||||||||
| 1925 | 2/27/2021 7:21:01 AM | 2/27/2021 7:21:03 AM | 2 | [{"op":"R","uid":"195","un":"asandap","dt":"2021-02-27T07:17:37.217Z"}] | 195 | ||||||||||||||||||||||||||||||||||||
| 1926 | 2/27/2021 7:19:29 AM | 3/2/2022 8:22:38 AM | WATER QUERY | <div><br></div><div><table border="0" cellpadding="0" cellspacing="0" width="668" style="border-collapse: collapse; width: 501pt;"><tbody><tr height="31" style="height: 23.45pt;"><td height="31" class="xl63" width="668" style="height: 23.45pt; 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></div> | 27 | 3 | 1797 | 37 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"37","un":"sokanan","dt":"2021-02-27T07:19:30.993Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-27T12:23:47.974Z"},{"op":"R","uid":"6","un":"lusandad","dt":"2021-11-10T11:52:24.736Z"}] | 9 | 123 | 6 | 3/2/2022 8:22:38 AM | 37 | 6 | ||||||||||||||||||||||
| 1923 | 2/27/2021 7:13:21 AM | 4/12/2022 9:39:10 AM | 6 MONTH POLICY DUE | Walk in consumer querying high water consumption, said that her neighbor meter was leaking not hers. 6 month policy due <br/><b>Journal Number</b>: [838628]<br/><b>Journal Amount</b>: [-R3,542.15] | 27 | 3 | 1796 | 4 | 2 | 23 | 1 | 95 | [{"op":"R","uid":"10","un":"mellozanef","dt":"2021-02-27T07:13:22.895Z"},{"op":"R","uid":"15","un":"chumab","dt":"2021-06-07T12:17:09.588Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-27T12:23:04.705Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-29T10:19:35.519Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2022-02-18T07:28:53.638Z"}] | 1 | 101 | 3 | 4/12/2022 9:39:10 AM | 4 | 3 | ||||||||||||||||||||||
| 1922 | 2/27/2021 7:09:13 AM | 3/2/2022 8:22:38 AM | WATER QUERY | High consumption, consumer to check for leaks and send plumbers invoice, | 27 | 3 | 1795 | 37 | 2 | 23 | 1 | 67 | 831 | [{"op":"R","uid":"37","un":"sokanan","dt":"2021-02-27T07:09:15.753Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-08-29T09:19:46.543Z"}] | 1 | 67 | 3/2/2022 8:22:38 AM | 37 | 17 | ||||||||||||||||||||||
| 1921 | 2/26/2021 2:48:25 PM | 2/26/2021 2:48:27 PM | 2 | 1794 | [{"op":"R","uid":"21","un":"heinrichs","dt":"2021-02-26T14:45:01.918Z"}] | 21 | |||||||||||||||||||||||||||||||||||
| 1920 | 2/26/2021 1:53:47 PM | 2/26/2021 1:53:53 PM | 2 | 1793 | [{"op":"R","uid":"21","un":"heinrichs","dt":"2021-02-26T13:50:23.734Z"}] | 21 | |||||||||||||||||||||||||||||||||||
| 1918 | 2/26/2021 12:36:15 PM | 2/26/2021 12:36:17 PM | 2 | 1792 | [{"op":"R","uid":"21","un":"heinrichs","dt":"2021-02-26T12:32:51.461Z"}] | 21 | |||||||||||||||||||||||||||||||||||
| 1917 | 2/26/2021 11:56:29 AM | 2/2/2022 12:28:44 PM | High water consumption | <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 | 1 | 67 | 830 | [{"op":"R","uid":"73","un":"nombongof","dt":"2021-02-26T11:56:32.642Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-29T10:19:14.759Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-10-30T09:52:36.063Z"}] | 9 | 123 | 14 | 2/2/2022 12:28:44 PM | 73 | 14 | ||||||||||||||||||||||
| 1916 | 2/26/2021 11:07:50 AM | 3/2/2022 8:22:38 AM | WATER QUERY | WATER QUERY<div>JRNL DONE FOR WATER LEAK - 7.10.2021</div> | 27 | 3 | 1791 | 37 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"37","un":"sokanan","dt":"2021-02-26T11:07:52.084Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2021-10-07T07:37:33.822Z"},{"op":"R","uid":"2","un":"debbiecr","dt":"2021-10-12T06:39:26.086Z"}] | 1 | 96 | 2 | 3/2/2022 8:22:38 AM | 37 | 2 | ||||||||||||||||||||||
| 1915 | 2/26/2021 11:01:29 AM | 2/24/2022 11:08:12 AM | water query submitted a plumbers letter | water query submitted plumbers letter | 27 | 3 | 1790 | 22 | 2 | 23 | 1 | 67 | 828 | [{"op":"R","uid":"22","un":"asandam","dt":"2021-02-26T11:01:31.585Z"},{"op":"R","uid":"22","un":"asandam","dt":"2021-02-26T11:01:43.602Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-29T10:10:59.429Z"}] | 1 | 67 | 2/24/2022 11:08:12 AM | 22 | 12 | ||||||||||||||||||||||
| 1914 | 2/26/2021 10:57:27 AM | 2/24/2022 11:08:12 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 | 1789 | 22 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"22","un":"asandam","dt":"2021-02-26T10:57:29.751Z"},{"op":"R","uid":"22","un":"asandam","dt":"2021-02-26T10:57:41.758Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-29T10:18:45.882Z"}] | 9 | 123 | 20 | 2/24/2022 11:08:12 AM | 22 | 20 | ||||||||||||||||||||||
| 1913 | 2/26/2021 10:52:55 AM | 2/24/2022 11:08:12 AM | readings | readings up-to-date | 27 | 3 | 1788 | 22 | 2 | 23 | 77 | 48 | [{"op":"R","uid":"22","un":"asandam","dt":"2021-02-26T10:52:57.949Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-15T08:29:41.971Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-08-15T08:30:10.442Z"}] | 77 | 48 | 2/24/2022 11:08:12 AM | 22 | 12 | |||||||||||||||||||||||
| 1912 | 2/26/2021 10:15:32 AM | 2/24/2022 11:08:12 AM | water query june 2020 | water query <div><br></div><div><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif; mso-fareast-font-family:"Times New Roman";mso-ansi-language:EN-ZA;mso-fareast-language: EN-US;mso-bidi-language:AR-SA">Waterworks control no: 713015 dated 2020/09 </span>recommendation credit and referred to Coastal Billing on 22.06.2021 </b></div><div><br></div><div><b>Journal processed and approved. Query resolved.</b></div> | 27 | 3 | 1787 | 22 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"22","un":"asandam","dt":"2021-02-26T10:15:34.761Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-07-10T06:24:38.344Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-29T10:17:48.125Z"},{"op":"R","uid":"214","un":"nandipan","dt":"2022-02-13T10:53:57.946Z"}] | 1 | 96 | 214 | 2/24/2022 11:08:12 AM | 22 | 214 | ||||||||||||||||||||||
| 1911 | 2/26/2021 10:10:00 AM | 2/24/2022 11:08:12 AM | water query | water query | 27 | 3 | 1786 | 22 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"22","un":"asandam","dt":"2021-02-26T10:10:02.703Z"},{"op":"R","uid":"13","un":"unathig","dt":"2021-10-23T08:41:17.753Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-10-29T10:17:17.656Z"}] | 1 | 113 | 13 | 2/24/2022 11:08:12 AM | 22 | 13 | ||||||||||||||||||||||
| 1910 | 2/26/2021 10:05:08 AM | 2/24/2022 11:08:12 AM | water query | water query<div>Journal done</div> | 27 | 3 | 1785 | 22 | 2 | 23 | 77 | 67 | [{"op":"R","uid":"22","un":"asandam","dt":"2021-02-26T10:05:10.496Z"},{"op":"R","uid":"17","un":"cwayitak","dt":"2021-10-14T07:56:23.761Z"}] | 1 | 101 | 17 | 2/24/2022 11:08:12 AM | 22 | 17 | ||||||||||||||||||||||
| 1909 | 2/26/2021 10:00:48 AM | 3/2/2022 8:22:38 AM | RATES QUERY | RATES QUERY<div><br></div><div>From Rates Dpt:</div><div><table border="0" cellpadding="0" cellspacing="0" width="64" style="border-collapse: collapse;width:48pt"><tbody><tr height="20" style="height:15.0pt"> <td height="20" class="xl65" align="right" width="64" style="height:15.0pt; width:48pt"><br></td></tr></tbody></table><table border="0" cellpadding="0" cellspacing="0" width="547" style="border-collapse: collapse;width:410pt"><tbody><tr height="20" style="height:15.0pt"> <td height="20" class="xl65" width="547" style="height:15.0pt;width:410pt">No records of objection or a query form submitted to Valuations.</td></tr></tbody></table></div> | 27 | 3 | 1783 | 37 | 2 | 23 | 77 | 62 | [{"op":"R","uid":"37","un":"sokanan","dt":"2021-02-26T10:00:50.249Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-05-28T09:25:46.557Z"}] | 77 | 62 | 3/2/2022 8:22:38 AM | 37 | 3 | |||||||||||||||||||||||
| 1909 | 2/26/2021 10:00:32 AM | 5/28/2021 9:23:49 AM | Unknown | Query voided due to no information | 4 | 2 | 77 | [{"op":"R","uid":"37","un":"sokanan","dt":"2021-02-26T10:00:34.533Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-05-28T09:26:35.710Z"}] | 77 | 5/28/2021 9:23:49 AM | 3 |