PDE Phase I Data Dictionary (March 2009)

                NAME             TYPE   LENGTH
-------------------------------------   ------
 723 Part D Event ID  		 CHAR	  15

	Identifies a unique Part D event for a
	beneficiary.
	
	SHORT NAME: PDE_ID
	LONG NAME: PDE_ID

	SOURCE:
	CCW


                NAME             TYPE   LENGTH
-------------------------------------   ------
 Encrypted 723 Beneficiary	CHAR	  15
 ID

	A unique CCW beneficiary identifier field
	that is specific to the Chronic Condition Warehouse.  
	This field is encrypted prior to delivery to 
	researchers. The BENE_ID field is used to cross-
	reference data for each beneficiary across all claim	
	and assessment data files.
	
	SHORT NAME: BENE_ID
	LONG NAME: BENE_ID

	SOURCE:
	CCW




              NAME            TYPE    LENGTH
-----------------------------------   ------
   RX SERVICE DATE             DATE      8

	This field contains the date on which the
	prescription was filled.

	CCYYMMDD

	SHORT NAME:	SRVC_DT
	LONG NAME:	SRVC_DT  

	SOURCE:
	CCW




              NAME            TYPE    LENGTH
-----------------------------------   ------
   PRODUCT SERVICE ID         CHAR	19

	This field identifies the dispensed drug using a National Drug 
	Code (NDC). The NDC is reported in NDC11 format. In instances 
	where a pharmacy formulates a compound containing multiple NDC
	drugs, the NDC of the most expensive drug is used.
	
	NDC code in the following format: MMMMMDDDDPP followed by 8 
	spaces. CMS rejects the following codes: 99999999999, 99999999992,
	99999999993, 99999999994, 99999999995 and 99999999996.

	SHORT NAME:	PRDSRVID
	LONG NAME:	PROD_SRVC_ID

	SOURCE:
	CCW




              NAME            TYPE    LENGTH
-----------------------------------------------
   QUANTITY DISPENSED         NUM      12

	This field indicates the number of units, 
	grams, milliliters, or other dispensed in the
	current drug event. If a compounded item, then
	the QUANTITY DISPENSED is the total of all ingredients. 

	SHORT NAME:	QTYDSPNS
	LONG NAME:	QTY_DSPNSD_NUM

	SOURCE:
	CCW




              NAME            TYPE    LENGTH
---------------------------------------------
   DAYS SUPPLY                CHAR      3

	This field indicates the number of days' supply of 
	medication dispensed by the pharmacy and will consist
	of the amount the pharmacy enters for the prescription.

	Possible values are 0 – 999.  

	SHORT NAME:	DAYSSPLY
	LONG NAME:	DAYS_SUPLY_NUM

	SOURCE:
	CCW




              NAME            TYPE    LENGTH
----------------------------------------------
   PATIENT PAY AMOUNT          NUM       10

	This field lists the dollar amount the beneficiary
	paid that is not reimbursed by a third party (e.g., 
	copayments, coinsurance, deductible or other patient 
	pay amounts). This amount contributes to a beneficiary's 
	TrOOP only when it is payment for a covered drug. 
	Payments made by the beneficiary or family and friends 
	shall also be reported in this field. Other third party 
	payments made on behalf of a beneficiary that contribute 
	to TrOOP shall be reported in Other TrOOP Amount
	or Low-Income Cost-Sharing Amount and payments
	that do not contribute shall be reported in Patient
	Liability Reduction due to Other Payer Amount.

	Amount beneficiary paid that is not reimbursed
	by a third party.

	SHORT NAME:	PTPAYAMT
	LONG NAME:	PTNT_PAY_AMT

	SOURCE:
	CCW




              NAME            TYPE    LENGTH
-----------------------------------   ------
Gross Drug Cost		      NUM       10


	This variable is derived from the sum of these variables:
	Ingredient Cost Paid
	Dispensing Fee Paid
	Total Amount Attributed to Sales Tax


	SHORT NAME:	TOTALCST
	LONG NAME:	TOT_RX_CST_AMT

	SOURCE:
	CCW




              NAME            TYPE    LENGTH
-----------------------------------   ------
Brand Name		      CHAR      30

	The name that appears on the package
	label provided by the manufacturer.

	SHORT NAME:	BN
	LONG NAME:	BN

	SOURCE:
	First DataBAnk






              NAME            TYPE    LENGTH
-----------------------------------   ------
Generic Name		      CHAR      30

	The drug ingredient name adopted by United
	States Adopted Names (USAN). The chemical 
	name is used when the USAN name is not available.
	For multi-ingredient products, abbreviations may 
	be used (such as HCTZ [Hydrochlorothiazide] 
	and PP [Phenylpropanolamine]). 

	SHORT NAME:	GNN
	LONG NAME:	GNN

	SOURCE:
	First DataBAnk





              NAME            TYPE    LENGTH
-----------------------------------   ------
Drug Strength Description     CHAR      10

	Description of drug potency in units 
	of grams, milligrams, percentage, and 
	other terms.

	SHORT NAME:	STR
	LONG NAME:	STR

	SOURCE:
	First DataBAnk




              NAME            TYPE    LENGTH
-----------------------------------   ------
Dosage Form Code              CHAR      2

	The dosage form of a clinical formulation
	describes the physical presentation of a 
	drug, such as tablet, capsule, or liquid. 
	It may also incorporate the delivery and 
	release mechanism of the drug.

	SHORT NAME:	GCDF
	LONG NAME:	GCDF

	SOURCE:
	First DataBAnk


              NAME            TYPE    LENGTH
-----------------------------------   ------
Dosage Form Code Description   CHAR      40

	Extended text description for a Dosage 
	Form Code (GCDF). The dosage form of a 
	clinical formulation describes the physical 
	presentation of a drug, such as tablet, 
	capsule, or liquid. It may also incorporate
	the delivery and release mechanism of the 
	drug. 

	SHORT NAME:	GCDF_DESC
	LONG NAME:	GCDF_DESC

	SOURCE:
	First DataBAnk



              NAME            TYPE    LENGTH
-----------------------------------   ------
Route of Aministration Code   CHAR      2

	The normal site or method by which a
	drug is administered in the body, such
	as oral, injection, or topical. 
	

	SHORT NAME:	GCRT2
	LONG NAME:	GCRT2

	SOURCE:
	First DataBAnk



              NAME            TYPE    LENGTH
-----------------------------------   ------
Route Description             CHAR      10

	A ten-character alphanumeric column 
	describing the route of administration
	from Route of Administration Code (GCRT2).
	Includes oral, topical, injection, etc.
	

	SHORT NAME:	RT
	LONG NAME:	RT

	SOURCE:
	First DataBAnk