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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8892 | 8/10/2021 10:26:19 AM | 10/27/2022 11:04:43 AM | Water query | High consumption<div><br></div><div>Do not qualify for 6 month policy</div> | 27 | 3 | 7849 | 15 | 2 | 23 | 1 | 67 | [{"op":"R","uid":"34","un":"mcdonaldm","dt":"2021-08-10T10:24:36.684Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-23T13:22:04.062Z"}] | 1 | 101 | 14 | 10/27/2022 11:04:42 AM | 137814 | 10 | 10 | |||||||||||||||||||||
| 8891 | 8/10/2021 10:22:26 AM | 8/10/2021 10:22:28 AM | 2 | [{"op":"R","uid":"34","un":"mcdonaldm","dt":"2021-08-10T10:20:43.682Z"}] | 34 | ||||||||||||||||||||||||||||||||||||
| 8890 | 8/10/2021 10:05:36 AM | 8/10/2021 10:05:38 AM | 2 | [{"op":"R","uid":"58","un":"dorelld","dt":"2021-08-10T10:06:39.374Z"}] | 58 | ||||||||||||||||||||||||||||||||||||
| 8889 | 8/10/2021 10:04:59 AM | 8/10/2021 10:05:01 AM | 1 | [{"op":"R","uid":"58","un":"dorelld","dt":"2021-08-10T10:06:01.801Z"}] | 58 | ||||||||||||||||||||||||||||||||||||
| 478566 | 5817 | 8/10/2021 10:04:14 AM | 8/10/2021 10:04:15 AM | IVR call:$83 | Received call for $616 for account 10380799 | 4963 | 8/10/2021 10:04:15 AM | ||||||||||||||||||||||||||||||||||
| 8888 | 8/10/2021 10:00:24 AM | 8/10/2021 10:03:31 AM | 2 | 7848 | [{"op":"R","uid":"58","un":"dorelld","dt":"2021-08-10T10:01:27.634Z"},{"op":"R","uid":"58","un":"dorelld","dt":"2021-08-10T10:04:32.153Z"}] | 58 | |||||||||||||||||||||||||||||||||||
| 5252 | 8/10/2021 9:53:43 AM | 2/21/2023 7:57:32 AM | Six Months Policy | Please apply six months policy<div><br></div><div>100% leak credit done for to periods 2020 & 2022 as per water works reports<br><br><table class="rich-table " id="baseForm:bem10024Table" border="0" cellpadding="0" cellspacing="0" style="margin: 0px; padding: 0px; border-width: 1px 0px 0px 1px; border-top-style: solid; border-right-style: initial; border-bottom-style: initial; border-left-style: solid; border-top-color: rgb(192, 192, 192); border-right-color: initial; border-bottom-color: initial; border-left-color: rgb(192, 192, 192); border-image: initial; font-family: Arial, Helvetica, sans-serif; empty-cells: show; border-collapse: collapse; border-radius: 4px; font-size: 11px; letter-spacing: 1px; white-space: pre-wrap; width: 713px;"><tbody id="baseForm:bem10024Table:tb" style="margin: 0px; padding: 0px; border: 0px;"><tr class="rich-table-row n2j-odd" style="margin: 0px; padding: 0px; border: 0px; vertical-align: middle; height: 18px; background-color: rgb(241, 241, 241);"></tr><tr class="rich-table-row n2j-even" style="margin: 0px; padding: 0px; border: 0px; vertical-align: middle; height: 18px;"><td class="rich-table-cell " id="baseForm:bem10024Table:5:j_id104" width="87px" style="margin: 0px; padding: 0px; border-right-width: 1px; border-bottom-width: 1px; border-top-style: initial; border-left-style: initial; border-top-color: initial; border-right-color: rgb(192, 192, 192); border-bottom-color: rgb(192, 192, 192); border-left-color: initial; border-image: initial; font-family: Arial, Verdana, sans-serif; font-size: 11px; vertical-align: middle; height: 18px;"><span class="n2j-row-cell" style="margin: 0px; padding: 0px; border: 0px; font-family: "Courier New", Helvetica, sans-serif; white-space: pre; width: 80px;">2020/11/25</span></td><td class="rich-table-cell " id="baseForm:bem10024Table:5:j_id107" width="23px" style="margin: 0px; padding: 0px; border-right-width: 1px; border-bottom-width: 1px; border-top-style: initial; border-left-style: initial; border-top-color: initial; border-right-color: rgb(192, 192, 192); border-bottom-color: rgb(192, 192, 192); border-left-color: initial; border-image: initial; font-family: Arial, Verdana, sans-serif; font-size: 11px; vertical-align: middle; height: 18px;"><span class="n2j-row-cell" style="margin: 0px; padding: 0px; border: 0px; font-family: "Courier New", Helvetica, sans-serif; white-space: pre; width: 24px;">3</span></td><td class="rich-table-cell " id="baseForm:bem10024Table:5:j_id110" width="111px" style="margin: 0px; padding: 0px; border-right-width: 1px; border-bottom-width: 1px; border-top-style: initial; border-left-style: initial; border-top-color: initial; border-right-color: rgb(192, 192, 192); border-bottom-color: rgb(192, 192, 192); border-left-color: initial; border-image: initial; font-family: Arial, Verdana, sans-serif; font-size: 11px; vertical-align: middle; height: 18px; text-align: right;"><span class="n2j-row-cell" style="margin: 0px; padding: 0px; border: 0px; font-family: "Courier New", Helvetica, sans-serif; white-space: pre; width: 104px;">1443.000</span></td><td class="rich-table-cell " id="baseForm:bem10024Table:5:j_id113" width="103px" style="margin: 0px; padding: 0px; border-right-width: 1px; border-bottom-width: 1px; border-top-style: initial; border-left-style: initial; border-top-color: initial; border-right-color: rgb(192, 192, 192); border-bottom-color: rgb(192, 192, 192); border-left-color: initial; border-image: initial; font-family: Arial, Verdana, sans-serif; font-size: 11px; vertical-align: middle; height: 18px; text-align: right;"><span class="n2j-row-cell" style="margin: 0px; padding: 0px; border: 0px; font-family: "Courier New", Helvetica, sans-serif; white-space: pre; width: 96px;">1.00000</span></td><td class="rich-table-cell " id="baseForm:bem10024Table:5:j_id116" width="119px" style="margin: 0px; padding: 0px; border-right-width: 1px; border-bottom-width: 1px; border-top-style: initial; border-left-style: initial; border-top-color: initial; border-right-color: rgb(192, 192, 192); border-bottom-color: rgb(192, 192, 192); border-left-color: initial; border-image: initial; font-family: Arial, Verdana, sans-serif; font-size: 11px; vertical-align: middle; height: 18px; text-align: right;"><span class="n2j-row-cell" style="margin: 0px; padding: 0px; border: 0px; font-family: "Courier New", Helvetica, sans-serif; white-space: pre; width: 104px;">411.000</span></td><td class="rich-table-cell " id="baseForm:bem10024Table:5:j_id119" width="28px" style="margin: 0px; padding: 0px; border-right-width: 1px; border-bottom-width: 1px; border-top-style: initial; border-left-style: initial; border-top-color: initial; border-right-color: rgb(192, 192, 192); border-bottom-color: rgb(192, 192, 192); border-left-color: initial; border-image: initial; font-family: Arial, Verdana, sans-serif; font-size: 11px; vertical-align: middle; height: 18px;"><span class="n2j-row-cell" style="margin: 0px; padding: 0px; border: 0px; font-family: "Courier New", Helvetica, sans-serif; white-space: pre; width: 8px;">C</span></td><td class="rich-table-cell " id="baseForm:bem10024Table:5:j_id122" width="31px" style="margin: 0px; padding: 0px; border-right-width: 1px; border-bottom-width: 1px; border-top-style: initial; border-left-style: initial; border-top-color: initial; border-right-color: rgb(192, 192, 192); border-bottom-color: rgb(192, 192, 192); border-left-color: initial; border-image: initial; font-family: Arial, Verdana, sans-serif; font-size: 11px; vertical-align: middle; height: 18px;"><span class="n2j-row-cell" style="margin: 0px; padding: 0px; border: 0px; font-family: "Courier New", Helvetica, sans-serif; white-space: pre; width: 30px;"></span></td><td class="rich-table-cell " id="baseForm:bem10024Table:5:j_id125" width="87px" style="margin: 0px; padding: 0px; border-right-width: 1px; border-bottom-width: 1px; border-top-style: initial; border-left-style: initial; border-top-color: initial; border-right-color: rgb(192, 192, 192); border-bottom-color: rgb(192, 192, 192); border-left-color: initial; border-image: initial; font-family: Arial, Verdana, sans-serif; font-size: 11px; vertical-align: middle; height: 18px;"><span class="n2j-row-cell" style="margin: 0px; padding: 0px; border: 0px; font-family: "Courier New", Helvetica, sans-serif; white-space: pre; width: 80px;">2020/12/27</span></td><td class="rich-table-cell " id="baseForm:bem10024Table:5:j_id128" width="50px" style="margin: 0px; padding: 0px; border-right-width: 1px; border-bottom-width: 1px; border-top-style: initial; border-left-style: initial; border-top-color: initial; border-right-color: rgb(192, 192, 192); border-bottom-color: rgb(192, 192, 192); border-left-color: initial; border-image: initial; font-family: Arial, Verdana, sans-serif; font-size: 11px; vertical-align: middle; height: 18px;"><br><span class="n2j-row-cell" style="margin: 0px; padding: 0px; border: 0px; font-family: "Courier New", Helvetica, sans-serif; white-space: pre; width: 48px;"></span></td></tr><tr class="rich-table-row n2j-odd" style="margin: 0px; padding: 0px; border: 0px; vertical-align: middle; height: 18px; background-color: rgb(241, 241, 241);"><td class="rich-table-cell " id="baseForm:bem10024Table:6:j_id104" width="87px" style="margin: 0px; padding: 0px; border-right-width: 1px; border-bottom-width: 1px; border-top-style: initial; border-left-style: initial; border-top-color: initial; border-right-color: rgb(192, 192, 192); border-bottom-color: rgb(192, 192, 192); border-left-color: initial; border-image: initial; font-family: Arial, Verdana, sans-serif; font-size: 11px; vertical-align: middle; height: 18px;"><span class="n2j-row-cell" style="margin: 0px; padding: 0px; border: 0px; font-family: "Courier New", Helvetica, sans-serif; white-space: pre; width: 80px;">2020/03/19</span></td><td class="rich-table-cell " id="baseForm:bem10024Table:6:j_id107" width="23px" style="margin: 0px; padding: 0px; border-right-width: 1px; border-bottom-width: 1px; border-top-style: initial; border-left-style: initial; border-top-color: initial; border-right-color: rgb(192, 192, 192); border-bottom-color: rgb(192, 192, 192); border-left-color: initial; border-image: initial; font-family: Arial, Verdana, sans-serif; font-size: 11px; vertical-align: middle; height: 18px;"><span class="n2j-row-cell" style="margin: 0px; padding: 0px; border: 0px; font-family: "Courier New", Helvetica, sans-serif; white-space: pre; width: 24px;">3</span></td><td class="rich-table-cell " id="baseForm:bem10024Table:6:j_id110" width="111px" style="margin: 0px; padding: 0px; border-right-width: 1px; border-bottom-width: 1px; border-top-style: initial; border-left-style: initial; border-top-color: initial; border-right-color: rgb(192, 192, 192); border-bottom-color: rgb(192, 192, 192); border-left-color: initial; border-image: initial; font-family: Arial, Verdana, sans-serif; font-size: 11px; vertical-align: middle; height: 18px; text-align: right;"><span class="n2j-row-cell" style="margin: 0px; padding: 0px; border: 0px; font-family: "Courier New", Helvetica, sans-serif; white-space: pre; width: 104px;">1032.000</span></td><td class="rich-table-cell " id="baseForm:bem10024Table:6:j_id113" width="103px" style="margin: 0px; padding: 0px; border-right-width: 1px; border-bottom-width: 1px; border-top-style: initial; border-left-style: initial; border-top-color: initial; border-right-color: rgb(192, 192, 192); border-bottom-color: rgb(192, 192, 192); border-left-color: initial; border-image: initial; font-family: Arial, Verdana, sans-serif; font-size: 11px; vertical-align: middle; height: 18px; text-align: right;"><span class="n2j-row-cell" style="margin: 0px; padding: 0px; border: 0px; font-family: "Courier New", Helvetica, sans-serif; white-space: pre; width: 96px;">1.00000</span></td><td class="rich-table-cell " id="baseForm:bem10024Table:6:j_id116" width="119px" style="margin: 0px; padding: 0px; border-right-width: 1px; border-bottom-width: 1px; border-top-style: initial; border-left-style: initial; border-top-color: initial; border-right-color: rgb(192, 192, 192); border-bottom-color: rgb(192, 192, 192); border-left-color: initial; border-image: initial; font-family: Arial, Verdana, sans-serif; font-size: 11px; vertical-align: middle; height: 18px; text-align: right;"><span class="n2j-row-cell" style="margin: 0px; padding: 0px; border: 0px; font-family: "Courier New", Helvetica, sans-serif; white-space: pre; width: 104px;">67.000</span></td><td class="rich-table-cell " id="baseForm:bem10024Table:6:j_id119" width="28px" style="margin: 0px; padding: 0px; border-right-width: 1px; border-bottom-width: 1px; border-top-style: initial; border-left-style: initial; border-top-color: initial; border-right-color: rgb(192, 192, 192); border-bottom-color: rgb(192, 192, 192); border-left-color: initial; border-image: initial; font-family: Arial, Verdana, sans-serif; font-size: 11px; vertical-align: middle; height: 18px;"><span class="n2j-row-cell" style="margin: 0px; padding: 0px; border: 0px; font-family: "Courier New", Helvetica, sans-serif; white-space: pre; width: 8px;">C</span></td><td class="rich-table-cell " id="baseForm:bem10024Table:6:j_id122" width="31px" style="margin: 0px; padding: 0px; border-right-width: 1px; border-bottom-width: 1px; border-top-style: initial; border-left-style: initial; border-top-color: initial; border-right-color: rgb(192, 192, 192); border-bottom-color: rgb(192, 192, 192); border-left-color: initial; border-image: initial; font-family: Arial, Verdana, sans-serif; font-size: 11px; vertical-align: middle; height: 18px;"><span class="n2j-row-cell" style="margin: 0px; padding: 0px; border: 0px; font-family: "Courier New", Helvetica, sans-serif; white-space: pre; width: 30px;">003</span></td><td class="rich-table-cell " id="baseForm:bem10024Table:6:j_id125" width="87px" style="margin: 0px; padding: 0px; border-right-width: 1px; border-bottom-width: 1px; border-top-style: initial; border-left-style: initial; border-top-color: initial; border-right-color: rgb(192, 192, 192); border-bottom-color: rgb(192, 192, 192); border-left-color: initial; border-image: initial; font-family: Arial, Verdana, sans-serif; font-size: 11px; vertical-align: middle; height: 18px;"><span class="n2j-row-cell" style="margin: 0px; padding: 0px; border: 0px; font-family: "Courier New", Helvetica, sans-serif; white-space: pre; width: 80px;">2020/04/24 </span></td></tr></tbody></table></div><br/><b>Journal Number</b>: [744777]<br/><b>Journal Amount</b>: [54196.05] | 27 | 3 | 4427 | 15 | 4 | 23 | 1 | 95 | [{"op":"R","uid":"196","un":"lazolaw","dt":"2021-08-10T09:53:45.483Z"},{"op":"R","uid":"196","un":"lazolaw","dt":"2021-08-13T08:59:04.377Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-23T13:21:28.533Z"},{"op":"R","uid":"1208","un":"xolar","dt":"2022-04-19T07:54:58.185Z"}] | 1 | 101 | 1208 | 2/21/2023 7:57:26 AM | 127958 | 2 | 2 | |||||||||||||||||||||
| 8887 | 8/10/2021 9:51:37 AM | 6/18/2022 1:21:41 PM | Incorrect Meter | Meter on site - 1409497, reading - 514 (taken today, 10/08/2021)<div><b>I<i>nvestigate and Evaluate six Month policy</i></b>-Period 202002-202101</div> | 23 | 3 | 7847 | 2 | 1 | 1 | 98 | [{"op":"R","uid":"196","un":"lazolaw","dt":"2021-08-10T09:51:39.569Z"},{"op":"R","uid":"230","un":"nolusindisos","dt":"2021-09-27T09:40:59.595Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-23T13:20:44.605Z"}] | 1 | 112 | 14 | 13 | |||||||||||||||||||||||||
| 478551 | 6523 | 8/10/2021 9:50:26 AM | 8/10/2021 9:50:27 AM | IVR call: balance | Received call for balance for account 10406206 undefined | 7 | 2 | 5641 | 78 | 78 | 8/10/2021 9:50:27 AM | ||||||||||||||||||||||||||||||
| 8886 | 8/10/2021 9:48:49 AM | 11/17/2022 1:21:40 PM | WATER QUERY | High water consumption and current readings 165<div><br></div><div>- H/C reported w/w ref 793797</div><div><b><u><br></u></b></div><div><b><u>QRC RESPONSE: </u></b>Write offs cleared HC Debt. Customer needs to log a new query and check for internal leaks.</div> | 27 | 3 | 7846 | 17 | 4 | 23 | 1 | 67 | [{"op":"R","uid":"199","un":"siphokazin","dt":"2021-08-10T09:48:51.221Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-23T13:19:58.045Z"}] | 1 | 111 | 14 | 11/17/2022 1:21:40 PM | 8 | 8 | ||||||||||||||||||||||
| 478540 | 5266 | 8/10/2021 9:46:48 AM | 8/10/2021 9:46:49 AM | IVR call: balance | Received call for balance for account 10022863 undefined | 7 | 2 | 4441 | 78 | 78 | 8/10/2021 9:46:49 AM | ||||||||||||||||||||||||||||||
| 478530 | 8878 | 8/10/2021 9:43:24 AM | 8/10/2021 9:43:25 AM | IVR call: balance | Received call for balance for account 10345764 undefined | 7 | 2 | 7836 | 78 | 78 | 8/10/2021 9:43:25 AM | ||||||||||||||||||||||||||||||
| 478529 | 8885 | 8/10/2021 9:43:16 AM | 8/10/2021 9:44:10 AM | IVR call: statement | Received call for statement for account 10422217 sent message: 1572 | 8 | 2 | 7845 | 79 | 79 | 8/10/2021 9:44:10 AM | 117301 | |||||||||||||||||||||||||||||
| 478520 | 8878 | 8/10/2021 9:41:28 AM | 8/10/2021 9:41:29 AM | IVR call: balance | Received call for balance for account 10345764 undefined | 7 | 2 | 7836 | 78 | 78 | 8/10/2021 9:41:29 AM | ||||||||||||||||||||||||||||||
| 478519 | 8/10/2021 9:40:27 AM | 8/10/2021 9:40:28 AM | IVR call:$82 | Received call for $615 for account undefined | 8/10/2021 9:40:28 AM | ||||||||||||||||||||||||||||||||||||
| 8884 | 8/10/2021 9:36:19 AM | 1/12/2023 10:58:46 AM | water | water leak<div>QRC Response - consumer to submit or resubmit plumber"s report. no registered contact number on account</div><div><br></div><div>query closed due to insufficient info</div> | 27 | 3 | 7844 | 17 | 3 | 23 | 1 | 96 | [{"op":"R","uid":"196","un":"lazolaw","dt":"2021-08-10T09:34:36.152Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-23T13:19:25.972Z"}] | 1 | 96 | 14 | 1/12/2023 10:58:46 AM | 141570 | 13 | 13 | |||||||||||||||||||||
| 478504 | 8883 | 8/10/2021 9:29:10 AM | 8/10/2021 9:29:12 AM | IVR call: balance | Received call for balance for account 10012437 undefined | 7 | 2 | 7841 | 78 | 78 | 8/10/2021 9:29:12 AM | ||||||||||||||||||||||||||||||
| 478502 | 8882 | 8/10/2021 9:28:55 AM | 8/10/2021 9:28:57 AM | IVR call: balance | Received call for balance for account 10151311 undefined | 7 | 2 | 7840 | 78 | 78 | 8/10/2021 9:28:57 AM | ||||||||||||||||||||||||||||||
| 8880 | 8/10/2021 9:22:56 AM | 2/14/2023 6:41:10 AM | water | water leak | 30 | 3 | 7839 | 17 | 3 | 23 | 1 | 96 | [{"op":"R","uid":"196","un":"lazolaw","dt":"2021-08-10T09:21:13.409Z"},{"op":"R","uid":"14","un":"asandag","dt":"2021-11-23T13:18:57.941Z"}] | 1 | 96 | 14 | 232 | ||||||||||||||||||||||||
| 478465 | 7829 | 8/10/2021 9:14:22 AM | 8/10/2021 9:14:44 AM | IVR call: statement | Received call for statement for account 10015498 sent message: 1571 | 8 | 2 | 6871 | 79 | 79 | 8/10/2021 9:14:44 AM | 117300 |