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 SD99_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  SD99_V1
Full Name  AHRQ\CCFS\BA002XXX\DATA\MEPS\D110802\SD99_V1.SD9
CD Volume  CD_0562
File Type  Miscellaneous Data Center File
Title  1999 MPC Separately Billing Doctors (SD) Post-Imputation File
Description  1999 MPC Separately Billing Doctors (SD) Post-Imputation File
Data Year(s)  1999
Records  9773
Population  1999 MPC Separately Billing Doctors (SD) 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
AGE31X AGE R31 (EDITED/IMPUTED) Demographics
AGE42X AGE R42 (EDITED/IMPUTED) Demographics
AGE99X AGE AS OF 12/31/99 (EDITED/IMPUTED) Demographics
AMT1 SBD PAID, FAMILY (IMPUTED)
AMT10 SBD PAID, OTHER INSURANCE (IMPUTED)
AMT2 SBD PAID, MEDICARE (IMPUTED)
AMT3 SBD PAID, MEDICAID (IMPUTED)
AMT4 SBD PAID, PRIVATE INSURANCE (IMPUTED)
AMT5 SBD PAID, VETERANS (IMPUTED)
AMT6 SBD PAID, CHAMPUS/CHAMPVA (IMPUTED)
AMT7 SBD PAID, OTHER FEDERAL (IMPUTED)
AMT8 SBD PAID, STATE/LOCAL GOV'T (IMPUTED)
AMT9 SBD PAID, WORKERS COMP (IMPUTED)
CCHPR1 CCHPR CONDITION CODE #1
CCHPR2 CCHPR CONDITION CODE #2
CCHPR3 CCHPR CONDITION CODE #3
CCHPR4 CCHPR CONDITION CODE #4
CCHPRC1 MPC - COLLAPSED CCHPR (NK) CODE #1
CCHPRC2 MPC - COLLAPSED CCHPR (NK) CODE #2
CCHPRC3 MPC - COLLAPSED CCHPR (NK) CODE #3
CCHPRC4 MPC - COLLAPSED CCHPR (NK) CODE #4
CHMP99EV CHAMPUS/VA SOME TIME DURING 99
CHP1C1 MPC - CCHPR COND CODE #1
CHP1C2 MPC - CCHPR COND CODE #2
CHP1C3 MPC - CCHPR COND CODE #3
CHP1C4 MPC - CCHPR COND CODE #4
COND1 HC - ICD9 CONDITION CODE 1
COND2 HC - ICD9 CONDITION CODE 2
COND3 HC - ICD9 CONDITION CODE 3
COND4 HC - ICD9 CONDITION 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
DISAVOWL DISAVOWAL RC FLAG
DONFLG IMPUTATION DONATION FLAG
DONOR HDIMPUTE DONOR: Y/N
DONORID WESID OF DONOR
DSUMPAY FAC IMP DONOR'S SUMPAY
DTLCHRG DONOR'S TOTAL CHARGE
DUPERSID SAMPLE PERSON ID (DN+PN) FOR PUBLIC USE Identifiers
ENCTRCNT MPC - NO. ENCOUNTERS IN NODE
EVNTTYPE EVENT TYPE
FAMWT99F POVERTY ADJUSTED FAMILY WEIGHT Sampling Weights and Variance Estimation
FEECAP MPC - FEE OR CAP SUMMARY
FEEORCAP MPC - FEE FOR SERVICE OR CAPITATED BASIS
FLATFEE HC FLAT FEE INDICATOR
GFEEFLAG MPC - NODE HAS GLOBAL FEE
GFEEID MPC - GLOBAL FEE ID
GFEEYEAR MPC - YEAR GLOBAL FEE BEGAN
GFTYPE PURE OR SMPL GLOBAL FEE TYPE
GLOFEE MPC - GLOBAL FEE INDICATOR
IMPFLAG IMPUTATION FLAG
IMPGROUP IMPUTATION GROUP: R1 RF1...RM RFM N/A
IMPUTED IMPUTED FLAG: Y/N
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, CHAMPUS/CHAMPVA
ISOP7 POTENTIAL SOP INDICATOR, OTHER FEDERAL
ISOP8 POTENTIAL SOP INDICATOR, STATE/LOCAL GOV
ISOP9 POTENTIAL SOP INDICATOR, WORKERS COMP
LOS # OF NIGHTS IN HOSP, IMPUTED
MARRY31X MARITAL STATUS - R31 (EDITED/IMPUTED) Family Relationships
MARRY42X MARITAL STATUS - R42 (EDITED/IMPUTED) Family Relationships
MARRY99X MARITAL STATUS -12/31/99(EDITED/IMPUTED) Family Relationships
MCAD99EV MEDICAID COVERAGE SOMETIME DURING 99
MCPT1 MPC - ORIG CPT4 PROCEDURE CODE #1
MCPT10 MPC - ORIG CPT4 PROCEDURE CODE #10
MCPT11 MPC - ORIG CPT4 PROCEDURE CODE #11
MCPT12 MPC - ORIG CPT4 PROCEDURE CODE #12
MCPT13 MPC - ORIG CPT4 PROCEDURE CODE #13
MCPT14 MPC - ORIG CPT4 PROCEDURE CODE #14
MCPT15 MPC - ORIG CPT4 PROCEDURE CODE #15
MCPT16 MPC - ORIG CPT4 PROCEDURE CODE #16
MCPT17 MPC - ORIG CPT4 PROCEDURE CODE #17
MCPT18 MPC - ORIG CPT4 PROCEDURE CODE #18
MCPT19 MPC - ORIG CPT4 PROCEDURE CODE #19
MCPT2 MPC - ORIG CPT4 PROCEDURE CODE #2
MCPT20 MPC - ORIG CPT4 PROCEDURE CODE #20
MCPT21 MPC - ORIG CPT4 PROCEDURE CODE #21
MCPT22 MPC - ORIG CPT4 PROCEDURE CODE #22
MCPT23 MPC - ORIG CPT4 PROCEDURE CODE #23
MCPT24 MPC - ORIG CPT4 PROCEDURE CODE #24
MCPT25 MPC - ORIG CPT4 PROCEDURE CODE #25
MCPT26 MPC - ORIG CPT4 PROCEDURE CODE #26
MCPT27 MPC - ORIG CPT4 PROCEDURE CODE #27
MCPT28 MPC - ORIG CPT4 PROCEDURE CODE #28
MCPT29 MPC - ORIG CPT4 PROCEDURE CODE #29
MCPT3 MPC - ORIG CPT4 PROCEDURE CODE #3
MCPT30 MPC - ORIG CPT4 PROCEDURE CODE #30
MCPT31 MPC - ORIG CPT4 PROCEDURE CODE #31
MCPT32 MPC - ORIG CPT4 PROCEDURE CODE #32
MCPT4 MPC - ORIG CPT4 PROCEDURE CODE #4
MCPT5 MPC - ORIG CPT4 PROCEDURE CODE #5
MCPT6 MPC - ORIG CPT4 PROCEDURE CODE #6
MCPT7 MPC - ORIG CPT4 PROCEDURE CODE #7
MCPT8 MPC - ORIG CPT4 PROCEDURE CODE #8
MCPT9 MPC - ORIG CPT4 PROCEDURE CODE #9
MCPTCH1 MPC - CHARGE FOR SERVICE #1
MCPTCH10 MPC - CHARGE FOR SERVICE #10
MCPTCH11 MPC - CHARGE FOR SERVICE #11
MCPTCH12 MPC - CHARGE FOR SERVICE #12
MCPTCH13 MPC - CHARGE FOR SERVICE #13
MCPTCH14 MPC - CHARGE FOR SERVICE #14
MCPTCH15 MPC - CHARGE FOR SERVICE #15
MCPTCH16 MPC - CHARGE FOR SERVICE #16
MCPTCH17 MPC - CHARGE FOR SERVICE #17
MCPTCH18 MPC - CHARGE FOR SERVICE #18
MCPTCH19 MPC - CHARGE FOR SERVICE #19
MCPTCH2 MPC - CHARGE FOR SERVICE #2
MCPTCH20 MPC - CHARGE FOR SERVICE #20
MCPTCH21 MPC - CHARGE FOR SERVICE #21
MCPTCH22 MPC - CHARGE FOR SERVICE #22
MCPTCH23 MPC - CHARGE FOR SERVICE #23
MCPTCH24 MPC - CHARGE FOR SERVICE #24
MCPTCH25 MPC - CHARGE FOR SERVICE #25
MCPTCH26 MPC - CHARGE FOR SERVICE #26
MCPTCH27 MPC - CHARGE FOR SERVICE #27
MCPTCH28 MPC - CHARGE FOR SERVICE #28
MCPTCH29 MPC - CHARGE FOR SERVICE #29
MCPTCH3 MPC - CHARGE FOR SERVICE #3
MCPTCH30 MPC - CHARGE FOR SERVICE #30
MCPTCH31 MPC - CHARGE FOR SERVICE #31
MCPTCH32 MPC - CHARGE FOR SERVICE #32
MCPTCH4 MPC - CHARGE FOR SERVICE #4
MCPTCH5 MPC - CHARGE FOR SERVICE #5
MCPTCH6 MPC - CHARGE FOR SERVICE #6
MCPTCH7 MPC - CHARGE FOR SERVICE #7
MCPTCH8 MPC - CHARGE FOR SERVICE #8
MCPTCH9 MPC - CHARGE FOR SERVICE #9
MCPTDS1 MPC - PROCEDURE TEXT #1
MCPTDS10 MPC - PROCEDURE TEXT #10
MCPTDS11 MPC - PROCEDURE TEXT #11
MCPTDS12 MPC - PROCEDURE TEXT #12
MCPTDS13 MPC - PROCEDURE TEXT #13
MCPTDS14 MPC - PROCEDURE TEXT #14
MCPTDS15 MPC - PROCEDURE TEXT #15
MCPTDS16 MPC - PROCEDURE TEXT #16
MCPTDS17 MPC - PROCEDURE TEXT #17
MCPTDS18 MPC - PROCEDURE TEXT #18
MCPTDS19 MPC - PROCEDURE TEXT #19
MCPTDS2 MPC - PROCEDURE TEXT #2
MCPTDS20 MPC - PROCEDURE TEXT #20
MCPTDS21 MPC - PROCEDURE TEXT #21
MCPTDS22 MPC - PROCEDURE TEXT #22
MCPTDS23 MPC - PROCEDURE TEXT #23
MCPTDS24 MPC - PROCEDURE TEXT #24
MCPTDS25 MPC - PROCEDURE TEXT #25
MCPTDS26 MPC - PROCEDURE TEXT #26
MCPTDS27 MPC - PROCEDURE TEXT #27
MCPTDS28 MPC - PROCEDURE TEXT #28
MCPTDS29 MPC - PROCEDURE TEXT #29
MCPTDS3 MPC - PROCEDURE TEXT #3
MCPTDS30 MPC - PROCEDURE TEXT #30
MCPTDS31 MPC - PROCEDURE TEXT #31
MCPTDS32 MPC - PROCEDURE TEXT #32
MCPTDS4 MPC - PROCEDURE TEXT #4
MCPTDS5 MPC - PROCEDURE TEXT #5
MCPTDS6 MPC - PROCEDURE TEXT #6
MCPTDS7 MPC - PROCEDURE TEXT #7
MCPTDS8 MPC - PROCEDURE TEXT #8
MCPTDS9 MPC - PROCEDURE TEXT #9
MCRE99EV MEDICARE COVERAGE SOMETIME DURING 99
MCRMC MEDICARE COVERAGE THRU HMO FOR ROUND
MPSEVTYP MPC - EVENT TYPE
MPSID UNIQUE MPC IDENTIFIER
MPSTOTL MPC - TOTLCHRG
MSA53 MSA R53 STATUS
MSA99 MSA AS OF 12/31/99
NORMLWGT NORMALIZED WEIGHT
NUMMISS2 # MISSING AMTS WITH SOP=2
NUMMISSS TOTAL NUMBER OF MISSING AMTS
ORIGTCHG MPC - ORIG TOTTCHRG
PDDIRID PROVIDER DIRECTORY ID
PERSID SAMPLE PERSON Identifiers
PERWT99F POVERTY/MORTALITY ADJUSTED PERSON WEIGHT Sampling Weights and Variance Estimation
PRIV99EV PRIV. INSUR SOME TIME DURING 99
PRIVMC PRIVATE HMO/GATEKEEPER COVERAGE FOR RND
PRIVNET PRIVATE PLAN COV WITH OUT-OF-NET OPTION
PUBMC MEDICAID/PUBLIC MANAGED CARE COV FOR RND
RACETHNX RACE/ETHNICITY (EDITED/IMPUTED)
RACEX RACE (EDITED/IMPUTED)
REGION31 CENSUS REGION - R31 Demographics
REGION42 CENSUS REGION - R42 Demographics
REGION99 CENSUS REGION AS OF 12/31/99 Demographics
ROUND ROUND NUMBER
SBDCNT # SBDS PER MPSID (TOIMPUTE)
SBD_ID MPC - NODE ID
SDONFLG DONATION FLAG FOR SBD
SEDITLOG FINAL STATUS ASSIGNMENT EDIT RECORD
SEX SEX
SOP1 PERSON/FAMILY IS A PAYER/BASED ON SBD
SOP10 OTHER INSURANCE IS A PAYER/BASED ON SBD
SOP2 MEDICARE IS A PAYER/BASED ON SBD
SOP3 MEDICAID IS A PAYER/BASED ON SBD
SOP4 PRIVATE INS IS A PAYER/BASED ON SBD
SOP5 VA IS A PAYER/BASED ON SBD
SOP6 CHAMPUS/CHAMPVA IS A PAYER/BASED ON SBD
SOP7 OTHER FEDL GOVT IS A PAYER/BASED ON SBD
SOP8 STATE/LOCL GOVT IS A PAYER/BASED ON SBD
SOP9 WORKMN'S COMP IS A PAYER/BASED ON SBD
SPECCODE SPECIALTY CODE
SPECLTY MPC - SPECIALTY TEXT
SSTATUS IMPUTATION STATUS FOR SBD
STATUS IMPUTATION STATUS
SUMPAY SUM OF AMT1 - AMT10
SURGFLAG MPC - HOSPITAL EVENT - SURGERY FLAG
TDONORID WESID OF DONOR FOR TLCHG IMP
TLCHRG TOTAL CHARGE FOR VISIT
TOIMPUTE ELIGIBLE FOR IMPUTATION
TOTLCHRG MPC - TOTAL CHARGES
TOTTCHRG TOTAL CHARGE SUMMARY
VAPLACE IN VETERANS ADMIN PROVIDER DIRECTORY
VARPSU99 VARIANCE ESTIMATION PSU - 1999 Sampling Weights and Variance Estimation
VARSTR99 VARIANCE ESTIMATION STRATUM PSU - 1999 Sampling Weights and Variance Estimation
WEIGHT WEIGHT USED IN IMPUTATION
WESID UNIQUE ID FOR IMPUTATION
WGTPAN3 PANEL 3, 1999 PERSON LEVEL WEIGHT
WGTPAN4 PANEL 4, 1999 PERSON LEVEL WEIGHT
_AGECAT AGE CLASS VARIABLE Demographics
_HMO HMO CLASS VARIABLE
_LOS LENGTH OF STAY CLASS VARIABLE
_MCRMC MCRMC CLASS VARIABLE
_MPSEVTP MPS EVNTTYPE CLASS VARIABLE
_MPSID ORIGINAL MPHSPSID (BEFORE SBD_ROLLUP)
_MSA MSA CLASS VARIABLE
_PRIVMC PRIVMC CLASS VARIABLE
_RACETHN RACE ETHNICITY CLASS VARIABLE
_REGION REGION CLASS VARIABLE Demographics
_SPECCOD SPECIALTY CODE CLASS VARIABLE
_TLCHRG ORIGINAL TLCHRG BEFORE IMPUTING TLCRG

   Page last revised:  January 31, 2012