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,
`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_id	int(20)	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(10)	DEFAULT NULL	Assigned by data provider, ex: state	0012
name	varchar(255)	DEFAULT NULL		Ted's ACO
aka	varchar(255)	DEFAULT NULL		Ted Jr's ACO
address	varchar(255)	DEFAULT NULL	Physical Location	123 Fake St
city	varchar(255)	DEFAULT NULL		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		11042
county_name	varchar(30)	DEFAULT NULL		Nassau
county_fips	varchar(10)	DEFAULT NULL	Determined by state	056
phone_number	varchar(46)	DEFAULT NULL		5165550123
url	varchar(255)	DEFAULT NULL	url	www.site.com
closed_date	date	DEFAULT NULL	YYYY-MM-DD	2011-01-12
created	datetime		when the row was created	2000-01-01 11:11:11
modified	datetime		when the row was most recently changed	2014-08-01 01:12:12