PROVIDER_DIMENSION Table
Each record in the PROVIDER_DIMENSION table represents a physician or provider at an institution. The PROVIDER_PATH is the path that describes how the provider fits into the institutional hierarchy. Institution, department, provider name and a code may be included in the path.
PROVIDER_DIMENSION |
|
|
PK | PROVIDER_ID | varchar(50) |
PK | PROVIDER_PATH | varchar(700) |
| NAME_CHAR | varchar(850) |
| CONCEPT_BLOB | text |
| UPDATE_DATE | datetime |
| DOWNLOAD_DATE | datetime |
| IMPORT_DATE | datetime |
| SOURCESYSTEM_CD | varchar(50) |
| UPLOAD_ID | int |