NAME |
TYPE |
LENGTH |
REQUIRED |
NOTES |
hj_import_int |
INT |
|
Y |
|
client_id |
VARCHAR |
100 |
Y |
Healthjump’s client identifier. |
source_provider_id |
VARCHAR |
40 |
Y |
The unique identifier from the source system for this provider record. |
npi |
VARCHAR |
50 |
Y |
|
provider_ssn |
VARCHAR |
50 |
|
|
tin |
VARCHAR |
50 |
|
The provider tax ID. |
first_name |
VARCHAR |
250 |
Y |
|
middle_name |
VARCHAR |
250 |
|
|
last_name |
VARCHAR |
250 |
Y |
|
degree |
VARCHAR |
50 |
|
MD, PA, etc. |
address_line_1 |
VARCHAR |
500 |
|
|
address_line_2 |
VARCHAR |
500 |
|
|
city |
VARCHAR |
50 |
|
|
state |
VARCHAR |
3 |
|
|
zip |
VARCHAR |
10 |
|
|
phone1 |
VARCHAR |
25 |
|
|
phone1_description |
VARCHAR |
100 |
|
Translated during the extraction of data from the source system. |
phone2 |
VARCHAR |
25 |
|
|
phone2_description |
VARCHAR |
100 |
|
Translated during the extraction of data from the source system. |
specialty1 |
VARCHAR |
50 |
|
|
specialty2 |
VARCHAR |
50 |
|
|
hj_create_timestamp |
TIMESTAMP |
|
|
For internal Healthjump use and reference. |
hj_modify_timestamp |
TIMESTAMP |
|
|
For internal Healthjump use and reference. |
row_hash |
CHAR |
32 |
|
For internal Healthjump use and reference. |