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
`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_id int(20) UNSIGNED NOT NULL AUTO_INCREMENT Provided by Pellucid, same as entities table 1219198502 upin_id varchar(10) DEFAULT NULL Unique Physician Identification Number I12345 npi_id varchar(10) DEFAULT NULL Derived from Government registry 1918445361 dea_id varchar(10) DEFAULT NULL DEA Registration Number BS1234567 rde_id varchar(10) DEFAULT NULL 1234567890 tax_id varchar(20) DEFAULT NULL Practice's Employer ID Number 123456789 med_license_id varchar(10) DEFAULT NULL Medical License Number MD12345 practice_name varchar(255) DEFAULT NULL The Name of the Practice Tom's Rhinoplasty address varchar(255) DEFAULT NULL Physical Location 123 Fake St city varchar(255) DEFAULT NULL Physical Location Lake Success state varchar(2) DEFAULT NULL Two-letter state abbreviation NY state_fips varchar(10) DEFAULT NULL Nationally defined 09 zipcode varchar(5) DEFAULT NULL Five Digit Postal Code 11042 county_name varchar(30) DEFAULT NULL Physical Location Nassau county_fips varchar(10) DEFAULT NULL Determined by state 056 phone_number varchar(46) DEFAULT NULL Telephone Number 5165550123 closed_date date DEFAULT NULL Date of closure YYYY-MM-DD 2001-01-24 created timestamp DEFAULT NULL The date and time the row was created 2014-07-18 09:15:36 modified timestamp DEFAULT NULL The date and time the row was last modified 2014-07-18 09:15:36
`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_id int(20) UNSIGNED NOT NULL AUTO_INCREMENT Provided by Pellucid, same as entities table 1219198502 upin_id varchar(10) DEFAULT NULL Unique Physician Identification Number I12345 npi_id varchar(10) DEFAULT NULL Derived from Government registry 1918445361 dea_id varchar(10) DEFAULT NULL DEA Registration Number BS1234567 rde_id varchar(10) DEFAULT NULL 1234567890 tax_id varchar(20) DEFAULT NULL Practice's Employer ID Number 123456789 med_license_id varchar(10) DEFAULT NULL Medical License Number MD12345 practice_name varchar(255) DEFAULT NULL The Name of the Practice Tom's Rhinoplasty address varchar(255) DEFAULT NULL Physical Location 123 Fake St city varchar(255) DEFAULT NULL Physical Location Lake Success state varchar(2) DEFAULT NULL Two-letter state abbreviation NY state_fips varchar(10) DEFAULT NULL Nationally defined 09 zipcode varchar(5) DEFAULT NULL Five Digit Postal Code 11042 county_name varchar(30) DEFAULT NULL Physical Location Nassau county_fips varchar(10) DEFAULT NULL Determined by state 056 phone_number varchar(46) DEFAULT NULL Telephone Number 5165550123 closed_date date DEFAULT NULL Date of closure YYYY-MM-DD 2001-01-24 created timestamp DEFAULT NULL The date and time the row was created 2014-07-18 09:15:36 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_id | int(20) | UNSIGNED NOT NULL AUTO_INCREMENT | Provided by Pellucid, same as entities table | 1219198502 | |
| upin_id | varchar(10) | DEFAULT NULL | Unique Physician Identification Number | I12345 | |
| npi_id | varchar(10) | DEFAULT NULL | Derived from Government registry | 1918445361 | |
| dea_id | varchar(10) | DEFAULT NULL | DEA Registration Number | BS1234567 | |
| rde_id | varchar(10) | DEFAULT NULL | 1234567890 | ||
| tax_id | varchar(20) | DEFAULT NULL | Practice's Employer ID Number | 123456789 | |
| med_license_id | varchar(10) | DEFAULT NULL | Medical License Number | MD12345 | |
| practice_name | varchar(255) | DEFAULT NULL | The Name of the Practice | Tom's Rhinoplasty | |
| address | varchar(255) | DEFAULT NULL | Physical Location | 123 Fake St | |
| city | varchar(255) | DEFAULT NULL | Physical Location | Lake Success | |
| state | varchar(2) | DEFAULT NULL | Two-letter state abbreviation | NY | |
| state_fips | varchar(10) | DEFAULT NULL | Nationally defined | 09 | |
| zipcode | varchar(5) | DEFAULT NULL | Five Digit Postal Code | 11042 | |
| county_name | varchar(30) | DEFAULT NULL | Physical Location | Nassau | |
| county_fips | varchar(10) | DEFAULT NULL | Determined by state | 056 | |
| phone_number | varchar(46) | DEFAULT NULL | Telephone Number | 5165550123 | |
| closed_date | date | DEFAULT NULL | Date of closure YYYY-MM-DD | 2001-01-24 | |
| created | timestamp | DEFAULT NULL | The date and time the row was created | 2014-07-18 09:15:36 | |
| modified | timestamp | DEFAULT NULL | The date and time the row was last modified | 2014-07-18 09:15:36 |