SOCIAL_HX
Description:
The SOCIAL_HX table contains social history data for each history encounter stored in your system. This table has one row per history encounter.

Primary Key
Column Name Ordinal Position
PAT_ENC_CSN_ID 1

Column Information
Name Type Discontinued?
1 CONTACT_DATE DATETIME No
The date of this contact in calendar format.
2 CIGARETTES_YN VARCHAR No
Y if the patient uses cigarettes. N if the patient does not. NOTE: Uses the EPIC_IN_ITEM function to determine if a given value exists in a multiple response item. If the category value for this selection exists in the multiple response item, then it returns "Y", otherwise it returns "N".
May contain organization-specific values: Yes
Category Entries:
Cigarettes
Pipe
Cigars
Snuff
Chew
3 PIPES_YN VARCHAR No
Y if the patient smokes a pipe. N if the patient does not. NOTE: Uses the EPIC_IN_ITEM function to determine if a given value exists in a multiple response item. If the category value for this selection exists in the multiple response item, then it returns "Y", otherwise it returns "N".
The category values for this column were already listed for column: CIGARETTES_YN
4 CIGARS_YN VARCHAR No
Y if the patient uses cigars. N if the patient does not. NOTE: Uses the EPIC_IN_ITEM function to determine if a given value exists in a multiple response item. If the category value for this selection exists in the multiple response item, then it returns "Y", otherwise it returns "N".
The category values for this column were already listed for column: CIGARETTES_YN
5 SNUFF_YN VARCHAR No
Y if the patient uses snuff. N if the patient does not. NOTE: Uses the EPIC_IN_ITEM function to determine if a given value exists in a multiple response item. If the category value for this selection exists in the multiple response item, then it returns "Y", otherwise it returns "N".
The category values for this column were already listed for column: CIGARETTES_YN
6 CHEW_YN VARCHAR No
Y if the patient uses chewing tobacco. N if the patient does not. NOTE: Uses the EPIC_IN_ITEM function to determine if a given value exists in a multiple response item. If the category value for this selection exists in the multiple response item, then it returns "Y", otherwise it returns "N".
The category values for this column were already listed for column: CIGARETTES_YN
7 ALCOHOL_OZ_PER_WK VARCHAR No
The fluid ounces of alcohol the patient consumes per week.
8 ALCOHOL_COMMENT VARCHAR No
Free-text comments regarding the patient’s use of alcohol.
9 IV_DRUG_USER_YN VARCHAR No
Y if the patient is an IV drug user. N if the patient is not. NOTE: Uses the EPIC_IN_ITEM function to determine if a given value exists in a multiple response item. If the category value for this selection exists in the multiple response item, then it returns "Y", otherwise it returns "N".
May contain organization-specific values: Yes
Category Entries:
IV
10 ILLICIT_DRUG_FREQ VARCHAR No
The times per week the patient uses or used illicit drugs.
11 ILLICIT_DRUG_CMT VARCHAR No
Free-text comments regarding the patient’s use of illicit drugs.
12 FEMALE_PARTNER_YN VARCHAR No
Y if the patient has a female sexual partner. N if the patient does not. NOTE: Uses the EPIC_IN_ITEM function to determine if a given value exists in a multiple response item. If the category value for this selection exists in the multiple response item, then it returns "Y", otherwise it returns "N".
May contain organization-specific values: Yes
Category Entries:
Female
Male
13 MALE_PARTNER_YN VARCHAR No
Y if the patient has a male sexual partner. N if the patient does not. NOTE: Uses the EPIC_IN_ITEM function to determine if a given value exists in a multiple response item. If the category value for this selection exists in the multiple response item, then it returns "Y", otherwise it returns "N".
The category values for this column were already listed for column: FEMALE_PARTNER_YN
14 CONDOM_YN VARCHAR No
Y if the patient uses a condom during sexual activity. N if the patient does not. NOTE: Uses the EPIC_IN_ITEM function to determine if a given value exists in a multiple response item. If the category value for this selection exists in the multiple response item, then it returns "Y", otherwise it returns "N".
May contain organization-specific values: Yes
Category Entries:
Condom
Pill
Diaphragm
I.U.D.
Surgical
Spermicide
Implant
Rhythm
Injection
Sponge
Inserts
Abstinence
15 PILL_YN VARCHAR No
Y if the patient uses birth control pills. N if the patient does not. NOTE: Uses the EPIC_IN_ITEM function to determine if a given value exists in a multiple response item. If the category value for this selection exists in the multiple response item, then it returns "Y", otherwise it returns "N".
The category values for this column were already listed for column: CONDOM_YN
16 DIAPHRAGM_YN VARCHAR No
Y if the patient uses a diaphragm. N if the patient does not. NOTE: Uses the EPIC_IN_ITEM function to determine if a given value exists in a multiple response item. If the category value for this selection exists in the multiple response item, then it returns "Y", otherwise it returns "N".
The category values for this column were already listed for column: CONDOM_YN
17 IUD_YN VARCHAR No
Y if the patient uses an IUD. N if the patient does not. NOTE: Uses the EPIC_IN_ITEM function to determine if a given value exists in a multiple response item. If the category value for this selection exists in the multiple response item, then it returns "Y", otherwise it returns "N".
The category values for this column were already listed for column: CONDOM_YN
18 SURGICAL_YN VARCHAR No
Y if the patient uses a surgical method of birth control such as hysterectomy, vasectomy, or tubal-ligation. N if the patient does not. NOTE: Uses the EPIC_IN_ITEM function to determine if a given value exists in a multiple response item. If the category value for this selection exists in the multiple response item, then it returns "Y", otherwise it returns "N".
The category values for this column were already listed for column: CONDOM_YN
19 SPERMICIDE_YN VARCHAR No
Y if the patient uses spermicide. N if the patient does not. NOTE: Uses the EPIC_IN_ITEM function to determine if a given value exists in a multiple response item. If the category value for this selection exists in the multiple response item, then it returns "Y", otherwise it returns "N".
The category values for this column were already listed for column: CONDOM_YN
20 IMPLANT_YN VARCHAR No
Y if the patient uses an implant as a form of birth control. N if the patient does not. NOTE: Uses the EPIC_IN_ITEM function to determine if a given value exists in a multiple response item. If the category value for this selection exists in the multiple response item, then it returns "Y", otherwise it returns "N".
The category values for this column were already listed for column: CONDOM_YN
21 RHYTHM_YN VARCHAR No
Y if the patient uses the rhythm method as a form of birth control. N if the patient does not. NOTE: Uses the EPIC_IN_ITEM function to determine if a given value exists in a multiple response item. If the category value for this selection exists in the multiple response item, then it returns "Y", otherwise it returns "N".
The category values for this column were already listed for column: CONDOM_YN
22 INJECTION_YN VARCHAR No
Y if the patient uses an injection as a form of birth control. N if the patient does not. NOTE: Uses the EPIC_IN_ITEM function to determine if a given value exists in a multiple response item. If the category value for this selection exists in the multiple response item, then it returns "Y", otherwise it returns "N".
The category values for this column were already listed for column: CONDOM_YN
23 SPONGE_YN VARCHAR No
Y if the patient uses a sponge as a form of birth control. N if the patient does not. NOTE: Uses the EPIC_IN_ITEM function to determine if a given value exists in a multiple response item. If the category value for this selection exists in the multiple response item, then it returns "Y", otherwise it returns "N".
The category values for this column were already listed for column: CONDOM_YN
24 INSERTS_YN VARCHAR No
Y if the patient uses inserts as a form of birth control. N if the patient does not. NOTE: Uses the EPIC_IN_ITEM function to determine if a given value exists in a multiple response item. If the category value for this selection exists in the multiple response item, then it returns "Y", otherwise it returns "N".
The category values for this column were already listed for column: CONDOM_YN
25 ABSTINENCE_YN VARCHAR No
Y if the patient practices abstinence. N if the patient does not. NOTE: Uses the EPIC_IN_ITEM function to determine if a given value exists in a multiple response item. If the category value for this selection exists in the multiple response item, then it returns "Y", otherwise it returns "N".
The category values for this column were already listed for column: CONDOM_YN
26 SEX_COMMENT VARCHAR No
Free-text comments regarding the patient’s sexual activity.
27 YEARS_EDUCATION VARCHAR No
The number of years of education the patient has completed. Note: This is a free text field.
28 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.
29 TOB_SRC_C_NAME VARCHAR No
Source for Tobacco History
May contain organization-specific values: Yes
Category Entries:
Provider
Patient
Parent
Legal Guardian
Proxy User
Automatically reconciled from patient
Automatically reconciled from proxy
30 ALCOHOL_SRC_C_NAME VARCHAR No
This columns stores the person (e.g. provider, patient, legal guardian) who provided alcohol use information for this encounter.
The category values for this column were already listed for column: TOB_SRC_C_NAME
31 DRUG_SRC_C_NAME VARCHAR No
This columns stores the person (e.g. provider, patient, legal guardian) who provided illicit drug use information for this encounter.
The category values for this column were already listed for column: TOB_SRC_C_NAME
32 SEX_SRC_C_NAME VARCHAR No
This columns stores the person (e.g. provider, patient, legal guardian) who provided sexual activity information for this encounter.
The category values for this column were already listed for column: TOB_SRC_C_NAME
33 HX_LNK_ENC_CSN NUMERIC No
The Contact Serial Number of the encounter in which the history was created/edited. If the history was created/edited outside of the context of an encounter, then this column will be blank.
34 ALCOHOL_USE_C_NAME VARCHAR No
The category value associated with the patient's alcohol use. Data may include, Yes, No, or Not Asked.
May contain organization-specific values: No
Category Entries:
Yes
No
Not Asked
Defer
Not Currently
Never
35 ILL_DRUG_USER_C_NAME VARCHAR No
The category value associated with the patient's use of illicit drugs. Data may include, Yes, No, or Not Asked.
May contain organization-specific values: No
Category Entries:
Yes
No
Not Asked
Defer
Not Currently
Never
36 SEXUALLY_ACTIVE_C_NAME VARCHAR No
The category value associated with the patient's sexual activity. Data may include Yes, No, Not Asked, or Not Now
May contain organization-specific values: No
Category Entries:
Yes
Never
Not Asked
Not Currently
Defer
37 TOBACCO_USER_C_NAME VARCHAR No
The category value associated with the patient's tobacco use. Data may include, Yes, Never, Not Asked or Quit.
May contain organization-specific values: No
Category Entries:
Yes
Never
Not Asked
Quit
Passive
38 SMOKELESS_TOB_USE_C INTEGER No
Stores the patient's usage of smokeless tobacco. Data may include, Current User, Former User, Never Used or Unknown.
39 SMOKELESS_QUIT_DATE DATETIME No
The date on which the patient quit using smokeless tobacco.
40 SMOKING_TOB_USE_C INTEGER No
Stores the patient's usage of smoking tobacco. Data may include, Current Everyday Smoker, Current Some Day Smoker, Former Smoker, Never Smoker, Unknown If Ever Smoked or Smoker, Current Status Unknown.
41 UNKNOWN_FAM_HX_YN VARCHAR No
Y if the patient's family history is unknown by the patient. N otherwise.
May contain organization-specific values: No
Category Entries:
No
Yes
42 EDU_LEVEL_C_NAME VARCHAR No
This item stores responses to the social drivers of health question about level of education. Response is categorical, and corresponds to highest level of school attended.
May contain organization-specific values: No
Category Entries:
1st grade
2nd grade
3rd grade
4th grade
5th grade
6th grade
7th grade
8th grade
9th grade
10th grade
11th grade
12th grade
High school graduate
GED or equivalent
Associate degree: occupational, technical, or vocational program
Associate degree: academic program
Bachelor's degree (e.g., BA, AB, BS)
Master's degree (e.g., MA, MS, MEng, MEd, MSW, MBA)
Professional school degree (e.g., MD, DDS, DVM, JD)
Doctorate
Some college, no degree
Never attended school
Patient refused
Not asked
43 FIN_RESOURCE_STRAIN_C_NAME VARCHAR No
This item stores responses to the social drivers of health question about financial resource strain.
May contain organization-specific values: No
Category Entries:
Very hard
Hard
Somewhat hard
Not very hard
Not hard at all
Patient unable to answer
Patient declined
Not asked
44 IPV_EMOTIONAL_ABUSE_C_NAME VARCHAR No
This item stores responses to the social drivers of health question about emotional abuse from an intimate partner.
May contain organization-specific values: No
Category Entries:
Yes
No
Patient unable to answer
Patient declined
Not asked
45 IPV_FEAR_C_NAME VARCHAR No
This item stores responses to the social drivers of health question about fear of an intimate partner.
May contain organization-specific values: No
Category Entries:
Yes
No
Patient unable to answer
Patient declined
Not asked
46 IPV_SEXUAL_ABUSE_C_NAME VARCHAR No
This item stores responses to the social drivers of health question about sexual abuse from an intimate partner.
May contain organization-specific values: No
Category Entries:
Yes
No
Patient unable to answer
Patient declined
Not asked
47 IPV_PHYSICAL_ABUSE_C_NAME VARCHAR No
This item stores responses to the social drivers of health question about physical abuse from an intimate partner.
May contain organization-specific values: No
Category Entries:
Yes
No
Patient unable to answer
Patient declined
Not asked
48 ALCOHOL_FREQ_C_NAME VARCHAR No
This item stores responses for the social drivers of health question about frequency of drinking alcohol.
May contain organization-specific values: No
Category Entries:
Never
Monthly or less
2-4 times a month
2-3 times a week
4 or more times a week
Patient unable to answer
Patient declined
Not asked
49 ALCOHOL_DRINKS_PER_DAY_C_NAME VARCHAR No
This item stores responses for the social drivers of health questions about number of standard drinks consumed in a typical day.
May contain organization-specific values: No
Category Entries:
Patient does not drink
1 or 2
3 or 4
5 or 6
7 to 9
10 or more
Patient unable to answer
Patient declined
Not asked
50 ALCOHOL_BINGE_C_NAME VARCHAR No
This item stores responses for the social drivers of health questions about binge drinking.
May contain organization-specific values: No
Category Entries:
Never
Less than monthly
Monthly
Weekly
Daily or almost daily
Patient unable to answer
Patient declined
Not asked
51 LIVING_W_SPOUSE_C_NAME VARCHAR No
This item stores the response to social drivers of health question about whether or not the patient is currently living with spouse or partner.
May contain organization-specific values: No
Category Entries:
Yes
No
Married
Widowed
Divorced
Separated
Never married
Living with partner
Patient unable to answer
Patient declined
Not asked
52 DAILY_STRESS_C_NAME VARCHAR No
This item stores responses to the social drivers of health question about daily stress.
May contain organization-specific values: No
Category Entries:
Not at all
Only a little
To some extent
Rather much
Very much
Patient unable to answer
Patient declined
Not asked
53 PHONE_COMMUNICATION_C_NAME VARCHAR No
This item stores responses to the social drivers of health question about how often the patient socializes with friends or family over the phone.
May contain organization-specific values: No
Category Entries:
Never
Once a week
Twice a week
Three times a week
More than three times a week
Patient unable to answer
Patient declined
Not asked
54 SOCIALIZATION_FREQ_C_NAME VARCHAR No
This item stores responses to the social drivers of health question about how often the patient socializes with friends or family in person.
May contain organization-specific values: No
Category Entries:
Never
Once a week
Twice a week
Three times a week
More than three times a week
Patient unable to answer
Patient declined
Not asked
55 CHURCH_ATTENDANCE_C_NAME VARCHAR No
This item stores responses to the social drivers of health question about how often the patient attends religious services.
May contain organization-specific values: No
Category Entries:
Never
1 to 4 times per year
More than 4 times per year
Patient unable to answer
Patient declined
Not asked
56 CLUBMTG_ATTENDANCE_C_NAME VARCHAR No
This item stores responses to the social drivers of health question about how often the patient attends club or other organization meetings in a year.
May contain organization-specific values: No
Category Entries:
Never
1 to 4 times per year
More than 4 times per year
Patient unable to answer
Patient declined
Not asked
57 CLUB_MEMBER_C_NAME VARCHAR No
This item stores responses to the social drivers of health question about whether the patient is a member of any clubs or organizations.
May contain organization-specific values: No
Category Entries:
Yes
No
Patient unable to answer
Patient declined
Not asked
58 PHYS_ACT_DAYS_PER_WEEK_C_NAME VARCHAR No
This item stores responses to the social drivers of health question about how many days a week the patient exercises.
May contain organization-specific values: No
Category Entries:
0 days
1 day
2 days
3 days
4 days
5 days
6 days
7 days
Patient unable to answer
Patient declined
Not asked
59 PHYS_ACT_MIN_PER_SESS_C_NAME VARCHAR No
This item stores responses to the social drivers of health question about how many minutes the patient exercises on days that they exercise.
May contain organization-specific values: No
Category Entries:
0 min
10 min
20 min
30 min
40 min
50 min
60 min
70 min
80 min
90 min
100 min
110 min
120 min
130 min
140 min
150+ min
Patient unable to answer
Patient declined
Not asked
60 FOOD_INSECURITY_SCARCE_C_NAME VARCHAR No
This item stores responses to the social drivers of health question about whether or not the patient had run out of food and was not able to buy more.
May contain organization-specific values: No
Category Entries:
Never true
Sometimes true
Often true
Patient unable to answer
Patient declined
Not asked
61 FOOD_INSECURITY_WORRY_C_NAME VARCHAR No
This item stores responses to the social drivers of health question about whether the patient worried about food running out in the past year or not.
May contain organization-specific values: No
Category Entries:
Never true
Sometimes true
Often true
Patient unable to answer
Patient declined
Not asked
62 MED_TRANSPORT_NEEDS_C_NAME VARCHAR No
This item stores responses to the social drivers of health question about whether the patient had difficulty regarding transportation for medical appointments and medicine.
May contain organization-specific values: No
Category Entries:
Yes
No
Patient unable to answer
Patient declined
Not asked
63 OTHER_TRANSPORT_NEEDS_C_NAME VARCHAR No
This item stores responses to the social drivers of health question about whether the patient had difficulty regarding transportation for things other than medical appointments and medicine.
May contain organization-specific values: No
Category Entries:
Yes
No
Patient unable to answer
Patient declined
Not asked
64 SOC_PHONE_SRC_C_NAME VARCHAR No
Stores the source of entry for a patient's Social Connections Phone history.
The category values for this column were already listed for column: TOB_SRC_C_NAME
65 SOC_TOGETHER_SRC_C_NAME VARCHAR No
Stores the source of entry for a patient's Social Connections Get Together history.
The category values for this column were already listed for column: TOB_SRC_C_NAME
66 SOC_CHURCH_SRC_C_NAME VARCHAR No
Stores the source of entry for a patient's Social Connections Church history.
The category values for this column were already listed for column: TOB_SRC_C_NAME
67 SOC_MEETINGS_SRC_C_NAME VARCHAR No
Stores the source of entry for a patient's Social Connections Meetings history.
The category values for this column were already listed for column: TOB_SRC_C_NAME
68 SOC_MEMBER_SRC_C_NAME VARCHAR No
Stores the source of entry for a patient's Social Connections Membership history.
The category values for this column were already listed for column: TOB_SRC_C_NAME
69 SOC_LIVING_SRC_C_NAME VARCHAR No
Stores the source of entry for a patient's Social Connections Living history.
The category values for this column were already listed for column: TOB_SRC_C_NAME
70 PHYS_DPW_SRC_C_NAME VARCHAR No
Stores the source of entry for a patient's Physical Activity Days per Week history.
The category values for this column were already listed for column: TOB_SRC_C_NAME
71 PHYS_MPS_SRC_C_NAME VARCHAR No
Stores the source of entry for a patient's Physical Activity Minutes Per Session history.
The category values for this column were already listed for column: TOB_SRC_C_NAME
72 STRESS_SRC_C_NAME VARCHAR No
Stores the source of entry for a patient's Stress history.
The category values for this column were already listed for column: TOB_SRC_C_NAME
73 EDUCATION_SRC_C_NAME VARCHAR No
Stores the source of entry for a patient's Education history.
The category values for this column were already listed for column: TOB_SRC_C_NAME
74 FINANCIAL_SRC_C_NAME VARCHAR No
Stores the source of entry for a patient's Financial history.
The category values for this column were already listed for column: TOB_SRC_C_NAME
75 IPV_EMOTIONAL_SRC_C_NAME VARCHAR No
Stores the source of entry for a patient's Intimate Partner Violence (IPV) emotional history.
The category values for this column were already listed for column: TOB_SRC_C_NAME
76 IPV_FEAR_SRC_C_NAME VARCHAR No
Stores the source of entry for a patient's IPV Fear history.
The category values for this column were already listed for column: TOB_SRC_C_NAME
77 IPV_SEXABUSE_SRC_C_NAME VARCHAR No
Stores the source of entry for a patient's IPV Sexual Abuse history.
The category values for this column were already listed for column: TOB_SRC_C_NAME
78 IPV_PHYSABUSE_SRC_C_NAME VARCHAR No
Stores the source of entry for a patient's physical abuse history.
The category values for this column were already listed for column: TOB_SRC_C_NAME
79 ALC_FREQ_SRC_C_NAME VARCHAR No
Stores the source of entry for a patient's Alcohol Frequency history.
The category values for this column were already listed for column: TOB_SRC_C_NAME
80 ALC_STD_DRINK_SRC_C_NAME VARCHAR No
Stores the source of entry for a patient's Alcohol Standard Drinks history.
The category values for this column were already listed for column: TOB_SRC_C_NAME
81 ALC_BINGE_SRC_C_NAME VARCHAR No
Stores the source of entry for a patient's Alcohol Binge history.
The category values for this column were already listed for column: TOB_SRC_C_NAME
82 FOOD_WORRY_SRC_C_NAME VARCHAR No
Stores the source of entry for a patient's Food Worry history.
The category values for this column were already listed for column: TOB_SRC_C_NAME
83 FOOD_SCARCITY_SRC_C_NAME VARCHAR No
Stores the source of entry for a patient's Food Scarcity history.
The category values for this column were already listed for column: TOB_SRC_C_NAME
84 TRANS_MED_SRC_C_NAME VARCHAR No
Stores the source of entry for a patient's Transport Medical history.
The category values for this column were already listed for column: TOB_SRC_C_NAME
85 TRANS_NONMED_SRC_C_NAME VARCHAR No
Stores the source of entry for a patient's Transport Non-medical history.
The category values for this column were already listed for column: TOB_SRC_C_NAME
86 FAM_PAT_ADPT_PAR_1 INTEGER No
Stores the family history ID of the patient's adoptive parent. A patient can have two adoptive parents. The ID of the other parent is in FAM_PAT_ADPT_PAR_2.
87 FAM_PAT_ADPT_PAR_2 INTEGER No
Stores the family history ID of the patient's adoptive parent. A patient can have two adoptive parents. The ID of the other parent is in FAM_PAT_ADPT_PAR_1.
88 TOB_HX_ADDL_PACKYEARS NUMERIC No
Number to add to the total number of pack years calculated for the patient's tobacco history.
89 TOB_HX_SMOKE_EXPOSURE_CMT VARCHAR No
Store the comment for passive tobacco smoke exposure.
90 PASSIVE_SMOKE_EXPOSURE_C_NAME VARCHAR No
Document the patient's passive smoke exposure.
May contain organization-specific values: No
Category Entries:
Current
Past
Never
Yes
91 FAMHX_PAT_IS_ADOPTED_C_NAME VARCHAR No
The Adoption Status category ID for the patient.
May contain organization-specific values: No
Category Entries:
Yes
No
92 AVERAGE_PPD NUMERIC No
Holds the average packs per day a patient has smoked from their earliest start date to their latest quit date.