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 |
