...
`entity_id` int(10) NOT NULL AUTO_INCREMENT,
`mpn_id` varchar(7) DEFAULT NULL,
`npi_id` int(12) DEFAULT NULL,
`local_id` varchar(12) DEFAULT NULL,
`payer_type` varchar(255) DEFAULT NULL,
`name` varchar(255) DEFAULT NULL,
`aka` varchar(255) DEFAULT NULL,
`address` varchar(255) DEFAULT NULL,
`city` varchar(255) DEFAULT NULL,
`state` varchar(2) DEFAULT NULL,
`state_fips` varchar(2) DEFAULT NULL,
`zipcode` varchar(10) DEFAULT NULL,
`county_name` varchar(255) DEFAULT NULL,
`county_fips` varchar(3) DEFAULT NULL,
`phone_number` varchar(25) DEFAULT NULL,
`url` varchar(255) DEFAULT NULL,
`closed_date` date DEFAULT NULL,
`created` datetime DEFAULT NULL,
`modified` datetime DEFAULT NULL,
PRIMARY KEY (`entity_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=214813 ;
...
field | type | attributes | notes | example |
|---|---|---|---|---|
| entity_id | int(10) | UNSIGNED NOT NULL AUTO_INCREMENT | Provided by Pellucid, same as entities table | 1219198502 |
| mpn_id | varchar(7) | DEFAULT NULL | Medicare Provider Number | 025236 |
| npi_id | int(12) | DEFAULT NULL | National Provider Identifier | 1234567891 |
| local_id | varchar(12) | DEFAULT NULL | Assigned by data provider, ex: state | 0012 |
| payer_type | varchar(255) | DEFAULT NULL | Assigned by the provider: CCO, PPO, HMO, etc | PPO |
| name | varchar(255) | DEFAULT NULL | MCO Name | Ted's ACO |
| aka | varchar(255) | DEFAULT NULL | Alternative MCO Name | Ted Jr's ACO |
| 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(2) | DEFAULT NULL | Nationally defined | 09 |
| zipcode | varchar(10) | DEFAULT NULL | 5 Digit Postal Code | 11042 |
| county_name | varchar(255) | DEFAULT NULL | Physical Location | Nassau |
| county_fips | varchar(3) | DEFAULT NULL | Determined by state | 056 |
| phone_number | varchar(25) | DEFAULT NULL | Telephone Number | 5165550123 |
| url | varchar(255) | DEFAULT NULL | Website address | www.site.com |
| closed_date | date | DEFAULT NULL | YYYY-MM-DD | 2011-01-12 |
| created | datetime | DEFAULT NULL | When the row was created | 2000-01-01 11:11:11 |
| modified | datetime | DEFAULT NULL | When the row was most recently changed | 2014-08-01 01:12:12 |