|
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 |
|
service_date |
VARCHAR |
8 |
Y |
Format: YYYYMMDD (Administration Date) |
|
service_time |
VARCHAR |
8 |
|
Format: HH:MM:SS |
|
cpt_code |
VARCHAR |
10 |
|
|
|
cvx_code |
VARCHAR |
10 |
Y |
Must have CVX or RxNorm. Cannot use CPT, SNOMED or LOINC. |
|
description |
VARCHAR |
250 |
Y |
|
|
dose |
VARCHAR |
50 |
|
|
|
units |
VARCHAR |
50 |
|
Describes the dose, ex. mg |
|
route_code |
VARCHAR |
10 |
|
|
|
route_description |
VARCHAR |
250 |
|
Ex. Oral / Intramuscular |
|
clinician_npi |
VARCHAR |
10 |
|
NPI of the provider that administered the immunization (NPI) |
|
clinician |
VARCHAR |
100 |
|
The name of the provider that administered the immunization |
|
lot_number |
VARCHAR |
20 |
|
The manufacturer’s lot number for the product administered |
|
encounter_id |
VARCHAR |
40 |
|
Identifies the encounter during which this was performed |
|
loinc_code |
VARCHAR |
10 |
|
|
|
snomed_code |
VARCHAR |
20 |
|
|
|
exception_reason_code |
VARCHAR |
20 |
|
Coded exception reason for not administering the immunization (patient refusal, not available), SNOMED |
|
hj_create_timestamp |
TIMESTAMP |
|
|
For internal Healthjump use and reference. |
|
hj_modify_timestamp |
TIMESTAMP |
|
|
For internal Healthjump use and reference. |
|
client_immunization_id |
VARCHAR |
50 |
|
Immunization ID from the client’s source system |
|
row_hash |
CHAR |
32 |
|
For internal Healthjump use and reference. |
Immunization
