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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3829 | 5/4/2021 1:19:44 PM | 2/25/2023 9:16:21 AM | WATER QUERY | WATER QUERY<div><br></div><div>QRC RESPONSE: 6 MONTH POLICY - 201311</div><div>CONSUMER MUST TO PHONED TO FIND OUT IF ANY LEAKS HAVE BEEN REPAIRED AS SYSTEM SHOWS H/C.</div> | 30 | 3 | 3250 | 15 | 2 | 23 | 1 | 67 | 1788 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-05-04T13:23:46.002Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-05-04T13:24:40.536Z"},{"op":"R","uid":"30","un":"thembekilem","dt":"2021-05-04T17:19:01.320Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-22T10:34:49.175Z"}] | 1 | 101 | 14 | 143171 | 10 | ||||||||||||||||||||||
| 3825 | 5/4/2021 1:16:52 PM | 4/12/2022 9:39:10 AM | el reading 693 its for water meter , but it was starting date of el meter | el reading 693 its for water meter , but it was starting date of el meter <br/><b>Journal Number</b>: [204162]<br/><b>Journal Amount</b>: [-R14,225.12] | 27 | 3 | 3249 | 4 | 4 | 23 | 2 | 44 | 2245 | [{"op":"R","uid":"4","un":"babalwam","dt":"2021-05-04T13:16:36.360Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-05-22T08:55:28.588Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-05-22T11:01:03.008Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-22T10:33:39.214Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2022-01-07T12:27:26.845Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2022-01-07T12:30:32.382Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2022-01-12T12:20:54.413Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2022-01-18T13:36:28.153Z"}] | 1 | 111 | 3 | 4/12/2022 9:39:10 AM | 4 | 3 | |||||||||||||||||||||
| 3827 | 5/4/2021 1:12:54 PM | 11/22/2021 10:32:57 AM | QUERY | <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 | 3248 | 14 | 2 | 23 | 1 | 67 | 1784 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-05-04T13:16:58.953Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-05-04T13:18:05.078Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-22T10:31:37.371Z"}] | 9 | 123 | 14 | 11/22/2021 10:32:57 AM | 14 | 14 | |||||||||||||||||||||
| 3825 | 5/4/2021 1:09:19 PM | 3/28/2022 6:33:19 AM | leak 100% credit | leak 100% credit | 27 | 3 | 3249 | 3 | 4 | 23 | 1 | 44 | [{"op":"R","uid":"4","un":"babalwam","dt":"2021-05-04T13:09:04.866Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-05-04T13:09:45.939Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2021-05-04T13:09:58.226Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-05-22T08:55:56.401Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2022-01-07T12:26:55.668Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2022-01-07T12:27:11.095Z"},{"op":"R","uid":"4","un":"babalwam","dt":"2022-01-13T11:09:53.191Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2022-01-18T13:36:25.213Z"}] | 1 | 96 | 4 | 3/28/2022 6:33:19 AM | 3 | 4 | ||||||||||||||||||||||
| 3826 | 5/4/2021 1:07:01 PM | 3/28/2022 7:10:22 AM | SIX MONTHS POLICY | ACCOUNT ADJUSTED<br/><b>Journal Number</b>: [521254]<br/><b>Journal Amount</b>: [217.33] | 27 | 3 | 3247 | 11 | 2 | 23 | 1 | 67 | 1782 | [{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-05-04T13:07:03.577Z"},{"op":"R","uid":"12","un":"thembesas","dt":"2021-06-13T10:47:11.194Z"},{"op":"R","uid":"201","un":"nonkosim","dt":"2022-03-09T11:09:32.919Z"},{"op":"R","uid":"201","un":"nonkosim","dt":"2022-03-09T11:17:04.978Z"},{"op":"R","uid":"201","un":"nonkosim","dt":"2022-03-10T09:42:46.186Z"},{"op":"R","uid":"201","un":"nonkosim","dt":"2022-03-10T09:43:03.143Z"}] | 1 | 67 | 3/28/2022 7:10:22 AM | 11 | 201 | ||||||||||||||||||||||
| 3824 | 5/4/2021 12:49:48 PM | 5/19/2022 7:53:10 AM | WATER QUERY | WATER QUERY | 27 | 3 | 3246 | 18 | 2 | 23 | 1 | 67 | 1781 | [{"op":"R","uid":"18","un":"lindan","dt":"2021-05-04T12:49:32.374Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-05-04T12:50:27.148Z"},{"op":"R","uid":"16","un":"cumilem","dt":"2021-08-18T07:36:46.105Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-22T10:30:17.530Z"},{"op":"R","uid":"13","un":"unathig","dt":"2022-02-13T10:26:13.149Z"}] | 1 | 101 | 13 | 5/19/2022 7:53:10 AM | 18 | 13 | |||||||||||||||||||||
| 3823 | 5/4/2021 12:41:17 PM | 2/12/2022 9:16:01 AM | WATER QUERY | WATER QUERY<div><br></div><div>ACC DOES NOT QUALIFY FOR 6 MONTHS POLICY</div> | 27 | 3 | 3245 | 14 | 2 | 23 | 1 | 67 | 1779 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-05-04T12:45:18.241Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-05-04T12:46:35.948Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-22T10:29:19.523Z"},{"op":"R","uid":"15","un":"chumab","dt":"2022-02-12T09:15:21.423Z"}] | 1 | 101 | 15 | 2/12/2022 9:16:01 AM | 14 | 15 | |||||||||||||||||||||
| 3822 | 5/4/2021 12:30:03 PM | 10/16/2022 8:07:04 AM | WATER QUERY | plumbers letter/affidavit submitted for leak fixed in october 2020 | 30 | 3 | 3244 | 17 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"18","un":"lindan","dt":"2021-05-04T12:29:48.030Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-05-04T12:31:09.594Z"},{"op":"R","uid":"16","un":"cumilem","dt":"2021-08-18T07:54:07.457Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-11-12T06:23:38.988Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-22T10:28:44.397Z"}] | 1 | 96 | 14 | 137954 | 14 | |||||||||||||||||||||||
| 3821 | 5/4/2021 12:23:42 PM | 2/25/2023 9:02:42 AM | WATER QUERY SIX MONTHS POLICY | WATER QUERY SIX MONTHS POLICY<div><br></div><div>SIX MONTHS POLICY ADJUSTMENT DONE<br></div><br><b>Journal Number</b>: [994323]<div><br></div><div>QRC RESPONSE: JOURNAL AUTHORIZED AND ADJUSTED -202203</div> | 27 | 3 | 3243 | 15 | 4 | 23 | 1 | 95 | [{"op":"R","uid":"18","un":"lindan","dt":"2021-05-04T12:23:27.174Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-05-04T12:24:43.235Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-22T10:27:46.480Z"},{"op":"R","uid":"15","un":"chumab","dt":"2022-02-21T12:30:20.399Z"},{"op":"R","uid":"15","un":"chumab","dt":"2022-02-27T08:28:43.381Z"},{"op":"R","uid":"15","un":"chumab","dt":"2022-02-27T08:30:52.242Z"}] | 1 | 101 | 15 | 2/25/2023 9:02:42 AM | 124337 | 10 | 10 | |||||||||||||||||||||
| 3820 | 5/4/2021 12:19:32 PM | 4/3/2023 12:33:31 PM | water query | high water consumption <div><br></div><div>Reading of 2020/08 billing was changed, but no adjustment done. </div><div>Adjustment under assessment</div><div><br></div><div>Over read journal processed with reversal of interest from 202010/202206<br><span id="baseForm:a4jContentPanel"><table class="rich-table " id="baseForm:bem08002Table" style="position: absolute;height: 212px;width: 708px;" cellspacing="0" cellpadding="0" border="0"><tbody id="baseForm:bem08002Table:tb"><tr class="rich-table-row n2j-odd"><td class="rich-table-cell " id="baseForm:bem08002Table:2:j_id135" width="71px"><span class="n2j-row-cell" style="width: 64px;">20200821</span></td></tr></tbody></table></span></div><br/><b>Journal Number</b>: [889224]<br/><b>Journal Amount</b>: [-R18,507.51] | 27 | 3 | 3242 | 12 | 2 | 23 | 1 | 95 | [{"op":"R","uid":"26","un":"nobulalim","dt":"2021-05-04T12:48:56.082Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-22T10:26:02.807Z"}] | 1 | 111 | 14 | 4/3/2023 12:33:27 PM | 143166 | 3 | 3 | |||||||||||||||||||||
| 3819 | 5/4/2021 12:11:46 PM | 2/25/2023 8:52:45 AM | WATER QUERY 6 MONTH POLICY | WATER QUERY 6 MONTH POLICY<div><br></div><div>QRC RESPONSE: 6 MONTH POLICIES DUE FOR BOTH PERIODS 202004 AND 202102.</div><div>JOURNALS TO BE PROCESSED </div> | 30 | 3 | 3241 | 15 | 4 | 23 | 1 | 67 | 1776 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-05-04T12:15:47.566Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-05-04T12:17:00.512Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-22T10:25:27.209Z"}] | 1 | 101 | 14 | 143164 | 10 | ||||||||||||||||||||||
| 3818 | 5/4/2021 11:39:08 AM | 2/25/2023 8:45:13 AM | SIX MONTHS POLICY | ACCOUNT ADJUSTED<br><b>Journal Number</b>: [507830]<div><br></div><div>QRC RESPONSE: 6 MONTH POLICY AUTHORIZED AND ADJUSTED 202107 FOR THE PERIOD 201912</div> | 27 | 3 | 3240 | 15 | 2 | 23 | 1 | 67 | 1774 | [{"op":"R","uid":"11","un":"sibusisoy","dt":"2021-05-04T11:39:10.446Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-22T10:24:41.940Z"}] | 1 | 101 | 14 | 2/25/2023 8:45:13 AM | 143161 | 10 | 10 | ||||||||||||||||||||
| 3816 | 5/4/2021 11:19:00 AM | 2/2/2022 12:28:44 PM | High water consumption | Kindly investigate high water charges raised on this account.<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 | 72 | 2 | 23 | 1 | 67 | 1773 | [{"op":"R","uid":"73","un":"nombongof","dt":"2021-05-04T11:18:44.609Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-22T10:22:46.603Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-22T10:23:04.121Z"}] | 9 | 123 | 14 | 2/2/2022 12:28:44 PM | 73 | 14 | ||||||||||||||||||||||
| 3815 | 5/4/2021 10:56:39 AM | 2/2/2022 12:28:44 PM | High water consumption | Kindly investigate high water charges raised on this account.<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 | 72 | 2 | 23 | 1 | 67 | 1772 | [{"op":"R","uid":"73","un":"nombongof","dt":"2021-05-04T10:56:23.707Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-22T10:21:19.319Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-22T10:21:31.951Z"}] | 9 | 123 | 14 | 2/2/2022 12:28:44 PM | 73 | 14 | ||||||||||||||||||||||
| 3808 | 5/4/2021 10:51:17 AM | 2/2/2022 12:28:44 PM | High water consumption | Kindly investigate high water charges raised on this account.<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 | 72 | 2 | 23 | 1 | 67 | 1771 | [{"op":"R","uid":"73","un":"nombongof","dt":"2021-05-04T10:51:02.305Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-22T10:19:50.958Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-22T10:20:04.476Z"}] | 9 | 123 | 14 | 2/2/2022 12:28:44 PM | 73 | 14 | ||||||||||||||||||||||
| 3813 | 5/4/2021 10:47:06 AM | 11/22/2021 10:19:18 AM | QUERY | <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 | 3239 | 14 | 4 | 23 | 1 | 67 | 1770 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-05-04T10:51:07.659Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-05-04T10:51:56.216Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-22T10:16:59.072Z"}] | 9 | 123 | 14 | 11/22/2021 10:19:18 AM | 14 | 14 | |||||||||||||||||||||
| 3811 | 5/4/2021 10:41:57 AM | 11/22/2021 10:16:35 AM | WATER QUERY 6 MONTH POLICY | WATER QUERY 6 MONTH POLICY | 30 | 3 | 3238 | 4 | 23 | 1 | 67 | 1768 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-05-04T10:45:59.161Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-05-04T10:47:10.353Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-22T10:16:24.851Z"}] | 1 | 101 | 14 | 14 | ||||||||||||||||||||||||
| 3809 | 5/4/2021 9:55:11 AM | 5/17/2022 8:51:08 AM | double charge on fire levy -- credit due to consumer | double charge on fire levy -- credit due to consumer<div><br><div>Duplicate query closed</div></div> | 27 | 3 | 3237 | 20 | 2 | 23 | 3 | 105 | [{"op":"R","uid":"20","un":"nzwanam","dt":"2021-05-04T09:54:56.506Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-05-04T09:56:16.275Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-05-04T09:56:21.028Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-05-12T12:09:17.976Z"},{"op":"R","uid":"5","un":"ivanh","dt":"2021-06-09T13:20:06.786Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-06-13T10:41:02.104Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-06-13T10:41:37.961Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2022-02-23T10:15:34.264Z"}] | 3 | 105 | 5/17/2022 8:51:08 AM | 20 | 20 | |||||||||||||||||||||||
| 3807 | 5/4/2021 9:16:52 AM | 5/17/2022 8:51:08 AM | Water query | Water query - water leak<div><br></div><div>Duplicate query resolve don ref #11864</div> | 27 | 3 | 3236 | 20 | 2 | 23 | 1 | 96 | [{"op":"R","uid":"20","un":"nzwanam","dt":"2021-05-04T09:16:37.205Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-05-04T09:19:42.079Z"},{"op":"R","uid":"20","un":"nzwanam","dt":"2021-05-04T09:19:44.741Z"},{"op":"R","uid":"18","un":"lindan","dt":"2021-06-08T07:45:52.229Z"},{"op":"R","uid":"3","un":"fareezar","dt":"2021-08-08T10:03:21.808Z"}] | 1 | 96 | 5/17/2022 8:51:08 AM | 20 | 3 | |||||||||||||||||||||||
| 3806 | 5/4/2021 8:50:16 AM | 11/25/2022 2:02:43 PM | HIGH WATER CONSUMPTION | CONSUMER QUERYING THE HIGH CONSUMPTION OF WATER. KINDLY INVESTIGATE AND RESOLVE.<br/><b>Journal Number</b>: [642666]<br/><b>Journal Amount</b>: [75113.77] | 27 | 3 | 3235 | 15 | 2 | 23 | 1 | 67 | 1766 | [{"op":"R","uid":"14","un":"asandag","dt":"2021-05-04T08:54:26.239Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-22T10:15:37.265Z"},{"op":"R","uid":"201","un":"nonkosim","dt":"2022-02-14T09:03:27.232Z"},{"op":"R","uid":"201","un":"nonkosim","dt":"2022-02-15T07:40:04.850Z"},{"op":"R","uid":"13","un":"unathig","dt":"2022-02-15T11:46:24.619Z"}] | 1 | 101 | 13 | 11/25/2022 2:02:35 PM | 2 | 2 |