NAME |
TYPE |
LENGTH |
REQUIRED |
NOTES |
hj_import_int |
INT (PK) |
|
Y |
|
client_id |
VARCHAR |
100 |
Y |
Datavant Site Connect’s client identifier. |
location_id |
VARCHAR |
50 |
Y |
Location ID obtained from the source system |
location_name |
VARCHAR |
500 |
Y |
|
address_line_1 |
VARCHAR |
500 |
|
Location address line 1. |
address_line_2 |
VARCHAR |
500 |
|
Location address line 2. |
city |
VARCHAR |
100 |
|
Location city. |
state |
VARCHAR |
100 |
|
Location state. |
zip |
VARCHAR |
50 |
|
Location zip. |
create_timestamp |
TIMESTAMP |
|
Y |
Create timestamp acquired from the source system. |
modify_timestamp |
TIMESTAMP |
|
Y |
Modify timestamp acquired from the source system |
hj_create_timestamp |
TIMESTAMP |
|
|
For internal Datavant Site Connect use and reference |
hj_modify_timestamp |
TIMESTAMP |
|
|
For internal Datavant Site Connect use and reference |