entity_physician_locations

This table tracks all possible locations a physician bills from.  It is associated with CMS Physician Compare Data.  Essentially, they duplicate a physician for each location it bills from.  This system encourages less duplication by simply linking an entity_id to all of its addresses in a lookup table.

Table Structure

CREATE TABLE IF NOT EXISTS `entity_physician_locations` (
`location_id` int(20) NOT NULL,
`entity_id` int(10) DEFAULT NULL,
`address` varchar(255) DEFAULT NULL,
`address_line2` varchar(255) DEFAULT NULL,
`city` varchar(255) DEFAULT NULL,
`state` varchar(25) DEFAULT NULL,
`state_fips` varchar(2) DEFAULT NULL,
`zipcode` varchar(25) DEFAULT NULL,
`county_name` varchar(64) DEFAULT NULL,
`county_fips` varchar(3) DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=2026831 DEFAULT CHARSET=latin1;

Field Information

`location_id` an automatically generated id number that is unique for each entity and address combination
`entity_id` outside link to the entities table, identifies the physician associated with the row
`address` location information
`address_line2` secondary information on location, if any
`city`
`state`
`state_fips` 2 digit FIPS code generated nationally
`county_name` name of the county where the physician address is located
`county_fips` 3 digit FIPS code generated nationally

Fields