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

Child:

• careplan_activity_detail_code_coding
• careplan_activity_detail_performer