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.

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