TYPE |
LEN |
REQ |
VALUE |
NOTES |
PK |
Y |
Immunization 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 |
8 |
Y |
Service Date |
Format: YYYYMMDD (Administration Date) |
VARCHAR |
8 |
Service Time |
Format: HH:MM:SS |
|
VARCHAR |
10 |
CPT Code |
||
VARCHAR |
10 |
Y |
CVX Code |
Must have CVX or RxNorm. Cannot use CPT, SNOMED or LOINC. |
VARCHAR |
250 |
Y |
Immunization Description |
|
VARCHAR |
50 |
Immunization Dose |
||
VARCHAR |
50 |
Immunization Units |
Describes the dose, ex. mg |
|
VARCHAR |
10 |
Route Code |
||
VARCHAR |
250 |
Route Description |
Ex. Oral / Intramuscular |
|
VARCHAR |
10 |
Performing Clinician NPI |
NPI of the provider that administered the immunization (NPI) |
|
VARCHAR |
100 |
Performing Clinician |
The name of the provider that administered the immunization |
|
VARCHAR |
20 |
Lot Number |
The manufacturer’s lot number for the product administered |
|
VARCHAR |
40 |
Encounter Unique ID |
Identifies the encounter during which this was performed |
|
VARCHAR |
10 |
LOINC Code |
||
VARCHAR |
20 |
SNOMEDCode |
||
VARCHAR |
20 |
Exception Reason Code |
Coded exception reason for not administering the immunization (patient refusal, not available), SNOMED |
|
DATE (Time) |
|
HJ Create Timestamp |
For internal Healthjump use and reference. |
|
DATE (Time) |
|
HJ Modify Timestamp |
For internal Healthjump use and reference. |
|
VARCHAR |
50 |
Immunization ID |
Immunization ID from the client’s source system |
|
CHAR |
32 |
Row Hash |
For internal Healthjump use and reference. |