|
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 |
|
id_ndc |
VARCHAR |
40 |
Y* |
|
|
id_rxnorm |
VARCHAR |
40 |
Y* |
|
|
id_other |
VARCHAR |
40 |
Y* |
|
|
type |
VARCHAR |
10 |
|
Prescription or OTC HITSP C80 Section 2.2.3.3.5 |
|
name |
VARCHAR |
100 |
Y |
|
|
dose |
VARCHAR |
60 |
|
Use HITSP C80 Section 2.2.6.6 value set |
|
form |
VARCHAR |
100 |
|
Use HITSP C80 Section 2.2.3.3 value set |
|
route |
VARCHAR |
100 |
|
How the medication is to be taken. (Intramuscular, Oral, Etc.) |
|
sig_code |
VARCHAR |
30 |
|
|
|
sig |
VARCHAR |
1000 |
|
The medication instructions. |
|
duration |
VARCHAR |
50 |
|
Length of time medication should be continued. |
|
frequency |
VARCHAR |
50 |
|
How often the medication is to be administered. |
|
start_date |
VARCHAR |
10 |
Y |
Date medication was dispensed. Format: YYYYMMDD |
|
stop_date |
VARCHAR |
10 |
|
Format: YYYYMMDD |
|
comment |
VARCHAR |
1000 |
|
|
|
quantity |
VARCHAR |
10 |
|
How much of the medication is prescribed per refill. |
|
refill |
VARCHAR |
3 |
|
The number of refills remaining / allowed for the medication. |
|
fill_status |
VARCHAR |
50 |
|
completed, never, dispensed, etc. |
|
sample_indicator |
CHAR |
1 |
|
Y = this prescription is a sample, N = this prescription is not a sample |
|
generic_indicator |
CHAR |
1 |
|
Y = generic version may be dispensed, N = generic version is not allowed |
|
brand_name_code |
VARCHAR |
20 |
|
HITSP C80 Section 2.2.3.3.7, 2.2.3.3.10 |
|
prescribed_npi |
VARCHAR |
10 |
|
The NPI of the provider that prescribed the medication. |
|
status |
VARCHAR |
15 |
|
Active, Inactive, etc. |
|
encounter_id |
VARCHAR |
40 |
|
Identifies the encounter during which this medication was prescribed. |
|
hj_create_timestamp |
TIMESTAMP |
|
|
For internal Healthjump use and reference. |
|
hj_modify_timestamp |
TIMESTAMP |
|
|
For internal Healthjump use and reference. |
|
client_medication_id |
VARCHAR |
50 |
|
|
|
row_hash |
CHAR |
32 |
|
For internal Healthjump use and reference. |
*Y* – One of these values must be specified.