...
field | type | attributes | notes | example | |||||
|---|---|---|---|---|---|---|---|---|---|
| entity_id | int(2010) | UNSIGNED NOT NULL AUTO_INCREMENT | Provided by Pellucid, same as entities table | 1219198502 | |||||
| entity_hospital_id | int(10) | DEFAULT NULL | hospital Hospital entity_id that the clinic is tied to | 100001 | |||||
| local_id | varchar(104) | DEFAULT NULL | Assigned by data provider, ex: state | 0012 | |||||
| type | varchar(25) | DEFAULT NULL | Provides details on the type of service | DBA | |||||
| name | varchar(255) | DEFAULT NULL | Clinic Name | Ted's ACO | |||||
| aka | varchar(255) | DEFAULT NULL | Alternative Clinic 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(10) | DEFAULT NULL | Nationally defined | 09 |
| zipcode | varchar(5) | DEFAULT NULL | Five Digit Postal Code | 11042 | |||||
| county_name | varchar(30255) | DEFAULT NULL | Physical Location | Nassau | |||||
| county_fips | varchar(103) | DEFAULT NULL | Determined by state | 056 | |||||
| phone_number | varchar(4625) | DEFAULT NULL | Telephone Number | 5165550123 | |||||
| closed_date | date | DEFAULT NULL | YYYY-MM-DD | 2011-01-12 | |||||
| created | datetime | DEFAULT NULL | when When the row was created | 2000-01-01 11:11:11 | |||||
| modified | datetimetimestamp | DEFAULT NULL | when When the row was most recently changed | 2014-08-01 01:12:12 |