TYPE |
LEN |
REQ |
VALUE |
NOTES |
PK |
Y |
Medication Primary Key |
||
VARCHAR |
100 |
Y |
Client ID |
Healthjump’s client identifier. |
VARCHAR |
40 |
Y |
Patient ID |
Related to demographic.patient_id = demographic.patient_id |
VARCHAR |
40 |
Y* |
Medication ID – NDC |
|
VARCHAR |
40 |
Y* |
Medication ID – RxNorm |
|
VARCHAR |
40 |
Y* |
Medication ID – Other |
|
VARCHAR |
10 |
Medication Type |
Prescription or OTC HITSP C80 Section 2.2.3.3.5 |
|
VARCHAR |
100 |
Y |
Medication Name |
|
VARCHAR |
60 |
Medication Dose |
Use HITSP C80 Section 2.2.6.6 value set |
|
VARCHAR |
100 |
Medication Form |
Use HITSP C80 Section 2.2.3.3 value set |
|
VARCHAR |
100 |
Medication Route |
How the medication is to be taken. (Intramuscular, Oral, Etc.) |
|
VARCHAR |
30 |
Medication SIGCode |
||
VARCHAR |
1000 |
Medication SIG |
The medication instructions. |
|
VARCHAR |
50 |
Duration |
Length of time medication should be continued. |
|
VARCHAR |
50 |
Frequency |
How often the medication is to be administered. |
|
VARCHAR |
10 |
Y |
Start Date |
Date medication was dispensed. Format: YYYYMMDD |
VARCHAR |
10 |
Stop Date |
Format: YYYYMMDD |
|
VARCHAR |
1000 |
Comment |
||
VARCHAR |
10 |
Quantity |
How much of the medication is prescribed per refill. |
|
VARCHAR |
3 |
Refills |
The number of refills remaining / allowed for the medication. |
|
VARCHAR |
50 |
Fill Status |
completed, never, dispensed, etc. |
|
CHAR |
1 |
Sample Indicator |
Y = this prescription is a sample, N = this prescription is not a sample |
|
CHAR |
1 |
Generic Allowed Indicator |
Y = generic version may be dispensed, N = generic version is not allowed |
|
VARCHAR |
20 |
Brand Name Code |
HITSP C80 Section 2.2.3.3.7, 2.2.3.3.10 |
|
VARCHAR |
10 |
Prescribed By NPI |
The NPI of the provider that prescribed the medication. |
|
VARCHAR |
15 |
Status Description |
Active, Inactive, etc. |
|
VARCHAR |
40 |
Encounter Unique ID |
Identifies the encounter during which this medication was prescribed. |
|
DATE (Time) |
|
HJ Create Timestamp |
For internal Healthjump use and reference. |
|
DATE (Time) |
|
HJ Modify Timestamp |
For internal Healthjump use and reference. |
|
VARCHAR |
50 |
Client Medication ID |
|
|
CHAR |
32 |
Row Hash |
For internal Healthjump use and reference. |
*Y* – One of these values must be specified.