clinical_plans


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

The Clinical Quality Measures that are being applied to a specific patient to track. This is used in the clinical reminders system

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 31 ''

Unique and maps to list_options list clinical_plans
pid BIGINT 19 0
patient_data.pid Defined in XML R

The internal patient identifier
normal_flag BOOLEAN 3 √ NULL

Normal Activation Flag
cqm_flag BOOLEAN 3 √ NULL

Clinical Quality Measure flag (unable to customize per patient)
cqm_measure_group VARCHAR 10 ''

Clinical Quality Measure Group Identifier
cqm_2011_flag BOOLEAN 3 √ NULL

2011 Clinical Quality Measure flag (unable to customize per patient)
cqm_2014_flag BOOLEAN 3 √ NULL

2014 Clinical Quality Measure flag (unable to customize per patient)

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc/Asc id + pid

Relationships

Close relationships within degrees of separation