Hello everybody,
The medical record in my institution is mostly based on forms that contained both structured (blood pressure for example) and unstructured data (diagnostic and therapeutic project, for example).
We want to make all these information available in OMOP but we face some difficulties.
We first think of SURVEY_CONDUCT.
This option allow us to keep the link between all the items of a form, which is very good
However it also means:
- storing every data in the OBSERVATION table, while some fields are clearly supposed to end in other table (MEASURMENT, CONDITION…)
- some fields may contain string that are longer than the 60 caracters allowed in the OBSERVATION.value_as_string field
Forgetting about the first issue how should we resolve the second one ?
should the OBSERVATION.value_as_string type modified to varchar(MAX) ?
Or should we use the NOTE table to store these information, building link between SURVEY_CONDUCT and NOTE similarly to the one between SURVEY_CONDUCT and OBSERVATION (i.e. _event_id and _event_field_concept_id) ?
Or any other solution ?
The second option is to store each field in the corresponding table (NOTE for the free text clinical fields, OBSERVATION, MEASURMENT…) The main issue being the loss the link between all the items of a form, which is not very satisfying…
Did anybody face the same issue ? or have any idea for a good solution ?
Sincerely
Nicolas