Page Comparison

2015-09-24

Added a sig_var_test field to the measures table, meant to track what kind of significance tests are applied to the measure:

ALTER TABLE `measures` ADD `sig_var_test` VARCHAR(64) NULL DEFAULT NULL AFTER `evidence`;

 2015-04-24:

changed aa_br in entity_home_healths to allow for nulls

2015-04-23:

ALTER TABLE `entity_mcos` ADD `payer_type` VARCHAR(255) NULL AFTER `local_id`;
(added payer_type field to allow for NY data to be stored and a crosswalk to be created)
Currently, local_id or provider ID is used in 3 places, only with different payer types
This allows us to link entity_id to the combination of the provider ID and the payer_type fields

ALTER TABLE `entity_mco_attributes` ADD `source` VARCHAR(64) NULL ;
(adds a source to the attributes for MCOS)
This table was previously unused but is populated now

Added measure_type 'mixed' to the possible available measure_types

2015-03-30:
created entity_dialysis_facilities table in pellucid to track national dialysis facilities for ESRD patients

CREATE TABLE IF NOT EXISTS `entity_dialysis_facilities` (
`entity_id` int(10) NOT NULL,
`mpn_id` varchar(7) DEFAULT NULL,
`local_id` varchar(20) DEFAULT NULL,
`network_id` varchar(2) DEFAULT NULL,
`name` varchar(255) DEFAULT NULL,
`aka` varchar(255) DEFAULT NULL,
`address` varchar(255) DEFAULT NULL,
`city` varchar(64) DEFAULT NULL,
`state` varchar(2) DEFAULT NULL,
`state_fips` varchar(2) DEFAULT NULL,
`zipcode` varchar(10) DEFAULT NULL,
`county_name` varchar(64) DEFAULT NULL,
`county_fips` varchar(3) DEFAULT NULL,
`phone_number` varchar(20) DEFAULT NULL,
`ownership` varchar(64) DEFAULT NULL,
`chain` tinyint(1) DEFAULT NULL,
`chain_name` varchar(255) DEFAULT NULL,
`certified_date` date DEFAULT NULL,
`closed_date` date DEFAULT NULL,
`created` datetime DEFAULT NULL,
`modified` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;