Data Documentation

For most files, a table of variables will display below, with links to the variable definitions. If no table displays, or if you need additional information for a specific variable, please see the CCW website. Data documentation is available for all files and codebooks for many.

If you are unable to locate the information you need, please contact ResDAC.

CCW Codebook - Part D Event & Drug Characteristics_Version 092023.pdf466.77 KB

If you are unable to locate the information you need, please contact ResDAC.

CCW Record Layout - Part D Event & Drug Characteristics_Version 092023.xlsx18.11 KB

Number	SAS Name	Variable Name
1	PDE_ID	CCW Encrypted Part D Event Number
2	BENE_ID	CCW Encrypted Beneficiary ID Number
3	DOB_DT	Patient Date of Birth (DOB)
4	GNDR_CD	Patient Gender
5	SRVC_DT	RX Service Date
6	PD_DT	Paid Date
7	RX_SRVC_RFRNC_NUM	RX Service Reference Number
8	PROD_SRVC_ID	Product Service ID
9	PLAN_CNTRCT_REC_ID	Plan Contract ID
10	PLAN_PBP_REC_NUM	Plan Benefit Package ID
11	CMPND_CD	Compound Code
12	DAW_PROD_SLCTN_CD	Dispense as Written (DAW) Product Selection Code
13	QTY_DSPNSD_NUM	Quantity Dispensed
14	DAYS_SUPLY_NUM	Days Supply (Part D)
15	FILL_NUM	Number of drug fills
16	DSPNSTCD_STUS_CD	Dispensing Status Code
17	DRUG_CVRG_STUS_CD	Drug Coverage Status Code
18	ADJSTMT_DLTN_CD	Adjustment Deletion Code
19	NSTD_FRMT_CD	Non-Standard Format Code
20	PRCNG_EXCPTN_CD	Pricing Exception Code
21	CTSTRPHC_CVRG_CD	Catastrophic Coverage Code
22	GDC_BLW_OOPT_AMT	Gross Drug Cost Below Part D Out-of-Pocket Threshold (GDCB)
23	GDC_ABV_OOPT_AMT	Gross Drug Cost Above Part D Out-of-Pocket Threshold (GDCA)
24	PTNT_PAY_AMT	Amount Paid by Patient
25	OTHR_TROOP_AMT	Other True Out-of-Pocket (TrOOP) Amount
26	LICS_AMT	Amount paid for the PDE by Part D low income subsidy
27	PLRO_AMT	Reduction in patient liability due to payments by other payers (PLRO)
28	CVRD_D_PLAN_PD_AMT	Amount paid by Part D plan for the PDE (drug is covered by Part D)
29	NCVRD_PLAN_PD_AMT	Amount paid by Part D plan for the PDE (drug is not covered by Part D)
30	TOT_RX_CST_AMT	Total Drug Cost (Part D)
31	RX_ORGN_CD	Prescription Origination Code
32	RPTD_GAP_DSCNT_NUM	Gap Discount Amount
33	BRND_GNRC_CD	Brand-Generic Code Reported by Submitting Plan
34	PHRMCY_SRVC_TYPE_CD	Pharmacy service type code
35	PTNT_RSDNC_CD	Patient Residence Code
36	SUBMSN_CLR_CD	Submission clarification code
37	BENEFIT_PHASE	Benefit Phase of Part D Event
38	CCW_PHARM_ID	CCW Pharmacy Identifier
39	NCPDP_ID	NCPDP Pharmacy Identifier (Event)
40	PRSCRBR_ID	Prescriber Identification Number
41	PRSCRBR_ID_QLFYR_CD	Prescriber identification number qualifier code
42	CCW_PRSCRBR_ID	CCW Prescriber Identifier
43	PDE_PRSCRBR_ID_FRMT_CD	PDE Prescriber ID Format Code
44	PRIOR_AUTHORIZATION_YN	Prior Authorization Indicator (Event)
45	Medicare Part D formulary tier identifier
46	QUANTITY_LIMIT_YN	Quantity Limit Indicator (Event)
47	STEP	Step Number
48	FORMULARY_ID	Formulary identification number
49	FRMLRY_RX_ID	CCW Formulary drug identifier
50	BN	Brand Name
51	GNN	Generic Name
52	STR	Drug Strength Description
53	GCDF	Dosage Form Code
54	GCDF_DESC	Dosage Form Code Description
55	PTD_MODEL_IND	Part D Model Indicator