Versions Compared

Version Old Version 1 New Version Current
Changes made by

Joseph Gulotta

Joseph Gulotta

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Summary

This table is used to track identifying data for Accountable Care Organizations (ACOs) nationally.  
The unique entity_id links to the entities, entity_aco_attributes, and entity_aco_overrides tables.

Table Creation

CREATE TABLE IF NOT EXISTS `entity_acos` (
`entity_id` int(10) NOT NULL DEFAULT '0',
`local_id` varchar(10) DEFAULT NULL,
`name` varchar(255) DEFAULT NULL,
`aka` varchar(255) DEFAULT NULL,
`entity_type` varchar(255) DEFAULT NULL,
`classification` varchar(255) DEFAULT NULL,
`date_start` date DEFAULT NULL,
`counties_served` varchar(255) DEFAULT NULL,
`address` varchar(255) DEFAULT NULL,
`city` varchar(255) DEFAULT NULL,
`state` varchar(2552) 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,
`phonenumber` varchar(46) DEFAULT NULL,
`geo_lat` float DEFAULT NULL,
`geo_long` float DEFAULT NULL,
`website` varchar(255) DEFAULT NULL,
`contact_ipro` varchar(255) DEFAULT NULL,
`contact_cmwf` varchar(255) DEFAULT NULL,
`summary_detail` varchar(255) DEFAULT NULL,
`estimated_members` varchar(255) DEFAULT NULL,
`estimated_physicians` varchar(255) DEFAULT NULL,
`physician_details` varchar(255) DEFAULT NULL,
`closed_date` date DEFAULT NULL,
`created` datetime DEFAULT NULL,
`modified` datetime DEFAULT NULL,
PRIMARY KEY (`entity_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 

Fields

fieldtypeattributesnotesexample
entity_acos.entity_idint(2010)UNSIGNED NOT NULL AUTO_INCREMENTProvided by Pellucid, same as FOREIGN KEY: links to entities table1219198502
entity_acos.local_idvarchar(10)DEFAULT NULLAssigned by data provider, ex: state 0012
entity_acos.namevarchar(255)DEFAULT NULL Ted's ACO
entity_acos.akavarchar(255)DEFAULT NULL Ted Jr's ACO
entity_acos.entity_typevarchar(255)DEFAULT NULL Medicare Shared Savings
entity_acos.classificationvarchar(255)DEFAULT NULLDetails on the Operating status of the entityPartnership of Hospitals
entity_acos.date_startdate YYYY-MM-DD2014-08-04
entity_acos.counties_servedvarchar(255)DEFAULT NULLList of counties that are part of the ACONassau
entity_acos.addressvarchar(255)DEFAULT NULLPhysical Location123 Fake St
entity_acos.cityvarchar(255)DEFAULT NULL Lake Success
entity_acos.statevarchar(2)DEFAULT NULLTwo-letter state abbreviationNY
entity_acos.state_fipsvarchar(10)DEFAULT NULL 09
entity_acos.zipcodevarchar(5)DEFAULT NULL 11042
entity_acos.county_namevarchar(30)DEFAULT NULL Nassau
entity_acos.county_fipsvarchar(10)DEFAULT NULL 056
entity_acos.phone_numbervarchar(46)DEFAULT NULL 5165550123
entity_acos.geo_latfloatDEFAULT NULLlatitude location-45.00032
entity_acos.geo_longfloatDEFAULT NULLlongitude location101.12345
entity_acos.websitevarchar(255)DEFAULT NULLurlwww.site.com
entity_acos.contact_iprovarchar(255)DEFAULT NULLcontact through IPRO

 

jim@ipro.us

entity_acos.contact_cmwfvarchar(255)DEFAULT NULLcontact through Common Wealth Funds jim@fake.org
entity_acos.summary_detailvarchar(255)DEFAULT NULL  a description of who runs the ACO and what locations it servesCEO James Bond is the contact
entity_acos.estimated_membersvarchar(255)DEFAULT NULLapproximate number of members600
entity_acos.estimated_physiciansvarchar(255)DEFAULT NULLapproximate number of physicians6
entity_acos.physician_detailsvarchar(255)DEFAULT NULL  indicates the number of primary care physicians and specialistsPCPs = 12; Specialists = 4
entity_acos.closed_datedateDEFAULT NULL 2011-01-12
entity_acos.createddatetime when the row was created2000-01-01 11:11:11
entity_acos.modifieddatetime when the row was most recently changed2014-08-01 01:12:12

...