...
This table documents the relationships between Ambulatory Surgical Centers and hospitals. It serves as a link between entity_hospitals and entity_ascs. This table can be used to find information on the affiliations that ASCs and hospitals have with each other.
...
| field | type | attributes | notes | example |
|---|---|---|---|---|
| asc_id | BIGINT(20) | UNSIGNED NOT NULL | Provided by Pellucid | 01234567890 |
| hospital_id | BIGINT(20) | UNSIGNED NOT NULL | Provided by Pellucid, known as entity_id in entity_hospitals | 01234567890 |
| type | enum('asc_affiliation','hospital-ownership') | DEFAULT 'asc_affiliation' | relationship between the two | 'asc_affiliation' |
...