Cameron Rentch (cameron@internetthings.com)
2025-01-06 09:56:40

@deleted-U04GZ79CPNG @deleted-U05EFH3S2TA @deleted-U07JFNH9C7P Urgent item:

In talking with Flatirons, the benchmark report is not showing any medical records ordered or recevied since July for AFFF and Paraquat. I need this fixed immediately today, ahead of all other items. I also need quality assurance checks on this daily, we can not have mistakes or have things break. They are relying on this data and the integrity of the work. Please tend to this asap and update me when this is fixed. https://docs.google.com/spreadsheets/d/1m4rxn2RqSaVGAiuInWMKWRkKaaWZ0G40bkW9GnC1gBM/edit?gid=432371362#gid=432371362

Flatirons Campaign Benchmark Data
Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-01-06 10:05:21

@Cameron Rentch we will review together and update today

Cameron Rentch (cameron@internetthings.com)
2025-01-06 10:18:04

thank you @Nicholas McFadden

Cameron Rentch (cameron@internetthings.com)
2025-01-06 17:13:51

@deleted-U04GZ79CPNG @Nicholas McFadden is there an update here? I have a call this evening and need to give update to Flatirons

deleted-U04GZ79CPNG
2025-01-06 17:26:54

@Cameron Rentch The reason that we have not been able to update these fields is because Dicello Levitt stopped sending the data after their switch to Litify at the end of July. My team received the data from @Nicholas McFadden at 1:30 and we are working on manually updating the medical records data while Edward works on automating this process based on the new format of the data that we received.

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-01-06 17:30:16

@Cameron Rentch the medical records are going to be included in today's update manually as Brittany just mentioned. We are working to automate the medical record update for the forecast along with my changes by Thursday.

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-01-06 17:32:04

A fully integrated process in GCP will be created over the next couple of weeks to fully automate everything. This will include a Looker Dashboard alongside the excel report.

Cameron Rentch (cameron@internetthings.com)
2025-01-06 20:55:45

Thank you @deleted-U04GZ79CPNG @Nicholas McFadden I appreciate it

deleted-U04GZ79CPNG
2025-01-06 23:01:49

@here Flatirons Benchmarks are updated with medical record data.

Cameron Rentch (cameron@internetthings.com)
2025-01-07 21:52:45

@deleted-U04GZ79CPNG thank you

Cameron Rentch (cameron@internetthings.com)
2025-05-15 16:01:04

@deleted-U05EFH3S2TA

Can you please ensure that the DL benchmarks are 1000% accurate for all DL Flatirons, specifically regarding NH and Maryland.

NH - my understanding is that we were almost completed with all of the claims online. However, ABE mentioned to me that we were about 50% done. I need to have a clear answer and understand it.

Maryland - we had some differences in the data and I need to make sure it is all properly reflected within the benchmarks and clearly understand where we are in regards to accurate total signed, claimants and completed secondary interviews

Cameron Rentch (cameron@internetthings.com)
2025-05-15 16:01:17

@deleted-U04GZ79CPNG @Nicholas McFadden

Cameron Rentch (cameron@internetthings.com)
2025-05-15 16:02:07

@deleted-U07JFNH9C7P i’d like to get an understanding of a breakdown between how many claimants have been processed by Vernon and how many have been processed by Henry due to this concern of Abe’s.

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-05-15 16:53:35

@Cameron Rentch our MD benchmark is correct. DL needs to move things around in their system but we are handling them correctly. We will review NH, we started on LA County according to Abe’s prioritization. We will pivot to NH and begin that audit but I would imagine if there are differences it will be due to DL miscategorizing the ones they put in manually

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-05-15 16:58:36

We have the counts correct but the flatiron milestones from the secondary aren’t necessarily copied back to the intake where we are generating things. We just had a discussion yesterday about this and trying to copy over what is in the secondary back into the intake as an automated process so this information stays up to date. However, the count and statuses of the leads in the data are all correct

deleted-U07JFNH9C7P
2025-05-15 17:30:08

Overall processing info is: Docket of 101, 1 opt out, 10 incompleted for VSS secondary, 90-62= 28 not put on portal tracker that are eligible. Should have the individual info later.

deleted-U05EFH3S2TA
2025-05-15 17:43:16

@Cameron Rentch @deleted-U07JFNH9C7P The attached sheet shows the reasons that the 28 have not been uploaded to the portal .https://docs.google.com/spreadsheets/d/1E_mY_iek6qnFQ9k0FdYKKcPF09UmjDOgA3hXfU5eUpg/edit?usp=sharing

Benchmarks
deleted-U05EFH3S2TA
2025-05-15 17:43:21

@Cameron Rentch @deleted-U07JFNH9C7P The attached sheet shows the reasons that the 28 have not been uploaded to the portal .https://docs.google.com/spreadsheets/d/1E_mY_iek6qnFQ9k0FdYKKcPF09UmjDOgA3hXfU5eUpg/edit?usp=sharing

deleted-U07JFNH9C7P
2025-05-15 17:44:53

Super, thanks for posting!