Documentation/EHI_Export/docs/tables/clinical_plans.html
| 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_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)
| | cqm_measure_group | VARCHAR | 10 | | | '' |
|
|
Clinical Quality Measure Group Identifier
|
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc/Asc | id + pid |