ProcedureOccurrence

• nhs_number
• procedure_concept_id
• procedure_date
• procedure_datetime
• procedure_end_date
• procedure_end_datetime
• procedure_type_concept_id
• procedure_source_value
• procedure_source_concept_id
• RecordConnectionIdentifier
• quantity

SusOPProcedureOccurrence

Comment or raise an issue for this mapping.

SusCCMDSProcedureOccurrence

Comment or raise an issue for this mapping.

SusAPCProcedureOccurrence

Comment or raise an issue for this mapping.

SusAEProcedureOccurrence

Comment or raise an issue for this mapping.

RtdsProcedureOccurrence

Comment or raise an issue for this mapping.

OxfordGPProcedureOccurrence

Comment or raise an issue for this mapping.

COSDv9URProcedureOccurrenceProcedureOpcs

Comment or raise an issue for this mapping.

COSDv9URProcedureOccurrencePrimaryProcedureOpcs

Comment or raise an issue for this mapping.

COSDv9URProcedureOccurrenceDiagnosticProcedureSnomedCt

Comment or raise an issue for this mapping.

COSDv9URProcedureOccurrenceDiagnosticProcedureOpcs

Comment or raise an issue for this mapping.

COSDv8URProcedureOccurrenceProcedureOPCS

Comment or raise an issue for this mapping.

COSDv8URProcedureOccurrencePrimaryProcedureOPCS

Comment or raise an issue for this mapping.

COSDv9UGProcedureOccurrenceProcedureOpcs

Comment or raise an issue for this mapping.

COSDv9UGProcedureOccurrencePrimaryProcedureOpcs

Comment or raise an issue for this mapping.

COSDv9UGProcedureOccurrenceDiagnosticProcedureSnomedCt

Comment or raise an issue for this mapping.

COSDv9UGProcedureOccurrenceDiagnosticProcedureOpcs

Comment or raise an issue for this mapping.

COSDv8UGProcedureOccurrenceProcedureOPCS

Comment or raise an issue for this mapping.

COSDv8UGProcedureOccurrencePrimaryProcedureOPCS

Comment or raise an issue for this mapping.

COSDv9SKProcedureOccurrenceProcedureOpcs

Comment or raise an issue for this mapping.

COSDv9SKProcedureOccurrencePrimaryProcedureOpcs

Comment or raise an issue for this mapping.

COSDv9SKProcedureOccurrenceDiagnosticProcedureSnomedCt

Comment or raise an issue for this mapping.

COSDv9SKProcedureOccurrenceDiagnosticProcedureOpcs

Comment or raise an issue for this mapping.

COSDv8SKProcedureOccurrenceProcedureOPCS

Comment or raise an issue for this mapping.

COSDv8SKProcedureOccurrencePrimaryProcedureOPCS

Comment or raise an issue for this mapping.

COSDv9SAProcedureOccurrenceProcedureOpcsProcedureDate

Comment or raise an issue for this mapping.

COSDv9SAProcedureOccurrencePrimaryProcedureOpcsProcedureDate

Comment or raise an issue for this mapping.

COSDv8SAProcedureOccurrenceProcedureOPCSProcedureDate

Comment or raise an issue for this mapping.

COSDv8SAProcedureOccurrencePrimaryProcedureOPCSProcedureDate

Comment or raise an issue for this mapping.

COSDv9LVProcedureOccurrenceProcedureOpcs

Comment or raise an issue for this mapping.

COSDv9LVProcedureOccurrencePrimaryProcedureOpcs

Comment or raise an issue for this mapping.

COSDv8LVProcedureOccurrenceProcedureOPCS

Comment or raise an issue for this mapping.

COSDv8LVProcedureOccurrencePrimaryProcedureOPCS

Comment or raise an issue for this mapping.

CosdV9LungProcedureOccurrenceRelapseMethodOfDetection

Comment or raise an issue for this mapping.

CosdV9LungProcedureOccurrenceProcedureOpcs

Duplicates

COSD data contains numerous duplicated records due to repeated submissions that include the same records. The latest record may occasionally have a NULL field that was previously populated. We observed this for address fields, date of birth and other personal details, but did not observe it for procedure data.

In order to avoid true duplicates occurring in the data, we have included distinct records for NHSNumber (person_id) , ProcedureOpcsCode(procedure_concept_id), ProcedureDate (procedure_date) and excluded all duplicates. The tool will handle things a little differently, as each new submission will have to be dealt with as it arrives.

Comment or raise an issue for this mapping.

CosdV9LungProcedureOccurrencePrimaryProcedureOpcs

Duplicates

COSD data contains numerous duplicated records due to repeated submissions that include the same records. The latest record may occasionally have a NULL field that was previously populated. We observed this for address fields, date of birth and other personal details, but did not observe it for procedure data.

In order to avoid true duplicates occurring in the data, we have included distinct records for NHSNumber (person_id) , PrimaryProcedureOpcs(procedure_concept_id), ProcedureDate (procedure_date) and excluded all duplicates. The tool will handle things a little differently, as each new submission will have to be dealt with as it arrives.

Comment or raise an issue for this mapping.

CosdV8LungProcedureOccurrenceRelapseMethodOfDetection

Comment or raise an issue for this mapping.

CosdV8LungProcedureOccurrenceProcedureOpcs

Duplicates

COSD data contains numerous duplicated records due to repeated submissions that include the same records. The latest record may occasionally have a NULL field that was previously populated. We observed this for address fields, date of birth and other personal details, but did not observe it for procedure data.

In order to avoid true duplicates occurring in the data, we have included distinct records for NHSNumber (person_id) , ProcedureOpcsCode(procedure_concept_id), ProcedureDate (procedure_date) and excluded all duplicates. The tool will handle things a little differently, as each new submission will have to be dealt with as it arrives.

Comment or raise an issue for this mapping.

CosdV8LungProcedureOccurrencePrimaryProcedureOpcs

Assumptions

• Primary procedure OPCS codes from lung cancer treatment records
• Procedure dates are taken as recorded in the clinical system
• Duplicates are handled by selecting distinct records based on NHS Number, Procedure Date, and Primary Procedure OPCS

Comment or raise an issue for this mapping.

COSDv9HAProcedureOccurrenceProcedureOpcs

Comment or raise an issue for this mapping.

COSDv9HAProcedureOccurrencePrimaryProcedureOpcs

Comment or raise an issue for this mapping.

COSDv9HAProcedureOccurrenceDiagnosticProcedureSnomedCt

Comment or raise an issue for this mapping.

COSDv9HAProcedureOccurrenceDiagnosticProcedureOpcs

Comment or raise an issue for this mapping.

COSDv901CTProcedureOccurrenceProcedureOpcs

Comment or raise an issue for this mapping.

COSDv901CTProcedureOccurrencePrimaryProcedureOpcs

Comment or raise an issue for this mapping.

COSDv8CTProcedureOccurrencePrimaryProcedureOPCS

Comment or raise an issue for this mapping.

COSDv9COProcedureOccurrenceProcedureOpcs

Comment or raise an issue for this mapping.

COSDv9COProcedureOccurrencePrimaryProcedureOpcs

Comment or raise an issue for this mapping.

COSDv8COProcedureOccurrenceProcedureOPCS

Comment or raise an issue for this mapping.

COSDv8COProcedureOccurrencePrimaryProcedureOPCS

Comment or raise an issue for this mapping.

CosdV9ProcedureOccurrenceProcedureOpcs

Duplicates

COSD data contains numerous duplicated records due to repeated submissions that include the same records. The latest record may occasionally have a NULL field that was previously populated. We observed this for address fields, date of birth and other personal details, but did not observe it for procedure data.

In order to avoid true duplicates occurring in the data, we have included distinct records for NHSNumber (person_id) , PrimaryProcedureOpcs(procedure_concept_id), ProcedureOpcs(procedure_concept_id), ProcedureDate (procedure_date) and excluded all duplicates. The tool will handle things a little differently, as each new submission will have to be dealt with as it arrives.

Comment or raise an issue for this mapping.

CosdV9ProcedureOccurrencePrimaryProcedureOpcs

Duplicates

COSD data contains numerous duplicated records due to repeated submissions that include the same records. The latest record may occasionally have a NULL field that was previously populated. We observed this for address fields, date of birth and other personal details, but did not observe it for procedure data.

In order to avoid true duplicates occurring in the data, we have included distinct records for NHSNumber (person_id) , PrimaryProcedureOpcs(procedure_concept_id), ProcedureOpcs(procedure_concept_id), ProcedureDate (procedure_date) and excluded all duplicates. The tool will handle things a little differently, as each new submission will have to be dealt with as it arrives.

Comment or raise an issue for this mapping.

CosdV8ProcedureOccurrenceProcedureOpcs

Duplicates

COSD data contains numerous duplicated records due to repeated submissions that include the same records. The latest record may occasionally have a NULL field that was previously populated. We observed this for address fields, date of birth and other personal details, but did not observe it for procedure data.

In order to avoid true duplicates occurring in the data, we have included distinct records for NHSNumber (person_id) , PrimaryProcedureOpcs(procedure_concept_id), ProcedureOpcs(procedure_concept_id), ProcedureDate (procedure_date) and excluded all duplicates. The tool will handle things a little differently, as each new submission will have to be dealt with as it arrives.

Comment or raise an issue for this mapping.

CosdV8ProcedureOccurrencePrimaryProcedureOpcs

Duplicates

COSD data contains numerous duplicated records due to repeated submissions that include the same records. The latest record may occasionally have a NULL field that was previously populated. We observed this for address fields, date of birth and other personal details, but did not observe it for procedure data.

In order to avoid true duplicates occurring in the data, we have included distinct records for NHSNumber (person_id) , PrimaryProcedureOpcs(procedure_concept_id), ProcedureOpcs(procedure_concept_id), ProcedureDate (procedure_date) and excluded all duplicates. The tool will handle things a little differently, as each new submission will have to be dealt with as it arrives.

Comment or raise an issue for this mapping.

CosdV9BreastProcedureOccurrenceProcedureOpcs

Duplicates

COSD data contains numerous duplicated records due to repeated submissions that include the same records. The latest record may occasionally have a NULL field that was previously populated. We observed this for address fields, date of birth and other personal details, but did not observe it for procedure data.

In order to avoid true duplicates occurring in the data, we have included distinct records for NHSNumber (person_id) , PrimaryProcedureOpcs(procedure_concept_id), ProcedureOpcs(procedure_concept_id), ProcedureDate (procedure_date) and excluded all duplicates. The tool will handle things a little differently, as each new submission will have to be dealt with as it arrives.

Comment or raise an issue for this mapping.

CosdV9BreastProcedureOccurrencePrimaryProcedureOpcs

Duplicates

COSD data contains numerous duplicated records due to repeated submissions that include the same records. The latest record may occasionally have a NULL field that was previously populated. We observed this for address fields, date of birth and other personal details, but did not observe it for procedure data.

In order to avoid true duplicates occurring in the data, we have included distinct records for NHSNumber (person_id) , PrimaryProcedureOpcs(procedure_concept_id), ProcedureOpcs(procedure_concept_id), ProcedureDate (procedure_date) and excluded all duplicates. The tool will handle things a little differently, as each new submission will have to be dealt with as it arrives.

Comment or raise an issue for this mapping.

CosdV8BreastProcedureOccurrenceProcedureOpcs

Duplicates

COSD data contains numerous duplicated records due to repeated submissions that include the same records. The latest record may occasionally have a NULL field that was previously populated. We observed this for address fields, date of birth and other personal details, but did not observe it for procedure data.

In order to avoid true duplicates occurring in the data, we have included distinct records for NHSNumber (person_id) , PrimaryProcedureOpcs(procedure_concept_id), ProcedureOpcs(procedure_concept_id), ProcedureDate (procedure_date) and excluded all duplicates. The tool will handle things a little differently, as each new submission will have to be dealt with as it arrives.

Comment or raise an issue for this mapping.

CosdV8BreastProcedureOccurrencePrimaryProcedureOpcs

Duplicates

COSD data contains numerous duplicated records due to repeated submissions that include the same records. The latest record may occasionally have a NULL field that was previously populated. We observed this for address fields, date of birth and other personal details, but did not observe it for procedure data.

In order to avoid true duplicates occurring in the data, we have included distinct records for NHSNumber (person_id) , PrimaryProcedureOpcs(procedure_concept_id), ProcedureOpcs(procedure_concept_id), ProcedureDate (procedure_date) and excluded all duplicates. The tool will handle things a little differently, as each new submission will have to be dealt with as it arrives.

Comment or raise an issue for this mapping.

COSDv9BAProcedureOccurrenceProcedureOpcsProcedureDate

Comment or raise an issue for this mapping.

COSDv9BAProcedureOccurrencePrimaryProcedureOpcsProcedureDate

Comment or raise an issue for this mapping.

COSDv9BAProcedureOccurrenceBiopsyTypeProcedureDate

Comment or raise an issue for this mapping.

COSDv8BAProcedureOccurrencePrimaryProcedureOPCSProcedureDate

Comment or raise an issue for this mapping.