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)

_{† Metriport Platform added}

Column	Data Type	Description
procedure_id	varchar	Unique identifier for the procedure
patient_id	varchar	Unique identifier for the patient (subject)
status	varchar	Status of the procedure (e.g. completed, in-progress)
performeddatetime	datetime	Performed date/time if provided directly
performedperiod_start	datetime	Start of performed period
performed_date†	datetime	Coalesced performed date (performeddatetime or performedperiod_start)
performedperiod_end	datetime	End of performed period
code_text	varchar	Free-text description of the procedure
code_cpt_code†	varchar	CPT code for the procedure
code_cpt_display†	varchar	Human-readable CPT description
code_snomed_code†	varchar	SNOMED CT code for the procedure
code_snomed_display†	varchar	Human-readable SNOMED CT description
note_text†	varchar	Additional notes about the procedure (first note)
meta_source	varchar	Source document filename from FHIR meta.source
data_source_ext†	varchar	Integration source of the data, derived from FHIR extension

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)