value_source_value

Sus OP Measurement

Source column DiagnosisICD. Resolve Measurement domain ICD10 codes to Maps To Value concepts.

• DiagnosisICD ICD10 diagnosis code PRIMARY DIAGNOSIS (ICD)

select
    distinct
        d.DiagnosisICD,
        op.GeneratedRecordIdentifier,
        op.NHSNumber,
        op.CDSActivityDate
from omop_staging.sus_OP_ICDDiagnosis d
    inner join omop_staging.sus_OP op
        on d.MessageId = op.MessageId
where op.NHSNumber is not null
	and AttendedorDidNotAttend in ('5','6')
	

Comment or raise an issue for this mapping.

Sus CCMDS Measurement - Person Weight

• Value copied from ValueAsNumber

• ValueAsNumber Value of the Person weight PERSON WEIGHT

		select distinct
				apc.NHSNumber,
				apc.GeneratedRecordIdentifier,
				cc.CriticalCareStartDate as MeasurementDate,
				coalesce(cc.CriticalCareStartTime, '00:00:00') as MeasurementDateTime,
				cc.PersonWeight as ValueAsNumber
		from [omop_staging].[sus_CCMDS] cc 
		inner join [omop_staging].sus_APC apc on cc.GeneratedRecordID = apc.GeneratedRecordIdentifier
		where apc.NHSNumber is not null
		and cc.PersonWeight is not null
	

Comment or raise an issue for this mapping.

Sus APC Measurement

Source column DiagnosisICD. Resolve Measurement domain ICD10 codes to Maps To Value concepts.

• DiagnosisICD ICD10 diagnosis code PRIMARY DIAGNOSIS (ICD)

select
    distinct
        d.DiagnosisICD,
        apc.GeneratedRecordIdentifier,
        apc.NHSNumber,
        apc.CDSActivityDate
from omop_staging.sus_ICDDiagnosis d
    inner join omop_staging.sus_APC apc
        on d.MessageId = apc.MessageId
where apc.NHSNumber is not null
	

Comment or raise an issue for this mapping.