did the report you got have the update fields?
Hey @Carter Matzinger They did update the values of the law ruler IDs so we went from like 870 blank law ruler IDs to today 52 which is a good news
on the 52 what makes those missing?
I am still looking into that but I believe majority or all may of have been when Richard and I uploaded them in Litify with DL or their contractors giving us all the mapping locations
That was prior to DL saying don't touch anything in Litify
Yeah I shall update you on that when I figure out more
I sent you the meeting invite for the 12:30 call just so we can hear the requests
good job man. I know that is tedious work and you are laying it out really well
We also need to discuss with them (just thought of this now) there are some campaigns in their system we don't have integration automations for (which we probably don't need anymore since they are no longer any future sign ups) but since it is clients they do not have, we need a method for them to be uploaded such as manually them manually entering them. Example:
Firefighting Foam - DL - Flatirons - Shield Legal CPAP - DL - Flatirons - Shield Legal
Cpap I don't think they have any more sign ups and in the settlement phase and the firefighting one Daniel stated that one is in an old end point
yes there are about 171 of those
the list we were working on had 44 cpap but now I am seeing a few more from your list
Yeah this is the file Sahil sent me stating these would need to be backfilled
I talked to Dustin and Nick M and I removed some clients that were in statuses such as flagged and wip. Those two have signed retainers but they are not in signed & declined or final status. Meaning, they have something wrong with them (such as maybe needs to answer missing questions or something similar) and once that is filled out it will go final or if it truly doesn't qualify it will be declined.
But if that is the case they "should" eventually move into signed & declined or signed e-sign final status (granted Luis's team doesn't miss any of those flagged and wips)
So that got our # lower but still a concern for me
these were not on the origional sheet 437465 452238 470845 489553 503793 507243 522349
Original sheet as in the google sheets?
yeah the one we were discussing with Cam for those 171 that were not sent
I see. I just checked them in LR and they all have signed retainers in their profiles so those should be included in the daily MRT
but we didn't identify them in our sheet as not sent
Yeah now I wonder if they do have those clients in Litify but not in our daily report
this sheet here was the one discussing with Cam
No worries maybe a screenshot may work
I see what you are referring to now
Ah this does answer a lot of questions
I am going to swing by
470845 489553 503793 452238 437465 507243
These 6 are CPAP clients who are not in the google sheets but have signed retainers and not in JP's medical record tracker report
Did you have the link for the zoom meeting?
ok yeah me too. I wonder who's the host
hopefully not Joe
I was on view only but Jackson was working on it so I sent him the ID's
Oh okay that makes sense. That works
Hi Carter — would it be okay if we asked Brittany (and/or her team) for their help with one more full reconciliation once we’ve finished backfilling everything? The daily checks have been working well on my end, but once we’re fully caught up, it would be incredibly helpful to have another set of eyes to do a full audit across all case types and all time periods. That way, we can feel confident everything is aligned before continuing with daily checks moving forward. Let me know what you think
I would think once everything is backfilled I 'should' be able to audit the whole thing myself but just in case I run into any road blocks or other requests from cameron, etc I just want to cover my tail and also having extra set of eyes would make myself feel more confident that we sent everything to DL as well
pull whomever you need to make sure you feel comfortable with the report
What does your afternoon look like tomorrow for the flatiron meeting?
I am free in the afternoon if needed to be
Hi @Carter Matzinger — I’m going to start putting together what I think we’ll need in order to complete the dashboard request from Flatirons. I’ll break it down into parts, outline any challenges or limitations we may face, and then share it with you and Joe. That way, when they ask for a realistic timeline, we’ll be able to respond strategically.
I do think this will likely require a few others to help as well, but I’ll include those thoughts in the write-up so we can discuss further once it’s ready.
As part of that, I can also create a simple dashboard using just a small sample of client sign-ups as a walkthrough. That version would cover all the key points above, and we can use the time it takes to build that sample to help estimate how long it might take to scale for all 15K clients.
Hey Edward....sorry I am just seeing this. who would you like to assist you on the dashboard?
Hi Carter. No worries. I haven't decided that part yet however I will later on today finish the structure of it / the blueprints and we can go from there to see if we need to pull others which most likely we would if we want to build it a specific way that they may want it
is it easy if you bring your laptop to my office to go over the dashboard?
when can you swing by?
Are you able to add Andy to flatirons dashboard