SDD_DATA

Description: |
This table stores defining information about a patient's SDOH data. Each row in this table represents documentation for a single SDOH domain for a single patient.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
SDOH_DATA_ID | 1 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | SDOH_DATA_ID | NUMERIC | No |
The unique identifier (.1 item) for the social driver data record.
2 | RECORD_STATUS_C_NAME | VARCHAR | No |
Stores the record status. SDD only supports soft deleted records.
May contain organization-specific values: No
Category Entries:
Soft Deleted
Hidden
Hidden and Soft Deleted
3 | DOMAIN_C_NAME | VARCHAR | No |
Stores the domain this record stores data for.
May contain organization-specific values: Yes
Category Entries:
Intimate Partner Violence
Social Connections
Alcohol Use
Tobacco Use
Financial Resource Strain
Depression
Stress
Physical Activity
Food Insecurity
Transportation Needs
Housing Stability
Health Literacy
Substance Use
Internet Access
Digital Inclusion
Inadequate Housing
Homelessness
Educational Attainment
Employment Status
Veteran Status
Elder Abuse
Health Insurance Status
Medical Cost Burden
Utilities
Personal Safety
Access to Care
Postpartum Depression
Caregiver Education and Work
Safety and Environment
Caregiver Health
Child Education
Adolescent Education and Socialization
Adolescent Substance Use
Adolescent Education
Adolescent Socialization
Mental Health
Self-Management
4 | PAT_ID | VARCHAR | No |
The patient this SDD record stores data for.
5 | CONCERNS_PRESENT_YN | VARCHAR | No |
Tracks whether the patient has needs in any source for this domain. Checks the most recent entry across all sources to determine if there is a concern.
May contain organization-specific values: No
Category Entries:
No
Yes