Summary
This table is used to track identifying data for Managed Care Organizations (MCOs) nationally. The data present in this table is currently limited to Kentucky and Maryland MCOs.
Table Creation
CREATE TABLE IF NOT EXISTS `entity_mcos` (
...
`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 ;
Fields
field | type | attributes | notes | example |
|---|---|---|---|---|
| entity_mcos.entity_id | int(10) | UNSIGNED NOT NULL AUTO_INCREMENT | Provided by Pellucid, FOREIGN KEY: links to 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 |