form_history_sdoh


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT UNSIGNED 20 √ null
form_history_sdoh_health_concerns.sdoh_history_id Defined in XML R
uuid BINARY 16 √ NULL
pid INT UNSIGNED 10 null
patient_data.pid Defined in XML R
encounter INT UNSIGNED 10 √ NULL
form_encounter.encounter Defined in XML R
created_at DATETIME 19 current_timestamp()
updated_at DATETIME 19 current_timestamp()
created_by INT UNSIGNED 10 √ NULL
users.id Defined in XML R
updated_by INT UNSIGNED 10 √ NULL
users.id Defined in XML R
assessment_date DATE 10 √ NULL
screening_tool VARCHAR 255 √ NULL
list_options.option_id Defined in XML R

Comes from the list_options.list_id=‘sdoh_instruments’
assessor VARCHAR 255 √ NULL
users.username Defined in XML R
food_insecurity VARCHAR 50 √ NULL
list_options.option_id Defined in XML R

Comes from the list_options.list_id=‘sdoh_food_insecurity_risk’ and represents the food insecurity status of the patient
food_insecurity_notes TEXT 65535 √ NULL
housing_instability VARCHAR 50 √ NULL
list_options.option_id Defined in XML R

Comes from the list_options.list_id=‘sdoh_housing_worry’ and represents the housing stability status of the patient
housing_instability_notes TEXT 65535 √ NULL
transportation_insecurity VARCHAR 50 √ NULL
list_options.option_id Defined in XML R

Comes from the list_options.list_id=‘sdoh_transportation_barrier’ and represents the transportation insecurity status of the patient
transportation_insecurity_notes TEXT 65535 √ NULL
utilities_insecurity VARCHAR 50 √ NULL
list_options.option_id Defined in XML R

Comes from the list_options.list_id=‘sdoh_utilities_shutoff’ and represents the utilities insecurity status of the patient
utilities_insecurity_notes TEXT 65535 √ NULL
interpersonal_safety VARCHAR 50 √ NULL
list_options.option_id Defined in XML R

Comes from the list_options.list_id=‘sdoh_ipv_yesno’ and represents the interpersonal safety status of the patient
interpersonal_safety_notes TEXT 65535 √ NULL
financial_strain VARCHAR 50 √ NULL
list_options.option_id Defined in XML R

Comes from the list_options.list_id=‘sdoh_financial_strain’ and represents the financial strain status of the patient at the time of assessment
financial_strain_notes TEXT 65535 √ NULL
social_isolation VARCHAR 50 √ NULL
list_options.option_id Defined in XML R

Comes from the list_options.list_id=‘sdoh_social_isolation_freq’ and represents the social isolation status of the patient
social_isolation_notes TEXT 65535 √ NULL
childcare_needs VARCHAR 50 √ NULL
list_options.option_id Defined in XML R

Comes from the list_options.list_id=‘sdoh_childcare_needs’ and represents the childcare needs of the patient
childcare_needs_notes TEXT 65535 √ NULL
digital_access VARCHAR 50 √ NULL
list_options.option_id Defined in XML R

Comes from the list_options.list_id=‘sdoh_digital_access’ and represents the digital access status of the patient
digital_access_notes TEXT 65535 √ NULL
employment_status VARCHAR 50 √ NULL
education_level VARCHAR 50 √ NULL
caregiver_status VARCHAR 20 √ NULL
veteran_status VARCHAR 20 √ NULL
pregnancy_status VARCHAR 20 √ NULL
list_options.option_id Defined in XML R

Comes from the list_options.list_id=‘pregnancy_status’
pregnancy_edd DATE 10 √ NULL
pregnancy_gravida SMALLINT 5 √ NULL
pregnancy_para SMALLINT 5 √ NULL
postpartum_status VARCHAR 20 √ NULL
list_options.option_id Defined in XML R

Comes from the list_options.list_id=‘postpartum_status’
postpartum_end DATE 10 √ NULL
goals TEXT 65535 √ NULL
interventions TEXT 65535 √ NULL
instrument_score INT 10 √ NULL
positive_domain_count INT 10 √ NULL
declined_flag BOOLEAN 3 √ NULL
disability_status VARCHAR 50 √ NULL
list_options.option_id Defined in XML R

Comes from the list_options.list_id=‘disability_status’
disability_status_notes TEXT 65535 √ NULL
disability_scale TEXT 65535 √ NULL
hunger_q1 VARCHAR 50 √ NULL
list_options.option_id Defined in XML R

Comes from the list_options.list_id=‘vital_signs_answers’
hunger_q2 VARCHAR 50 √ NULL
list_options.option_id Defined in XML R

Comes from the list_options.list_id=‘vital_signs_answers’
hunger_score INT 10 √ NULL

Calculated HVS score
pregnancy_intent VARCHAR 32 √ NULL
list_options.option_id Defined in XML R

Comes from the list_options.list_id=‘pregnancy_intent’

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
assessment_idx Performance Asc assessment_date
encounter_idx Performance Asc encounter
pid_idx Performance Asc pid
uuid_idx Performance Asc uuid

Relationships

Close relationships within degrees of separation