measurement_source_concept_id

Sus OP Measurement

Source column DiagnosisICD. Resolve ICD10 codes to standard or non standard OMOP concepts. If code cannot be mapped, map using the parent code.

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 APC Measurement

Source column DiagnosisICD. Resolve ICD10 codes to standard or non standard OMOP concepts. If code cannot be mapped, map using the parent code.

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.

COSD V9 Measurement TNM Category Integrated Stage

  • Constant value set to 2000500013. TNMCategoryIntegratedStage

Comment or raise an issue for this mapping.

COSD V9 Measurement TNM Category Final Pre Treatment Stage

  • Constant value set to 2000500017. TNMCategoryFinalPreTreatmentStage

Comment or raise an issue for this mapping.

COSD V9 Measurement T Category Integrated Stage

  • Constant value set to 2000500012. TCategoryIntegratedStage

Comment or raise an issue for this mapping.

COSD V9 Measurement T Category Final Pre Treatment Stage

  • Constant value set to 2000500016. TCategoryFinalPreTreatmentStage

Comment or raise an issue for this mapping.

COSD V9 Measurement Primary Pathway Metastasis

  • Constant value set to 2000500007. PrimaryPathwayMetastasis

Comment or raise an issue for this mapping.

COSD V9 Measurement Non Primary Pathway Recurrence Metastasis

  • Constant value set to 2000500008. NonPrimaryPathwayRecurrenceMetastasis

Comment or raise an issue for this mapping.

COSD V9 Measurement Non Primary Pathway Progression Metastasis

  • Constant value set to 2000500009. NonPrimaryPathwayProgressionMetastasis

Comment or raise an issue for this mapping.

COSD V9 Measurement N Category Integrated Stage

  • Constant value set to 2000500011. NCategoryIntegratedStage

Comment or raise an issue for this mapping.

COSD V9 Measurement N Category Final Pre Treatment Stage

  • Constant value set to 2000500015. NCategoryFinalPreTreatmentStage

Comment or raise an issue for this mapping.

COSD V9 Measurement M Category Integrated Stage

  • Constant value set to 2000500010. MCategoryIntegratedStage

Comment or raise an issue for this mapping.

COSD V9 Measurement M Category Final Pre Treatment Stage

  • Constant value set to 2000500014. MCategoryFinalPreTreatmentStage

Comment or raise an issue for this mapping.

COSD V8 Measurement TNM Category Integrated Stage

  • Constant value set to 2000500013. TNMCategoryIntegratedStage

Comment or raise an issue for this mapping.

COSD V8 Measurement TNM Category Final Pre Treatment Stage

  • Constant value set to 2000500017. TNMCategoryFinalPreTreatmentStage

Comment or raise an issue for this mapping.

COSD V8 Measurement T Category Integrated Stage

  • Constant value set to 2000500012. TCategoryIntegratedStage

Comment or raise an issue for this mapping.

COSD V8 Measurement T Category Final Pre Treatment Stage

  • Constant value set to 2000500016. TCategoryFinalPreTreatmentStage

Comment or raise an issue for this mapping.

COSD V8 Measurement N Category Integrated Stage

  • Constant value set to 2000500011. NCategoryIntegratedStage

Comment or raise an issue for this mapping.

COSD V8 Measurement N Category Final Pre Treatment Stage

  • Constant value set to 2000500015. NCategoryFinalPreTreatmentStage

Comment or raise an issue for this mapping.

COSD V8 Measurement M Category Integrated Stage

  • Constant value set to 2000500010. MCategoryIntegratedStage

Comment or raise an issue for this mapping.

COSD V8 Measurement M Category Final Pre Treatment Stage

  • Constant value set to 2000500014. MCategoryFinalPreTreatmentStage

Comment or raise an issue for this mapping.