Skip Navigation  U.S. Department of Health and Human Services  www.hhs.gov
Agency for Healthcare Research Quality www.ahrq.gov
www.ahrq.gov
MEPS Home Medical Expenditure Panel Survey
Font Size:
Contact MEPS FAQ Espanol Site Map
 
S
M
L
XL
 
spacer
 :: Survey Background
 :: Workshops & Events
 :: Data Release Schedule
 :: Household
 :: Insurance/Employer
 :: Medical Provider
 :: Survey Questionnaires
 Data and Statistics
 :: Data Overview
 :: MEPS Topics
 :: Publications Search
 :: Summary Data Tables
 :: MEPSnet Query Tools
 :: Data Files
 :: Data Centers
 Communication
 :: What's New
 :: Mailing List
 :: Discussion Forum
 :: Participants' Corner

 

 

Variable Locator Tool
Variable Locator Home > View File List > View File Details
Details for File MN02_V1

Search for Variables in This File | Show in Excel Format | Show in CSV Format | Show in Rich Text Format
Select a link above to open the file with the default application or save it to disk. Saved files may be opened using multiple software options.

File Attribute Attribute Value
File Name  MN02_V1
Full Name  AHRQ2\BA002XXX\DATA\MPC02_PsIm\D122304\MNPIMP02\MN02_V1.sas7bdat
CD Volume  CD_2004
File Type  Miscellaneous Data Center File
Title  2002 MPC Medical Visits Not Eligible for MPC Collection (MN) Post-Imputation File
Description  2002 MPC Medical Visits Not Eligible for MPC Collection (MN) Post-Imputation File
Data Year(s)  2002
Records  30430
Population  2002 MPC Medical Visits Not Eligible for MPC Collection (MN) Post-Imputation sample
Status  Complete
Task Number  AH.BA002
Research Findings 
Constructed at AHRQ?  No
For Findings?  No
For Stat Brief?  No


Select the name to display variable details; select column headings to sort the list.
Name Label Category
AGE02X AGE AS OF 12/31/02 (EDITED/IMPUTED) Demographics
AGE31X AGE R31 (EDITED/IMPUTED) Demographics
AGE42X AGE R42 (EDITED/IMPUTED) Demographics
AMT1 AMOUNT PAID, FAMILY (IMPUTED)
AMT10 AMOUNT PAID, OTHER INSURANCE (IMPUTED)
AMT11 AMT PAID, UNCOLLECTED LIABILTY (IMPUTED)
AMT12 AMOUNT PAID, OTHER PRIVATE (IMPUTED)
AMT13 AMOUNT PAID, OTHER PUBLIC (IMPUTED)
AMT2 AMOUNT PAID, MEDICARE (IMPUTED)
AMT3 AMOUNT PAID, MEDICAID (IMPUTED)
AMT4 AMOUNT PAID, PRIVATE INS (IMPUTED)
AMT5 AMOUNT PAID, VETERANS (IMPUTED)
AMT6 AMOUNT PAID, TRICARE (IMPUTED)
AMT7 AMOUNT PAID, OTHER FEDERAL (IMPUTED)
AMT8 AMOUNT PAID, STATE/LOCAL GOV'T (IMPUTED)
AMT9 AMOUNT PAID, WORKERS COMP (IMPUTED)
AMTORIG ALL PAYMENTS MADE BY FAM (INCL REIMB)
ANESTH DURING THIS VISIT P RECEIVE ANESTHESIA
CCS1 CCS CONDITION CODE #1
CCS2 CCS CONDITION CODE #2
CCS3 CCS CONDITION CODE #3
CCS4 CCS CONDITION CODE #4
CCSMTCH1 HC - COLLAPSED CCS CONDITION CODE #1
CCSMTCH2 HC - COLLAPSED CCS CONDITION CODE #2
CCSMTCH3 HC - COLLAPSED CCS CONDITION CODE #3
CCSMTCH4 HC - COLLAPSED CCS CONDITION CODE #4
CHEMOTH THIS VISIT DID P HAVE CHEMOTHERAPY
COND1 HC - ICD9 CODE 1
COND2 HC - ICD9 CODE 2
COND3 HC - ICD9 CODE 3
COND4 HC - ICD9 CODE 4
DELTA1 DELTA (PRESENCE INDICATOR) FOR AMT1
DELTA10 DELTA (PRESENCE INDICATOR) FOR AMT10
DELTA2 DELTA (PRESENCE INDICATOR) FOR AMT2
DELTA3 DELTA (PRESENCE INDICATOR) FOR AMT3
DELTA4 DELTA (PRESENCE INDICATOR) FOR AMT4
DELTA5 DELTA (PRESENCE INDICATOR) FOR AMT5
DELTA6 DELTA (PRESENCE INDICATOR) FOR AMT6
DELTA7 DELTA (PRESENCE INDICATOR) FOR AMT7
DELTA8 DELTA (PRESENCE INDICATOR) FOR AMT8
DELTA9 DELTA (PRESENCE INDICATOR) FOR AMT9
DONFLG IMPUTATION DONOR FLAG
DONOR HDIMPUTE DONOR: Y/N
DONORID WESID OF DONOR
DRUGTRT THIS VST DID P HAVE TRT FOR DRUG OR ALCH
DSUMPAY FAC IMP DONOR'S SUMPAY
DTLCHRG DONOR'S TOTAL CHARGE
DUID DWELLING UNIT ID Identifiers
DUPERSID SAMPLE PERSON ID (DN+PN) FOR PUBLIC USE Identifiers
EDITLOG HC EDIT RECORD
EEG DURING THIS VISIT DID P HAVE A CATSCAN
EKG THIS VISIT DID P HAVE AN EKG OR ECG
ELSEPAY DOES R EXPECT SOMEONE ELSE TO PAY
EVNTBEGD EVENT START DATE - DAY
EVNTBEGM EVENT START DATE - MONTH
EVNTBEGY EVENT START DATE - YEAR
EVNTTYPE EVENT TYPE
EVPVID UNIQUE EVPV ID KEY: EVNTID + PROVID
FAMWT02F EXPENDITURE FILE FAMILY WEIGHT, 2002 Sampling Weights and Variance Estimation
FFEEID UNIQUE ID FOR FLAT FEE BUNDLES Identifiers
FFEVTYPE PURE OR MIXED FLAT FEE BUNDLE
FFTYPE FLAT FEE BUNDLE
FLATFEE HC FLATFEE INDICATOR
HASRAD WERE ANY RADIOLOGY SERVICES PERFORMED
HASSURG WAS SURGERY PERFORMED
IMPFLAG IMPUTATION STATUS
IMPGROUP IMPUTATION GROUP: R1 RF1...RM RFM N/A
IMPUTED IMPUTED FLAG: Y/N
ISCOPAY WAS THERE A COPAYMENT FOR EVENT
ISOP1 POTENTIAL SOP INDICATOR, FAMILY
ISOP10 POTENTIAL SOP INDICATOR, OTHER INS
ISOP11 POTNTL SOP INDICATOR, UNCOLLECTED LIBLTY
ISOP2 POTENTIAL SOP INDICATOR, MEDICARE
ISOP3 POTENTIAL SOP INDICATOR, MEDICAID
ISOP4 POTENTIAL SOP INDICATOR, PRIVATE INS
ISOP5 POTENTIAL SOP INDICATOR, VETERANS
ISOP6 POTENTIAL SOP INDICATOR, TRICARE
ISOP7 POTENTIAL SOP INDICATOR, OTHER FEDERAL
ISOP8 POTENTIAL SOP INDICATOR, STATE/LOCAL GOV
ISOP9 POTENTIAL SOP INDICATOR, WORKERS COMP
IVTHER THIS VISIT DID P HAVE IV THERAPY
KIDNEYD THIS VISIT DID P HAVE KIDNEY DIALYSIS
KNOWCHRG KNOW THE TOTAL CHARGE
LABTEST THIS VISIT DID P HAVE LAB TESTS
MAMMOG THIS VISIT DID P HAVE A MAMMOGRAM
MARRY02X MARITAL STATUS-12/31/02 (EDITED/IMPUTED) Family Relationships
MARRY31X MARITAL STATUS - R31 (EDITED/IMPUTED) Family Relationships
MARRY42X MARITAL STATUS - R42 (EDITED/IMPUTED) Family Relationships
MCAD02EV MEDICAID COVERAGE SOME TIME DURING 02
MCRE02EV MEDICARE COVERAGE SOME TIME DURING 02
MCRMC MEDICARE COVERAGE THRU HMO FOR ROUND
MEDPTYPE TYPE OF MED PERSON P TALKED TO ON VST DT
MRI THIS VISIT DID P HAVE AN MRI
MSA02 MSA AS OF 12/31/02
MSA31 MSA STATUS - R3/1
MSA42 MSA STATUS - R4/2
MSA53 MSA STATUS - R5/3
NORMLWGT NORMALIZED WEIGHT
NUMMISS TOTAL NUMBER OF MISSING AMTS
NUMMISS2 # MISSING AMTS WITH SOP=2
OCCUPTH THIS VISIT DID P HAVE OCCUPATIONAL THERA
OTHSRCS OTHER SOURCES EXPECTED TO REIMBURSE
OTHSVCE HAVE OTHER DIAG TEST THIS VISIT
PANEL02 PANEL INDICATOR Survey Administration and Eligibility Status
PAYBACK DOES R EXPECT SOURCE TO REIMBURSE
PERSID SAMPLE PERSON Identifiers
PERWT02F EXPENDITURE FILE PERSON WEIGHT, 2002 Sampling Weights and Variance Estimation
PHYSTH THIS VISIT DID P HAVE PHYSICAL THERAPY
PPANWT02 NH&M ADJ PANEL PERS WGT
PRIV02EV PRIV. INSUR SOME TIME DURING 02
PRIVMC PRIVATE HMO/GATEKEEPER COVERAGE FOR RND
PRIVNET PRIVATE PLAN COV WITH OUT-OF-NET OPTION
PSYCHOTH DID P HAVE PSYCHOTHERAPY/COUNSELING
PUBMC MEDICAID/PUBLIC MANAGED CARE COV FOR RND
RACETHNX RACE/ETHNICITY (EDITED/IMPUTED)
RACEX RACE (EDITED/IMPUTED)
RADIATTH THIS VISIT DID P HAVE RADIATION THERAPY
RCVDBILL ANY BILL/STATEMENT RECEIVED
RCVSHOT THIS VISIT DID P RECEIVE AN ALLERGY SHOT
RCVVAC THIS VISIT DID P RECEIVE VACCINATION
REGION02 CENSUS REGION AS OF 12/31/02 Demographics
REGION31 CENSUS REGION - R31 Demographics
REGION42 CENSUS REGION - R42 Demographics
REIMB1 AMOUNT REIMBURSED BY FAMILY
REIMB10 AMOUNT REIMBURSED BY OTHER INSURANCE
REIMB11 AMT REIMBURSED BY UNCOLLECTED LIABILTY
REIMB2 AMOUNT REIMBURSED BY MEDICARE
REIMB3 AMOUNT REIMBURSED BY MEDICAID
REIMB4 AMOUNT REIMBURSED BY PRIVATE INS
REIMB5 AMOUNT REIMBURSED BY VETERANS
REIMB6 AMOUNT REIMBURSED BY TRICARE
REIMB7 AMOUNT REIMBURSED BY OTHER FEDERAL
REIMB8 AMOUNT REIMBURSED BY STATE/LOCAL GOV'T
REIMB9 AMOUNT REIMBURSED BY WORKERS COMP
ROUND ROUND NUMBER
RTEHLTH1 PERCEIVED HEALTH STATUS BY ROUND
SAMEAMT ANY VISIT COST THE SAME AMT AS STEM
SEX SEX
SONOGRAM HAVE SONOGRAM/ULTRASOUND THIS VISIT
SOP1 SRCE OF PAYM INDICATOR, FAMILY
SOP10 SRCE OF PAYM INDICATOR, OTHER INS
SOP11 SRCE OF PAYM INDICATOR, UNCLAIMED LIABLT
SOP2 SRCE OF PAYM INDICATOR, MEDICARE
SOP3 SRCE OF PAYM INDICATOR, MEDICAID
SOP4 SRCE OF PAYM INDICATOR, PRIVATE INS
SOP5 SRCE OF PAYM INDICATOR, VETERANS
SOP6 SRCE OF PAYMENT INDICATOR, TRICARE
SOP7 SRCE OF PAYM INDICATOR, OTH FEDERAL
SOP8 SRCE OF PAYM INDICATOR, STATE/LOCAL GOV
SOP9 SRCE OF PAYM INDICATOR, WORKER COMP
SPEECHTH THIS VISIT DID P HAVE SPEECH THERAPY
STATUS FLAG: PERSON IS OR IS NOT COVRD IN MONTH
SUMPAY SUM OF AMT1-AMT10,AMT12,AMT13 AFTER IMP
SUMPAY1 SUM OF AMT1 - AMT10
SUMPAY2 SUM OF AMT1-AMT10 EXCLUDES MISSING AMT
SUMPAY3 SUM OF AMT2-AMT10/AMTORG
SUMPAY4 SUM AMT2-AMT10/AMTORG EXCLD MISSING AMT
SUMPAYF SUM OF AMT1-AMT10 AFTER EDITING
SURGPROC HAVE SURGICAL PROCEDURE THIS VISIT
TDONORID WESID OF DONOR FOR TLCHRG IMP
TLCHRG TOTAL CHARGE FOR VISIT
TOTEV01 NUMBER OF 2001 EVENTS IN FLAT FEE
TRI02EV TRICARE/VA SOMETIME DURING 2002
UEDIED02 PERSON IS DECEASED IN 2002
UEGNINS PERSON COVERED BY INSURANCE
UPAYMOR EXPECT ANYONE IN FAMILY TO PAY MORE
VAFAC IS PROV A FACILITY OF THE VETERAN'S ADMI
VAPLACE IN VETERANS ADMIN PROVIDER DIRECTORY
VARPSU VARIANCE ESTIMATION PSU - 2002 Sampling Weights and Variance Estimation
VARSTR VARIANCE ESTIMATION STRATUM - 2002 Sampling Weights and Variance Estimation
VSTCTGRY BEST CATEGORY FOR CARE P RECV ON VST DT
WEIGHT WEIGHT USED IN IMPUTATION
WESID UNIQUE ID FOR IMPUTATION
WHOBILLC WHERE BILL SENT - CODE
XRAYS THIS VISIT DID P HAVE X-RAYS
YNOBILL WHY BILL/STATEMENT NOT RECEIVED
_AGECAT1 AGE CLS-CHI NUR PHY PSY SOC TEC OMP OTH Demographics
_AGECAT2 AGE CLASS VAR-OPT ACU MAS HOM OAC Demographics
_DIALYS DIALYSIS CLASS VARIABLE
_HMO HMO CLASS VARIABLE
_LABTEST LABTEST CLASS VARIABLE
_MAMMOG MAMMOGRAPHY CLASS VARIABLE
_MEDPTYP MEDPTYPE CLASS VARIABLE
_MRI MRI CLASS VARIABLE FOR IMPUTATION
_MSA MSA CLASS VARIABLE
_PHYSTH PHYS THERAPY CLASS VARIABLE
_PRIVMC PRIVMC CLASS VARIABLE
_PSYCHTH PSYCHOTHERAPY CLASS VARIABLE
_RACETHN RACE/ETHNICITY CLASS VARIABLE
_REGION REGION CLASS VARIABLE Demographics
_SONOGRM SONOGRAM CLASS VARIABLE
_TLCHRG ORIGINAL TLCHRG BEFORE IMPUTING
_XRAYS X-RAYS CLASS VARIABLE

   Page last revised:  January 31, 2012