device_exposure_end_datetime

SUS AE Device Exposure

Source columns EndDate, EndTime. Combines a date with a time of day.

• EndDate The latest episode end date for the spell, or the latest activity date if none are specified. CDS ACTIVITY DATE, END DATE (EPISODE)

• EndTime The latest episode end time for the spell, or midnight if none are specified. END TIME (EPISODE)

	select
		ae.AEAttendanceNumber,
		ae.NHSNumber,
		coalesce(ae.ArrivalDate, ae.CDSActivityDate) as StartDate,
		coalesce(ae.ArrivalTime, '000000') as StartTime,
		coalesce(ae.AEDepartureDate, ae.AEAttendanceConclusionDate) as EndDate,
		coalesce(ae.AEDepartureTime, ae.AEAttendanceConclusionTime, '000000') as EndTime,
		i.AccidentAndEmergencyInvestigation
	from omop_staging.sus_AE_investigation i
		inner join omop_staging.sus_AE ae
			on i.MessageId = ae.MessageId
	where ae.NHSNumber is not null
	and i.AccidentAndEmergencyInvestigation in ('01', '02', '08', '09', '10', '11', '12', '19')
	

Comment or raise an issue for this mapping.