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
	

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.