ConditionOccurrence

• nhs_number
• condition_source_concept_id
• condition_concept_id
• condition_start_date
• condition_source_value
• condition_type_concept_id
• RecordConnectionIdentifier
• condition_status_concept_id
• condition_status_source_value

SusOPConditionOccurrence

Comment or raise an issue for this mapping.

SusAPCConditionOccurrence

Comment or raise an issue for this mapping.

CosdV8ConditionOccurrencePrimaryDiagnosis

Assumptions

• Any changes in a Diagnosis that may occur in later submissions, for the same Diagnosis date, is taken to be an additional diagnosis as opposed to a change (hence removal of the original)
• If the same Diagnosis occurs but we have 2 separate “basis of diagnosis” values, then the first one will be taken only

Comment or raise an issue for this mapping.

CosdV8ConditionOccurrencePrimaryDiagnosisHistologyTopography

Assumptions

• For a given Diagnosis date, all valid combinations of Histology and Topography are added (thereby giving us an ICD-O-3 condition) as well as the ICD10 Diagnosis.
• Any changes in a Diagnosis that may occur in later submissions, for the same Diagnosis date, is taken to be an additional diagnosis as opposed to a change (hence removal of the original)
• If the same Diagnosis occurs but we have 2 separate “basis of diagnosis” values, then the first one will be taken only

Comment or raise an issue for this mapping.

CosdV9ConditionOccurrenceSecondaryDiagnosis

Comment or raise an issue for this mapping.

CosdV9ConditionOccurrenceRecurrence

Assumptions

• Any changes in a Diagnosis that may occur in later submissions, for the same Diagnosis date, is taken to be an additional diagnosis as opposed to a change (hence removal of the original)
• If the same Diagnosis occurs but we have 2 separate “basis of diagnosis” values, then the first one will be taken only

Comment or raise an issue for this mapping.

CosdV9ConditionOccurrenceProgression

Assumptions

• Any changes in a Diagnosis that may occur in later submissions, for the same Diagnosis date, is taken to be an additional diagnosis as opposed to a change (hence removal of the original)
• If the same Diagnosis occurs but we have 2 separate “basis of diagnosis” values, then the first one will be taken only

Comment or raise an issue for this mapping.

CosdConditionOccurrencePrimaryDiagnosis

Assumptions

• Any changes in a Diagnosis that may occur in later submissions, for the same Diagnosis date, is taken to be an additional diagnosis as opposed to a change (hence removal of the original)
• If the same Diagnosis occurs but we have 2 separate “basis of diagnosis” values, then the first one will be taken only

Comment or raise an issue for this mapping.

CosdConditionOccurrencePrimaryDiagnosisHistologyTopography

Assumptions

• For a given Diagnosis date, all valid combinations of Histology and Topography are added (thereby giving us an ICD-O-3 condition) as well as the ICD10 Diagnosis.
• Any changes in a Diagnosis that may occur in later submissions, for the same Diagnosis date, is taken to be an additional diagnosis as opposed to a change (hence removal of the original)
• If the same Diagnosis occurs but we have 2 separate “basis of diagnosis” values, then the first one will be taken only

Comment or raise an issue for this mapping.

CdsConditionOccurrence

Duplicates

CDS data contains numerous duplicated records for cds_diagnosis.DiagnosisCode (condition_concept_id), cds_line01.cdsActivityDate (condition_start_date) and cds_line01.NHSNumber (person_id).

In order to avoid true duplicates occurring in the data, we have included distinct records for cds_diagnosis.DiagnosisCode (condition_concept_id), cds_line01.cdsActivityDate (condition_start_date) , cds_line01.NHSNumber (person_id) and cds_line01.RecordConnectionIdentifier and excluded all duplicates.

Comment or raise an issue for this mapping.