Notifications
Clear all
Topic starter
I know that there is an OBS code for "BIRTH MONTH", HDID=10235.
However, we have not put anything in there yet. We do have data in a patient's date of birth. Trying to figure a way to populate the OBS term in one program. Figure to have a Crystal report create an Excel worksheet with patient name, MRN, date of birth, and the two-digit month. Then, would need to do 'some magic' to have this imported into GE Logician.
The goal is simply to break up our patient list so that at brith month, we can remind patients of need for annual physical and any tests.
But... stuck on a way with Inquiry to do birth month - other than having 100 inquiries! Or, can I use MEL programming at an inquiry?
Posted : April 26, 2013 4:25 am
Off the top of my head you could add a text component to your encounters that did something like:
You could do
COND
case sub(PATIENT.DATEOFBIRTH,1,2) = "01" and OBSNOW("BIRTH MONTH") = ""
OBSNOW("BIRTH MONTH","January")
etc. etc.
ENDCOND
You could probably make that a little more elegant...
If you have CCC, there is a ccc_month() function that returns January, etc. You want to do a test to see if you already have the obs term populated and if not do a
OBSNOW("BIRTH MONTH",ccc_month())
David Shower
OU Tulsa School of Community Medicine
Posted : April 26, 2013 8:18 am
Topic starter
Thanks for the idea, David.
That will help going forward.
But, how do I retroactively set birth month for thousands of patients already in the EMR?
Posted : April 26, 2013 8:27 am
We have created batches of HL7 files from CSV files using Qvera (our most excellent interface engine) and processed them to do obs term updates. If you don't have access to Qvera someone might be able to script something. Other than that, it would be directly manipulating the database with a SQL script and that isn't something I would recommend. I don't know if GE would do that for you or not.
David Shower
OU Tulsa School of Community Medicine
Posted : April 26, 2013 11:22 pm
