(for ProcedureOccurrence:) A foreign key to the provider in the PROVIDER table who was responsible for carrying out the procedure.

(for Observation:) A foreign key to the provider in the PROVIDER table who was responsible for making the observation.

(for Person:) A foreign key to the primary care provider the person is seeing in the provider table.

(for Note:) A foreign key to the Provider in the PROVIDER table who took the Note.

(for SurveyConduct:) A foreign key to the provider in the provider table who was associated with the survey completion.

(for ConditionOccurrence:) A foreign key to the Provider in the PROVIDER table who was responsible for capturing (diagnosing) the Condition.

(for DeviceExposure:) A foreign key to the provider in the PROVIDER table who initiated or administered the Device.

(for Measurement:) A foreign key to the provider in the PROVIDER table who was responsible for initiating or obtaining the measurement.

(for DrugExposure:) A foreign key to the provider in the PROVIDER table who initiated (prescribed or administered) the Drug Exposure.

(for VisitDetail:) A foreign key to the provider in the provider table who was associated with the visit.

(for VisitOccurrence:) A foreign key to the provider in the provider table who was associated with the visit.

visit_occurrence.provider_id#246 AS Provider

drug_exposure.provider_id#59 AS Provider

procedure_occurrence.provider_id#174 AS Provider

survey_conduct.provider_id#202 AS Provider

person.provider_id#157 AS Provider

observation.provider_id#132 AS Provider

measurement.provider_id#84 AS Provider

device_exposure.provider_id#38 AS Provider

note.provider_id#103 AS Provider

condition_occurrence.provider_id#22 AS Provider

visit_detail.provider_id#227 AS Provider

provider