Notifications
Clear all
Topic starter
Has anyone found a way to filter definitively for lab values in the OBS table? Using LabOrderPanelId IS NOT NULL gets me most of the way there, but has two shortcomings: labs results that are entered manually and in-house lab results.
Thanks,
Matt
Posted : May 23, 2018 2:22 am
You're probably going to have to join in the OBSHEAD table and look for certain units or one of the coding systems being populated.
Posted : June 11, 2018 12:59 pm
Did you get this resolved?
As DavidShower said I would join to the OBSHEAD table with a join on the HDID and then filter to those rows in the OBSHEAD table where LOINCCODE column is not null. That might get you the rest that don't have a LabOrderPanelId. It is my understanding that LOINC codes are specific to lab results and observations.
Posted : July 16, 2018 8:49 am
