Server (Cells) Design
Space shortcuts
Space Tools
Skip to end of metadata
Go to start of metadata

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



  • No labels