How to populate drug_exposure.provider_id

[burrowse]

How to populate drug_exposure.provider_id

CDM or THEMIS convention?

Themis

Table or Field level?

Field

Is this a general convention?

No

Summary of issues

• For drug exposures coming from multiple sources, a decision needs to be made in the ETL to determine what provider id to associate with the record (e.g. ordering provider, the provider who administered the drug etc)

Summary of answer

• The CDM documentation states the following: The ETL may need to make a choice as to which PROVIDER_ID to put here. Based on what is available this may or may not be different than the provider associated with the overall VISIT_OCCURRENCE record, for example the ordering vs administering physician on an EHR record.

Related links

• Forum Post: https://forums.ohdsi.org/t/ordering-provider-vs-rendering-provider/21213
• CDM Documentation: https://ohdsi.github.io/CommonDataModel/cdm54.html#procedure_occurrence

[MelaniePhilofsky]

Issue # and location

NA

Issue summary

For some drug exposure records, there may be more than one provider associated with the record (e.g. ordering provider, the provider who administered the drug, etc.). Which provider should the ETL chose?

Convention type

Table

CDM table

drug_exposure

CDM field

provider_id

Links to issue discussion

Forum Post

Provenance of data

General

The ratified convention

• The CDM documentation states the following: The ETL may need to make a choice as to which PROVIDER_ID to put here. The decision is up to the ETL and should be documented. Based on what is available this may or may not be different than the provider associated with the overall VISIT_OCCURRENCE record, for example the ordering vs administering physician on an EHR record.

Date of ratification/published

NA

Downstream implications

NA

Link to DQD check

Yes - isForeignKey.

Related conventions/further information

NA

#Tags drug_exposure, provider

[clairblacketer]

@MelaniePhilofsky I am going to move this to the needs more work column. This is not so much a convention rather just "make a choice". It would be nice if we could give a hierarchy like order > administering, etc.

[burrowse]

@clairblacketer @MelaniePhilofsky It looks like this is also coming up for procedure_occurrence and measurement, should we open separate issues and link them to this discussion?