Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | VARCHAR | 31 | '' |
|
|
Unique and maps to list_options list clinical_rules |
||
| pid | BIGINT | 19 | 0 |
|
|
0 is default for all patients, while > 0 is id from patient_data table |
||
| active_alert_flag | BOOLEAN | 3 | √ | NULL |
|
|
Active Alert Widget Module flag - note not yet utilized |
|
| passive_alert_flag | BOOLEAN | 3 | √ | NULL |
|
|
Passive Alert Widget Module 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_nqf_code | VARCHAR | 10 | '' |
|
|
Clinical Quality Measure NQF identifier |
||
| cqm_pqri_code | VARCHAR | 10 | '' |
|
|
Clinical Quality Measure PQRI identifier |
||
| amc_flag | BOOLEAN | 3 | √ | NULL |
|
|
Automated Measure Calculation flag (unable to customize per patient) |
|
| amc_2011_flag | BOOLEAN | 3 | √ | NULL |
|
|
2011 Automated Measure Calculation flag for (unable to customize per patient) |
|
| amc_2014_flag | BOOLEAN | 3 | √ | NULL |
|
|
2014 Automated Measure Calculation flag for (unable to customize per patient) |
|
| amc_2015_flag | BOOLEAN | 3 | √ | NULL |
|
|
2015 Automated Measure Calculation flag for (unable to customize per patient) |
|
| amc_code | VARCHAR | 10 | '' |
|
|
Automated Measure Calculation identifier (MU rule) |
||
| amc_code_2014 | VARCHAR | 30 | '' |
|
|
Automated Measure Calculation 2014 identifier (MU rule) |
||
| amc_code_2015 | VARCHAR | 30 | '' |
|
|
Automated Measure Calculation 2014 identifier (MU rule) |
||
| amc_2014_stage1_flag | BOOLEAN | 3 | √ | NULL |
|
|
2014 Stage 1 - Automated Measure Calculation flag for (unable to customize per patient) |
|
| amc_2014_stage2_flag | BOOLEAN | 3 | √ | NULL |
|
|
2014 Stage 2 - Automated Measure Calculation flag for (unable to customize per patient) |
|
| patient_reminder_flag | BOOLEAN | 3 | √ | NULL |
|
|
Clinical Reminder Module flag |
|
| bibliographic_citation | VARCHAR | 255 | '' |
|
|
|||
| developer | VARCHAR | 255 | '' |
|
|
Clinical Rule Developer |
||
| funding_source | VARCHAR | 255 | '' |
|
|
Clinical Rule Funding Source |
||
| release_version | VARCHAR | 255 | '' |
|
|
Clinical Rule Release Version |
||
| web_reference | VARCHAR | 255 | '' |
|
|
Clinical Rule Web Reference |
||
| linked_referential_cds | VARCHAR | 50 | '' |
|
|
|||
| access_control | VARCHAR | 255 | 'patients:med' |
|
|
ACO link for access control |
||
| patient_dob_usage | TEXT | 65535 | √ | NULL |
|
|
Description of how patient DOB is used by this rule |
|
| patient_ethnicity_usage | TEXT | 65535 | √ | NULL |
|
|
Description of how patient ethnicity is used by this rule |
|
| patient_health_status_usage | TEXT | 65535 | √ | NULL |
|
|
Description of how patient health status assessments are used by this rule |
|
| patient_gender_identity_usage | TEXT | 65535 | √ | NULL |
|
|
Description of how patient gender identity information is used by this rule |
|
| patient_language_usage | TEXT | 65535 | √ | NULL |
|
|
Description of how patient language information is used by this rule |
|
| patient_race_usage | TEXT | 65535 | √ | NULL |
|
|
Description of how patient race information is used by this rule |
|
| patient_sex_usage | TEXT | 65535 | √ | NULL |
|
|
Description of how patient birth sex information is used by this rule |
|
| patient_sexual_orientation_usage | TEXT | 65535 | √ | NULL |
|
|
Description of how patient sexual orientation is used by this rule |
|
| patient_sodh_usage | TEXT | 65535 | √ | NULL |
|
|
Description of how patient social determinants of health are used by this rule |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc/Asc | id + pid |