procedure

An action that is or was performed on or for a patient. This can be a physical intervention like an operation, or less invasive like long term services, counseling, or hypnotherapy. See the HL7 FHIR R4 spec for full details. Previous version: procedure Tables in this resource:

• procedure – Main procedure record (this page)
• procedure_code_coding
• procedure_bodysite – Backbone for body site
• procedure_bodysite_coding
• procedure_reasoncode – Backbone for reason code
• procedure_reasoncode_coding
• procedure_note – Notes per procedure
• procedure_extension
• procedure_extension_vcc_coding
• procedure_references – Normalized references; see Reference Tables

Primary Keys:

• procedure_id

Foreign Keys:

• patient_id - links to the patient table (subject)

Related Tables: Parent:

• patient

Child:

• procedure_bodysite
• procedure_code_coding
• procedure_extension
• procedure_note
• procedure_reasoncode
• procedure_reasoncode_coding

​

Version diff

Renamed

• end_date → performedperiod_end
• cpt_code → code_cpt_code
• cpt_display → code_cpt_display
• snomed_code → code_snomed_code
• snomed_display → code_snomed_display
• data_source → meta_source

Moved to separate tables

• source_code_code → procedure_code_coding.code w/ code_rank = 1
• source_code_display → procedure_code_coding.display w/ code_rank = 1
• source_code_system → procedure_code_coding.system w/ code_rank = 1
• bodysite_snomed_code → procedure_bodysite_coding.code w/ system = 'http://snomed.info/sct'
• bodysite_snomed_display → procedure_bodysite_coding.display w/ system = 'http://snomed.info/sct'
• source_bodysite_code → procedure_bodysite_coding.code w/ code_rank = 1
• source_bodysite_display → procedure_bodysite_coding.display w/ code_rank = 1
• source_bodysite_system → procedure_bodysite_coding.system w/ code_rank = 1
• source_reason_code → procedure_reasoncode_coding.code w/ code_rank = 1
• source_reason_display → procedure_reasoncode_coding.display w/ code_rank = 1
• source_reason_system → procedure_reasoncode_coding.system w/ code_rank = 1
• reason_snomed_code → procedure_reasoncode_coding.code (deprecated SQL column on base table; filter by system as needed)
• reason_snomed_display → procedure_reasoncode_coding.display (same)
• reasoncode_snomed_code → procedure_reasoncode_coding.code (preferred base-table snapshot; filter by system as needed)
• reasoncode_snomed_display → procedure_reasoncode_coding.display (same)