AHRQ v2018 Alteryx Modules from Discharge Data

[kuljisd]

Hello All!

My name is Dominick Kuljis, a healthcare research data analyst at Colorado Hospital Association! Our organization is a part of the HIIN (Hospital Improvement Innovation Network) and a couple of their measures (Falls, Sepsis, VTE) use the AHRQ v2018 definitions which pulls from our discharge data using ICD 10 Diagnosis and Procedure Codes. On the AHRQ website they have SAS modules for each of these measures and was wondering if we could do something similar with Alteryx?

I have created a couple workflows for some of the AHRQ measures (Thank you AliKat for the springboard!) and was wondering if others have already created these AHRQ v2018 data pulls or not. I would be happy to share my Alteryx modules to anyone who is using these AHRQ definitions! :D 

Dom 

[karlyhedrick]

Hi Dom,

I'd love if you would be willing to share the AHRQ modules you've developed! We've been working on some here at Mosaic Medical, but they would take quite a bit of clean up to get in sharing order. :)

Thanks,

Karly

[kuljisd]

Karly,

Awesome! Yes i think mine will also take some cleaning up...What version of AHRQ measures are you building in Alteryx?

Dom

[karlyhedrick]

We are focused on PQI 90 Overall Composite and the measures it includes.

Here's the link: https://www.qualityindicators.ahrq.gov/Modules/PQI_TechSpec_ICD10_v2018.aspx

Which measures are you building?

Thanks,
Karly

[kuljisd]

Karly,

Ahhhh T.T I am building the Patient Safety Indicators in Alteryx. The PSI measures we are building are PSI 12, 13, 17, 18, 19. 

I am so sorry :( 

Dom

[kailintu]

We've worked on PSI's  3, 4, 6, 9, 12, and 13.

I believe we also have the TJ complications measure as well.  

[kailintu]

Why not use the SAS or WINQI software to get the data?  We are currently looking at the WINQI software.

The specs for these measures are not very clear at times and we did identify one issue that needed to be corrected.

[kuljisd]

Kailintu, you do bring up a good point for using the WINQI software to pull all the PSI or PQI Measures from ARHQ. We do no have access to SAS. Please let me know what your experience is using the WINQI software! 

I have attached the PSI 12, 17, 18, 19 along with Colorado Hospital Association's data dictionary which details what each column in the excel holders mean! I hope this helps others! 

Regards,

Dom

[kailintu]

Thanks.  We need to do some work to share our PSI workflows.  Will post when ready.  

We will also share our assessment of the WINQI software.

[kailintu]

We have been reviewing the data from the WINQI software and we feel this is the best route going forward.  It has the feature to automate the load and report generation of PSI results.  

If you are still interested in our PSI workflows let me know.  We will need to prep them as we are loading data from our data warehouse.