|
NAME |
TYPE |
LENGTH |
REQUIRED |
NOTES |
|
hj_import_int |
INT |
|
Y |
|
|
client_id |
VARCHAR |
100 |
Y |
Healthjump’s client identifier. |
|
patient_id |
VARCHAR |
40 |
Y |
Related to demographic.patient_id = demographic.patient_id |
|
order_number |
VARCHAR |
50 |
Y |
Unique ID for this lab order obtained from the source system. |
|
service_code |
VARCHAR |
50 |
Y |
|
|
service_description |
VARCHAR |
250 |
|
|
|
provider_id |
VARCHAR |
50 |
|
NPI |
|
provider_name |
VARCHAR |
200 |
|
|
|
service_coding_system_name |
VARCHAR |
50 |
|
|
|
encounter_id |
VARCHAR |
40 |
|
Unique encounter ID obtained from the source system. |
|
order_date |
VARCHAR |
10 |
|
Format: YYYYMMDD |
|
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. |