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

Report for patients over 65

General Discussion

Last Post by mdiventi 7 years ago

9 Posts

6 Users

0 Reactions

74 Views

RSS

jessicaw

(@jessicaw)

Posts: 434

Prominent Member

Topic starter

Does anyone have a report that will populate all patients over the age of 65 with their address? We are wanting to send a letter out to those patients and would like to be able to use the report with Mail Merge to create mailing labels. When I run an Inquiry for these patients and export to Excel I am not finding a way to break all of the necessary info into individual columns so that it will work with Mail Merge.

Posted : February 10, 2017 3:41 am

jfitzmd

(@jfitzmd)

Posts: 419

Reputable Member

If you have access to Crystal, this is a very simple process. Contact me directly if you wish to see an approach to this problem.

Posted : February 10, 2017 3:53 am

joeg1962

(@joeg1962)

Posts: 843

Noble Member

Pt105alt Patients All LOC

Crystal Report for EMR

This will include all patient who have had a BP taken in prior five years -- an indicator that a current patient. Take a look through the fields to be printed, as you may not need all the fields which we include. Note - we use this Excel file for many things like this.

Posted : February 10, 2017 4:09 am

jsander

(@jsander)

Posts: 108

Estimable Member

Another way to handle this without custom programming is to create a letter in Centricity with the patient's address placed at the top to fit into a window envelope. Then just run the inquiry based on age or date of birth, use the Actions option to print your letters, and fold them to show the address in the envelope window. We try to format all Centricity letters like this to eliminate the need for labels.

Julie Dils, North Florida Women's Care

Posted : February 10, 2017 4:15 am

jessicaw

(@jessicaw)

Posts: 434

Prominent Member

Topic starter

Unfortunately I do not have access to Crystal Reports....

Posted : February 10, 2017 4:32 am

jessicaw

(@jessicaw)

Posts: 434

Prominent Member

Topic starter

I didn't think of that option. After discussing with the Office Manager I think that is the approach we are going to take. Thank you!!

Posted : February 10, 2017 5:04 am

jsander

(@jsander)

Posts: 108

Estimable Member

Yay! I love to help people use Centricity without add-ons. It can save the letter to the chart, too. 🙂

Posted : February 10, 2017 6:43 am

chaddix

(@chaddix)

Posts: 177

Estimable Member

If you have access to run a SQL query, this should work. Paste the results into Excel and you should be able to turn it into a mail merge.

SELECT P.PatientId, P.First, P.Last, P.Address1, P.Address2, P.City, P.State, P.Zip
FROM PatientProfile P
WHERE DATEDIFF(hour, P.Birthdate, GETDATE())/8766 > 65
AND P.pstatus = 'A'

Posted : February 13, 2017 6:26 am

mdiventi

(@mdiventi)

Posts: 54

Trusted Member

Thank you so much for this!!! I have been working with Centricity for 15 years and have done several mass mailings (docs leaving, etc). WHY HAVE I NOT THOUGHT OF THIS?! It is so funny how we can all be so smart and get hung up by the littlest things. I love this group!!

Posted : June 29, 2017 5:43 am

Share:

24 Forums
9,940 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