We have survey data stored in Excel. So, I am currently transforming my question and response pairs as records in observation table.
Can you please help me understand the above two fields (obs_event_id and obs_event_concept_id) from observation table with a simple example?
In addition, I would also like to know whether
Qualifier value - What does this field mean? What value goes into this? Can you please help?
Observation_source_value - I am planning to store our column names (our data is stored in excel so, I make use of the column names to kind of help us further in retrieving the data )