- 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
- procedure_id
- 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 |
- procedure_bodysite
- procedure_code_coding
- procedure_extension
- procedure_note
- procedure_reasoncode
- procedure_reasoncode_coding
Version diff
Renamedend_date→performedperiod_endcpt_code→code_cpt_codecpt_display→code_cpt_displaysnomed_code→code_snomed_codesnomed_display→code_snomed_displaydata_source→meta_source
source_code_code→procedure_code_coding.codew/code_rank = 1source_code_display→procedure_code_coding.displayw/code_rank = 1source_code_system→procedure_code_coding.systemw/code_rank = 1bodysite_snomed_code→procedure_bodysite_coding.codew/system = 'http://snomed.info/sct'bodysite_snomed_display→procedure_bodysite_coding.displayw/system = 'http://snomed.info/sct'source_bodysite_code→procedure_bodysite_coding.codew/code_rank = 1source_bodysite_display→procedure_bodysite_coding.displayw/code_rank = 1source_bodysite_system→procedure_bodysite_coding.systemw/code_rank = 1source_reason_code→procedure_reasoncode_coding.codew/code_rank = 1source_reason_display→procedure_reasoncode_coding.displayw/code_rank = 1source_reason_system→procedure_reasoncode_coding.systemw/code_rank = 1reason_snomed_code→procedure_reasoncode_coding.code(deprecated SQL column on base table; filter bysystemas needed)reason_snomed_display→procedure_reasoncode_coding.display(same)reasoncode_snomed_code→procedure_reasoncode_coding.code(preferred base-table snapshot; filter bysystemas needed)reasoncode_snomed_display→procedure_reasoncode_coding.display(same)