Service Request by Jessica on how best to capture IPA Implementation Status

[donriepurcell]

• [x] Qualtrics Service Request Form was received from User
• [x] e-mail acknowledging that User's Qualtrics Service Request Form was sent
• [x] Problem FULLY RESOLVED and Issue is Closed
• [x] Post-Service Request Survey was sent to User

Use comments feature (below) to document:

1. A clear and concise description of the solution.

2. A clear and concise description of any alternative solutions or features you've considered.

3. Any additional context, such as screenshots about the problem.

[donriepurcell]

From: Jessica Neufeld <jn2434@columbia.edu>

Subject: IPA Tracker Qs

Date: September 7, 2021 at 4:07:34 PM EDT

To: Donrie Purcell <donrie.purcell@einsteinmed.org>

CAUTION: This email comes from an external source; the attachments and/or links may compromise our secure environment. Do not open or click on suspicious emails. Please click on the “Phish Alert” button on the top right of the Outlook dashboard to report any suspicious emails. --

Hi Donrie, 

I hope you had a great long weekend. 

I'm trying to pull a count of all the IPAs. So far, I have a count of 109 unique IPA strategies (from the strategy report and minus 3 discontinued strategies). 

Then from there, I wanted to get an overview of the number of sectors. From a measure's report, I got a total of 164 sectors, a combination of priority sectors 1-3. 

Is there a way to pull the implementation status of the IPAs? I'm not sure I see this as an option in the tracker but I might be looking in the wrong place. I was looking under Milestones in the IPA Monitoring section. 

Best,

Jessica  

-- 

Jessica Neufeld, MPH

Program Manager 

HEALing Communities Study

Social Intervention Group

Columbia University School of Social Work
1255 Amsterdam Avenue

New York, NY 10027

jn2434@columbia.edu  

Website:  https://sig.columbia.edu/

   

[donriepurcell]

Strategies-2021-09-07.xlsx Measures_2021-09-07.xlsx From: Donrie Purcell donrie.purcell@einsteinmed.org Subject: Re: IPA Tracker Qs Date: September 7, 2021 at 7:45:26 PM EDT To: Jessica Neufeld jn2434@columbia.edu Cc: david lounsbury david.lounsbury@einsteinmed.org

Hi Jessica

As with all things, the data we have will depend on:

• When we pulled the data and,

• Whether or not there has been any changes in the tracker such that it affects the integrity of the data we currently have.

I have a count of 112 active strategies for all counties from the download I pulled in response to your email (See attached the strategies spreadsheet). This also concurs with what I had from last week.

Also, I have a total of 167 priority sectors (See Countif formula in Column Q in the attached Measures spreadsheet,…)

Please allow me the opportunity to run the implementation status question by Dr. Lounsbury and team.

Still herein is also my take:

I take it that if one wants to know the implementation status of an IPA, one would look to the # of active strategies related to a specific IPA (see column B Strategies spreadsheet). That in itself should say whether or not the IPA is specified as active.

Also, in Monitoring of Challenges, from a qualitatively perspective one can discern the status of an IPA and its corresponding strategies. In other words, one will learn from the data whether or not the strategy and/or IPA has been abandoned for a particular reason.

Now vis-à-vis the said issue, Monitoring of Measures may not be that specific but one can also see the activities related a specified IPA’s smart strategy.

Nonetheless, the issue you’ve raised is certainly one worth discussing further and looking into making simpler.

Ps. If you have any questions or detect any errors on my part, can we set up a zoom call and work through it. I am always here for you and your team, and always open to learning from you all.

Kind Regards Donrie Purcell, PhD, MPH

Every generation has the obligation to free men's minds for a look at new worlds,....to look out from a higher plateau than the last generation. Ellison S. Onizuka

CONFIDENTIALITY: This email (including any attachments) may contain confidential, proprietary and/or privileged information. Any duplication, copying, distribution, dissemination, transmission, disclosure or use in any manner of this email (including any attachments) without the authorization of the sender is strictly prohibited. If you receive this email (including any attachments) in error, please notify the sender and delete this email (including any attachments) from your system. Thank you.

[dlounsbu]

From: david lounsbury Sent: Tuesday, September 7, 2021 10:49 PM To: Donrie Purcell donrie.purcell@einsteinmed.org; Jessica Neufeld jn2434@columbia.edu Subject: RE: IPA Tracker Qs

Thanks Donrie and Jessica!

I will have a look and follow up ASAP.

Best, David

[dlounsbu]

From: david lounsbury Sent: Friday, September 17, 2021 4:59 PM To: Jessica Neufeld jn2434@columbia.edu Cc: Donrie Purcell donrie.purcell@einsteinmed.org; Nicholas Bove nicholas.bove@einsteinmed.org; Emma Rodgers emr2241@columbia.edu; Sandra Rodriguez sr3717@columbia.edu Subject: Strategy Discontinue button now available

Hi Jessica:

You will notice that there is a Discontinue button on the Tracker Specification page that will you to indicate that the county has decided to end, or terminate, a Smart Strategy.

This should address the matter of clearly indicating what IPA/Strategies are Active or Discontinued.

Let us know how this feature serves your efforts!

Thanks, David