TYPE |
LEN |
REQ |
VALUE |
NOTES |
---|---|---|---|---|
PK |
Y |
Allergy Primary Key |
||
VARCHAR |
100 |
Y |
Client ID |
Healthjump’s client identifier. |
VARCHAR |
40 |
Y |
Patient ID |
Related to demographic data. patient_id = demographic.patient_id |
VARCHAR |
40 |
Allergy ID |
The ID used by the source system to identify the allergy. |
|
VARCHAR |
40 |
Encounter ID |
The encounter ID from when this allergy was first recorded. |
|
VARCHAR |
250 |
Allergen Type |
Allergen type. See Table 006 for cross-reference. |
|
VARCHAR |
1000 |
Y |
Allergy Description |
Description of allergy. |
VARCHAR |
8 |
Onset Date |
Format: YYYYMMDD |
|
VARCHAR |
8 |
Resolved Date |
Format: YYYYMMDD |
|
VARCHAR |
2000 |
Allergy Severity |
Allergy severity description. |
|
VARCHAR |
2000 |
Reaction Code |
Code describing the reaction based on HITSP C80 Section 2.2.3.4.1 |
|
VARCHAR |
2000 |
Allergy Reaction |
Allergy reaction description. |
|
VARCHAR |
200 |
Product Code |
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) |
|
VARCHAR |
4000 |
Comment |
Allergy comments from the source system. |
|
DATE (Time) |
|
HJ Create Timestamp |
For internal Healthjump use and reference. |
|
DATE (Time) |
HJ Modify Tempstamp | For internal Healthjump use and reference. | ||
CHAR |
32 |
|
Row Hash |
For internal Healthjump use and reference. |