Entity_home_healths

Summary

Separate entities for home health institutions. Originally, this table was intended to track homes health facilities for NY state, but value generation was expanded to include data from the CMS Home Health Compare Data set, which includes national data.  An entity_id is generated, which is unique to the entities table, and can also be linked to entity_home_health_attributes and entity_home_health_overrides.

Table Creation

CREATE TABLE IF NOT EXISTS `entity_home_healths` ( 
`entity_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, 
`mpn_id` varchar(15) DEFAULT NULL, 
`local_id` varchar(15) DEFAULT NULL, 
`local_id2` varchar(15) DEFAULT NULL, 
`name` varchar(255) DEFAULT NULL, 
`aka` varchar(255) DEFAULT NULL, 
`address` varchar(255) DEFAULT NULL, 
`city` varchar(255) DEFAULT NULL, 
`state` enum ('AK','AL','AR','AZ','CA','CO','CT','DC','DE','FL','GA','GU','HI','IA','ID','IL', 
'IN','KS','KY','LA','MA','MD','ME','MI','MN','MO','MP','MS','MT','NC','ND','NE','NH','NJ','NM', 
'NV','NY','OH','OK','OR','PA','PR','RI','SC','SD','TN','TX','US','UT','VA','VI','VT','WA','WI','WV','WY') DEFAULT NULL, 
`state_fips` varchar(10) DEFAULT NULL, 
`zipcode` varchar(5) DEFAULT NULL, 
`county_name` varchar(30) DEFAULT NULL, 
`county_fips` varchar(10) DEFAULT NULL, 
`region` varchar(25) DEFAULT , 
`phone_number` varchar(46) DEFAULT NULL, 
`fax_number` varchar(25) DEFAULT NULL, 
`url` varchar(200) DEFAULT NULL, 
`entity_type` varchar(25) DEFAULT NULL, 
`service_id` varchar(255) DEFAULT NULL, 
`ipro_ownership_group` varchar(100) DEFAULT NULL, 
`ownership` varchar(100) DEFAULT NULL, 
`operator_address` varchar(255) DEFAULT NULL, 
`operator_city` varchar(255) DEFAULT NULL, 
`operator_state` enum ('AK','AL','AR','AZ','CA','CO','CT','DC','DE','FL','GA','GU','HI','IA','ID','IL','IN', 
'KS','KY','LA','MA','MD','ME','MI','MN','MO','MP','MS','MT','NC','ND','NE','NH','NJ','NM','NV','NY','OH', 
'OK','OR','PA','PR','RI','SC','SD','TN','TX','US','UT','VA','VI','VT','WA','WI','WV','WY') DEFAULT NULL, 
`operator_zipcode` varchar(5) DEFAULT NULL, 
`specialties` varchar(50) DEFAULT NULL, 
`aa_br` smallint(6) NOT NULL DEFAULT '0', 
`aa_cb` tinyint(4) DEFAULT '0', 
`aa_sn` tinyint(4) DEFAULT '0', 
`aa_da` varchar(25) DEFAULT NULL, 
`opened_date` date NOT NULL DEFAULT '0000-00-00', 
`closed_date` date DEFAULT NULL, 
`created` timestamp 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 (`entity_id`), 
UNIQUE KEY `hh_pfi_idx` (`entity_type`,`local_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=14265 ; 
ALTER TABLE `entity_home_healths` 
ADD CONSTRAINT `entity_home_healths_ibfk_1` FOREIGN KEY (`entity_id`) REFERENCES `entities` (`entity_id`) ON DELETE CASCADE;

Field Information

`entity_id` the unique ID that is created by IPRO and links this table to the entities table 
`mpn_id` the medicare provider number 
`local_id` other identifying number associated with the entity. In this case it is generally the PFI number 
`local_id2` secondary local id. Often is the opcert number 
`name` publicly recognized name for the home health 
`aka` alias for the entity 
`address` 
`city` 
`state` 
`state_fips` the federal fips code associated with the state 
`zipcode` 
`county_name` 
`county_fips` the fips code assigned to the county. Generally 3-digit 
`region` the region that this entity resides in. This field may be removed later on. 
`phone_number` 
`fax_number` 
`url` website for the entity 
`entity_type` abbreviated classification for the entity 
`service_id` extended entity_type classification 
`ipro_ownership_group` details regarding the nature of the entity (for profit/government owned, etc) 
`ownership` describes who owns the entity 
`operator_address` 
`operator_city` 
`operator_state` 
`operator_zipcode` 
`specialties` list of known specialties for the home health entity 
`aa_br` branches 
`aa_cb` is combination? 0 is no, 1 is yes 
`aa_sn` is special needs? 0 is no, 1 is yes 
`aa_da` deeming agency: Information on the agency that deemed the entity 
`opened_date` 
`closed_date` 
`created` 
`modified`

Fields

Notes