Notifications
Clear all
Topic starter
Hi,
Does any one have an sql script that works with PatientVisit, Patientprofile, Immunizations
I am trying to do a list of patients who had vaccines done for a time period that will show lot numbers and patient info.
any help would be grateful.
Thanks
George Caga Jewish Renaissance Medical Center [email protected]
Posted : July 27, 2016 11:33 am
Are you on CPS? Your profile says C-EMR but I have never heard of "PatientVisit" or "Patientprofile" and we don't have tables for them. This would be easy to whip one up using the Immunizations table but in CEMR you would use the PERSON table and you would not need a visit (though you could have one if you linked in document to immunization and then through document used visitid to link to the APPT table)
Posted : July 29, 2016 5:18 am
Topic starter
Thanks the info it help.
I am working in sql and those are table names
Posted : July 29, 2016 8:38 am
