> ## Documentation Index
> Fetch the complete documentation index at: https://docs.metriport.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Diagnostic Report

> Schema documentation for the Diagnostic Report table in the Metriport data model

A diagnostic report is the set of information that is typically provided by a diagnostic service when investigations are complete. The information includes a mix of atomic results, text reports, images, and codes.

**Reference Table:**

The `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

For detailed information about reference table structure and indexing, see the [Reference Tables documentation](/medical-api/handling-data/schema-v000/reference-tables).

**Presented Forms:**
For information about the `diagnostic_report_presented_forms` table that contains the actual content of diagnostic reports (text, images, and other media), see the [Diagnostic Report Presented Forms](/medical-api/handling-data/schema-v000/diagnostic-report-presented-forms) documentation.

**Diagnostic Report Table:**

**Primary Keys:**

* diagnostic\_report\_id

**Foreign Keys:**

* 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: <br />– `registered`: The existence of the report is registered, but there is nothing yet available. <br />– `partial`: This is a partial (e.g. preliminary) report: data in the report may be incomplete or unverified. <br />– `preliminary`: Verified early results are available, but the report is not yet final. <br />– `final`: The report is complete, verified, and issued. <br />– `amended`: The report has been modified subsequent to being final, and is complete and verified. <br />– `corrected`: Subsequent to being final, the report has been modified to correct an error in the report or referenced results. <br />– `appended`: New information is available, but it does not change the existing report content. <br />– `cancelled`: The report is unavailable because the measurement was not started or not completed (also sometimes called "aborted"). <br />– `entered-in-error`: The report has been withdrawn following a previous final release (e.g. released in error). <br />– `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                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |
| source\_code\_code        | varchar   | Original code from source system                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |
| source\_code\_display     | varchar   | Original code display from source system                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |
| source\_code\_system      | varchar   | Original code system from source system                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |
| 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                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |
| meta\_source              | varchar   | Source document filename from FHIR meta.source                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
| data\_source              | varchar   | **Deprecated.** Use `meta_source` instead.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
| data\_source\_ext         | varchar   | Integration source of the data, derived from FHIR extension                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |