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

# careplan_activity

Identifies a planned item that is part of the care plan (`CarePlan.activity[]`).

**Primary Keys:**

* careplan\_activity\_id

**Foreign Keys:**

* careplan\_id - links to the [care plan](/medical-api/handling-data/schema-v100/careplan/base) table

| Column                            | Data Type | Description                                                                               |
| --------------------------------- | --------- | ----------------------------------------------------------------------------------------- |
| careplan\_activity\_id            | varchar   | Unique identifier for the activity row                                                    |
| careplan\_id                      | varchar   | Parent care plan                                                                          |
| detail\_status                    | varchar   | Status of the activity detail                                                             |
| detail\_scheduledperiod\_start    | datetime  | Start of scheduled period for the activity (FHIR `activity.detail.scheduledPeriod.start`) |
| detail\_scheduledperiod\_end      | datetime  | End of scheduled period for the activity (FHIR `activity.detail.scheduledPeriod.end`)     |
| detail\_code\_text                | varchar   | Free-text activity detail code (FHIR `activity.detail.code.text`)                         |
| detail\_description               | varchar   | Description of the activity                                                               |
| detail\_location\_reference\_id   | varchar   | Resolved ID of the location where the activity takes place                                |
| detail\_location\_reference\_type | varchar   | Type of referenced resource (e.g. Location)                                               |

**Related Tables:**

**Parent:**

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

**Child:**

* [careplan\_activity\_detail\_code\_coding](/medical-api/handling-data/schema-v100/careplan/activity_detail_code_coding)
* [careplan\_activity\_detail\_performer](/medical-api/handling-data/schema-v100/careplan/activity_detail_performer)