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. |