observation_source_concept_id

Sus CCMDS High Cost Drugs

Source column ObservationSourceValue. Resolve OPCS4 codes to OMOP concepts. If code cannot be mapped, map using the parent code.

		select distinct
			apc.NHSNumber,
			apc.HospitalProviderSpellNumber,
			cc.CriticalCareStartDate as ObservationDate,
			coalesce(cc.CriticalCareStartTime, '00:00:00') as ObservationDateTime,
			d.CriticalCareHighCostDrugs as ObservationSourceValue
		from [omop_staging].[sus_CCMDS_CriticalCareHighCostDrugs] d
		inner join [omop_staging].[sus_CCMDS] cc on d.MessageId = cc.MessageId
		inner join [omop_staging].sus_APC apc on cc.GeneratedRecordID = apc.GeneratedRecordIdentifier
		where apc.NHSNumber is not null

Comment or raise an issue for this mapping.

SUS APC Anaesthetic Given Post Labour Delivery Observation

  • Constant value set to 2000500002. ANAESTHETIC GIVEN POST LABOUR OR DELIVERY CODE

Comment or raise an issue for this mapping.

SUS APC Anaesthetic During Labour Delivery Observation

  • Constant value set to 2000500001. ANAESTHETIC GIVEN DURING LABOUR OR DELIVERY CODE

Comment or raise an issue for this mapping.

CosdV9HistoryOfAlcoholPast

  • Constant value set to 2000500004. History Of Alcohol (Past)

Comment or raise an issue for this mapping.

CosdV9HistoryOfAlcoholCurrent

  • Constant value set to 2000500003. History Of Alcohol (Current)

Comment or raise an issue for this mapping.

CosdV9FamilialCancerSyndrome

  • Constant value set to 2000500005. Familial Cancer (Indicator)

Comment or raise an issue for this mapping.

CosdV9FamilialCancerSyndromeSubsidiaryComment

  • Constant value set to 2000500006. Familial Cancer (Comment)

Comment or raise an issue for this mapping.

CosdV8FamilialCancerSyndromeIndicator

  • Constant value set to 2000500005. Familial Cancer (Indicator)

Comment or raise an issue for this mapping.

CosdV8AlcoholHistoryCancerInLastThreeMonths

  • Constant value set to 2000500003. History Of Alcohol (Current)

Comment or raise an issue for this mapping.

CosdV8AlcoholHistoryCancerBeforeLastThreeMonths

  • Constant value set to 2000500004. History Of Alcohol (Past)

Comment or raise an issue for this mapping.

Cds Anaesthetic Given Post Labour Delivery Observation

  • Constant value set to 2000500002. ANAESTHETIC GIVEN POST LABOUR OR DELIVERY CODE

Comment or raise an issue for this mapping.

Cds Anaesthetic During Labour Delivery Observation

  • Constant value set to 2000500001. ANAESTHETIC GIVEN DURING LABOUR OR DELIVERY CODE

Comment or raise an issue for this mapping.