|
NAME |
TYPE |
LENGTH |
REQUIRED |
NOTES |
|
hj_import_int |
INT |
|
Y |
|
|
client_id |
VARCHAR |
100 |
Y |
Datavant Site Connect’s client identifier. |
|
patient_id |
VARCHAR |
40 |
Y |
Related to demographic.patient_id = demographic.patient_id |
|
source_provider_id |
VARCHAR |
40 |
|
The source system identifier for the provider this patient is attributed to |
|
provider_npi |
VARCHAR |
10 |
|
|
|
provider_first_name |
VARCHAR |
50 |
|
|
|
provider_last_name |
VARCHAR |
50 |
|
|
|
program_name |
VARCHAR |
100 |
|
The program, or group, that this patient is part of |
|
location_id |
VARCHAR |
40 |
|
The source system identifier for the location this patient is attributed to |
|
location_name |
VARCHAR |
100 |
|
|
|
comment |
VARCHAR |
250 |
|
|
|
hj_create_timestamp |
TIMESTAMP |
|
|
For internal Datavant Site Connect use and reference. |
|
hj_modify_timestamp |
TIMESTAMP |
|
|
For internal Datavant Site Connect use and reference. |
|
row_hash |
CHAR |
32 |
|
For internal Datavant Site Connect use and reference. |