Cameron Rentch (cameron@internetthings.com)
2025-05-01 14:09:24

@deleted-U05EFH3S2TA @Ralecia Marks @deleted-U04GZ79CPNG can you please run a pivot table report on all Dl/Flatirons CA Juv hall abuse cases.

We are looking for Type/classification of abuse (this should be standardized in a drop down of some type (ie penetration, oral copulation etc) Incidents of abuse (amount of times)

It may be better to run pivot from the secondary interview data as opposed to the intake questionaiire. Let me know asap thank you

deleted-U04GZ79CPNG
2025-05-01 14:29:36

@Cameron Rentch in a meeting. Sent to one of my team members to work on

deleted-U05EFH3S2TA
2025-05-01 14:54:28

@deleted-U04GZ79CPNG @deleted-U077J4CPUCC It is important to consider that the second interview is housed in Smart Advocate and only has a pdf of the Fact sheet in Law Ruler, we might need to discuss the best way to gather this information.

✅ Ralecia Marks
deleted-U04GZ79CPNG
2025-05-01 16:36:37

@Cameron Rentch Update: Looks like we can get some of the data out of Smart Advocate for the secondary interviews. We are currently able to get the type/classification of abuse and single/multiple for the number of incidents of abuse. We will get you a report with what we have shortly and continue trying to find a way to pull the specific number of incidents out of Smart Advocate.

🙌 Cameron Rentch
Cameron Rentch (cameron@internetthings.com)
2025-05-05 20:15:33

@deleted-U04GZ79CPNG can you give me an update on this asap?

Cameron Rentch (cameron@internetthings.com)
2025-05-06 14:12:21

@deleted-U04GZ79CPNG following up on the above^

deleted-U04GZ79CPNG
2025-05-06 14:16:54

@Cameron Rentch We are still following up on some of the data. There are a few clients who were not on the initial reporting we received to work on from Smart Advocate. Attached is the data as it stands so far.

Ca Juv Hall DL_FL Preliminary data.xlsx
Cameron Rentch (cameron@internetthings.com)
2025-05-06 14:22:00

thanks I will review