Notifications
Clear all
Topic starter
How can I get the provider who saw the patient during a visit at which a certain OBS TERM was documented. I tried DOCUMENT.DOCTYPE=1 and linked DOCUMENT.USRID to USRINFO.PVID. But in the report i did without using DOCUMENT and USRINFO I have a few patients whose values are not showing up when I try to get the provider name also. My assumption is that the DOCTYPE is not 1 for the patients that are missing from the report. If I take out the DOCUMENT.DOCTYPE=1 condition, the report will pull thousands of unwanted records which I would like to avoid. Can someone offer help/suggestions?
Thanks in advance.
BAJ
Posted : September 20, 2012 2:32 am
Try linking:
PERSON.PID to DOCUMENT.PID
PERSON.PID to OBS.PID
OBS.HDID
OBSHEAD.HDID
Posted : November 13, 2012 12:26 am
