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

# goal

A Goal in health care services delivery is generally an expressed desired health state to be achieved by a subject of care (or family/group) over a period or at a specific point of time. See the [HL7 FHIR R4 spec](https://hl7.org/fhir/R4/goal.html) for full details.

**Tables in this resource:**

* **goal** – Main goal record (this page)
* [goal\_description\_coding](/medical-api/handling-data/schema-v100/goal/description_coding)
* [goal\_priority\_coding](/medical-api/handling-data/schema-v100/goal/priority_coding)
* [goal\_target](/medical-api/handling-data/schema-v100/goal/target) – Targets per goal
* [goal\_target\_measure\_coding](/medical-api/handling-data/schema-v100/goal/target_measure_coding)
* [goal\_extension](/medical-api/handling-data/schema-v100/goal/extension)
* [goal\_extension\_vcc\_coding](/medical-api/handling-data/schema-v100/goal/extension_vcc_coding)
* **goal\_references** – Normalized references; see [Reference Tables](/medical-api/handling-data/schema-v100/reference_tables)

**Primary Keys:**

* goal\_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                                                  |
| ----------------------- | --------- | ------------------------------------------------------------ |
| goal\_id                | varchar   | Unique identifier for the goal                               |
| patient\_id             | varchar   | Unique identifier for the patient (subject)                  |
| lifecyclestatus         | varchar   | Lifecycle status of the goal                                 |
| startdate               | datetime  | Start date of the goal                                       |
| description\_text       | varchar   | Free-text description of the goal                            |
| priority\_text          | varchar   | Free-text priority of the goal                               |
| priority\_hl7\_code†    | varchar   | Code from the preferred goal-priority system when matched    |
| priority\_hl7\_display† | varchar   | Display from the preferred goal-priority system when matched |
| meta\_source            | varchar   | Source document filename from FHIR meta.source               |
| data\_source\_ext†      | varchar   | Integration source of the data, derived from FHIR extension  |

**Related Tables:**

**Parent:**

* [patient](/medical-api/handling-data/schema-v100/patient/base)

**Child:**

* [goal\_description\_coding](/medical-api/handling-data/schema-v100/goal/description_coding)
* [goal\_extension](/medical-api/handling-data/schema-v100/goal/extension)
* [goal\_priority\_coding](/medical-api/handling-data/schema-v100/goal/priority_coding)
* [goal\_target](/medical-api/handling-data/schema-v100/goal/target)