Summary
The entity_practices table contains information on the practices reported in RDE and BTE files. The table is updated monthly. It contains details on the practice and its operating specifications. The entity_id field links to the entities, having the same id existing in both tables and acting as a key. The entity_id also acts as a link to the entity_practice_attributes and entity_practice_overrides tables.
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 CreationCREATE 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
`
`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;
`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 Fieldsfield type attributes notes example entity_practices.entity_id int(20) UNSIGNED NOT NULL AUTO_INCREMENT Provided by Pellucid, same as entities table 1219198502 entity_practices.upin_id varchar(10) DEFAULT NULL Unique Physician Identification Number I12345 entity_practices.npi_id varchar(10) DEFAULT NULL Derived from Government registry 1918445361 entity_practices.dea_id varchar(10) DEFAULT NULL DEA Registration Number BS1234567 entity_practices.rde_id varchar(10) DEFAULT NULL 1234567890 entity_practices.tax_id varchar(20) DEFAULT NULL Practice's Employer ID Number 123456789 entity_practices.med_license_id varchar(10) DEFAULT NULL Medical License Number MD12345 entity_practices.practice_name varchar(255) DEFAULT NULL The Name of the Practice Tom's Rhinoplasty entity_practices.address varchar(255) DEFAULT NULL Physical Location 123 Fake St entity_practices.city varchar(255) DEFAULT NULL Physical Location Lake Success entity_practices.state varchar(2) DEFAULT NULL Two-letter state abbreviation NY entity_practices.state_fips varchar(10) DEFAULT NULL Nationally defined 09 entity_practices.zipcode varchar(5) DEFAULT NULL Five Digit Postal Code 11042 entity_practices.county_name varchar(30) DEFAULT NULL Physical Location Nassau entity_practices.county_fips varchar(10) DEFAULT NULL Determined by state 056 entity_practices.phone_number varchar(46) DEFAULT NULL Telephone Number 5165550123 entity_practices.closed_date date DEFAULT NULL Date of closure YYYY-MM-DD 2001-01-24 entity_practices.created timestamp DEFAULT NULL The date and time the row was created 2014-07-18 09:15:36 entity_practices.modified timestamp DEFAULT NULL The date and time the row was last modified 2014-07-18 09:15:36
to current ON UPDATE CURRENT_TIMESTAMP
Fieldsfield type attributes notes example entity_practices.entity_id int(20) UNSIGNED NOT NULL AUTO_INCREMENT Provided by Pellucid, same as entities table 1219198502 entity_practices.upin_id varchar(10) DEFAULT NULL Unique Physician Identification Number I12345 entity_practices.npi_id varchar(10) DEFAULT NULL Derived from Government registry 1918445361 entity_practices.dea_id varchar(10) DEFAULT NULL DEA Registration Number BS1234567 entity_practices.rde_id varchar(10) DEFAULT NULL 1234567890 entity_practices.tax_id varchar(20) DEFAULT NULL Practice's Employer ID Number 123456789 entity_practices.med_license_id varchar(10) DEFAULT NULL Medical License Number MD12345 entity_practices.practice_name varchar(255) DEFAULT NULL The Name of the Practice Tom's Rhinoplasty entity_practices.address varchar(255) DEFAULT NULL Physical Location 123 Fake St entity_practices.city varchar(255) DEFAULT NULL Physical Location Lake Success entity_practices.state varchar(2) DEFAULT NULL Two-letter state abbreviation NY entity_practices.state_fips varchar(10) DEFAULT NULL Nationally defined 09 entity_practices.zipcode varchar(5) DEFAULT NULL Five Digit Postal Code 11042 entity_practices.county_name varchar(30) DEFAULT NULL Physical Location Nassau entity_practices.county_fips varchar(10) DEFAULT NULL Determined by state 056 entity_practices.phone_number varchar(46) DEFAULT NULL Telephone Number 5165550123 entity_practices.closed_date date DEFAULT NULL Date of closure YYYY-MM-DD 2001-01-24 entity_practices.created timestamp DEFAULT NULL The date and time the row was created 2014-07-18 09:15:36 entity_practices.modified timestamp DEFAULT NULL The date and time the row was last modified 2014-07-18 09:15:36
| field | type | attributes | notes | example |
|---|---|---|---|---|
| entity_practices.entity_id | int(20) | UNSIGNED NOT NULL AUTO_INCREMENT | Provided by Pellucid, same as entities table | 1219198502 |
| entity_practices.upin_id | varchar(10) | DEFAULT NULL | Unique Physician Identification Number | I12345 |
| entity_practices.npi_id | varchar(10) | DEFAULT NULL | Derived from Government registry | 1918445361 |
| entity_practices.dea_id | varchar(10) | DEFAULT NULL | DEA Registration Number | BS1234567 |
| entity_practices.rde_id | varchar(10) | DEFAULT NULL | 1234567890 | |
| entity_practices.tax_id | varchar(20) | DEFAULT NULL | Practice's Employer ID Number | 123456789 |
| entity_practices.med_license_id | varchar(10) | DEFAULT NULL | Medical License Number | MD12345 |
| entity_practices.practice_name | varchar(255) | DEFAULT NULL | The Name of the Practice | Tom's Rhinoplasty |
| entity_practices.address | varchar(255) | DEFAULT NULL | Physical Location | 123 Fake St |
| entity_practices.city | varchar(255) | DEFAULT NULL | Physical Location | Lake Success |
| entity_practices.state | varchar(2) | DEFAULT NULL | Two-letter state abbreviation | NY |
| entity_practices.state_fips | varchar(10) | DEFAULT NULL | Nationally defined | 09 |
| entity_practices.zipcode | varchar(5) | DEFAULT NULL | Five Digit Postal Code | 11042 |
| entity_practices.county_name | varchar(30) | DEFAULT NULL | Physical Location | Nassau |
| entity_practices.county_fips | varchar(10) | DEFAULT NULL | Determined by state | 056 |
| entity_practices.phone_number | varchar(46) | DEFAULT NULL | Telephone Number | 5165550123 |
| entity_practices.closed_date | date | DEFAULT NULL | Date of closure YYYY-MM-DD | 2001-01-24 |
| entity_practices.created | timestamp | DEFAULT NULL | The date and time the row was created | 2014-07-18 09:15:36 |
| entity_practices.modified | timestamp | DEFAULT NULL | The date and time the row was last modified | 2014-07-18 09:15:36 |