DOCS_RCVD_SDOH
Description:
Contains discrete external social driver of health information from outside sources.

Primary Key
Column Name Ordinal Position
DOCUMENT_ID 1
CONTACT_DATE_REAL 2
LINE 3

Column Information
Name Type Discontinued?
1 DOCUMENT_ID NUMERIC No
The unique identifier (.1 item) for the document record.
2 CONTACT_DATE_REAL FLOAT No
A unique contact date in decimal format. The integer portion of the number indicates the date of contact. The digits after the decimal distinguish different contacts on the same date and are unique for each contact on that date. For example, .00 is the first/only contact, .01 is the second contact, etc.
3 LINE INTEGER No
The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
4 CONTACT_DATE DATETIME No
The date of this contact in calendar format.
5 SDOH_IDENTIFIER VARCHAR No
This item stores the unique reference ID of a discrete social driver of health documentation.
6 SDOH_ENTRY_DATE DATETIME No
This item stores the date a social driver of health was documented for the patient.
7 SDOH_CONCERN_LEVEL_C_NAME VARCHAR No
This item stores the Epic-standard concern level for a social driver entry.
May contain organization-specific values: No
Category Entries:
Unknown
Low Risk
Medium Risk
High Risk
Patient Unable To Answer
Patient Declined
8 SDOH_INTERPRETATION VARCHAR No
This item stores the free text description of the concern for a social driver entry.
9 SDOH_NAME VARCHAR No
This item stores the name of a social driver entry.
10 SDOH_DOM_CONFIG_ID_RECORD_NAME VARCHAR No
The name of the social driver domain configuration record.
11 SDOH_ASMNT_IDENTIFIER VARCHAR No
This item stores the reference ID of the assessment this social driver entry was created from.
12 SDOH_EVENT_IDENT VARCHAR No
This item stores the ID of the event that is associated with an SDOH entry. In cases where there are multiple encounters that link to an SDOH entry, the earliest encounter is represented here.