***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

field	type	attributes	notes	example
measure_sets.measure_set_id	int(11)	NOT NULL AUTO_INCREMENT	Provided by Pellucid	00000000001
measure_sets.name	varchar(255)	DEFAULT NULL	Provides the name of the set	'Outpatient Surgery'
measure_sets.measure_id	int(11)	DEFAULT NULL	Provided by Pellucid, links to primary key of measures table	123456
measure_sets.visualization	varchar(255)	DEFAULT NULL	Details of the visualizations	tastey pie chart?
measure_sets.measure_alias	varchar(255)	DEFAULT NULL	Other names for the measure	'Surgery: Outpatient'
measure_sets.description_alias	text	DEFAULT NULL
measure_sets.rationale_alias	text	DEFAULT NULL
measure_sets.sort_order	int(11)	DEFAULT NULL		01234567890
measure_sets.level	int(11)	DEFAULT 0		0
measure_sets.suppress_on_denominator_less_than	decimal(12,2)	DEFAULT NULL	minimum denominator before suppression	30.00
measure_sets.suppress_on_denominator_null	tinyint(1)	DEFAULT 0	suppresses row if denominator is null 1=Y,0=N	0
measure_sets.suppress_on_numerator_less_than	decimal(12,2)	DEFAULT NULL	minimum numerator before suppression	30.00
measure_sets.suppress_on_numerator_null	tinyint(1)	DEFAULT 0	suppresses row if numerator is null 1=Y,0=N	0
measure_sets.suppress_on_value_less_than	decimal(12,2)	DEFAULT NULL	minimum value before suppression	123456.78
measure_sets.suppress_on_value_null	tinyint(1)	DEFAULT 0	suppresses row if value is null 1=Y,0=N	0
measure_sets.suppression_list	text	DEFAULT NULL
measure_sets.show_tooltip	tinyint(1)	DEFAULT 1	1=Y,0=N	1
measure_sets.show_rate	tinyint(1)	DEFAULT 1	1=Y,0=N	1
measure_sets.show_cases	tinyint(1)	DEFAULT 1	1=Y,0=N	1
measure_sets.numerator_label	varchar(64)	DEFAULT	Details on the numerator	'patients'
measure_sets.denominator_label	varchar(64)	DEFAULT 'patients'	Details on the denominator	'patients'
measure_sets.separator_label	varchar(64)	DEFAULT 'of'	Details on the numerator/denominator relationship	'of'
measure_sets.rate_label	varchar(64)	DEFAULT 'Risk-adjusted Rate'	Details on rate	'Risk-adjusted Rate'
measure_sets.unit_label	varchar(64)	DEFAULT '<unit>'	Details on the unit of measure	'percent'
measure_sets.cases_label	varchar(64)	DEFAULT ""	Details on cases	'Risk-adjusted Rate'
measure_sets.display	tinyint(1)	DEFAULT 1		1
measure_sets.view_template	varchar(255)	DEFAULT 'default'
measure_sets.created	timestamp	NOT NULL DEFAULT '0000-00-00 00:00:00'	the date and time the row was created	'2010-05-18 09:15:36'
measure_sets.modified	timestamp	NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP	the date and time the row was last modified	'2010-05-18 09:15:36'

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

Browser not supported