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


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.