Mapping Service Details:
This table is available as a paid add-on per connection. This table supports LOINC mapping of the raw data extracted from the EHR for A1C, Hemoglobin, Albumin Creatinine, eGFR, and Chlamydia lab results. The Healthjump mapping service identifies rows for the supported lab results to be mapped and checks for valid LOINC codes. If the code is not valid or blank it will run it through the mapping algorithm to assign the correct LOINC code if possible. The identified rows that have made it through the mapping services are then aggregated into the Enhanced Lab Results table.
Table Details:
The Enhanced Lab Result table format is identical to the unmapped Lab Result table to allow joining back to the raw data to see the raw code vs map code. This table is available for use in DBX, Healthjump API, and S3 unload service.
|
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 |
|
LOINC code mapped by Healthjump LOINC mapping service |
|
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 |
|
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. |