diagnosticreport

The findings and interpretation of diagnostic tests performed on patients, groups of patients, devices, and locations, and/or specimens derived from these. See the HL7 FHIR R4 spec for full details.

Previous version: diagnostic_report

Tables in this resource:

• 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

Primary Keys:

• diagnosticreport_id

Foreign Keys:

• 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

Related Tables:

Parent:

• patient

Child:

• diagnosticreport_category
• diagnosticreport_code_coding
• diagnosticreport_extension
• diagnosticreport_presentedform

Version diff

Renamed

• diagnostic_report_id → diagnosticreport_id
• end_date → effectiveperiod_end
• loinc_code → code_loinc_code
• loinc_display → code_loinc_display
• data_source → meta_source

Moved to separate tables

• category_hl7_code → diagnosticreport_category_coding.code w/ system = 'http://terminology.hl7.org/CodeSystem/v2-0074'
• category_hl7_display → diagnosticreport_category_coding.display w/ system = 'http://terminology.hl7.org/CodeSystem/v2-0074'
• source_category_code → diagnosticreport_category_coding.code w/ code_rank = 1
• source_category_display → diagnosticreport_category_coding.display w/ code_rank = 1
• source_category_system → diagnosticreport_category_coding.system w/ code_rank = 1
• source_code_code → diagnosticreport_code_coding.code w/ code_rank = 1
• source_code_display → diagnosticreport_code_coding.display w/ code_rank = 1
• source_code_system → diagnosticreport_code_coding.system w/ code_rank = 1