|
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 |
|
smoking_status |
VARCHAR |
100 |
|
SNOMED smoking indicator code defined by CMS. |
|
marital_status |
VARCHAR |
100 |
|
|
|
employment_status |
VARCHAR |
100 |
|
|
|
transportation |
VARCHAR |
100 |
|
Y = has available transportation, N = does not have transportation available |
|
living_arrangement |
VARCHAR |
100 |
|
|
|
alcohol_user |
VARCHAR |
100 |
|
Y = Uses alcohol, N = Does not use alcohol, SNOMED219006 (Y), SNOMED 105542008 (N) |
|
drug_user |
VARCHAR |
100 |
|
Y = Uses drugs, N = Does not use drugs |
|
caffeine_user |
VARCHAR |
100 |
|
Y = Uses caffeine, N = does not use caffeine, SNOMED67961000119106 (Y) |
|
sexually_active |
VARCHAR |
100 |
|
Y = Is sexually active, N = Is not sexually active, SNOMED228453005 (Y), SNOMED 162171002 (N) |
|
exercise_hours_week |
VARCHAR |
20 |
|
|
|
education_level |
VARCHAR |
200 |
|
|
|
hj_create_timestamp |
TIMESTAMP |
|
|
For internal Healthjump use and reference |
|
hj_modify_timestamp |
TIMESTAMP |
|
|
For internal Healthjump use and reference |
|
enc_id |
VARCHAR |
40 |
|
The encounter ID from when the social history was first recorded |
|
client_social_id |
VARCHAR |
50 |
|
|
|
row_hash |
CHAR |
32 |
|
For internal Healthjump use and reference |
Social History
