RecordConnectionIdentifier
Oxford Visit Occurrence
- Value copied from
GPEventsPrimaryKey
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