...
This table is used to track identifying data for clinics. Currently, the entity_clinics table is limited to entities in New York State.
The unique entity_id links to the entities, entity_clinic_attributes, and entity_clinic_overrides tables.
...
field | type | attributes | notes | example |
|---|---|---|---|---|
| entity_clinics.entity_id | int(10) | UNSIGNED NOT NULL AUTO_INCREMENT | Provided by Pellucid, same as FOREIGN KEY: links to entities table | 1219198502 |
| entity_clinics.entity_hospital_id | int(10) | DEFAULT NULL | Hospital entity_id that the clinic is tied to | 100001 |
| entity_clinics.local_id | varchar(4) | DEFAULT NULL | Assigned by data provider, ex: state | 0012 |
| entity_clinics.type | varchar(25) | DEFAULT NULL | Provides details on the type of service | DBA |
| entity_clinics.name | varchar(255) | DEFAULT NULL | Clinic Name | Ted's ACO |
| entity_clinics.aka | varchar(255) | DEFAULT NULL | Alternative Clinic Name | Ted Jr's ACO |
| entity_clinics.address | varchar(255) | DEFAULT NULL | Physical Location | 123 Fake St |
| entity_clinics.city | varchar(255) | DEFAULT NULL | Physical Location | Lake Success |
| entity_clinics.state | varchar(2) | DEFAULT NULL | Two-letter state abbreviation | NY |
| entity_clinics.zipcode | varchar(5) | DEFAULT NULL | Five Digit Postal Code | 11042 |
| entity_clinics.county_name | varchar(255) | DEFAULT NULL | Physical Location | Nassau |
| entity_clinics.county_fips | varchar(3) | DEFAULT NULL | Determined by state | 056 |
| entity_clinics.phone_number | varchar(25) | DEFAULT NULL | Telephone Number | 5165550123 |
| entity_clinics.closed_date | date | DEFAULT NULL | YYYY-MM-DD | 2011-01-12 |
| entity_clinics.created | datetime | DEFAULT NULL | When the row was created | 2000-01-01 11:11:11 |
| entity_clinics.modified | timestamp | DEFAULT NULL | When the row was most recently changed | 2014-08-01 01:12:12 |