entity_mcos

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.

The unique entity_id links to the entities, entity_mco_attributes, and entity_mco_overrides tables.

Table Creation

CREATE TABLE IF NOT EXISTS `entity_mcos` (

`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 ;

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