--000000000000e0647e0618576793 Content-Type: multipart/alternative; boundary="000000000000e0647d0618576792" --000000000000e0647d0618576792 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Lazlo, We did get the Canadian data over the weekend but we did not receive it on time this morning due to an issue with their control table that triggers our data integration. We have the up to date data now and are in the middle of running dependent processes. I am adding Amy on here since Ed has designated her to coordinate issue communication and escalations with Wellsky. However I did already alert them to the problem this morning. They said it was resolved over the weekend so I hope this was just a minor timing issue. Thanks, Monica On Mon, May 13, 2024 at 6:58=E2=80=AFAM Laszlo Kovacs wrote: > Hi Monica, > > > > Following up on this. Was Wellsky able to make any progress over the > weekend? I=E2=80=99m sure you=E2=80=99re aware of the prep that=E2=80=99s= gone into this conversion > by the Finance teams as well as messaging to impacted CAD customers. We > need to push our absolute hardest to have Wellskey get this remedied asap > or there will need to be a ton of re-work and an impact on customer > experience. > > > > Thanks, > > > > *From:* Monica Johnston > *Sent:* Friday, May 10, 2024 6:10 PM > *To:* Dart Team ; Data Engineering dataengineering@thekey.com>; Donny Deshotels > *Subject:* Re: Data lake missing Wellsky data from yesterday 5/9/24 > > > > *Update as of 4 pm Pacific:* > > > > Wellsky is still working on the issue. There is no ETA at this time. > > > > *Billing: *Since we will not have Canadian data available in the data > lake today, we are sending the US data to Netsuite now. > > > > Thanks, > > Monica > > > > On Fri, May 10, 2024 at 12:19=E2=80=AFPM Monica Johnston > wrote: > > *Update as of noon Pacific:* > > - Analytics Portal reports have been refreshed with up to date US data > - We have been notified by Wellsky that it will take them an > additional 2 hours to provide the Canadian data. > > > > On Fri, May 10, 2024 at 9:31=E2=80=AFAM Monica Johnston > wrote: > > This morning we did not receive any of the Canadian data from Wellsky. > This also caused an issue with our ability to load the US data into our > reporting tables in the data lake. > > > > *What is the Impact?* > > > > *Analytics Portal / Tableau Reports: *SoC, billed hours, revenue and > other metrics relying on Clearcare data are missing yesterday's totals. > > - ETA to have reports refreshed for US is 1 hour > - ETA for Canadian data is 4 hours > > *Billing: *Files sent to Netsuite this morning are missing data. We will > resend once Wellsky has provided the Canadian data. > > > > *Payroll:* This should not affect payroll. > > > > I will send out an update when I have more information. Please reach out > to me directly if you have any questions. > > > > Thanks! > > Monica > > > > BCC: Executive team, Regional Directors, Tableau Desktop U