Had a conversation today about if it is possible to store surgical expertise in the CDM. This warrants being stored in the CDM as there are important research questions around the impact expertise has on the short-term and long-term outcomes for a patient. Surgical experience also changes over time so while associated to the provider isn’t a static item to store in the PROVIDER table.
Let’s use an example:
For a given surgery, Dr. P. Ryan is the Primary Surgeon who is a certified surgeon in the area they are working and Dr. P. Rijnbeek is the Assistant Surgeon who is a surgeon in training.
PROVIDER
Dr. P. Ryan and Dr. P. Rijnbeek will both have records in this table.
PROCEDURE_OCCURRENCE
A record of the specific procedure being performed, this is linked to a VISIT_OCCURRENCE. You can list the PRIMARY surgeon on the PROCEDURE if you want as well.
VISIT_DETAIL
One record for each Surgeon involved.
VISIT_OCCURRENCE
This ties together 2 VISIT_DETAIL records. You could list the PRIMARY surgeon on the VISIT_OCCURRENCE if needed.
OBSERVATION
We store the PRIMARY versus SECONDARY surgeon bit in the OBSERVATION_CONCEPT_ID. Then in the VALUE_AS_CONCEPT_ID / VALUE_AS_STRING we can store the expertise at the time of the surgery. This record is tied to the surgeon via the VISIT_DETAIL table.
This isn’t necessarily graceful but you could get from a procedure, through visit, you could connect up the provider to their specialty. I just wanted to put this out there to see if people had better ideas.
Tagging my friends @sbicty, @gregk, @Alexdavv, @Alexandra_Orlova, @Albert_Prats, @clairblacketer