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

crystal report for signed visits on the same day

CPS, C-EMR, PM

Last Post by Anonymous 1 second ago

2 Posts

2 Users

0 Reactions

75 Views

RSS

mtooley

(@mtooley)

Posts: 62

Estimable Member

Topic starter

Does anyone have a report that would tell us how many visits per provider were opened and signed off on the same day? We are looking for some metrics for comparisons. This would be for CEMR.

Thank you Peg

Posted : March 15, 2019 7:28 am

beth_rose

(@beth_rose)

Posts: 8

Active Member

Hi Peg,

I don't have this in a crystal report format, but am happy to share some starter code that can be run in SQL developer. Please note, you may need to add additional doctypes if you have created custom clinical document types that are considered "Office Visits". Please feel free to reach out to me directly at the email address below if you need assistance modifying this code to meet your requirements or using it to create a Crystal report.

Select Distinct u.firstname||' '|| u.lastname as Username, Count(d.sdid) as OVCount
from document d
Inner join usr u on d.usrID = u.pvid
Inner join doccontb dc on d.sdid = dc.sdid and to_char(d.DB_Create_date,'DD/MM/YYYY') = to_char(dc.CONTB_TIME,'DD/MM/YYYY')
where d.DB_CREATE_DATE > '31 JAN 2019'
and d.DB_CREATE_DATE < '28 FEB 2019'
and contb_action = 7 -- Initial & Final Signature
and d.doctype = 1 -- Office Visit
and XID = 100000000000000000000000000000000000
group by u.firstname, u.lastname,u.pvid

Beth Rose
[email protected]

Posted : March 23, 2019 4:28 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