>
> *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: TheKey] <https://homecareassistance.com/>
>>>
>>