Sdoh Dataset Specification

SDOH Dataset Specification

The SDOH Dataset Specification contains the most recent Social Determinants of Health (SDOH) data for the member obtained from data vendors. Each record corresponds to a single member, with memberId serving as its unique key. It references members by Member_ID.

This dataset is essential for organizations focusing on improving health outcomes through a better understanding of how social factors affect health. It supports informed decision-making and policy development in healthcare and public health sectors by providing a comprehensive view of the social determinants impacting community health.

Key Components

Data Storage

Provides robust storage solutions for comprehensive data on SDOH, such as:
Economic stability
Education access and quality
Healthcare access
Neighborhood and built environment
Social and community context

Data Mapping

Includes tools and tables designed to link SDOH data with:
Health outcomes
Patient records
Other relevant healthcare datasets
Enables effective analysis and insights.

Data Logging

Features tables that capture:
Changes
Updates
Access logs related to SDOH data
Ensures a secure and traceable record of all data interactions.

Data Processing

Facilitates efficient processing of SDOH data, enabling:
Integration
Transformation
Analysis
Supports actionable insights and informs public health strategies.

Table: SDOH_Data

Column Name	Is Nullable	Data Type	Description
`memberId`	YES	STRING	Unique identifier for the member (patient) the SDOH data pertains to. Essential for linking SDOH data with specific patient records.
`createdAt`	YES	TIMESTAMP	Timestamp marking when the SDOH data record was initially created. Indicates the entry point of the data into the system.
`lastUpdatedAt`	YES	TIMESTAMP	Timestamp of the most recent update to the SDOH data record. Reflects the latest modifications or updates made to the data.
`receivedAt`	YES	TIMESTAMP	Timestamp indicating when the SDOH data was received from the provider. Helps to track the data flow and its recency.
`lastRequestedAt`	YES	TIMESTAMP	Timestamp of the last request for the member's SDOH data. Supports the capability to pause requests for a member if the provider has no new data.
`provider`	NO	STRING	Entity providing the SDOH data, typically HealthyEngage or Experian. This field indicates the source of the SDOH data.
`totalScore`	YES	INT64	Aggregate score ranging from 1 to 9, reflecting the overall social determinants of health status of the member.
`totalLevel`	YES	STRING	Categorization of the total score into Low, Medium, or High, providing a quick reference level of SDOH needs.
`accessToCareScore`	YES	INT64	Score from 1 to 9 assessing access to healthcare services. Part of the detailed breakdown of SDOH factors.
`accessToCareLevel`	YES	STRING	Level (Low, Medium, or High) corresponding to the access to care score, indicating the relative ease of accessing healthcare services.
`accessToMedScore`	YES	INT64	Score from 1 to 9 evaluating access to medications. Highlights potential barriers in obtaining necessary medications.
`accessToMedLevel`	YES	STRING	Level (Low, Medium, or High) associated with the access to medication score, reflecting the accessibility of medications.
`housingLevelScore`	YES	INT64	Score from 1 to 9 that assesses the housing situation of the member, an important aspect of social determinants.
`housingLevel`	YES	STRING	Level (Low, Medium, or High) based on the housing score, indicating the stability and adequacy of the member’s living conditions.
`foodLevelScore`	YES	INT64	Score from 1 to 9 that evaluates food security and access. Addresses an essential part of the member's social needs.
`foodLevel`	YES	STRING	Level (Low, Medium, or High) derived from the food score, assessing the adequacy of access to nutritious food.
`accessToERScore`	YES	INT64	Score from 1 to 9 measuring the ease of access to emergency medical services, an important factor in acute health situations.
`accessToERLevel`	YES	STRING	Level (Low, Medium, or High) indicating the ease of accessing emergency services, crucial for assessing emergency healthcare readiness.

Table: SDOH_Data_Attribute_Map

Column Name	Is Nullable	Data Type	Description
`memberId`	YES	STRING	Represents the unique identifier of the member (patient) for whom the SDOH attributes are recorded. This ID links the attribute data directly to the individual member in the SDOH data.
`provider`	NO	STRING	Array of strings identifying the providers of the SDOH data. Each provider might have unique attributes that they supply, which are stored in this table.
`attributeMapKey`	YES	STRING	The key for additional attributes provided by the SDOH data providers. These keys are specific to each provider and may not be universally supported across all providers. They represent the extra fields in the SDOH response that provide more detailed insights into the social determinants affecting the member.
`attributeMapValue`	YES	STRING	The value associated with each key in the attribute map. These values give the actual data for the additional SDOH fields provided by the provider, offering more granular details on the member’s social and environmental conditions.

Table: SDOH_log

Column Name	Is Nullable	Data Type	Description
`tenant`	YES	STRING	The identifier for the tenant under which the SDOH data is logged, aiding in data organization and segregation in multi-tenant environments.
`memberId`	YES	STRING	Unique identifier of the member whose social determinants of health data are being logged, crucial for linking the SDOH information to the specific individual in the database.
`createdAt`	YES	TIMESTAMP	Timestamp indicating when the SDOH record was initially created. Reflects the entry point of the data into the logging system.