diagnostic_report_references table contains normalized references from the diagnostic report to other entities. It supports the following reference properties:
- subject (required): links to the patient who is the subject of the diagnostic report
- encounter: links to the encounter where the diagnostic report was generated
- performer: links to practitioners who performed the diagnostic procedure
- result: links to observations or other diagnostic results referenced in the report
diagnostic_report_presented_forms table that contains the actual content of diagnostic reports (text, images, and other media), see the Diagnostic Report Presented Forms documentation.
Diagnostic Report Table:
Primary Keys:
- diagnostic_report_id
- patient_id
| Column | Data Type | Description |
|---|---|---|
| diagnostic_report_id | varchar | Unique identifier for the diagnostic report |
| patient_id | varchar | Unique identifier for the patient |
| status | varchar | Status of the diagnostic report. Possible values: – registered: The existence of the report is registered, but there is nothing yet available. – partial: This is a partial (e.g. preliminary) report: data in the report may be incomplete or unverified. – preliminary: Verified early results are available, but the report is not yet final. – final: The report is complete, verified, and issued. – amended: The report has been modified subsequent to being final, and is complete and verified. – corrected: Subsequent to being final, the report has been modified to correct an error in the report or referenced results. – appended: New information is available, but it does not change the existing report content. – cancelled: The report is unavailable because the measurement was not started or not completed (also sometimes called “aborted”). – entered-in-error: The report has been withdrawn following a previous final release (e.g. released in error). – unknown: The current status of the report is unknown. |
| effective_date | date | Start date of the diagnostic report |
| end_date | date | End date of the diagnostic report |
| loinc_code | varchar | LOINC code for the diagnostic report |
| loinc_display | varchar | Human-readable description of LOINC code |
| category_hl7_code | varchar | HL7 category code |
| category_hl7_display | varchar | Human-readable description of HL7 category |
| source_category_code | varchar | Original category code from source system |
| source_category_display | varchar | Original category display from source system |
| source_category_system | varchar | Original category system from source system |
| presented_form_text | varchar | Text content of the diagnostic report |
| data_source | varchar | Source of the diagnostic report data |