Medications Dataset Variables .edu



Medications Dataset Variables

For any field, -9 Not ascertained

-8 Unknown

-7 Refused to answer

-1 Inapplicable

|Variable |Label |Codes |

|DUID |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.

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download