entity_physicians

Summary

The entity_physicians table contains information on the physicians reported in CMS Physician Compare. The table is updated Quarterly. It contains details on the physician and its operating specifications. The unique  entity_id field links to the entities table and is used as a link to the entity_physicians_attributes and entity_physicians_overrides tables

Physician Billing addresses and locations are stored in the entity_physician_locations table, as one physician can have multiple practice locations

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_physicians` (
`entity_id` int(10) NOT NULL,
`npi_id` int(25) DEFAULT NULL,
`pac_id` bigint(25) DEFAULT NULL,
`enrollment_id` varchar(25) DEFAULT NULL,
`last_name` varchar(255) DEFAULT NULL,
`first_name` varchar(255) DEFAULT NULL,
`middle_name` varchar(255) DEFAULT NULL,
`suffix` varchar(255) DEFAULT NULL,
`gender` varchar(25) DEFAULT NULL,
`credential` varchar(255) DEFAULT NULL,
`med_school_name` varchar(255) DEFAULT NULL,
`grad_year` int(4) DEFAULT NULL,
`org_legal_name` varchar(255) DEFAULT NULL,
`org_dba_name` varchar(255) DEFAULT NULL,
`group_pac_id` varchar(25) DEFAULT NULL,
`group_members` int(25) DEFAULT NULL,
`accepts_MCR_assignment` char(1) DEFAULT NULL,
`eRx` varchar(1) DEFAULT NULL,
`pqrs` varchar(1) DEFAULT NULL,
`ehr` varchar(1) DEFAULT NULL,
`pqrs_maint_cert_incentive` varchar(1) DEFAULT NULL,
`mh` varchar(1) 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
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `entity_physicians`
--
ALTER TABLE `entity_physicians`
ADD PRIMARY KEY (`entity_id`), ADD KEY `NPI` (`npi_id`), ADD KEY `PAC_ID` (`pac_id`);

Field Information

`entity_id` the identifying entity number. Same as entity_id in the entities table and serves as a link

`npi_id` national provider number derived from https://nppes.cms.hhs.gov/NPPES/NPIRegistryHome.do
`pac_id` localized identifier for this data set. PACOS system ID
`dea_id` identification number provided by the DEA
`enrollment_id` outside identifier used for MCR enrollment
`last_name`
`first_name`
`middle_name`
`suffix`
`gender`
`credential` Documented degree achieved
`med_school_name` Name of medical school attended
`grad_year` year of medical school graduation
`org_legal_name` Primary Organization Legal Business Name
`org_dba_name`
`group_pac_id` PAC_id associated with the entire business group or practice
`group_members` Number of practicing members in the group
`accepts_MCR_assignment` Does the physician accept Medicare assignments? 1=Yes, 0=No
`eRx` Does the physician participate in electronic prescriptions? 1=Yes, 0=No
`pqrs` Does the physician participate in Physician Quality Reporting System? 1=Yes, 0=No
`ehr` Does the physician use electronic health records? 1=Yes, 0=No
`pqrs_maint_cert_incentive` Did they receive incentive for PQRS certification maintenance? 1=Yes, 0=No
`mh`
`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