OHDSI Home | Forums | Wiki | Github

What is Qualifier source value in Observation table?

estimationmethods
vocabularies
cdm
patientprediction

(Selva Muthu Kumaran Sathappan) #1

Hello Everyone,

I am trying to store the survey data (questionnaire data) of patients in the observation table. However, am not able to understand the meaning of “Qualifier Source Value” field in this table

Can someone here help me understand this with an example?

I did read the description from cdm doc that reads as “The source value associated with a qualifier to characterize the observation”

But couldn’t understand due to lack of healthcare domain knowledge.Might be due to english proficiency as well.

Any simple examples would be helpful. Currently we are storing patient info like smoking related questions, social-circumstances, lifestyle related questions etc.

If not applicable for our scenario, can you anyway given an example of what is that field about. Would be helpful

Thanks
Selva


(Selva Muthu Kumaran Sathappan) #2

Can someone help with this?


(Don Torok) #3

This query may help:
select * from concept where domain_id = ‘Observation’ and concept_class_id=‘Qualifier Value’ and standard_concept=‘S’


(Selva Muthu Kumaran Sathappan) #4

Thank you @DTorok but curious to know why can’t these values be stored in value_as_string and their value_as_concept_id columns? Why a separate column? Am I missing anything?

image


t