|
TYPE |
LEN |
REQ |
VALUE |
NOTES |
|
PK |
Y |
Social History 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 |
100 |
Smoking Status |
SNOMED smoking indicator code defined by CMS. |
|
|
VARCHAR |
100 |
Marital Status |
|
|
|
VARCHAR |
100 |
Employment Status |
|
|
|
VARCHAR |
100 |
Transportation Indicator |
Y = has available transportation, N = does not have transportation available |
|
|
VARCHAR |
100 |
Living Arrangement |
|
|
|
VARCHAR |
100 |
Alcohol User |
Y = Uses alcohol, N = Does not use alcohol, SNOMED219006 (Y), SNOMED 105542008 (N) |
|
|
VARCHAR |
100 |
Drug User |
Y = Uses drugs, N = Does not use drugs |
|
|
VARCHAR |
100 |
Caffeine User |
Y = Uses caffeine, N = does not use caffeine, SNOMED67961000119106 (Y) |
|
|
VARCHAR |
100 |
Sexually Active |
Y = Is sexually active, N = Is not sexually active, SNOMED228453005 (Y), SNOMED 162171002 (N) |
|
|
VARCHAR |
20 |
Hours of Exercise per Week |
||
|
VARCHAR |
200 |
Level of Education |
|
|
|
DATE (Time) |
|
HJ Create Timestamp |
|
|
|
DATE (Time) |
|
HJ Modify Timestamp |
|
|
|
VARCHAR |
40 |
First Encounter ID |
The encounter ID from when the social history was first recorded |
|
|
VARCHAR |
50 |
Client Social ID |
|
|
|
CHAR |
32 |
Row Hash |
|