Medications Dataset Variables
For any field, -9Not ascertained
-8Unknown
-7Refused to answer
-1Inapplicable
Variable / Label / CodesDUID / DWELLING UNIT ID
DUPERSID / PERSON ID (DUID + PID)
LINKIDX / ID FOR LINKAGE TO COND/OTH EVENT FILES
PCIMPFLG / TYPE OF HC TO PC PRESCRIPTION MATCH / 1=Exact match to PC RX for PID
2=Not exact match
CLMOMFLG / CHGE/PYMNT, Rx CLAIM FILING, OMTYPE STAT / 1 C+P=N, filter=pharmacy
2 C+P=N, filter=neither
3 C+P=Y, filter=unk/inap
4 C+P=Y, filter=family
5 C+P=Y, filter=pharmacy, OM=2,3
6=C+P=Y, filter=neither, OM=2,3
INPCFLG / PID HAS AT LEAST 1 RECORD IN PC / 0=No
1=Yes
DIABFLG / Rx INSULIN OR DIABETIC EQUIPMENT/SUPPLY
GBO / MULTUM BRAND/GENERIC DESIGNATION
PHARTP1 / TYPE OF PHARMACY PROV - 1ST / Type of Pharmacy Provider
PHARTP2 / TYPE OF PHARMACY PROV - 2ND / 1=mail order
PHARTP3 / TYPE OF PHARMACY PROV - 3RD / 2=in another store
PHARTP4 / TYPE OF PHARMACY PROV - 4TH / 3=in HMO/Clinic/hospital
PHARTP5 / TYPE OF PHARMACY PROV - 5TH / 4=drug store
PHARTP6 / TYPE OF PHARMACY PROV - 6TH / 5=on-line
PHARTP7 / TYPE OF PHARMACY PROV - 7TH
PHARTP8 / TYPE OF PHARMACY PROV - 8TH
PHARTP9 / TYPE OF PHARMACY PROV - 9TH
PID / PERSON NUMBER
PREGCAT / MULTUM PREGNANCY CATEGORY / A Controlled studies show no risk
B No evidence of risk in humans
C Risk cannot be ruled out
D Positive evidence of risk
N FDA has not classified the RX
X contraindicated in pregnancy
PURCHRD / ROUND Rx/PRESCR MED OBTAINED/PURCHASED
RXBEGDD / DAY PERSON STARTED TAKING MEDICINE
RXBEGMM / MONTH PERSON STARTED TAKING MEDICINE
RXBEGYRX / YEAR PERSON STARTED TAKING MEDICINE / -14 Not yet used/taken
RXCCC1X / MODIFIED CLINICAL CLASS CODE / Use the ICD9 codes instead
RXCCC2X / MODIFIED CLINICAL CLASS CODE
RXCCC3X / MODIFIED CLINICAL CLASS CODE
RXFLG / NDC IMPUTATION SOURCE ON PC DONOR REC / 1=no imputation
2=imputed from other PC record
3=imputed from secondary source
RXFORM / FORM OF Rx/PRESCRIBED MEDICINE (IMPUTED)
RXFRMUNT / UNIT OF MEAS FORM Rx/PRESC MED (IMPUTED)
RXHHNAME / HC REPORTED MEDICATION NAME
RXICD1X / 3 DIGIT ICD-9 CONDITION CODE / Available at
RXICD2X / 3 DIGIT ICD-9 CONDITION CODE
RXICD3X / 3 DIGIT ICD-9 CONDITION CODE
RXNAME / MEDICATION NAME (IMPUTED)
RXNDC / NATIONAL DRUG CODE (IMPUTED) / NDC codes give unique identifiers for the medications prescribed. They can be found here
RXQUANTY / QUANTITY OF Rx/PRESCR MED (IMPUTED)
RXRECIDX / UNIQUE Rx/PRESCRIBED MEDICINE IDENTIFIER
RXSTRENG / STRENGTH OF Rx/PRESCR MED DOSE (IMPUTED)
RXSTRUNT / UNIT OF MEAS STRENGTH OF Rx (IMPUTED)
SAMPLE / HOUSEHLD RCVD FREE SAMPLE OF Rx IN ROUND
TC1 / MULTUM THERAPEUTIC CLASS #1 / 1 Anti-infective
20 Antineoplastics
28 Biologicals
40 Cardiovascular agents
57 Central nervous system agents
TC2 / MULTUM THERAPEUTIC CLASS #2 / 81 Coagulation modifiers
87 Gastrointestinal agents
97 Hormones
105 miscellaneous agents
TC3 / MULTUM THERAPEUTIC CLASS #3 / 115 Nutritional products
122 Respiratory agents
133 Topical agents
218 Alternative medicines
242 Psychotherapeutic agents
254 Immonologic agents
331 Radiologic agents
358 Metabolic agents
TC1S1 / MULTUM THERAPEUTIC SUB-CLASS #1 FOR TC1 / These are subcategories of the therapeutic classes listed above.
TC1S2 / MULTUM THERAPEUTIC SUB-CLASS #2 FOR TC1
TC1S3 / MULTUM THERAPEUTIC SUB-CLASS #3 FOR TC1
TC1S1_1 / MULTUM THERAPEUT SUB-SUB-CLASS FOR TC1S1
TC1S1_2 / MULTUM THERAPEUT SUB-SUB-CLASS FOR TC1S1
TC1S2_1 / MULTUM THERAPEUT SUB-SUB-CLASS FOR TC1S2
TC1S3_1 / MULTUM THERAPEUT SUB-SUB-CLASS FOR TC1S3
TC2S1 / MULTUM THERAPEUTIC SUB-CLASS #1 FOR TC2
TC2S2 / MULTUM THERAPEUTIC SUB-CLASS #2 FOR TC2
TC2S1_1 / MULTUM THERAPEUT SUB-SUB-CLASS FOR TC2S1
TC2S1_2 / MULTUM THERAPEUT SUB-SUB-CLASS FOR TC2S1
TC3S1 / MULTUM THERAPEUTIC SUB-CLASS #1 FOR TC3
TC3S1_1 / MULTUM THERAPEUT SUB-SUB-CLASS FOR TC3S1
VARPSU / VARIANCE ESTIMATION PSU, 2003 / See below
VARSTR / VARIANCE ESTIMATION STRATUM, 2003
rxexpenditure / Medication expenditure
rxmedicaid / Amount Paid by Medicaid
rxmedicare / Amount Paid by Medicare
rxotherfed / Amount Paid by Other Federal Agency
rxotherinsur / Amount Paid by Other Insurance
rxotherpub / Amount Paid by Other Public Agency
rxotherpv / Amount Paid by Other Private Insurance
rxpayment / Amount paid total
rxprivateins / Amount Paid by private insurance
rxselfpaid / Amount Paid by the individual
rxstate / Amount Paid by the state
rxtotal / Total Charged
rxtricare / Tricare payment
rxveterans / VA payment
rxworkcomp / Workman’s Comp payment
year / Year data collected
Using the Taylor-series linearization method, variance estimation strata and the variance estimation PSUs within these strata must be specified. The variance strata variable is named VARSTR, while the variance PSU variable is named VARPSU. Specifying a “with replacement” design in a computer software package, such as SUDAAN, provides standard errors appropriate for assessing the variability of survey estimates. It should be noted that the number of degrees of freedom associated with estimates of variability indicated by such a package may not appropriately reflect the actual number available. Sample estimates for characteristics generally distributed throughout the country (and thus the sample PSUs), one can expect at least 100 degrees of freedom for the full year data associated with the corresponding estimates of variance.
The variance strata and PSUs were developed to be compatible so that such data can be pooled and the variance strata and PSU variables provided can be used without modification for variance estimation purposes for estimates covering multiple years of data. There are 203 variance estimation strata, each stratum with either two or three variance estimation PSUs.