RE: Data lake missing Wellsky data from yesterday 5/9/24

Hi Monica,



Following up on this. Was Wellsky able to make any progress over the
weekend? I’m sure you’re aware of the prep that’s 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 <johnstonm@thekey.com>
*Sent:* Friday, May 10, 2024 6:10 PM
*To:* Dart Team <dart-team@thekey.com>; Data Engineering <
dataengineering@thekey.com>; Donny Deshotels <donny.deshotels@thekey.com>
*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 PM Monica Johnston <johnstonm@thekey.com>
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 AM Monica Johnston <johnstonm@thekey.com>
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



-- 

*Monica Johnston *

Director, Data Platform and Services

johnstonm@thekey.com <https://brand.thekey.com/esg/johnstonm@thekey.com>

(602) 501-7890

*TheKey.com * <https://www.thekey.com/>

[image: Image removed by sender. TheKey] <https://homecareassistance.com/>