Notifications
Clear all
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
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
Topic starter
WOOOOOOO! I love CHUG! Thanks @acantu - I see exactly what you are talking about!
Posted : February 12, 2015 7:34 am
Topic starter
But what format is clinicaldate in? For example, 1739357964000000 is that in seconds or something?
Posted : February 12, 2015 7:35 am
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
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
Topic starter
Maybe I need a different JOIN.
Posted : February 12, 2015 7:48 am
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
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
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
Join the appt to the view erx_activity_rpt (provides the script date)
Jill
Posted : February 25, 2015 4:22 pm
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
