RecordConnectionIdentifier

Oxford Visit Occurrence

• Value copied from GPEventsPrimaryKey

• GPEventsPrimaryKey GP Events Unique ID

select
	GPEventsPrimaryKey,
	d.NHSNumber,
	e.EventDate
from omop_staging.oxford_gp_event e
	inner join omop_staging.oxford_gp_demographic d
		on e.PatientIdentifier = d.PatientIdentifier
order by
	d.NHSNumber,
	e.EventDate

Comment or raise an issue for this mapping.