|
NAME |
TYPE |
LENGTH |
REQUIRED |
NOTES |
|
hj_import_int |
INT |
|
Y |
|
|
client_id |
VARCHAR |
100 |
Y |
Healthjumps client identifier. |
|
patient_id |
VARCHAR |
40 |
Y |
Related to demographic.patient_id = demographic.patient_id |
|
date |
VARCHAR |
8 |
|
Format: YYYYMMDD |
|
code |
VARCHAR |
1000 |
|
Type of medical/surgical history observation. (SNOMED, ICD9 or ICD10) |
|
description |
VARCHAR |
1000 |
|
Value describing the medical/surgical history. (CABG, AMI, Colectomy, etc.) |
|
comments |
VARCHAR |
1000 |
|
|
|
hj_create_timestamp |
TIMESTAMP |
|
|
For internal Healthjump use and reference. |
|
hj_modify_timestamp |
TIMESTAMP |
|
|
For internal Healthjump use and reference. |
|
client_medsurg_id |
VARCHAR |
50 |
|
|
|
row_hash |
CHAR |
32 |
|
For internal Healthjump use and reference. |
Medical / Surgical History
