provider_name

SACT Provider

  • Value copied from Consultant_GMC_Code

  • Consultant_GMC_Code A unique code identifying a care professional CONSULTANT GMC CODE

	select distinct 
		Consultant_GMC_Code, 
		Consultant_Specialty_Code
	from omop_staging.sact_staging

Comment or raise an issue for this mapping.

RTDS Provider

  • Value copied from DoctorId

  • DoctorId This GENERAL MEDICAL PRACTITIONER works within the General Medical Practitioner Practice with which the PATIENT is registered. GENERAL MEDICAL PRACTITIONER (SPECIFIED)

		select distinct 
			DoctorId 
		from omop_staging.RTDS_1_Demographics 
		where DoctorId is not null

Comment or raise an issue for this mapping.