discharged_to_concept_id

Sus Inptatient VisitDetails

Source column DischargeDestinationCode. Lookup discharge destination concept.

DischargeDestinationCode discharged_to_concept_id notes
19 32759 Home Isolation
29 8602 Temporary Lodging
30 38004284 Psychiatric Hospital
37 38003619 Prison / Correctional Facility
38 38003619 Prison / Correctional Facility
48 38004284 Psychiatric Hospital
49 38004284 Psychiatric Hospital
50 8971 Inpatient Psychiatric Facility
51 8717 Inpatient Hospital
52 8650 Birthing Center
53 8976 Psychiatric Residential Treatment Center
54 8676 Nursing Facility
65 8676 Nursing Facility
66 38004205 Foster Care Agency
79 8650 Birthing Center
84 8971 Inpatient Psychiatric Facility
85 8676 Nursing Facility
87 8717 Inpatient Hospital
88 8546 Hospice
98   No mapping possible
99   No mapping possible

Notes

		with records as (
			select
				apc.NHSNumber,
				apc.HospitalProviderSpellNumber,
		
				coalesce(apc.StartDateConsultantEpisode, apc.StartDateHospitalProviderSpell, apc.CDSActivityDate) as VisitStartDate,
				coalesce(apc.StartTimeEpisode, apc.StartTimeHospitalProviderSpell, '000000') as VisitStartTime,
				coalesce(apc.EndDateConsultantEpisode, apc.DischargeDateFromHospitalProviderSpell, apc.CDSActivityDate) as VisitEndDate,
				coalesce(apc.EndTimeEpisode, apc.DischargeTimeHospitalProviderSpell, '000000') as VisitEndTime,
		
				apc.SourceOfAdmissionHospitalProviderSpell as SourceofAdmissionCode,
				apc.DischargeDestinationHospitalProviderSpell as DischargeDestinationCode
		
			from omop_staging.sus_APC apc
			where apc.NHSNumber is not null
		)
		select *
		from records
		order by 
			NHSNumber, 
			HospitalProviderSpellNumber, 
			VisitStartDate, 
			VisitStartTime, 
			VisitEndDate, 
			VisitEndTime, 
			SourceofAdmissionCode, 
			DischargeDestinationCode

Comment or raise an issue for this mapping.

Sus Inptatient VisitDetails

Source column DischargeDestinationCode. Lookup discharge destination concept for A&E.

DischargeDestinationCode discharged_to_concept_id notes
1 8717 In Patient Hospital
2 38004453 Family Practice
3 32759 Home Isolation
4 8870 Emergency Room - Hospital
5 8870 Emergency Room - Hospital
6 8756 Out Patient Hospital
7   No mapping possible
10   No mapping possible
11   No mapping possible
12   No mapping possible
13   No mapping possible
14   No mapping possible

Notes

		with records as (
			select  
				ae.NHSNumber,
				ae.AEAttendanceNumber,
				coalesce(ae.ArrivalDate, ae.CDSActivityDate) as VisitStartDate,
				coalesce(ae.ArrivalTime, '000000') as VisitStartTime,
				coalesce(ae.AEDepartureDate, ae.AEAttendanceConclusionDate, ae.ArrivalDate, ae.CDSActivityDate) as VisitEndDate,
				coalesce(ae.AEDepartureTime, ae.AEAttendanceConclusionTime, '000000') as VisitEndTime,
				ae.AEArrivalMode as SourceofAdmissionCode,
				ae.AEAttendanceDisposal as DischargeDestinationCode
			from omop_staging.sus_AE ae
			where ae.NHSNumber is not null
		)
		select *
		from records
		order by 
			NHSNumber, 
			AEAttendanceNumber, 
			VisitStartDate, 
			VisitStartTime, 
			VisitEndDate, 
			VisitEndTime, 
			SourceofAdmissionCode, 
			DischargeDestinationCode

Comment or raise an issue for this mapping.