CDR Rules tables

From OpenEMR Project Wiki
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
--
-- Table structure for table `rule_action`
--

DROP TABLE IF EXISTS `rule_action`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `rule_action` (
  `id` varchar(31) NOT NULL DEFAULT '' COMMENT 'Maps to the id column in the clinical_rules table',
  `group_id` bigint(20) NOT NULL DEFAULT '1' COMMENT 'Contains group id to identify collection of targets in a rule',
  `category` varchar(31) NOT NULL DEFAULT '' COMMENT 'Maps to the category item in the rule_action_item table',
  `item` varchar(31) NOT NULL DEFAULT '' COMMENT 'Maps to the item column in the rule_action_item table',
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `rule_action`
--

LOCK TABLES `rule_action` WRITE;
/*!40000 ALTER TABLE `rule_action` DISABLE KEYS */;
INSERT INTO `rule_action` VALUES ('rule_wt_assess_couns_child_cqm',1,'act_cat_measure','act_wt'),('rule_wt_assess_couns_child_cqm',2,'act_cat_edu','act_wt'),('rule_htn_bp_measure',1,'act_cat_measure','act_bp'),('rule_tob_use_assess',1,'act_cat_assess','act_tobacco'),('rule_tob_cess_inter',1,'act_cat_inter','act_tobacco'),('rule_adult_wt_screen_fu',1,'act_cat_measure','act_wt'),('rule_wt_assess_couns_child',1,'act_cat_measure','act_wt'),('rule_wt_assess_couns_child',2,'act_cat_edu','act_wt'),('rule_influenza_ge_50',1,'act_cat_treat','act_influvacc'),('rule_child_immun_stat',1,'act_cat_assess','act_vaccs'),('rule_pneumovacc_ge_65',1,'act_cat_treat','act_pneumovacc'),('rule_dm_hemo_a1c',1,'act_cat_measure','act_hemo_a1c'),('rule_dm_urine_alb',1,'act_cat_measure','act_urine_alb'),('rule_dm_eye',1,'act_cat_exam','act_eye'),('rule_dm_foot',1,'act_cat_exam','act_foot'),('rule_cs_mammo',1,'act_cat_measure','act_mammo'),('rule_cs_pap',1,'act_cat_exam','act_pap'),('rule_cs_colon',1,'act_cat_assess','act_colon_cancer_screen'),('rule_cs_prostate',1,'act_cat_assess','act_prostate_cancer_screen'),('rule_inr_monitor',1,'act_cat_measure','act_lab_inr'),('rule_appt_reminder',1,'act_cat_remind','act_appointment');
/*!40000 ALTER TABLE `rule_action` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `rule_action_item`
--

DROP TABLE IF EXISTS `rule_action_item`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `rule_action_item` (
  `category` varchar(31) NOT NULL DEFAULT '' COMMENT 'Maps to list_options list rule_action_category',
  `item` varchar(31) NOT NULL DEFAULT '' COMMENT 'Maps to list_options list rule_action',
  `clin_rem_link` varchar(255) NOT NULL DEFAULT '' COMMENT 'Custom html link in clinical reminder widget',
  `reminder_message` text NOT NULL COMMENT 'Custom message in patient reminder',
  `custom_flag` tinyint(1) NOT NULL DEFAULT '0' COMMENT '1 indexed to rule_patient_data, 0 indexed within main schema',
  PRIMARY KEY (`category`,`item`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `rule_action_item`
--

LOCK TABLES `rule_action_item` WRITE;
/*!40000 ALTER TABLE `rule_action_item` DISABLE KEYS */;
INSERT INTO `rule_action_item` VALUES ('act_cat_measure','act_bp','','',0),('act_cat_assess','act_tobacco','','',0),('act_cat_inter','act_tobacco','','',1),('act_cat_measure','act_wt','','',0),('act_cat_edu','act_wt','','',1),('act_cat_treat','act_influvacc','','',0),('act_cat_assess','act_vaccs','','',0),('act_cat_treat','act_pneumovacc','','',0),('act_cat_measure','act_hemo_a1c','','',1),('act_cat_measure','act_urine_alb','','',1),('act_cat_exam','act_eye','','',1),('act_cat_exam','act_foot','','',1),('act_cat_measure','act_mammo','','',1),('act_cat_exam','act_pap','','',1),('act_cat_assess','act_colon_cancer_screen','','',1),('act_cat_assess','act_prostate_cancer_screen','','',1),('act_cat_measure','act_lab_inr','','',0),('act_cat_remind','act_appointment','','',0);
/*!40000 ALTER TABLE `rule_action_item` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `rule_filter`
--

DROP TABLE IF EXISTS `rule_filter`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `rule_filter` (
  `id` varchar(31) NOT NULL DEFAULT '' COMMENT 'Maps to the id column in the clinical_rules table',
  `include_flag` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0 is exclude and 1 is include',
  `required_flag` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0 is required and 1 is optional',
  `method` varchar(31) NOT NULL DEFAULT '' COMMENT 'Maps to list_options list rule_filters',
  `method_detail` varchar(31) NOT NULL DEFAULT '' COMMENT 'Maps to list_options lists rule__intervals',
  `value` varchar(255) NOT NULL DEFAULT '',
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `rule_filter`
--

LOCK TABLES `rule_filter` WRITE;
/*!40000 ALTER TABLE `rule_filter` DISABLE KEYS */;
INSERT INTO `rule_filter` VALUES ('rule_htn_bp_measure_cqm',1,0,'filt_lists','medical_problem','CUSTOM::HTN'),('rule_htn_bp_measure_cqm',1,0,'filt_lists','medical_problem','ICD9::401'),('rule_htn_bp_measure_cqm',1,0,'filt_lists','medical_problem','ICD9::402'),('rule_htn_bp_measure_cqm',1,0,'filt_lists','medical_problem','ICD9::403'),('rule_htn_bp_measure_cqm',1,0,'filt_lists','medical_problem','ICD9::404'),('rule_htn_bp_measure_cqm',1,0,'filt_lists','medical_problem','ICD9::405'),('rule_htn_bp_measure_cqm',1,1,'filt_age_min','year','18'),('rule_htn_bp_measure_cqm',1,1,'filt_encounter_min','','2'),('rule_htn_bp_measure_cqm',1,1,'filt_measure_period','year','1'),('rule_tob_use_assess_cqm',1,1,'filt_age_min','year','18'),('rule_tob_use_assess_cqm',1,1,'filt_encounter_min','','2'),('rule_tob_cess_inter_cqm',1,1,'filt_database','','LIFESTYLE::tobacco::current'),('rule_tob_cess_inter_cqm',1,1,'filt_age_min','year','18'),('rule_wt_assess_couns_child_cqm',1,1,'filt_age_max','year','18'),('rule_influenza_ge_50_cqm',1,1,'filt_age_min','year','50'),('rule_child_immun_stat_cqm',1,1,'filt_age_min','year','1'),('rule_child_immun_stat_cqm',1,1,'filt_age_max','year','18'),('rule_pneumovacc_ge_65_cqm',1,1,'filt_age_min','year','65'),('rule_dm_eye_cqm',1,0,'filt_lists','medical_problem','CUSTOM::diabetes'),('rule_dm_eye_cqm',1,0,'filt_lists','medical_problem','ICD9::250'),('rule_dm_foot_cqm',1,0,'filt_lists','medical_problem','CUSTOM::diabetes'),('rule_dm_foot_cqm',1,0,'filt_lists','medical_problem','ICD9::250'),('rule_dm_bp_control_cqm',1,0,'filt_lists','medical_problem','CUSTOM::diabetes'),('rule_dm_bp_control_cqm',1,0,'filt_lists','medical_problem','ICD9::250'),('rule_htn_bp_measure',1,0,'filt_lists','medical_problem','CUSTOM::HTN'),('rule_htn_bp_measure',1,0,'filt_lists','medical_problem','ICD9::401'),('rule_htn_bp_measure',1,0,'filt_lists','medical_problem','ICD9::402'),('rule_htn_bp_measure',1,0,'filt_lists','medical_problem','ICD9::403'),('rule_htn_bp_measure',1,0,'filt_lists','medical_problem','ICD9::404'),('rule_htn_bp_measure',1,0,'filt_lists','medical_problem','ICD9::405'),('rule_tob_cess_inter',1,1,'filt_database','','LIFESTYLE::tobacco::current'),('rule_wt_assess_couns_child',1,1,'filt_age_max','year','18'),('rule_influenza_ge_50',1,1,'filt_age_min','year','50'),('rule_child_immun_stat',1,1,'filt_age_min','year','1'),('rule_child_immun_stat',1,1,'filt_age_max','year','18'),('rule_pneumovacc_ge_65',1,1,'filt_age_min','year','65'),('rule_dm_hemo_a1c',1,0,'filt_lists','medical_problem','CUSTOM::diabetes'),('rule_dm_hemo_a1c',1,0,'filt_lists','medical_problem','ICD9::250'),('rule_dm_urine_alb',1,0,'filt_lists','medical_problem','CUSTOM::diabetes'),('rule_dm_urine_alb',1,0,'filt_lists','medical_problem','ICD9::250'),('rule_dm_eye',1,0,'filt_lists','medical_problem','CUSTOM::diabetes'),('rule_dm_eye',1,0,'filt_lists','medical_problem','ICD9::250'),('rule_dm_foot',1,0,'filt_lists','medical_problem','CUSTOM::diabetes'),('rule_dm_foot',1,0,'filt_lists','medical_problem','ICD9::250'),('rule_cs_mammo',1,1,'filt_age_min','year','40'),('rule_cs_mammo',1,1,'filt_sex','','Female'),('rule_cs_pap',1,1,'filt_age_min','year','18'),('rule_cs_pap',1,1,'filt_sex','','Female'),('rule_cs_colon',1,1,'filt_age_min','year','50'),('rule_cs_prostate',1,1,'filt_age_min','year','50'),('rule_cs_prostate',1,1,'filt_sex','','Male'),('rule_inr_monitor',1,0,'filt_lists','medication','coumadin'),('rule_inr_monitor',1,0,'filt_lists','medication','warfarin');
/*!40000 ALTER TABLE `rule_filter` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `rule_patient_data`
--

DROP TABLE IF EXISTS `rule_patient_data`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `rule_patient_data` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `date` datetime DEFAULT NULL,
  `pid` bigint(20) NOT NULL,
  `category` varchar(31) NOT NULL DEFAULT '' COMMENT 'Maps to the category item in the rule_action_item table',
  `item` varchar(31) NOT NULL DEFAULT '' COMMENT 'Maps to the item column in the rule_action_item table',
  `complete` varchar(31) NOT NULL DEFAULT '' COMMENT 'Maps to list_options list yesno',
  `result` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `pid` (`pid`),
  KEY `category` (`category`,`item`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `rule_patient_data`
--

LOCK TABLES `rule_patient_data` WRITE;
/*!40000 ALTER TABLE `rule_patient_data` DISABLE KEYS */;
/*!40000 ALTER TABLE `rule_patient_data` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `rule_reminder`
--

DROP TABLE IF EXISTS `rule_reminder`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `rule_reminder` (
  `id` varchar(31) NOT NULL DEFAULT '' COMMENT 'Maps to the id column in the clinical_rules table',
  `method` varchar(31) NOT NULL DEFAULT '' COMMENT 'Maps to list_options list rule_reminder_methods',
  `method_detail` varchar(31) NOT NULL DEFAULT '' COMMENT 'Maps to list_options list rule_reminder_intervals',
  `value` varchar(255) NOT NULL DEFAULT '',
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `rule_reminder`
--

LOCK TABLES `rule_reminder` WRITE;
/*!40000 ALTER TABLE `rule_reminder` DISABLE KEYS */;
INSERT INTO `rule_reminder` VALUES ('rule_htn_bp_measure','clinical_reminder_pre','week','2'),('rule_htn_bp_measure','clinical_reminder_post','month','1'),('rule_htn_bp_measure','patient_reminder_pre','week','2'),('rule_htn_bp_measure','patient_reminder_post','month','1'),('rule_tob_use_assess','clinical_reminder_pre','week','2'),('rule_tob_use_assess','clinical_reminder_post','month','1'),('rule_tob_use_assess','patient_reminder_pre','week','2'),('rule_tob_use_assess','patient_reminder_post','month','1'),('rule_tob_cess_inter','clinical_reminder_pre','week','2'),('rule_tob_cess_inter','clinical_reminder_post','month','1'),('rule_tob_cess_inter','patient_reminder_pre','week','2'),('rule_tob_cess_inter','patient_reminder_post','month','1'),('rule_adult_wt_screen_fu','clinical_reminder_pre','week','2'),('rule_adult_wt_screen_fu','clinical_reminder_post','month','1'),('rule_adult_wt_screen_fu','patient_reminder_pre','week','2'),('rule_adult_wt_screen_fu','patient_reminder_post','month','1'),('rule_wt_assess_couns_child','clinical_reminder_pre','week','2'),('rule_wt_assess_couns_child','clinical_reminder_post','month','1'),('rule_wt_assess_couns_child','patient_reminder_pre','week','2'),('rule_wt_assess_couns_child','patient_reminder_post','month','1'),('rule_influenza_ge_50','clinical_reminder_pre','week','2'),('rule_influenza_ge_50','clinical_reminder_post','month','1'),('rule_influenza_ge_50','patient_reminder_pre','week','2'),('rule_influenza_ge_50','patient_reminder_post','month','1'),('rule_child_immun_stat','clinical_reminder_pre','week','2'),('rule_child_immun_stat','clinical_reminder_post','month','1'),('rule_child_immun_stat','patient_reminder_pre','week','2'),('rule_child_immun_stat','patient_reminder_post','month','1'),('rule_pneumovacc_ge_65','clinical_reminder_pre','week','2'),('rule_pneumovacc_ge_65','clinical_reminder_post','month','1'),('rule_pneumovacc_ge_65','patient_reminder_pre','week','2'),('rule_pneumovacc_ge_65','patient_reminder_post','month','1'),('rule_dm_hemo_a1c','clinical_reminder_pre','week','2'),('rule_dm_hemo_a1c','clinical_reminder_post','month','1'),('rule_dm_hemo_a1c','patient_reminder_pre','week','2'),('rule_dm_hemo_a1c','patient_reminder_post','month','1'),('rule_dm_urine_alb','clinical_reminder_pre','week','2'),('rule_dm_urine_alb','clinical_reminder_post','month','1'),('rule_dm_urine_alb','patient_reminder_pre','week','2'),('rule_dm_urine_alb','patient_reminder_post','month','1'),('rule_dm_eye','clinical_reminder_pre','week','2'),('rule_dm_eye','clinical_reminder_post','month','1'),('rule_dm_eye','patient_reminder_pre','week','2'),('rule_dm_eye','patient_reminder_post','month','1'),('rule_dm_foot','clinical_reminder_pre','week','2'),('rule_dm_foot','clinical_reminder_post','month','1'),('rule_dm_foot','patient_reminder_pre','week','2'),('rule_dm_foot','patient_reminder_post','month','1'),('rule_cs_mammo','clinical_reminder_pre','week','2'),('rule_cs_mammo','clinical_reminder_post','month','1'),('rule_cs_mammo','patient_reminder_pre','week','2'),('rule_cs_mammo','patient_reminder_post','month','1'),('rule_cs_pap','clinical_reminder_pre','week','2'),('rule_cs_pap','clinical_reminder_post','month','1'),('rule_cs_pap','patient_reminder_pre','week','2'),('rule_cs_pap','patient_reminder_post','month','1'),('rule_cs_colon','clinical_reminder_pre','week','2'),('rule_cs_colon','clinical_reminder_post','month','1'),('rule_cs_colon','patient_reminder_pre','week','2'),('rule_cs_colon','patient_reminder_post','month','1'),('rule_cs_prostate','clinical_reminder_pre','week','2'),('rule_cs_prostate','clinical_reminder_post','month','1'),('rule_cs_prostate','patient_reminder_pre','week','2'),('rule_cs_prostate','patient_reminder_post','month','1'),('rule_inr_monitor','clinical_reminder_pre','week','2'),('rule_inr_monitor','clinical_reminder_post','month','1'),('rule_inr_monitor','patient_reminder_pre','week','2'),('rule_inr_monitor','patient_reminder_post','month','1'),('rule_appt_remind','patient_reminder_pre','hour','72'),('rule_appt_remind','patient_reminder_post','SKIP','0'),('rule_appt_remind','patient_reminder_current','SKIP','0');
/*!40000 ALTER TABLE `rule_reminder` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `rule_target`
--

DROP TABLE IF EXISTS `rule_target`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `rule_target` (
  `id` varchar(31) NOT NULL DEFAULT '' COMMENT 'Maps to the id column in the clinical_rules table',
  `group_id` bigint(20) NOT NULL DEFAULT '1' COMMENT 'Contains group id to identify collection of targets in a rule',
  `include_flag` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0 is exclude and 1 is include',
  `required_flag` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0 is required and 1 is optional',
  `method` varchar(31) NOT NULL DEFAULT '' COMMENT 'Maps to list_options list rule_targets',
  `value` varchar(255) NOT NULL DEFAULT '' COMMENT 'Data is dependent on the method',
  `interval` bigint(20) NOT NULL DEFAULT '0' COMMENT 'Only used in interval entries',
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `rule_target`
--

LOCK TABLES `rule_target` WRITE;
/*!40000 ALTER TABLE `rule_target` DISABLE KEYS */;
INSERT INTO `rule_target` VALUES ('rule_htn_bp_measure_cqm',1,1,1,'target_database','::form_vitals::bps::::::ge::1',0),('rule_htn_bp_measure_cqm',1,1,1,'target_database','::form_vitals::bpd::::::ge::1',0),('rule_tob_use_assess_cqm',1,1,1,'target_database','LIFESTYLE::tobacco::',0),('rule_tob_use_assess_cqm',1,1,1,'target_interval','year',2),('rule_tob_cess_inter_cqm',1,1,1,'target_database','CUSTOM::act_cat_inter::act_tobacco::YES::ge::1',0),('rule_tob_cess_inter_cqm',1,1,1,'target_interval','year',2),('rule_adult_wt_screen_fu_cqm',1,1,1,'target_database','::form_vitals::weight::::::ge::2',0),('rule_wt_assess_couns_child_cqm',1,1,1,'target_database','::form_vitals::weight::::::ge::1',0),('rule_wt_assess_couns_child_cqm',2,1,1,'target_database','CUSTOM::act_cat_edu::act_wt::YES::ge::1',0),('rule_influenza_ge_50_cqm',1,1,1,'target_interval','flu_season',1),('rule_influenza_ge_50_cqm',1,1,0,'target_database','::immunizations::immunization_id::eq::30::ge::1',0),('rule_influenza_ge_50_cqm',1,1,0,'target_database','::immunizations::immunization_id::eq::31::ge::1',0),('rule_child_immun_stat_cqm',1,1,1,'target_database','::immunizations::::::::ge::1',0),('rule_pneumovacc_ge_65_cqm',1,1,0,'target_database','::immunizations::immunization_id::eq::19::ge::1',0),('rule_pneumovacc_ge_65_cqm',1,1,0,'target_database','::immunizations::immunization_id::eq::20::ge::1',0),('rule_pneumovacc_ge_65_cqm',1,1,0,'target_database','::immunizations::immunization_id::eq::21::ge::1',0),('rule_pneumovacc_ge_65_cqm',1,1,0,'target_database','::immunizations::immunization_id::eq::22::ge::1',0),('rule_dm_eye_cqm',1,1,1,'target_interval','year',1),('rule_dm_eye_cqm',1,1,1,'target_database','CUSTOM::act_cat_exam::act_eye::YES::ge::1',0),('rule_dm_foot_cqm',1,1,1,'target_interval','year',1),('rule_dm_foot_cqm',1,1,1,'target_database','CUSTOM::act_cat_exam::act_foot::YES::ge::1',0),('rule_dm_bp_control_cqm',1,1,1,'target_database','::form_vitals::bps::lt::140::ge::1',0),('rule_dm_bp_control_cqm',1,1,1,'target_database','::form_vitals::bpd::lt::90::ge::1',0),('rule_htn_bp_measure',1,1,1,'target_database','::form_vitals::bps::::::ge::1',0),('rule_htn_bp_measure',1,1,1,'target_database','::form_vitals::bpd::::::ge::1',0),('rule_tob_use_assess',1,1,1,'target_database','LIFESTYLE::tobacco::',0),('rule_tob_cess_inter',1,1,1,'target_database','CUSTOM::act_cat_inter::act_tobacco::YES::ge::1',0),('rule_adult_wt_screen_fu',1,1,1,'target_database','::form_vitals::weight::::::ge::2',0),('rule_wt_assess_couns_child',1,1,1,'target_database','::form_vitals::weight::::::ge::1',0),('rule_wt_assess_couns_child',2,1,1,'target_database','CUSTOM::act_cat_edu::act_wt::YES::ge::1',0),('rule_influenza_ge_50',1,1,1,'target_interval','flu_season',1),('rule_influenza_ge_50',1,1,0,'target_database','::immunizations::immunization_id::eq::30::ge::1',0),('rule_influenza_ge_50',1,1,0,'target_database','::immunizations::immunization_id::eq::31::ge::1',0),('rule_child_immun_stat',1,1,1,'target_database','::immunizations::::::::ge::1',0),('rule_pneumovacc_ge_65',1,1,0,'target_database','::immunizations::immunization_id::eq::19::ge::1',0),('rule_pneumovacc_ge_65',1,1,0,'target_database','::immunizations::immunization_id::eq::20::ge::1',0),('rule_pneumovacc_ge_65',1,1,0,'target_database','::immunizations::immunization_id::eq::21::ge::1',0),('rule_pneumovacc_ge_65',1,1,0,'target_database','::immunizations::immunization_id::eq::22::ge::1',0),('rule_dm_hemo_a1c',1,1,1,'target_interval','month',3),('rule_dm_hemo_a1c',1,1,1,'target_database','CUSTOM::act_cat_measure::act_hemo_a1c::YES::ge::1',0),('rule_dm_urine_alb',1,1,1,'target_interval','year',1),('rule_dm_urine_alb',1,1,1,'target_database','CUSTOM::act_cat_measure::act_urine_alb::YES::ge::1',0),('rule_dm_eye',1,1,1,'target_interval','year',1),('rule_dm_eye',1,1,1,'target_database','CUSTOM::act_cat_exam::act_eye::YES::ge::1',0),('rule_dm_foot',1,1,1,'target_interval','year',1),('rule_dm_foot',1,1,1,'target_database','CUSTOM::act_cat_exam::act_foot::YES::ge::1',0),('rule_cs_mammo',1,1,1,'target_interval','year',1),('rule_cs_mammo',1,1,1,'target_database','CUSTOM::act_cat_measure::act_mammo::YES::ge::1',0),('rule_cs_pap',1,1,1,'target_interval','year',1),('rule_cs_pap',1,1,1,'target_database','CUSTOM::act_cat_exam::act_pap::YES::ge::1',0),('rule_cs_colon',1,1,1,'target_database','CUSTOM::act_cat_assess::act_colon_cancer_screen::YES::ge::1',0),('rule_cs_prostate',1,1,1,'target_database','CUSTOM::act_cat_assess::act_prostate_cancer_screen::YES::ge::1',0),('rule_inr_monitor',1,1,1,'target_interval','week',3),('rule_inr_monitor',1,1,1,'target_proc','INR::::::::ge::1',0),('rule_appt_reminder',1,1,1,'target_appt','',0);
/*!40000 ALTER TABLE `rule_target` ENABLE KEYS */;
UNLOCK TABLES;