Note: This table is not part of our data model, but can be requested. Please speak to your sales representative for more details.
|
NAME |
TYPE |
LENGTH |
REQUIRED |
NOTES |
|
hj_import_int |
INT (PK) |
|
Y |
|
|
client_id |
VARCHAR |
100 |
Y |
Healthjump’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 Healthjump use and reference |
|
hj_modify_timestamp |
TIMESTAMP |
|
|
For internal Healthjump use and reference |