*Update:* *We have completed loading the raw Wellsky data to the data lake
and are working on the dependant processes.*
*Tableau Cloud / Analytics Portal Reports: *ETA for reports to be refreshed
is 3 hours.
*Billing: *We will start the extract process shortly and this takes approx
2-3 hours.
*Payroll: *We have pushed the data to Workday already and will refresh the
related Tableau reports now. ETA is 30 minutes.
Thanks,
Monica
On Tue, Dec 10, 2024 at 10:31 AM Monica Johnston <johnstonm@thekey.com>
wrote:
> *Update:* *This has been resolved on the Wellsky side and so we are now
> able to start loading the data.*
>
> *Analytics Portal / Tableau Reports: *ETA for reports to be refreshed is
> 4-5 hours
>
>
> *Billing: *Files should be sent in < 4 hours.
>
>
>
> *Payroll: *We should be ready to send the data to Workday as well as send
> the error report and refresh exception reports in 2-3 hours.
>
>
> Thanks,
>
> Monica
>
> On Tue, Dec 10, 2024 at 9:35 AM Monica Johnston <johnstonm@thekey.com>
> wrote:
>
>> We have not yet received yesterday's Wellsky US data into the data lake. We
>> do not yet have an ETA.
>>
>>
>>
>> *What is the Impact?*
>>
>>
>>
>> *Analytics Portal / Tableau Reports: *SoC, billed hours, revenue and
>> other metrics relying on Clearcare data are understated for the US sites
>> for current week (missing yesterday's updates).
>>
>>
>> *Billing: *Files were not sent to Netsuite yet today.
>>
>>
>>
>> *Payroll:* Caregiver shift and payroll expense data were not yet sent to
>> Workday.
>>
>>
>>
>> Please reach out if you have any questions.
>>
>>
>>
>> Thanks!
>>
>> Monica
>>
>>
>>
>> BCC: Executive team, Regional Directors, Tableau Desktop Users, Payroll
>> Notifications, Billing Alerts, Marketing Dept, General Managers, Sales
>> Leadership Team, BD Corp
>>
>>
>> --
>> 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/>
>>
>