--0000000000004b15f00618564752 Content-Type: multipart/alternative; boundary="0000000000004b15ef0618564751" --0000000000004b15ef0618564751 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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 g= one 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 ; 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 Users, Payroll Notifications, Billing Alerts --=20 *Monica Johnston * Director, Data Platform and Services johnstonm@thekey.com (602) 501-7890 *TheKey.com * [image: Image removed by sender. TheKey] --0000000000004b15ef0618564751 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable <!-- /* Font Definitions */ @font-face {font-family:Wingdings; panose-1:5 0 0 0 0 0 0 0 0 0;} @font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4;} @font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4;} @font-face {font-family:Aptos;} @font-face {font-family:Roboto;} @font-face {font-family:Georgia; panose-1:2 4 5 2 5 4 5 2 3 3;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {margin:0in; font-size:12.0pt; font-family:"Aptos",sans-serif;} a:link, span.MsoHyp