|
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. |
|
date |
VARCHAR |
8 |
|
Format: YYYYMMDD |
|
time |
VARCHAR |
8 |
|
Format: HH:MM:SS |
|
code |
VARCHAR |
50 |
|
|
|
value |
VARCHAR |
500 |
|
|
|
units |
VARCHAR |
50 |
|
|
|
ref_range |
VARCHAR |
50 |
|
The upper and lower bounds that define a normal value |
|
abnormal |
VARCHAR |
5 |
|
Abnormal Flag returned from lab (ex H, L, HH, LL, ABN) |
|
comment |
VARCHAR |
1000 |
|
|
|
observation_coding_system |
VARCHAR |
50 |
|
Ex. “LOINC” |
|
observation_description |
VARCHAR |
250 |
|
|
|
hj_create_timestamp |
TIMESTAMP |
|
|
For internal Healthjump use and reference. |
|
hj_modify_timestamp |
TIMESTAMP |
|
|
For internal Healthjump use and reference. |
|
status |
VARCHAR |
50 |
|
Whether or not the lab result was reviewed by the provider |
|
client_lab_result_id |
VARCHAR |
50 |
|
|
|
row_hash |
CHAR |
32 |
|
For internal Healthjump use and reference. |
Lab Result
