entity_systems

Summary

The entity_systems table contains information about systems of entities. This is a separate table because systems are not confined to specific geographies, and are neither ascs/hospitals nor are they calculated.

A row in this table consists of an entity_id that links to the entities table and an aha_sys_id which is a unique number that denotes the specific system and may be assigned to multiple hospitals. All the hospitals assigned to that aha_sys_id are part of the same system in entity_systems.  This system id is assigned by the American Hospital Association.

 The entity_id used by entity_systems also connects to entity_system_attributes and entity_system_overrides

Table Creation

CREATE TABLE IF NOT EXISTS `entity_systems` ( 
`entity_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, 
`aha_sys_id` varchar(4) DEFAULT NULL, 
`local_id` varchar(15) DEFAULT NULL, 
`name` varchar(255) DEFAULT NULL, 
`aka` varchar(255) DEFAULT NULL, 
`state` enum ('AK','AL','AR','AZ','CA','CO','CT','DC','DE','FL','GA','GU','HI','IA','ID','IL','IN', 
'KS','KY','LA','MA','MD','ME','MI','MN','MO','MP','MS','MT','NC','ND','NE','NH','NJ','NM','NV','NY', 
'OH','OK','OR','PA','PR','RI','SC','SD','TN','TX','US','UT','VA','VI','VT','WA','WI','WV','WY') DEFAULT NULL, 
`state_fips` varchar(10) DEFAULT NULL, 
`closed_date` date DEFAULT NULL, 
`created` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', 
`modified` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP, 
PRIMARY KEY (`entity_id`) 
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=107667 ;

Field Information

`entity_id` unique identifying entity number that links to the entities table 
`aha_sys_id` assigned by the AHA and denotes the system or group 
`local_id` any other identifying number specific to the system and assigned by the state/nation/reporting agency 
`name` the system's name 
`aka` any recognized alias for the system 
`state` US state 2 letter abbreviation. enum ('AK','AL','AR','AZ','CA','CO','CT','DC','DE','FL','GA','GU','HI', 
'IA','ID','IL','IN','KS','KY','LA','MA','MD','ME','MI','MN','MO','MP','MS','MT','NC','ND','NE','NH','NJ','NM', 
'NV','NY','OH','OK','OR','PA','PR','RI','SC','SD','TN','TX','US','UT','VA','VI','VT','WA','WI','WV','WY') 
`state_fips` FIPS coding denoting the state, assigned nationally 
`closed_date` the date a system is discontinued in YYYY-MM-DD format 
`created` the date and time that the row was created in YYYY-MM-DD HH:MM:SS format 
`modified` the date and time that the row was last edited in YYYY-MM-DD HH:MM:SS format. Automatically changes to the current date and time when a row is edited

Fields

PRIMARY KEY (`entity_id`)

Notes