Allergy

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.