V_EHI_SDD_DATA_FILTER

Description:

This view returns all defining information about a patient's SDOH data that is configured in the system. Each row in this table represents documentation for a single SDOH domain for a single patient.that can be used for EHI requests.

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 Skills 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