form_sdoh


If there is patient data for this table the file for this export will be found in the extracted zip folder location under the filename of form_sdoh.csv

If there are non-patient data column elements that are not part of the designated record set they will be marked in the Comment's column for that data element

Description

Encounter form that holds results for the Social Determinants of Health Screening Tool

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
forms.form_id Defined in XML R

The primary key which is the same as the forms.form_id column
date DATETIME 19 √ null
pid BIGINT 19 √ null
patient_data.pid Defined in XML R

The internal patient identifier
user VARCHAR 255 √ null
users.id Defined in XML R

The user that created this record.
groupname VARCHAR 255 √ null
groups.name Defined in XML R

The groupname that created this record.
authorized TINYINT 3 √ null
activity TINYINT 3 √ null
education VARCHAR 30 √ null
disability VARCHAR 30 √ null
housing VARCHAR 30 √ null
housingotherinput TEXT 65535 √ null
workfulltime VARCHAR 5 √ null
workparttime VARCHAR 5 √ null
worktemporary VARCHAR 5 √ null
workseasonal VARCHAR 5 √ null
worklooking VARCHAR 5 √ null
workretired VARCHAR 5 √ null
workdisabled VARCHAR 5 √ null
workstudent VARCHAR 5 √ null
worknotemployed VARCHAR 5 √ null
worknotans VARCHAR 5 √ null
workhours INT 10 √ null
hhincome INT 10 √ null
hhsize INT 10 √ null
careno VARCHAR 5 √ null
careunder5 VARCHAR 5 √ null
care5to12 VARCHAR 5 √ null
careover12 VARCHAR 5 √ null
carespecneeds VARCHAR 5 √ null
caredisabled VARCHAR 5 √ null
careelderly VARCHAR 5 √ null
careother VARCHAR 5 √ null
careotherinput TEXT 65535 √ null
debtno VARCHAR 5 √ null
debtmedical VARCHAR 5 √ null
debtcreditcards VARCHAR 5 √ null
debtrent VARCHAR 5 √ null
debtstudentloans VARCHAR 5 √ null
debttaxes VARCHAR 5 √ null
debtlegal VARCHAR 5 √ null
debtcar VARCHAR 5 √ null
debtutilities VARCHAR 5 √ null
debtother VARCHAR 5 √ null
debtotherinput TEXT 65535 √ null
moneyno VARCHAR 5 √ null
moneyfood VARCHAR 5 √ null
moneymedical VARCHAR 5 √ null
moneychildcare VARCHAR 5 √ null
moneyutilities VARCHAR 5 √ null
moneyphone VARCHAR 5 √ null
moneyrent VARCHAR 5 √ null
moneytransportation VARCHAR 5 √ null
moneyclothing VARCHAR 5 √ null
moneyeducation VARCHAR 5 √ null
moneyother VARCHAR 5 √ null
moneyotherinput TEXT 65535 √ null
transportationno VARCHAR 5 √ null
transportmedical VARCHAR 5 √ null
transportfood VARCHAR 5 √ null
transportwork VARCHAR 5 √ null
transportschool VARCHAR 5 √ null
transportfamily VARCHAR 5 √ null
transportother VARCHAR 5 √ null
transportotherinput TEXT 65535 √ null
medicalno VARCHAR 5 √ null
medicalnoinsurance VARCHAR 5 √ null
medicalcopay VARCHAR 5 √ null
medicalnotcovered VARCHAR 5 √ null
medicalwork VARCHAR 5 √ null
medicalnoprovider VARCHAR 5 √ null
medicalunderstand VARCHAR 5 √ null
medicaltrust VARCHAR 5 √ null
medicalchildcare VARCHAR 5 √ null
medicalother VARCHAR 5 √ null
medicalotherinput TEXT 65535 √ null
dentist VARCHAR 30 √ null
dentistotherinput TEXT 65535 √ null
social VARCHAR 30 √ null
stress VARCHAR 30 √ null
stressno VARCHAR 5 √ null
stressdeath VARCHAR 5 √ null
stressdivorce VARCHAR 5 √ null
stressjob VARCHAR 5 √ null
stressmoved VARCHAR 5 √ null
stressillness VARCHAR 5 √ null
stressvictim VARCHAR 5 √ null
stresswitness VARCHAR 5 √ null
stresslegal VARCHAR 5 √ null
stresshomeless VARCHAR 5 √ null
stressincarcerated VARCHAR 5 √ null
stressbankruptcy VARCHAR 5 √ null
stressmarriage VARCHAR 5 √ null
stressbirth VARCHAR 5 √ null
stressadultchild VARCHAR 5 √ null
stressother VARCHAR 5 √ null
stressotherinput TEXT 65535 √ null
safety VARCHAR 30 √ null
partnersafety VARCHAR 30 √ null
female VARCHAR 30 √ null
addiction VARCHAR 30 √ null
armedservices VARCHAR 30 √ null
refugee VARCHAR 30 √ null
discrimno VARCHAR 5 √ null
discrimrace VARCHAR 5 √ null
discrimgender VARCHAR 5 √ null
discrimsexpref VARCHAR 5 √ null
discrimgenexp VARCHAR 5 √ null
discrimreligion VARCHAR 5 √ null
discrimdisability VARCHAR 5 √ null
discrimage VARCHAR 5 √ null
discrimweight VARCHAR 5 √ null
discrimses VARCHAR 5 √ null
discrimedu VARCHAR 5 √ null
discrimmarital VARCHAR 5 √ null
discrimcitizen VARCHAR 5 √ null
discrimaccent VARCHAR 5 √ null
discrimcriminalhist VARCHAR 5 √ null
discrimother VARCHAR 5 √ null
discrimotherinput TEXT 65535 √ null
displaceno VARCHAR 5 √ null
displacework VARCHAR 5 √ null
displacehousing VARCHAR 5 √ null
displacehealth VARCHAR 5 √ null
displacelaw VARCHAR 5 √ null
displaceedu VARCHAR 5 √ null
displacepublic VARCHAR 5 √ null
displaceclubs VARCHAR 5 √ null
displacegovt VARCHAR 5 √ null
displacefinance VARCHAR 5 √ null
displaceother VARCHAR 5 √ null
displaceotherinput TEXT 65535 √ null
contact VARCHAR 30 √ null
contactotherinput TEXT 65535 √ null
additional_notes LONGTEXT 2147483647 √ null
totalscore INT 10 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id

Relationships

Close relationships within degrees of separation