form_care_plan


If there is patient data for this table the file for this export will be found in the extracted zip folder location under the filename of form_care_plan.csv

If there are non-patient data column elements that are not part of the designated record set they will be marked in the Comment's column for that data element

Description

Patient Clinical Care Plans

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
date DATETIME 19 √ NULL
pid BIGINT 19 √ NULL
patient_data.pid Defined in XML R

The internal patient identifier
encounter VARCHAR 255 √ NULL
user VARCHAR 255 √ NULL
groupname VARCHAR 255 √ NULL
authorized TINYINT 3 √ NULL
activity TINYINT 3 √ NULL
code VARCHAR 255 √ NULL
codetext TEXT 65535 √ NULL
description TEXT 65535 √ NULL
external_id VARCHAR 30 √ NULL
care_plan_type VARCHAR 30 √ NULL
list_options.option_id Defined in XML R

Comes from the list_options.list_id=‘Plan_of_Care_Type’
note_related_to TEXT 65535 √ NULL
date_end DATETIME 19 √ NULL
reason_code VARCHAR 31 √ NULL
reason_description TEXT 65535 √ NULL
reason_date_low DATETIME 19 √ NULL

The date the reason was recorded
reason_date_high DATETIME 19 √ NULL

The date the explanation reason for the care plan entry value ends
reason_status VARCHAR 31 √ NULL
plan_status VARCHAR 32 √ NULL
list_options.option_id Defined in XML R

Comes from the list_options.list_id=‘care_plan_status’
proposed_date DATETIME 19 √ NULL

Target or Achieve-by date for the goal

Indexes

Constraint Name Type Sort Column(s)
idx_status_date Performance Asc/Asc/Asc plan_status + date + date_end

Relationships

Close relationships within degrees of separation