- diagnosticreport – Main diagnostic report record (this page)
- diagnosticreport_category – Backbone for category; codings in diagnosticreport_category_coding
- diagnosticreport_category_coding
- diagnosticreport_code_coding
- diagnosticreport_presentedform – Attachment content
- diagnosticreport_extension
- diagnosticreport_extension_vcc_coding
- diagnosticreport_references – Normalized references; see Reference Tables
- diagnosticreport_id
- patient_id – links to the patient table (subject)
† Metriport Platform added
| Column | Data Type | Description |
|---|---|---|
| diagnosticreport_id | varchar | Unique identifier for the diagnostic report |
| patient_id | varchar | Unique identifier for the patient (subject) |
| status | varchar | Status of the report (e.g. registered, partial, preliminary, final, amended, corrected, appended, cancelled, entered-in-error, unknown) |
| effectivedatetime | datetime | Effective date/time if provided directly |
| effectiveperiod_start | datetime | Start of effective period |
| effective_date† | datetime | Coalesced effective date (effectivedatetime or effectiveperiod_start) |
| effectiveperiod_end | datetime | End of effective period |
| code_text | varchar | Free-text description of the report |
| code_loinc_code† | varchar | LOINC code for the report type |
| code_loinc_display† | varchar | Human-readable LOINC description |
| meta_source | varchar | Source document filename from FHIR meta.source |
| data_source_ext† | varchar | Integration source derived from FHIR extension |
- diagnosticreport_category
- diagnosticreport_code_coding
- diagnosticreport_extension
- diagnosticreport_presentedform
Version diff
Renameddiagnostic_report_id→diagnosticreport_idend_date→effectiveperiod_endloinc_code→code_loinc_codeloinc_display→code_loinc_displaydata_source→meta_source
category_hl7_code→diagnosticreport_category_coding.codew/system = 'http://terminology.hl7.org/CodeSystem/v2-0074'category_hl7_display→diagnosticreport_category_coding.displayw/system = 'http://terminology.hl7.org/CodeSystem/v2-0074'source_category_code→diagnosticreport_category_coding.codew/code_rank = 1source_category_display→diagnosticreport_category_coding.displayw/code_rank = 1source_category_system→diagnosticreport_category_coding.systemw/code_rank = 1source_code_code→diagnosticreport_code_coding.codew/code_rank = 1source_code_display→diagnosticreport_code_coding.displayw/code_rank = 1source_code_system→diagnosticreport_code_coding.systemw/code_rank = 1