Resurrecting this old thread.
I work in secondary / specialized health care unit and we utilise OMOP database alongside with traditional data warehouse (both in postgres). The OMOP is up and running and we have conducted studies utilising it successfully.
I stumbled upon a research question where we would need to calculate a time to an event, specifically we need to calculate the waiting time from a received referral to a certain unit in our hospital to a certain procedure performed to the patient. This it the first time we would like to utilise data of referrals in OMOP database and I just hadn’t think of it earlier do we even have that data in OMOP. We do not.
I cannot find any documentation nor discussions regarding where to map the referral data and how. At first, I was thinking maybe we can populate admitting_source_concept_id and preceding_visit_occurrence_id in visit_occurrence table somehow, but after I read the description/definition of those columns in that table I think it’s a wrong path.
I discussed this issue with a colleague of mine from another organization and she brought up an idea to populate observation_concept_id and value_as_concept_id in observation table to build up the direction and target of the referral (‘Referral for’ concept in observation_concept_id and desired hospital unit in value_as_concept_id).
I have no clue which of these two propositions would work if neither? Or maybe we are trying to use OMOP database to something that the CDM model is not ment for?