| cqc_auto_id | int(11) | NO | | PRI | auto_increment | |
| cqc_id | int(11) | NO | 0 | | | |
| cqc_cit_id | int(11) | NO | 0 | MUL | | CQM Info ID# |
| cqc_parent_cqc_id | int(11) | NO | 0 | | | Parent condition ID# |
| cqc_key | varchar(256) | NO | | | | Condition Key |
| cqc_oid | varchar(256) | NO | | | | Value set oid |
| cqc_concept | varchar(40) | NO | | | | Concept |
| cqc_concept_loinc | varchar(40) | NO | | | | Concept Loinc ID |
| cqc_desc | varchar(256) | NO | | | | Description |
| cqc_section | varchar(20) | NO | | | | IPP, DENOM, DENEXCEP, DENEXCL, NUMER, NUMEXCL, MSRPOPL, STRATA |
| cqc_logic_op | varchar(10) | YES | | | | AND OR |
| cqc_logic_op_negation | tinyint(1) | NO | 0 | | | NOT Logic |
| cqc_recent | tinyint(1) | NO | 0 | | | Indicates latest instance |
| cqc_first | tinyint(1) | NO | 0 | | | Indicates earliest instance |
| cqc_variable_commit | tinyint(1) | NO | 0 | | | Indicates variable condition |
| cqc_count_entries | tinyint(1) | NO | 0 | | | |
| cqc_value_type | varchar(45) | YES | | | | programmatic value type. Used for attributes as well |
| cqc_value_type_desc | varchar(256) | YES | | | | Use friendly value description |
| cqc_value | varchar(20) | YES | | | | Value for comparison |
| cqc_value_comparator | varchar(6) | YES | | | | Comparator >, >=, ==, =<, <, != |
| cqc_value_oid | varchar(256) | YES | | | | Comparison Value OID |
| cqc_value_desc | varchar(256) | NO | | | | Describes target value |
| cqc_duration_value | varchar(10) | YES | | | | Duration Value for comparison |
| cqc_duration_comparator | varchar(40) | YES | | | | Duration comparator >, >=, ==, =<, <, != |
| cqc_duration_unit | varchar(10) | YES | | | | Duration unit saved as php diff units |
| cqc_target | varchar(256) | YES | | | | Comparison target 1 description |
| cqc_target_comparator | varchar(6) | YES | | | | Comparator >, >=, ==, =<, <, != |
| cqc_target_id | varchar(256) | YES | | | | Value ID of source |
| cqc_target_attr | varchar(40) | YES | | | | Attribute for comparison (start date, end date, etc) |
| cqc_target_att_modifier | int(11) | NO | 0 | | | Date diff value |
| cqc_target_att_modifier_unit | varchar(5) | YES | | | | Date diff unit |
| cqc_target2 | varchar(256) | YES | | | | Comparison target 2 description |
| cqc_target2_comparator | varchar(6) | YES | | | | Comparator >, >=, ==, =<, <, != |
| cqc_target2_id | varchar(256) | YES | | | | ID of target criteria/condition |
| cqc_target2_attr | varchar(40) | YES | | | | Attribute for comparison (start date, end date, etc) |
| cqc_target2_att_modifier | int(11) | NO | 0 | | | Date diff value |
| cqc_target2_att_modifier_unit | varchar(5) | YES | | | | Date diff unit |
| cqc_source_attr | varchar(256) | NO | | | | Comparison target 1 description |
| cqc_source_attr_abs | tinyint(1) | NO | 0 | | | Indicates to take the absolute value |
| cqc_template_id | varchar(256) | NO | | | | QRDA Template ID |