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
`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`);
`
entity_id` the identifying entity number. Same as entity_id in the entities table and serves as a link`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
Fieldsfield type attributes notes example entity_physicians.entity_id bigint(10) UNSIGNED NOT NULL AUTO_INCREMENT Provided by Pellucid, FOREIGN KEY: links to entities table 1219198502 entity_physicians.npi_id varchar(25) Default NULL Derived from Government registry 1918445361 entity_physicians.pac_id varchar(25) Default NULL PACOS ID number BS1234567 entity_physicians.enrollment_id varchar(10) Default NULL 1234567890 entity_physicians.last_name varchar(255) Default NULL Physician's Last Name Smith entity_physicians.first_name varchar(255) Default NULL Physician's First Name John entity_physicians.middle_name varchar(255) Default NULL Physician's Middle Name David entity_physicians.suffix varchar(255) Default NULL Suffix of Physician's Name Sr. entity_physicians.gender varchar(25) Default NULL Gender M entity_physicians.credential varchar(255) Default NULL Degree Received MD entity_physicians.med_school_name varchar(255) Default NULL Name of Medical School Attended Doctor Med School entity_physicians.grad_year INT(4) Default NULL Year Graduated 2004 entity_physicians.org_legal_name varchar(255) Default NULL Name of the Legal Organization Smith Medical Doctors entity_physicians.org_dba_name varchar(255) Default NULL Alternate Name Smith's Medical Doctors entity_physicians.group_pac_id varchar(25) Default NULL Group's PAC ID 12345678 entity_physicians.group_members int(25) Default NULL Number of Members 27 entity_physicians.accepts_MCR_assignment varchar(1) Default NULL Does the physician accept Medicare assignments? 1=Yes, 0=No 1 entity_physicians.eRx varchar(1) Default NULL Does the physician participate in electronic prescriptions? 1=Yes, 0=No 1 entity_physicians.pqrs varchar(1) Default NULL Does the physician participate in Physician Quality Reporting System? 1=Yes, 0=No 0 entity_physicians.ehr varchar(1) Default NULL Does the physician use electronic health records? 1=Yes, 0=No 1 entity_physicians.pqrs_maint_cert_incentive varchar(1) Default NULL Did they receive incentive for PQRS certification maintenance? 1=Yes, 0=No 1 entity_physicians.mh varchar(1) Default NULL 1 entity_physicians.created timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' The date and time the row was created 2014-07-07 14:51:43 entity_physicians.modified timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP The date and time the row was last modified 2014-07-07 14:51:43
field | type | attributes | notes | example |
---|---|---|---|---|
entity_physicians.entity_id | bigint(10) | UNSIGNED NOT NULL AUTO_INCREMENT | Provided by Pellucid, FOREIGN KEY: links to entities table | 1219198502 |
entity_physicians.npi_id | varchar(25) | Default NULL | Derived from Government registry | 1918445361 |
entity_physicians.pac_id | varchar(25) | Default NULL | PACOS ID number | BS1234567 |
entity_physicians.enrollment_id | varchar(10) | Default NULL | 1234567890 | |
entity_physicians.last_name | varchar(255) | Default NULL | Physician's Last Name | Smith |
entity_physicians.first_name | varchar(255) | Default NULL | Physician's First Name | John |
entity_physicians.middle_name | varchar(255) | Default NULL | Physician's Middle Name | David |
entity_physicians.suffix | varchar(255) | Default NULL | Suffix of Physician's Name | Sr. |
entity_physicians.gender | varchar(25) | Default NULL | Gender | M |
entity_physicians.credential | varchar(255) | Default NULL | Degree Received | MD |
entity_physicians.med_school_name | varchar(255) | Default NULL | Name of Medical School Attended | Doctor Med School |
entity_physicians.grad_year | INT(4) | Default NULL | Year Graduated | 2004 |
entity_physicians.org_legal_name | varchar(255) | Default NULL | Name of the Legal Organization | Smith Medical Doctors |
entity_physicians.org_dba_name | varchar(255) | Default NULL | Alternate Name | Smith's Medical Doctors |
entity_physicians.group_pac_id | varchar(25) | Default NULL | Group's PAC ID | 12345678 |
entity_physicians.group_members | int(25) | Default NULL | Number of Members | 27 |
entity_physicians.accepts_MCR_assignment | varchar(1) | Default NULL | Does the physician accept Medicare assignments? 1=Yes, 0=No | 1 |
entity_physicians.eRx | varchar(1) | Default NULL | Does the physician participate in electronic prescriptions? 1=Yes, 0=No | 1 |
entity_physicians.pqrs | varchar(1) | Default NULL | Does the physician participate in Physician Quality Reporting System? 1=Yes, 0=No | 0 |
entity_physicians.ehr | varchar(1) | Default NULL | Does the physician use electronic health records? 1=Yes, 0=No | 1 |
entity_physicians.pqrs_maint_cert_incentive | varchar(1) | Default NULL | Did they receive incentive for PQRS certification maintenance? 1=Yes, 0=No | 1 |
entity_physicians.mh | varchar(1) | Default NULL | 1 | |
entity_physicians.created | timestamp | NOT NULL DEFAULT '0000-00-00 00:00:00' | The date and time the row was created | 2014-07-07 14:51:43 |
entity_physicians.modified | timestamp | NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP | The date and time the row was last modified | 2014-07-07 14:51:43 |