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.

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.

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.