|
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 data. patient_id = demographic.patient_id |
|
icd9_code |
VARCHAR |
50 |
Y* |
The actual ICD9, 10 or SNOMED code |
|
icd10_code |
VARCHAR |
50 |
Y* |
|
|
loinc_code |
VARCHAR |
50 |
Y* |
|
|
snomed_code |
VARCHAR |
50 |
Y* |
|
|
description |
VARCHAR |
250 |
|
Includes diagnoses from the problem list. |
|
diagnosed_date |
VARCHAR |
8 |
|
Format: YYYYMMDD |
|
onset_date |
VARCHAR |
8 |
|
Format: YYYYMMDD |
|
resolved_date |
VARCHAR |
8 |
|
Format: YYYYMMDD |
|
status |
VARCHAR |
500 |
|
|
|
severity |
VARCHAR |
500 |
|
|
|
clinician |
VARCHAR |
100 |
|
|
|
encounter_id |
VARCHAR |
40 |
|
Encounter ID obtained from the source system. |
|
confidentiality_indicator |
VARCHAR |
20 |
|
Y or N |
|
diagnosis_classification |
VARCHAR |
20 |
|
|
|
chronic_indicator |
VARCHAR |
20 |
|
Y or N |
|
hj_create_timestamp |
TIMESTAMP |
|
|
For internal Healthjump use and reference. |
|
hj_modify_timestamp |
TIMESTAMP |
|
|
For internal Healthjump use and reference. |
|
diagnosis_id |
VARCHAR |
40 |
|
The ID issued in the source system to uniquely identify the diagnosis |
|
row_hash |
CHAR |
32 |
|
For internal Healthjump use and reference. |
*Y* – One of these values must be specified.