Welcome to the NEW CHUG— your ultimate destination for cutting-edge insights and discussions at the intersection of healthcare and technology.

Our platform is dedicated to exploring the dynamic landscape of healthcare technology, empowering professionals, enthusiasts, and innovators alike with the knowledge and resources to navigate the rapidly evolving field.

From telemedicine revolutionizing patient care to the transformative potential of artificial intelligence in diagnostics, we delve into a myriad of topics shaping the future of healthcare delivery. Whether you’re a seasoned healthcare IT professional, an aspiring entrepreneur in the digital health space, or simply curious about the latest innovations, our curated content, expert interviews, and thought-provoking articles provide a comprehensive exploration of healthcare technology’s most pressing issues.

Join us as we navigate the forefront of innovation, driving forward the transformation of healthcare for a healthier, more connected world.

Have questions or suggestions? Please use the contact button below.

Notifications

Clear all

Inquiry Help

General Discussion

Last Post by Sirna 10 years ago

10 Posts

3 Users

0 Reactions

80 Views

RSS

Sirna

(@sirna)

Posts: 384

Honorable Member

Topic starter

I am currently trying to pull data for a specific patient population:

Patients under the age of 65

Are Diabetic

Not had a HGBA1C between a certain date range

I have ran this and still getting "0" returns. I did get a listing of patients that fit the first two criteria, but once I put in the date ranges it pulls null. Even though with spot checking the patient list on the first 2 variables I find patients that would fit into it. I am not sure what could be missing. Currently Using the CPS Inquiry feature.

Any help would be greatly appreciated!

Posted : May 19, 2015 8:03 am

acantu

(@acantu)

Posts: 722

Prominent Member

This SQL script should help, you might need to add additional OBS terms depending on the practice and what they use. And just change the dates.

SELECT * FROM PatientProfile AS PP WHERE dbo.PatientAgeInYears(Birthdate) < 65 AND pstatus = 'A' AND (SELECT COUNT(*) FROM PROBLEM WHERE CHANGE IN (2,6) AND PID = PP.PID AND CODE LIKE '%250.%') > 0 AND (SELECT COUNT(*) FROM OBS WHERE PID = PP.PID AND HDID IN (28) AND OBSDATE BETWEEN '1/1/2015' AND '12/31/2015') = 0

Posted : May 19, 2015 8:16 am

Sirna

(@sirna)

Posts: 384

Honorable Member

Topic starter

Would I be able to use this under the Inquiry section? Or do I need to use this in another place? I normally only work within the Inquiry section.

Posted : May 19, 2015 8:22 am

acantu

(@acantu)

Posts: 722

Prominent Member

You can use this with SQL Server Management, Excel, Crystal or anything else you can query your CPS database with.

Posted : May 19, 2015 8:24 am

Sirna

(@sirna)

Posts: 384

Honorable Member

Topic starter

Ok thank you very much.

Posted : May 19, 2015 8:28 am

Sirna

(@sirna)

Posts: 384

Honorable Member

Topic starter

So I do not have access to run this script. I need to be able to pull this via the Inquiry Section of the Chart Reports. Do you have any insight from within the Inquiry section?

Posted : May 19, 2015 9:06 am

acantu

(@acantu)

Posts: 722

Prominent Member

Yes, do the following steps:

In Chart Reports Inquiry, change Find to Patients.
Where to Date of Last Observation
From the search screen, click on your OBS Term, ie. HGBA1C
change to is before
input the date
Click on Add
Check Mark Active Patients Only
Now change Where to Problem Code ICD-9, Active
change to contains
input 250. <- Don't forget the dot
Click on Add
Change Where to Birthdate
change to on or after
input the date of birth that would make a person tomorrow 65, so if you were doing this today, you would input 5/20/1950
Click on Add

Now you can run the search or count. This should work for you.

Should look like this in the table of Find Patients where:

Date of Last HGBA1C is before 'DATE'
AND Problem Code ICD-9, Active contains '250.'
AND Birthdate is on or after '05/20/1950'

Posted : May 19, 2015 11:10 am

joeg1962

(@joeg1962)

Posts: 843

Noble Member

Inquiries just will not do an accurate job of this. It (Inquiries) is a very simple tool. Why does it have to be with Inquiries, since Crystal or SQL would better handle the logic?

To prove my point, find patients

Problem Code contains 250. (as previously stated) and birthdate on/after 5/20/1950. This just gave me 2785 patients.

Now, add logic for last obs (HGBA1C) is blank. My inquiry said 350 patients.

So, while 'acantu' solution will be close, you will need to find the patients without any HGBA1C also. Thus, you will need two inquiries to be run.

Posted : May 20, 2015 4:02 am

acantu

(@acantu)

Posts: 722

Prominent Member

You are correct joeg1962, the best solution would be sql script that I posted originally.

Posted : May 20, 2015 6:53 am

Sirna

(@sirna)

Posts: 384

Honorable Member

Topic starter

We will have the ability to run the script within Crystal soon. We were able to run the Inquiry and found the population we needed. So while it is a simple tool, it did work for this purpose (I did need to change my problem variable, was running for a specific code and needed to run Diabetes for example from 250.00 to just 250.) this helped a lot to capture more patients. I am hoping that when we can run Crystal, I will not need to use the Inquiry section any longer. Thank you both for your input!

Posted : May 20, 2015 6:59 am

Share:

24 Forums
9,942 Topics
39.9 K Posts
0 Online
6,470 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Powered by wpForo Powered by wpForo version 2.4.0