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/ Report by patient age

General Discussion

Last Post by gpincomb 8 years ago

5 Posts

4 Users

0 Reactions

69 Views

RSS

jessicaw

(@jessicaw)

Posts: 434

Prominent Member

Topic starter

I have a provider who needs a report that would show the age of all patients she has seen since we implemented GE. The only way I can think to do this would be to search for all signed documents by that provider and then take all of those patients and create my own excel document with the patients name and age. It will obviously be time consuming. Can anyone help me out with an easier way to get the results I need?

Posted : June 16, 2016 5:28 am

joeg1962

(@joeg1962)

Posts: 843

Noble Member

I have done this with Crystal Reports.Actually, the report includes lots more info - that you might find useful, or simply delete the columns.

Do you have Crystal Reports?

Posted : June 16, 2016 5:34 am

Scott Forest

(@sforest)

Posts: 527

Honorable Member

If you don't have crystal
patients>responsible provider and run that. Export the data only to excel
remove the 1st row: "results"

run this script
https://support.microsoft.com/en-us/kb/213610

Posted : June 16, 2016 6:08 am

jessicaw

(@jessicaw)

Posts: 434

Prominent Member

Topic starter

We don't have crystal reports. I did think to run the inquiry you mentioned. Our responsible provider field is set to the most recent provider the patient saw. So it will not give me an accurate report on all patients she has seen. Because the patient may have seen one of our other providers since they last saw her.

Posted : June 16, 2016 6:45 am

gpincomb

(@gpincomb)

Posts: 278

Reputable Member

I would start with the following script in SQL, you can also add the Document and DocTypes tables if you want to select only specific Visit Types (8766 = 365.25 *24). 'xxxxx' would be your provider's login id.

selectdistinctDATEDIFF(hour,pp.Birthdate,GETDATE())/8766 Age, pp.PatientId, pp.searchname

from PatientVisit pv, DoctorFacility df, PatientProfile pp

where pv.DoctorId = df.DoctorFacilityId

and df.LoginUser ='xxxxx'

and pv.PatientProfileId = pp.PatientProfileId

Posted : June 17, 2016 6:45 am

Share:

24 Forums
9,940 Topics
39.9 K Posts
3 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