| NAME | TYPE | LENGTH | REQUIRED | NOTES |
|
hj_import_int |
INT |
|
Y |
Datavant Site Connect’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 |
|
|
|
reaction |
VARCHAR |
2000 |
|
Allergy reaction description. |
|
product_code |
VARCHAR |
200 |
|
SNOMED Code |
|
comment |
VARCHAR |
4000 |
|
Allergy comments from the source system. |
|
hj_create_timestamp |
TIMESTAMP |
|
|
For internal Datavant Site Connect use and reference. |
|
hj_modify_timestamp |
TIMESTAMP |
|
|
For internal Datavant Site Connect 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 Datavant Site Connect use and reference. |