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
procedure table records medical procedures performed on patients, including surgical procedures, diagnostic tests, and other clinical interventions.
Primary Keys:
- procedure_id
- 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 |
| 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 |
| data_source | varchar | Source of the procedure data |