measure_sets

***MEASURE_SETS tables are bespoke for particular apps and not part of the pellucid master***

Summary

Measure_sets stores information on groups of measures, referencing the measures table. This table also stores information regarding which measures comprise a measure set, the details of a measure set's data suppression, labels for the numerator/denominator/rate/unit, and information referencing whether or not rates, cases, and tooltips will be visible.

`measure_set_id` is unique to each measure set, but `measure_id` can be used across multiple measure_sets. By definition, a measure set will generally contain multiple measure_ids.

This is a local table, as it is local to the specific website. This table differs from the pellucid measure_sets table, as it is a local override for measures control. It contains localized suppression and display information specific to the site. 

Table Creation:

DROP TABLE IF EXISTS `measure_sets`; 
CREATE TABLE measure_sets ( 
`measure_set_id` int(11) NOT NULL auto_increment, 
`name` varchar(255) default NULL, 
`measure_id` INT(11), 
`visualization` varchar(255) default null, 
`measure_alias` varchar(255) default null, 
`description_alias` text default null, 
`rationale_alias` text default null, 
`sort_order` int(11), 
`level` int(11) default 0, 
`suppress_on_denominator_less_than` decimal(12,2) default NULL, 
`suppress_on_denominator_null` tinyint(1) default 0, 
`suppress_on_numerator_less_than` decimal(12,2) default NULL, 
`suppress_on_numerator_null` tinyint(1) default 0, 
`suppress_on_value_less_than` decimal(12,2) default NULL, 
`suppress_on_value_null` tinyint(1) default 0, 
`suppression_list` text default NULL,
`show_tooltip` tinyint(1) default 1, 
`show_rate` tinyint(1) default 1, 
`show_cases` tinyint(1) default 1, 
`numerator_label` varchar(64) default , 
`denominator_label` varchar(64) default 'patients', 
`separator_label` varchar(64) default 'of', 
`rate_label` varchar(64) default 'Risk-adjusted rate', 
`unit_label` varchar(64) default '<unit>', 
`cases_label` varchar(64) default "", 
`display` tinyint(1) default 1,
`view_template` varchar(255) default 'default',
`created` datetime NOT NULL default '0000-00-00 00:00:00', 
`modified` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP, 
PRIMARY KEY (`measure_set_id`), 
CONSTRAINT `measure_sets_ibfk_1` FOREIGN KEY (`measure_id`) REFERENCES `measures` (`measure_id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ; 

Field Information:

`measure_set_id` primary key, the ID that is associated with the measure set 
`name` 
`measure_id` references the ref_measures table 
`visualization` contains information regarding details of the visualizations for the measure set 
`measure_alias` other names the set may be referred to as 
`description_alias` 
`rationale_alias` 
`sort_order` 
`level` 
`suppress_on_denominator_less_than` sets the minimum amount of cases for the measure not to be suppressed 
`suppress_on_denominator_null` suppresses the measure if the denominator is null (1=Yes, 0=No) 
`suppress_on_numerator_less_than` sets the minimum amount of cases for the measure not to be suppressed 
`suppress_on_numerator_null` suppresses the measure if the numerator is null (1=Yes, 0=No) 
`suppress_on_value_less_than` sets the minimum value for the measure not to be suppressed 
`suppress_on_value_null` suppresses the measure if the value is null (1=Yes, 0=No) 
`suppression_list` provides details on the suppressions 
`show_tooltip` (1=Yes, 0=No) 
`show_rate` (1=Yes, 0=No) 
`show_cases` (1=Yes, 0=No) 
`numerator_label` text details associated with the numerator to provide further explanation (example: 'patients') 
`denominator_label` text details associated with the denominator to provide further explanation (example: 'patients') 
`seperator_label` text details to explain the relationship between the numerator and denominator (example: 'of') 
`rate_label` text details to provide detail regarding the measure's rate (example: 'Risk-adjusted rate) 
`unit_label` text details providing details about the measure's unit (example: percent) 
`cases_label` 
`display` 
`view_template` 
`created` datetime in 'YYYY-MM-DD HH:MM:SS' Format. Default is '0000-00-00 00:00:00' 
`modified` timestamp in 'YYYY-MM-DD HH:MM:SS' Format. Default is '0000-00-00 00:00:00'. Modified on UPDATE CURRENT_TIMESTAMP

Fields

PRIMARY KEY (`measure_set_id`) 
CONSTRAINT `measure_sets_ibfk_1` 
FOREIGN KEY (`measure_id`)