CarePlan.activity[]).
Primary Keys:
- careplan_activity_id
- careplan_id - links to the care plan 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) |