Procedure

Schema documentation for the Procedure table in the Metriport data model

The procedure resource is used to record the details of current and historical procedures performed on or for a patient. A procedure is an activity that is performed on, with, or for a patient as part of the provision of care.

Reference Table:

The procedure_references table contains normalized references from the procedure to other entities. It supports the following reference properties:

• subject (required): links to the patient who underwent the procedure
• encounter: links to the encounter where the procedure was performed
• performer.actor: links to practitioners who performed the procedure
• location: links to the location where the procedure was performed
• report: links to diagnostic reports or other documents related to the procedure

For detailed information about reference table structure and indexing, see the Reference Tables documentation.

Procedure Table: The procedure table records medical procedures performed on patients, including surgical procedures, diagnostic tests, and other clinical interventions.

Primary Keys:

• procedure_id

Foreign Keys:

• patient_id

Column	Data Type	Description
procedure_id	varchar	Unique identifier for the procedure
patient_id	varchar	Unique identifier for the patient
status	varchar	Status of the procedure. Possible values: – preparation: The core event has not started yet, but some staging activities have begun (e.g., premedication, anesthetic, preparing the patient, etc.). – in-progress: The event is currently occurring. – not-done: The event was terminated prior to any activity beyond preparation. – on-hold: The event has been temporarily stopped but is expected to resume in the future. – stopped: The event was terminated prior to completion, after at least some activity has occurred. – completed: The event has now concluded. – entered-in-error: This electronic record should never have existed (e.g., wrong patient, wrong data, mistaken entry, etc.). – unknown: The authoring or source system does not know the current state of the event.
performed_date	date	Start date of the procedure
end_date	date	End date of the procedure
cpt_code	varchar	CPT code for the procedure
cpt_display	varchar	Human-readable description of CPT code
snomed_code	varchar	SNOMED CT code for the procedure
snomed_display	varchar	Human-readable description of SNOMED CT code
source_code_code	varchar	Original code from source system
source_code_display	varchar	Original code display from source system
source_code_system	varchar	Original code system from source system
bodysite_snomed_code	varchar	SNOMED CT body site code
bodysite_snomed_display	varchar	Human-readable description of SNOMED CT body site
reason_snomed_code	varchar	SNOMED CT reason code
reason_snomed_display	varchar	Human-readable description of SNOMED CT reason
note_text	varchar	Additional notes about the procedure
meta_source	varchar	Source document filename from FHIR meta.source
data_source	varchar	Deprecated. Use meta_source instead.
data_source_ext	varchar	Integration source of the data, derived from FHIR extension