> ## 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.

# 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](https://hl7.org/fhir/R4/diagnosticreport.html) for full details.

**Previous version:** [diagnostic\_report](/medical-api/handling-data/schema-v000/diagnostic-report)

**Tables in this resource:**

* **diagnosticreport** – Main diagnostic report record (this page)
* [diagnosticreport\_category](/medical-api/handling-data/schema-v100/diagnosticreport/category) – Backbone for category; codings in diagnosticreport\_category\_coding
* [diagnosticreport\_category\_coding](/medical-api/handling-data/schema-v100/diagnosticreport/category_coding)
* [diagnosticreport\_code\_coding](/medical-api/handling-data/schema-v100/diagnosticreport/code_coding)
* [diagnosticreport\_presentedform](/medical-api/handling-data/schema-v100/diagnosticreport/presentedform) – Attachment content
* [diagnosticreport\_extension](/medical-api/handling-data/schema-v100/diagnosticreport/extension)
* [diagnosticreport\_extension\_vcc\_coding](/medical-api/handling-data/schema-v100/diagnosticreport/extension_vcc_coding)
* **diagnosticreport\_references** – Normalized references; see [Reference Tables](/medical-api/handling-data/schema-v100/reference_tables)

**Primary Keys:**

* diagnosticreport\_id

**Foreign Keys:**

* patient\_id – links to the [patient](/medical-api/handling-data/schema-v100/patient/base) table (subject)

<div style={{textAlign: 'right'}}><sub>† Metriport Platform added</sub></div>

| 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](/medical-api/handling-data/schema-v100/patient/base)

**Child:**

* [diagnosticreport\_category](/medical-api/handling-data/schema-v100/diagnosticreport/category)
* [diagnosticreport\_code\_coding](/medical-api/handling-data/schema-v100/diagnosticreport/code_coding)
* [diagnosticreport\_extension](/medical-api/handling-data/schema-v100/diagnosticreport/extension)
* [diagnosticreport\_presentedform](/medical-api/handling-data/schema-v100/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`](/medical-api/handling-data/schema-v100/diagnosticreport/category_coding) w/ `system = 'http://terminology.hl7.org/CodeSystem/v2-0074'`
* `category_hl7_display` → [`diagnosticreport_category_coding.display`](/medical-api/handling-data/schema-v100/diagnosticreport/category_coding) w/ `system = 'http://terminology.hl7.org/CodeSystem/v2-0074'`
* `source_category_code` → [`diagnosticreport_category_coding.code`](/medical-api/handling-data/schema-v100/diagnosticreport/category_coding) w/ `code_rank = 1`
* `source_category_display` → [`diagnosticreport_category_coding.display`](/medical-api/handling-data/schema-v100/diagnosticreport/category_coding) w/ `code_rank = 1`
* `source_category_system` → [`diagnosticreport_category_coding.system`](/medical-api/handling-data/schema-v100/diagnosticreport/category_coding) w/ `code_rank = 1`
* `source_code_code` → [`diagnosticreport_code_coding.code`](/medical-api/handling-data/schema-v100/diagnosticreport/code_coding) w/ `code_rank = 1`
* `source_code_display` → [`diagnosticreport_code_coding.display`](/medical-api/handling-data/schema-v100/diagnosticreport/code_coding) w/ `code_rank = 1`
* `source_code_system` → [`diagnosticreport_code_coding.system`](/medical-api/handling-data/schema-v100/diagnosticreport/code_coding) w/ `code_rank = 1`