CDR Rules tables

From OpenEMR Project Wiki
Revision as of 02:57, 9 September 2012 by Bradymiller (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
--
-- 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;