entity_practices

 The practice_id field in entity_physicians is used to link physicians to their entity_practice, similar to the link between entity_hospitals and entity_systems.

EDIT: The entity_physicians table is no longer updated monthly from RDE and BTE files.  Instead we are looking to use quarterly CMS physicians Database updates to edit this table in the future

Table Creation

CREATE TABLE IF NOT EXISTS `entity_practices` (
`entity_id` int(20) NOT NULL,
`upin_id` varchar(10) DEFAULT NULL,
`npi_id` varchar(10) DEFAULT NULL,
`dea_id` varchar(10) DEFAULT NULL,
`rde_id` varchar(10) DEFAULT NULL,
`tax_id` varchar(20) DEFAULT NULL,
`med_license_id` varchar(10) DEFAULT NULL,
`practice_name` varchar(255) DEFAULT NULL,
`address` varchar(255) DEFAULT NULL,
`city` varchar(255) DEFAULT NULL,
`state` varchar(2) 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,
`phone_number` varchar(46) DEFAULT NULL,
`closed_date` date DEFAULT NULL,
`created` timestamp NULL DEFAULT NULL,
`modified` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 

Field Information

`entity_id` the identifying entity number. Same as entity_id in the entities  and serves as a link
`upin_id` alternative to the npi_id. Given as an identifier
`npi_id` national provider number derived from https://nppes.cms.hhs.gov/NPPES/NPIRegistryHome.do
`dea_id` identification number provided by the DEA
`rde_id` identifying RDE number for the administrative physician for the
practice. Links to [[entity_physicians]] table
`tax_id` the tax identification number associated with this practice
`med_license_id` medical license identification number
`practice_name`
`address` physical location of the establishment
`city`
`state` the two-letter state abbreviation
('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 is null and national entities have a state code of 'US'
`state_fips` FIPS state code, taken from AHA Annual Survey
`zipcode`
`county_name`
`county_fips` FIPS county code, taken from AHA Annual Survey
`phone_number`
`closed_date` date the physician record was closed in YYYY-MM-DD format
`created` date and time the row was created in YYYY-MM-DD HH:MM:SS format
`modified` date and time the row was modified in YYYY-MM-DD HH:MM:SS format. Can be set
to current ON UPDATE CURRENT_TIMESTAMP  

Fields