Re: Missing Client profiles in the Data Lake 1/16/24

From
Monica Johnston <johnstonm@thekey.com>
To
TheKey IT Support <itsupport@thekey.com>, Dart Team <dart-team@thekey.com>, Data Engineering <dataengineering@thekey.com>
Date
ue, 16 Jan 2024 11
Folder
INBOX
*Update 10 AM Pacific*

As a temporary workaround, we have reverted our data lake views to use
yesterday's data. This means we will still be missing any new clients
created yesterday but the profile information for older clients will all be
available.

*Next Steps:*

   - Tableau / Analytics Portal reports are being refreshed
   - New files will be sent to Netsuite for billing

Wellsky is looking into the problem but they have not shared an ETA for the
permanent fix.

Thanks,
Monica

On Tue, Jan 16, 2024 at 10:04 AM Monica Johnston <johnstonm@thekey.com>
wrote:

> This morning we did not receive all of the profile data from Wellsky .
> This means we are missing some active client information (not just new
> profiles).
>
> *What is the Impact?*
>
> *Analytics Portal / Tableau Reports: *Active Client Census metrics on
> reports will be incorrect. Detailed operational reports may have client
> ids/names missing.
>
> *Billing: *Overtime Exception reports missing client information. Files
> sent to Netsuite this morning are missing 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
> Manager of Data 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/>
>

Thread (1)