DOCS_RCVD_SOCIAL_HX

Description:

This table contains discrete social history items.

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
	This item stores the Received Document record ID.
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	SOH_REF_ID	VARCHAR	No
	This item stores the unique reference identifier associated with the social history.
6	SOH_TYPE_ID_C_NAME	VARCHAR	No
	This item stores the type of current social history information. May contain organization-specific values: No Category Entries: Other Smoking Status Tobacco Use Cigarette Packs Per Day Cigarette Pack Years Tobacco Cessation Sexually Active Pregnancy Smokeless Status Social Connections Phone Social Connections Get Together Social Connections Church Social Connections Meetings Social Connections Membership Physical Activity DPW Physical Activity MPS Stress Education Financial IPV Emotional IPV Fear IPV Sexual Abuse IPV Physical Abuse Alcohol Frequency Alcohol Std Drinks Alcohol Binge Social Connections Living Tobacco Comment Alcohol Comment Food Worry Food Scarcity Transport Med Transport Non-Med Birth Control Sexual Partner History of Alcohol Use Alcoholic Drinks Per Day Substance Use Status Abused Substance Frequency of Drug Misuse Travel History Communicable Disease Exposure Housing Unable to Pay Housing Places Lived Housing Homeless Last Year Sexual Orientation Gender Identity
7	SOH_START_DATE	DATETIME	No
	This item stores the start date of social history information.
8	SOH_END_DATE	DATETIME	No
	This item stores the end date of social history information.
9	SOH_CODE_NAME	VARCHAR	No
	This item stores the name of code which is associated with social history information.
10	SOH_SMOK_STATUS_C_NAME	VARCHAR	No
	This item stores the smoking status information within social history. May contain organization-specific values: No Category Entries: Every Day Some Days Smoker, Current Status Unknown Former Never Never Assessed Passive Smoke Exposure - Never Smoker Unknown Heavy Smoker Light Smoker
11	SOH_TOBACCO_TYPE_C_NAME	VARCHAR	No
	This item stores the tobacco types information within social history. May contain organization-specific values: Yes Category Entries: Cigarettes Pipe Cigars Snuff Chew
12	SOH_PREG_EDD_DATE	DATETIME	No
	This item stores the estimated date of delivery within social history.
13	SOH_VALUE	VARCHAR	No
	This item stores the value string of social history information.
14	SOH_SEX_ACTIVE_C_NAME	VARCHAR	No
	This item stores the sexually active status within social history. May contain organization-specific values: No Category Entries: Yes Never Not Asked Not Currently Defer
15	SOH_SOURCE_DXR_CSN	NUMERIC	No
	The unique contact serial number (CSN) of the received document that contains this this social history information.
16	SOH_SMOKELESS_C_NAME	VARCHAR	No
	This item stores smokeless tobacco use information within social history. May contain organization-specific values: No Category Entries: Current Former Never Unknown
17	SOH_RECORDED_DATE	DATETIME	No
	This item stores the recorded date of social history information.
18	SOH_TRAVEL_GEO_REGION_ID	NUMERIC	No
	The geographic region to which the patient has traveled associated with this social history.
19	SOH_TRAVEL_GEO_REGION_ID_GEO_REGION_NAME	VARCHAR	No
	The record name for the geographical region record.