OHDSI Home | Forums | Wiki | Github

Proposal: add place_of_service_concept_id to care_site table

This is a small proposal to add place_of_service_source_concept_id. It is a general OMOP convention to represent X_source_value as X_source_concept_id and X_concept_id, where X_concept_id is always standard-vocabulary for the domain, and X_source_concept_id maybe standard/non-standard vocabulary that is an integer representation of X_source_value. We don’t have X_source_concept_id in care_site and this proposal is to add it.

Use case: Many place of services such as Acquired immune deficiency syndrome clinic, Acute pain clinic, Bone marrow transplant clinic, Hospital-based outpatient emergency care center, Medical Intensive Care unit – does not always have 1:1 mapping with standard-concept ids. We have use cases where we want to use local place of service vocabulary for analytics e.g. how many persons attended the Acute Pain Clinic on Saturday’s vs Mondays. This cannot be addressed without adding the field place_of_service_source_concept_id

Proposal - Changes in red https://docs.google.com/document/d/1sdRNxQ0e8ctyi0Ek4NVK44pRaDkuXdW0QEU5lxnsGuI/edit?usp=sharing

Plus a few corrections and clarifications to descriptions.

t