Documentation/EHI_Export/docs/tables/clinical_rules.html
| 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
|
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc/Asc | id + pid |