SOCIAL_HX_ALC_USE

Description:

The SOCIAL_HX_ALC_USE table contains social alcohol history data entered in clinical system patient encounters. Note: Typically, only the most recent social history data for a patient is extracted. However, you may elect to extract all social history contacts if you wish. In this case, since one patient encounter may contain multiple social history contacts, each contact is uniquely identified by a combination of the patient encounter serial number and a line number.

Primary Key

Column Name	Ordinal Position
PAT_ENC_CSN_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	PAT_ENC_CSN_ID	NUMERIC	No
	A unique serial number for this encounter. This number is unique across all patients and encounters in the system.
2	LINE	INTEGER	No
	The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
3	CONTACT_DATE	DATETIME	No
	The contact date on which the history information was collected.
4	ALCOHOL_DRINKS_WK	VARCHAR	No
	Stores the alcohol history of drinks per week.
5	HX_DRINK_TYPES_C_NAME	VARCHAR	No
	Stores the type of alcohol consumed for alcohol history. May contain organization-specific values: Yes Category Entries: Glasses of wine Cans of beer Shots of liquor Drinks containing 0.5 oz of alcohol Standard drinks or equivalent