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

340B report

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

12 Posts

5 Users

0 Reactions

85 Views

RSS

clafty

(@clafty)

Posts: 37

Trusted Member

Topic starter

I've be working on a 340B report off and on for a few months, strictly in SQL. I'm having trouble tying the prescription date to a visit date. Is there a table that has visit dates? I found one table with all the prescription information, but if someone opens a chart for a patient it actually writes to this table like an audit log. Anyone out there have a 340B report already?

Posted : February 12, 2015 7:13 am

acantu

(@acantu)

Posts: 722

Prominent Member

You want to use the SDID Column, it will link to your DOCUMENT SDID. The SDID is key to a lot of linking within tables to your Visit itself.

Posted : February 12, 2015 7:17 am

clafty

(@clafty)

Posts: 37

Trusted Member

Topic starter

WOOOOOOO! I love CHUG! Thanks @acantu - I see exactly what you are talking about!

Posted : February 12, 2015 7:34 am

clafty

(@clafty)

Posts: 37

Trusted Member

Topic starter

But what format is clinicaldate in? For example, 1739357964000000 is that in seconds or something?

Posted : February 12, 2015 7:35 am

acantu

(@acantu)

Posts: 722

Prominent Member

clinicaldate is an ID that is coded, you can decode it using:::

dbo.Convert_ID_to_date(CLINICALDATE)

Feel free to vote up my answers if you they have helped you solve your question.

Posted : February 12, 2015 7:37 am

clafty

(@clafty)

Posts: 37

Trusted Member

Topic starter

Weird, that's still showing today as the clinical date.. The presecription was actuall on 2/5..

Posted : February 12, 2015 7:45 am

clafty

(@clafty)

Posts: 37

Trusted Member

Topic starter

Maybe I need a different JOIN.

Posted : February 12, 2015 7:48 am

acantu

(@acantu)

Posts: 722

Prominent Member

that is for the DOCUMENT, for the Prescription, look at the PRESCRIB table and CLINICALDATE or DB_CREATE_DATE

Posted : February 12, 2015 7:48 am

clafty

(@clafty)

Posts: 37

Trusted Member

Topic starter

This was a big help, I deleted a row linking patient information, that's what screwed up my dates. But your suggestions were very useful!

Posted : February 12, 2015 8:12 am

jfitzmd

(@jfitzmd)

Posts: 419

Reputable Member

Clinical date when an 16 digit number is converted to a date as follows:

DateAdd("d",Int([ClinicalDate]/1000000/24/3600),#01/01/1960#)

Posted : February 12, 2015 8:26 am

JillSnider

(@jillsnider)

Posts: 110

Estimable Member

Join the appt to the view erx_activity_rpt (provides the script date)

Jill

Posted : February 25, 2015 4:22 pm

mdiaz

(@mdiaz)

Posts: 5

Active Member

Would someone share their 340B report please. Our 340B compliance analyst would like a report to make sure the scripts are coming from a 340B eligible provider and clinic since providers work at different locations some not 340B. I was wondering if any of the reports you all have worked on would help track this?

My email is [email protected]

thank you,

Maria Diaz

Posted : December 27, 2019 11:25 am

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