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

Find NEW Patients

Page 2 / 2 Prev

Trading Post

Last Post by Anonymous 1 second ago

20 Posts

3 Users

0 Reactions

133 Views

RSS

acantu

(@acantu)

Posts: 722

Prominent Member

And to get even more accurate, use this one

SELECT        dbo.PERSON.*
FROM            dbo.PERSON INNER JOIN
                         dbo.[DOCUMENT] ON dbo.PERSON.PID = dbo.[DOCUMENT].PID
WHERE        (dbo.[DOCUMENT].VISDOCID IN (SELECT MIN(VISDOCID) FROM DOCUMENT WHERE PID = dbo.PERSON.PID)) AND dbo.Convert_ID_to_date(CLINICALDATE) BETWEEN '9/1/2012' AND '9/28/2012'

This will bypass NULL db_created dates and use the clinical date that was give to the document when it was created.

So I recommend creating a view with the above code, and then building your crystal report off of this.

Posted : September 28, 2012 1:51 am

jjordet

(@jjordet)

Posts: 545

Honorable Member

Here's my revamped report doing what the above select does without creating a view.

New Patients 2.rpt

Posted : September 28, 2012 2:02 am

wsc27

(@sclayton)

Posts: 142

Estimable Member

Topic starter

Which would you think would be more accurate to use PERSON.VISDOCID or DOCUMENT.VISDOCID? What do you think the difference would be if I used PERSON vs DOCUMENT table as far as finding the most accurate data for NEW patients?

Posted : September 28, 2012 2:11 am

acantu

(@acantu)

Posts: 722

Prominent Member

DOCVIS, cause the PERSON VIS Doesnt always get updated, and I believe that is the latest Visit Doc ID for that patient.

Posted : September 28, 2012 2:15 am

wsc27

(@sclayton)

Posts: 142

Estimable Member

Topic starter

jjordet said:

You'll miss any new patients where the first document was discarded with the above select. Here's a report that will check the first 3 VISDOCIDs.

New Patients.rpt

How did you upload the .rpt file to the forum? I only see upload image or media options.

Posted : November 6, 2012 11:42 pm

Page 2 / 2 Prev

Share:

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