2014 Health Center Patient Survey Dashboard User Manual
Data File Variables
All prevalence estimates presented by the dashboard are calculated using data from the 2014 Health Center Patient Survey’s public use data file. The tables below present the rows and outcomes available in the dashboard, along with their corresponding variables from the data file. You can refer to the user manual (PDF - 2 MB) for details on the construction of the data file variables.
You can consider legitimate skips and responses of “Refused” or “Don’t Know” as missing data for the purposes of the dashboard. These values in the data file variables were excluded when defining the dashboard’s row and outcome variables and performing dashboard calculations.
Table 3: Rows available in the dashboard and their corresponding public use data file (PUF) variables
|
Dashboard Row |
PUF Variable |
PUF Variable Level(s) |
|---|---|---|
|
Age: 0-17 |
agecat |
1 (0-17) |
|
Age: 18-44 |
agecat |
2 (18-44) |
|
Age: 45-64 |
agecat |
3 (45-64) |
|
Age: 65+ |
agecat |
4 (65-74 Years), 5 (75 Years and Over) |
|
Gender: Male |
edit_gen |
1 (Male) |
|
Gender: Female |
edit_gen |
2 (Female) |
|
Race/ethnicity: Hispanic |
final_race |
5 (Hispanic) |
|
Race/ethnicity: Non-Hispanic White |
final_race |
1 (Non-Hispanic White) |
|
Race/ethnicity: Non-Hispanic Black |
final_race |
2 (Non-Hispanic Black) |
|
Race/ethnicity: Non-Hispanic Other |
final_race |
3 (Non-Hispanic Asian), 4 (Non-Hispanic Other) |
|
Language at home: English |
INT4 |
2 (English) |
|
Language at home: Other |
INT4 |
1 (Other) |
|
Education: Less than HS |
Education |
1 (Less than HS) |
|
Education: HS |
Education |
2 (HS) |
|
Education: More than HS |
Education |
3 (More than HS) |
|
Marital status: Married or partner |
DMO9 |
1 (Married), 2 (Have a Domestic Partner) |
|
Marital status: Formerly married |
DMO9 |
3 (Widowed), 4 (Divorced), 5 (Separated) |
|
Marital status: Never married |
DMO9 |
6 (Never married) |
|
Urban or rural: Urban |
urban |
1 (Urban) |
|
Urban or rural: Rural |
urban |
2 (Rural) |
|
Federal poverty level: 0-100% |
fpl |
1 (0-100%) |
|
Federal poverty level: 101-138% |
fpl |
2 (101-138%) |
|
Federal poverty level: 139-199% |
fpl |
3 (139-199%) |
|
Federal poverty level: 200+% |
fpl |
4 (200% to 299% Fpl), 5 (300% to 399% Fpl), 6 (400% or More Than Fpl) |
| Health insurance: Insured | Insured | 1 (Insured) |
| Health insurance: Uninsured | Insured | 2 (Uninsured) |
|
Household size: 1 person |
numper |
1 (1 person) |
|
Household size: 2 people |
numper |
2 (2 people) |
|
Household size: 3+ people |
numper |
3 (3-5), 4 (6 or More) |
Table 4: Outcomes available in the dashboard and their corresponding public use data file (PUF) variables
|
Dashboard Outcome |
Category |
PUF Variable |
PUF Variable Level(s) |
Notes |
|
Needed medical care in the past year |
Access to Medical Care |
MED1 |
1 (Yes) |
|
|
Delayed in getting medical care in the past year |
Access to Medical Care |
MED5 |
1 (Yes) |
|
|
Unable to get medical care in the past year |
Access to Medical Care |
MED2 |
1 (Yes) |
|
|
Ever told have asthma |
Asthma |
CON11 |
1 (Yes) |
|
|
Currently have asthma |
Asthma |
CON11a |
1 (Yes) |
|
|
Had asthma attack in the past year |
Asthma |
CON11b |
1 (Yes) |
|
|
Ever taken course on how to manage asthma |
Asthma |
FOLL_CONF4f |
1 (Yes) |
|
|
Ever taught how to respond to asthma episodes by health professional |
Asthma |
FOLL_CONF4h |
1 (Yes) |
|
|
Been in hospital in the past year because of asthma |
Asthma |
FOLL_CONF4a |
1 (Yes) |
|
|
Ever tested for HPV |
Cancer Screening |
CAN1b1 |
1 (Yes) |
|
|
Had HPV test in the past 3 years |
Cancer Screening |
CAN1b2_r |
1 (Less Than a Year Ago), 2 (1 Year but Less Than 2 Years Ago), 3 (2 Years but Less Than 3 Years Ago) |
Time intervals are collapsed based on USPSTF cancer screening guidelines. |
|
Ever had Pap smear |
Cancer Screening |
CAN1 |
1 (Yes) |
|
|
Had Pap smear in the past 3 years |
Cancer Screening |
CAN1a |
1 (Less Than a Year Ago), 2 (1 Year but Less Than 2 Years Ago), 3 (2 Years but Less Than 3 Years Ago) |
Time intervals are collapsed based on USPSTF cancer screening guidelines. |
|
Had last Pap smear at health center |
Cancer Screening |
CAN1a1 |
1 (Yes) |
|
|
Health center staff suggested Pap smear |
Cancer Screening |
CAN2a |
1 (Yes) |
|
|
Ever had mammogram |
Cancer Screening |
CAN3 |
1 (Yes) |
|
|
Had mammogram in the past 2 years |
Cancer Screening |
CAN3a |
1 (Less Than a Year Ago), 2 (1 Year but Less Than 2 Years Ago) |
Time intervals are collapsed based on USPSTF cancer screening guidelines. |
|
Had last mammogram at health center |
Cancer Screening |
CAN3a1 |
1 (Yes) |
|
|
Health center staff suggested mammogram |
Cancer Screening |
CAN3h |
1 (Yes) |
|
|
Needed followup after mammogram |
Cancer Screening |
CAN3c |
1 (Yes) |
|
|
Ever had colonoscopy |
Cancer Screening |
CAN4 |
1 (Yes) |
|
|
Had colonoscopy in the past 10 years |
Cancer Screening |
CAN4a |
1 (Less Than a Year Ago), 2 (1 Year but Less Than 2 Years Ago), 3 (2 Years but Less Than 3 Years Ago), 4 (3 Years but Less Than 5 Years Ago), 5 (5 Years but Less Than 10 Years Ago) |
Time intervals are collapsed based on USPSTF cancer screening guidelines. |
|
Needed followup after colonoscopy |
Cancer Screening |
CAN4d |
1 (Yes) |
|
|
Health center staff suggested colonoscopy |
Cancer Screening |
CAN4i |
1 (Yes) |
|
|
Ever had fecal occult blood test |
Cancer Screening |
CAN5 |
1 (Yes) |
|
|
Had fecal occult blood test in the past year |
Cancer Screening |
CAN5a |
1 (Less Than 1 Year Ago) |
Time intervals are collapsed based on USPSTF cancer screening guidelines. |
|
Health center provided blood stool home test kit |
Cancer Screening |
CAN5a1 |
1 (Yes) |
|
|
Needed followup after fecal occult blood test |
Cancer Screening |
CAN5b |
1 (Yes) |
|
|
Ever told have high cholesterol |
Cardiovascular |
CON13b |
1 (Yes) |
|
|
Doctor suggested to reduce high fat foods to control high cholesterol |
Cardiovascular |
FOLL_CON22a |
1 (Yes) |
|
|
Doctor suggested controlling weight to reduce high cholesterol |
Cardiovascular |
FOLL_CON22b |
1 (Yes) |
|
|
Doctor suggested exercise to reduce high cholesterol |
Cardiovascular |
FOLL_CON22c |
1 (Yes) |
|
|
Doctor prescribed medication to reduce high cholesterol |
Cardiovascular |
FOLL_CON22d |
1 (Yes) |
|
|
Needed dental care in the past year |
Dental Care |
DEN1 |
1 (Yes) |
|
|
Delayed in getting dental care in the past year |
Dental Care |
DEN6 |
1 (Yes) |
|
|
Unable to get needed dental care in the past year |
Dental Care |
DEN2 |
1 (Yes) |
|
|
Ever had tongue exam for oral cancer |
Dental Care |
DEN10b |
1 (Yes) |
|
|
Ever had neck exam for oral cancer |
Dental Care |
DEN10c |
1 (Yes) |
|
|
Had oral cancer exam in the past year |
Dental Care |
DEN10d |
1 (Within Past Year) |
|
|
Have lost all permanent teeth |
Dental Care |
DEN14 |
1 (All of Your Adult Teeth) |
|
|
Have lost some permanent teeth |
Dental Care |
DEN14 |
2 (Some of Your Adult Teeth) |
|
|
Had missing teeth replaced |
Dental Care |
DEN15a |
1 (Yes) |
|
|
Overall condition of teeth and gums is good to excellent |
Dental Care |
DEN16a |
1 (Excellent), 2 (Very Good), 3 (Good) |
|
|
Overall condition of dentures is good to excellent |
Dental Care |
DEN16b |
1 (Excellent), 2 (Very Good), 3 (Good) |
|
|
Quality of health center dental services is good to best |
Dental Care |
DEN12_R |
4 (Good) |
|
|
Ever told have diabetes (other than during pregnancy) |
Diabetes |
CON12 |
1 (Yes) |
|
|
Currently taking insulin |
Diabetes |
FOLL_CONF5 |
1 (Yes) |
To distinguish temporary from long-term/chronic diabetes, patients with diabetes only during pregnancy are recoded to missing. |
|
Currently taking diabetic pills |
Diabetes |
FOLL_CONF5a |
1 (Yes) |
To distinguish temporary from long-term/chronic diabetes, patients with diabetes only during pregnancy are recoded to missing. |
|
Eye exam in the past year |
Diabetes |
FOLL_CONF5e4a |
1 (Yes) |
To distinguish temporary from long-term/chronic diabetes, patients with diabetes only during pregnancy are recoded to missing. |
|
Foot exam in the past year |
Diabetes |
FOLL_CONF5e4b |
1 (Yes) |
To distinguish temporary from long-term/chronic diabetes, patients with diabetes only during pregnancy are recoded to missing. |
|
Ever tested for HIV |
HIV Testing |
HTG1 |
1 (Yes) |
|
|
Ever received HIV test results |
HIV Testing |
HTG1a1 |
1 (Yes) |
|
|
Health center professional ever suggested HIV test |
HIV Testing |
HTG3 |
1 (Yes) |
|
|
Health center professional discussed HIV risk reduction |
HIV Testing |
HTG4 |
1 (Yes) |
|
|
Saw health professional 1-3 times in the past year |
Health Center Services |
HEA1_R |
1 (1 Time), 2 (2 Times), 3 (3 Times) |
|
|
Saw health professional 4-7 times in the past year |
Health Center Services |
HEA1_R |
4 (4 Times), 5 (5 Times), 6 (6 Times), 7 (7 Times) |
|
|
Saw health professional 8+ times in the past year |
Health Center Services |
HEA1_R |
8 (8 Times), 9 (9 Times), 10 (10 Times), 11 (11 or More Times) |
|
|
Saw health professional at health center 1-3 times in the past year |
Health Center Services |
HEA2_R |
1 (1 Time), 2 (2 Times), 3 (3 Times) |
|
|
Saw health professional at health center 4-7 times in the past year |
Health Center Services |
HEA2_R |
4 (4 Times), 5 (5 Times), 6 (6 Times), 7 (7 Times) |
|
|
Saw health professional at health center 8+ times in the past year |
Health Center Services |
HEA2_R |
8 (8 Times), 9 (9 Times), 10 (10 Times), 11 (11 or More Times) |
|
|
Referred to specialist in the past year |
Health Center Services |
HEA2a |
1 (Yes) |
|
|
Doctor speaks to patient in English |
Health Center Services |
HEA6_Up_R |
1 (English) |
|
|
Doctor speaks to patient in Spanish |
Health Center Services |
HEA6_Up_R |
2 (Spanish) |
|
|
Needed translator during appointment |
Health Center Services |
HEA6a |
1 (Yes) |
|
|
Health center ever helped get public assistance |
Health Center Services |
HEA7b |
1 (Yes) |
|
|
Health center ever helped with transportation to appointment |
Health Center Services |
HEA7c |
1 (Yes) |
|
|
Health center ever provided health education |
Health Center Services |
HEA7e_a |
1 (Yes) |
|
|
Health center ever provided counseling |
Health Center Services |
HEA7e_b |
1 (Yes) |
|
|
Health center ever provided translator |
Health Center Services |
HEA7e_c |
1 (Yes) |
|
|
Usually walk to health center |
Health Center Services |
HEA9 |
1 (Walking) |
|
|
Usually drive to health center |
Health Center Services |
HEA9 |
2 (Driving) |
|
|
Usually driven by someone else to health center |
Health Center Services |
HEA9 |
3 (Being Driven by Someone Else) |
|
|
Usually take public transportation to health center |
Health Center Services |
HEA9 |
4 (Bus, Subway or Other Public Transportation) |
|
|
Pays monthly premiums for health insurance |
Health Insurance |
INS22 |
1 (Yes) |
|
|
Had a time without health insurance in the past year |
Health Insurance |
INS11 |
2 (Had a Time Without Insurance) |
|
|
Health insurance pays for prescriptions |
Health Insurance |
INS3a |
1 (Yes) |
For greater clarity, only insured patients are retained for these supplemental coverage questions; uninsured patients, including those who provided responses based on past insurance, are recoded to missing. |
|
Health insurance pays for dental care |
Health Insurance |
INS3b |
1 (Yes) |
For greater clarity, only insured patients are retained for these supplemental coverage questions; uninsured patients, including those who provided responses based on past insurance, are recoded to missing. |
|
Health insurance pays for vision care |
Health Insurance |
INS3c |
1 (Yes) |
For greater clarity, only insured patients are retained for these supplemental coverage questions; uninsured patients, including those who provided responses based on past insurance, are recoded to missing. |
|
Health insurance pays for mental health care |
Health Insurance |
INS3d |
1 (Yes) |
For greater clarity, only insured patients are retained for these supplemental coverage questions; uninsured patients, including those who provided responses based on past insurance, are recoded to missing. |
|
Health is fair or poor |
Health Status |
CON1 |
4 (Fair), 5 (Poor) |
|
|
Health is better than a year ago |
Health Status |
CON1a |
1 (Better) |
|
|
Health is worse than a year ago |
Health Status |
CON1a |
2 (Worse) |
|
|
Health is about the same as a year ago |
Health Status |
CON1a |
3 (About the Same) |
|
|
Ever told have hepatitis |
Hepatitis |
CON11_hep |
1 (Yes) |
|
|
Ever told have hypertension |
Hypertension |
CON10 |
1 (Yes) |
|
|
Taking medications to control high blood pressure |
Hypertension |
CON10d |
1 (Yes) |
|
|
Doctor suggested change in eating habits to control hypertension |
Hypertension |
FOLL_CONF1a_a |
1 (Yes) |
|
|
Doctor suggested reduction of salt consumption to control hypertension |
Hypertension |
FOLL_CONF1a_b |
1 (Yes) |
|
|
Doctor suggested exercise to control hypertension |
Hypertension |
FOLL_CONF1a_c |
1 (Yes) |
|
|
Doctor suggested reduction of alcohol consumption to control hypertension |
Hypertension |
FOLL_CONF1a_d |
1 (Yes) |
|
|
Prescribed high blood pressure medication to control hypertension |
Hypertension |
FOLL_CONF2 |
1 (Yes) |
|
|
Regularly check blood pressure |
Hypertension |
FOLL_CONF3 |
1 (Yes) |
|
|
Someone in household received food stamps in the past year |
Income & Assets |
INC3a |
1 (Yes) |
|
|
Someone in household received WIC in the past year |
Income & Assets |
INC3b |
1 (Yes) |
|
|
Someone in household received TANF in the past year |
Income & Assets |
INC3c |
1 (Yes) |
|
|
Someone in household received Section 8 in the past year |
Income & Assets |
INC3d |
1 (Yes) |
|
|
Needed mental health care in the past year |
Mental Health |
MEN5 |
1 (Yes) |
|
|
Delayed in getting mental health care in the past year |
Mental Health |
MEN7 |
1 (Yes) |
|
|
Unable to get mental health care in the past year |
Mental Health |
MEN6 |
1 (Yes) |
|
|
Saw doctor for mental health care in the past year |
Mental Health |
MEN5a |
1 (Yes) |
|
|
Ever received mental health treatment or counseling |
Mental Health |
MEN9a2 |
1 (Yes) |
|
|
Received mental health treatment or counseling in the past year |
Mental Health |
MEN8 |
1 (Yes) |
|
|
Symptoms indicative of mental distress based on Kessler 6 scale |
Mental Health |
MEN1A, MEN1B, MEN1C, MEN1D, MEN1E, MEN1F |
See note |
|
|
Symptoms indicative of serious mental illness based on Kessler 6 scale |
Mental Health |
MEN1A, MEN1B, MEN1C, MEN1D, MEN1E, MEN1F |
See note |
|
|
Ever diagnosed with generalized anxiety |
Mental Health |
MEN2b |
1 (Yes) |
|
|
Ever diagnosed with panic disorder |
Mental Health |
MEN2c |
1 (Yes) |
|
|
Ever told have a weight problem |
Obesity |
CON7 |
1 (Yes) |
|
|
Doctor ever explained weight management |
Obesity |
CON8 |
1 (Yes) |
|
|
Tried to lose weight in the past year |
Obesity |
CON6b |
1 (Yes) |
|
|
Always or usually got quick appointment for routine care |
Patient Experience at Health Center |
HEA18 |
3 (Usually), 4 (Always) |
|
|
Always or usually got quick appointment for care needed right away |
Patient Experience at Health Center |
HEA15 |
3 (Usually), 4 (Always) |
|
|
Always or usually got a same day answer when called with question |
Patient Experience at Health Center |
HEA23 |
3 (Usually), 4 (Always) |
|
|
Always or usually got a same day answer when called with question after hours |
Patient Experience at Health Center |
HEA25 |
3 (Usually), 4 (Always) |
|
|
Received appointment reminders |
Patient Experience at Health Center |
HEA26 |
1 (Yes) |
|
|
Were always or usually seen within 15 minutes of appointment time |
Patient Experience at Health Center |
HEA27 |
3 (Usually), 4 (Always) |
|
|
Provider always or usually listens carefully |
Patient Experience at Health Center |
HEA29 |
3 (Usually), 4 (Always) |
|
|
Medical information from doctor was always or usually easy to understand |
Patient Experience at Health Center |
HEA31 |
3 (Usually), 4 (Always) |
|
|
Doctor always or usually knew the patient's important medical history |
Patient Experience at Health Center |
HEA32 |
3 (Usually), 4 (Always) |
|
|
Doctor always or usually showed respect for what the patient said |
Patient Experience at Health Center |
HEA33 |
3 (Usually), 4 (Always) |
|
|
Doctor always or usually spent enough time with the patient |
Patient Experience at Health Center |
HEA34 |
3 (Usually), 4 (Always) |
|
|
Health professional always or usually followed up with results of tests |
Patient Experience at Health Center |
HEA36 |
3 (Usually), 4 (Always) |
|
|
Receptionists were always or usually helpful |
Patient Experience at Health Center |
HEA51 |
3 (Usually), 4 (Always) |
|
|
Receptionists always or usually treated patient with respect |
Patient Experience at Health Center |
HEA52 |
3 (Usually), 4 (Always) |
|
|
Quality of health professionals at health center is good to best |
Patient Experience at Health Center |
HEA41_R |
3 (Good), 4 (Best) |
|
|
Physically active for 1 hour on 0 days in the past week |
Physical Activity |
CON9o |
0 (0 Days) |
|
|
Physically active for 1 hour on 1-4 days in the past week |
Physical Activity |
CON9o |
1 (1 Day), 2 (2 Days), 3 (3 Days), 4 (4 Days) |
|
|
Physically active for 1 hour on 5-7 days in the past week |
Physical Activity |
CON9o |
5 (5 Days), 6 (6 Days), 7 (7 Days) |
|
|
Ever been pregnant |
Pregnancy |
CON2 |
1 (Yes) |
|
|
Been pregnant in the past 3 years |
Pregnancy |
PRG1 |
1 (Yes) |
|
|
Needed prescription medication in the past year |
Prescription Medications |
PRS1 |
1 (Yes) |
|
|
Delayed in getting prescription medication in the past year |
Prescription Medications |
PRS3 |
1 (Yes) |
|
|
Unable to get prescription medication in the past year |
Prescription Medications |
PRS2 |
1 (Yes) |
|
|
Take prescription medication regularly |
Prescription Medications |
PRS5 |
1 (Yes) |
|
|
Get prescriptions filled at the health center |
Prescription Medications |
PRS6 |
1 (Fill Prescriptions at This Health Center), 2 (Fill Some Prescriptions at This Health Center and Fill Some Prescriptions Elsewhere) |
|
|
Had physical exam in the past 2 years |
Routine Care |
ROU10 |
2 (Less Than 1 Year Ago), 3 (At Least 1 Year but Less Than 2 Years) |
|
|
Ever had pneumonia shot |
Routine Care |
ROU8 |
1 (Yes) |
|
|
Ever had blood-lead test |
Routine Care |
ROU14 |
1 (Yes) |
|
|
Visited emergency room visit in the past year |
Routine Care |
ROU2_R |
1 (1 Time), 2 (2 Times), 3 (3 Times), 4 (4 Times), 5 (5 Times), 6 (6 Times), 7 (7 or More Times) |
|
|
Hospitalized overnight in the past year |
Routine Care |
ROU3 |
1 (Yes) |
|
|
Wanted to stop smoking in the past 12 months |
Substance Use |
SUB1f |
1 (Yes) |
|
|
Ever used smokeless tobacco |
Substance Use |
SUB1g |
1 (Yes) |
|
|
Currently use smokeless tobacco |
Substance Use |
SUB1h1 |
1 (Every Day), 2 (Some Days) |
|
|
Health professional recommended quitting tobacco products in the past year |
Substance Use |
SUB1k |
1 (Yes) |
|
|
Ever used alcohol |
Substance Use |
SUB2a |
1 (Yes) |
|
|
Used alcohol in the past 3 months |
Substance Use |
SUB2a_a |
1 (Once or Twice), 2 (Monthly), 3 (Weekly), 4 (Daily or Almost Daily) |
|
|
Health professional asked about alcohol use in the past year |
Substance Use |
SUB9a |
1 (Yes) |
|
|
Ever used marijuana |
Substance Use |
SUB2b |
1 (Yes) |
|
|
Used marijuana in the past 3 months |
Substance Use |
SUB2b_a |
1 (Once or Twice), 2 (Monthly), 3 (Weekly), 4 (Daily or Almost Daily) |
