Back to top

File Version: CCW data documentation version 1-28-19

Short SAS NameLong SAS NameVariable Name
1PDE_IDPDE_IDCCW Encrypted Part D Event Number
2BENE_IDBENE_IDCCW Encrypted Beneficiary ID Number
3DOB_DTDOB_DTPatient Date of Birth (DOB)
4GNDR_CDGNDR_CDPatient Gender
5SRVC_DTSRVC_DTRX Service Date
6PD_DTPD_DTPaid Date
7SRVRFNUMRX_SRVC_RFRNC_NUMRX Service Reference Number
8PRDSRVIDPROD_SRVC_IDProduct Service ID
9PLNCNTRCPLAN_CNTRCT_REC_IDPlan Contract ID
10PLNPBPRCPLAN_PBP_REC_NUMPlan Benefit Package ID
11CMPND_CDCMPND_CDCompound Code
12DAWPS_CDDAW_PROD_SLCTN_CDDispense as Written (DAW) Product Selection Code
13QTYDSPNSQTY_DSPNSD_NUMQuantity Dispensed
14DAYSSPLYDAYS_SUPLY_NUMDays Supply
15Fill Number
16DSPNSTCDDSPNSTCD_STUS_CDDispensing Status Code
17DRCVSTCDDRUG_CVRG_STUS_CDDrug Coverage Status Code
18ADJDELCDADJSTMT_DLTN_CDAdjustment Deletion Code
19NSTFMTCDNSTD_FRMT_CDNon-Standard Format Code
20PRCGEXCDPRCNG_EXCPTN_CDPricing Exception Code
21CATCOVCDCTSTRPHC_CVRG_CDCatastrophic Coverage Code
22GDCBOOPTGDC_BLW_OOPT_AMTGross Drug Cost Below Part D Out-of-Pocket Threshold (GDCB)
23GDCAOOPTGDC_ABV_OOPT_AMTGross Drug Cost Above Part D Out-of-Pocket Threshold (GDCA)
24PTPAYAMTPTNT_PAY_AMTAmount Paid by Patient
25OTHTROOPOTHR_TROOP_AMTOther True Out-of-Pocket (TrOOP) Amount
26LICS_AMTLICS_AMTAmount paid for the PDE by Part D low income subsidy
27PLRO_AMTPLRO_AMTReduction in patient liability due to payments by other payers (PLRO)
28CPP_AMTCVRD_D_PLAN_PD_AMTAmount paid by Part D plan for the PDE (drug is covered by Part D)
29NPP_AMTNCVRD_PLAN_PD_AMTAmount paid by Part D plan for the PDE (drug is not covered by Part D)
30TOTALCSTTOT_RX_CST_AMTTotal drug cost (Part D)
31RX_ORGN_CDRX_ORGN_CDPrescription Origination Code
32GAPDSCNTRPTD_GAP_DSCNT_NUMGap Discount Amount
33BRNDGNCDBRND_GNRC_CDBrand-Generic Code Reported by Submitting Plan
34PHRMCY_SRVC_TYPE_CDPharmacy service type code
35PTNT_RSDNC_CDPTNT_RSDNC_CDPatient Residence Code
36SUBMSN_CLR_CDSubmission clarification code
37BNFTPHASBENEFIT_PHASEBenefit Phase of Part D Event
38SRVC_PRVDR_IDSRVC_PRVDR_IDService provider identification number
39SRVC_PRVDR_ID_QLFYR_CD SRVC_PRVDR_ID_QLFYR_CDService provider identification number qualifier code
40CCW_PHARM_IDCCW_PHARM_IDCCW Pharmacy Identifier
41NCPDP_IDNCPDP_IDNCPDP Pharmacy Identifier (Event)
42PRSCRBR_IDPRSCRBR_IDPrescriber Identification Number
43PRSCRBR_ID_QLFYR_CDPRSCRBR_ID_QLFYR_CDPrescriber identification number qualifier code
44CCW_PRSCRBR_IDCCW_PRSCRBR_IDCCW Prescriber Identifier
45PDE_PRSCRBR_ID_FRMT_CDPDE_PRSCRBR_ID_FRMT_CDPDE Prescriber ID Format Code
46PRIOR_AUTHORIZATION_YNPRIOR_AUTHORIZATION_YNPrior Authorization Indicator (Event)
47TIER_IDTIER_IDMedicare Part D Formulary Tier Number
48QUANTITY_LIMIT_YNQUANTITY_LIMIT_YNQuantity Limit Indicator (Event)
49STEPSTEPMaximum Step Number
50FORMULARY_ID FORMULARY_ID Formulary identification number
51FRMLRY_RX_IDFRMLRY_RX_IDCCW Formulary drug identifier
CSV