NAME | TYPE | LENGTH | REQUIRED | NOTES |
hj_import_int |
INT |
|
Y |
Healthjump’s client identifier. |
client_id |
VARCHAR |
100 |
Y |
|
patient_id |
VARCHAR |
40 |
Y |
Related to demographic data. patient_id = demographic.patient_id |
type |
VARCHAR |
250 |
|
Allergen type. |
description |
VARCHAR |
1000 |
|
Description of allergy. |
onset_date |
VARCHAR |
8 |
|
Format: YYYYMMDD |
resolved_date |
VARCHAR |
8 |
|
Format: YYYYMMDD |
severity |
VARCHAR |
2000 |
|
Allergy severity description. |
reaction_code |
VARCHAR |
2000 |
|
Code describing the reaction based on HITSP C80 Section 2.2.3.4.1 |
reaction |
VARCHAR |
2000 |
|
Allergy reaction description. |
product_code |
VARCHAR |
200 |
|
Code describing the product, HITSP C80 Section(s): 2.2.3.3.9, 2.2.3.3.11, 2.2.3.3.7, 2.2.3.3.8) |
comment |
VARCHAR |
4000 |
|
Allergy comments from the source system. |
hj_create_timestamp |
TIMESTAMP |
|
|
For internal Healthjump use and reference. |
hj_modify_timestamp |
TIMESTAMP |
|
|
For internal Healthjump use and reference. |
enc_id |
VARCHAR |
40 |
|
The encounter ID from when this allergy was first recorded. |
allergy_id |
VARCHAR |
40 |
|
The ID used by the source system to identify the allergy. |
row_hash |
CHAR |
32 |
|
For internal Healthjump use and reference. |