opened on: 12 Jan 2018, 10:16:09 _dta: 1. ndc_hcpcsxw set up by Jean Roth , jroth@nber.org , 11 Jan 2018 2. ndchcpcsasp200510 set up by Jean Roth , jroth@nber.org , 21 Jun 2015 3. Source: Oct05ASPNDC-HCPCSCrosswalk_10 28 05.xls 4. Health Care Common Procedure Coding System (HCPCS) 5. National Drug Code (NDC) 6. Average Sale Price (ASP) 7. Average Wholesale Price (AWP) 8. Hospital Outpatient Prospective Payment System (OPPS) 9. ndchcpcsasp20057 set up by Jean Roth , jroth@nber.org , 21 Jun 2015 10. Source: HCPCSCrosswalk_062005.xls 11. ndchcpcsasp20054 set up by Jean Roth , jroth@nber.org , 21 Jun 2015 12. Source: Apr05ASPNDC-HCPCSCrosswalk_05.12.05.xls 13. ndchcpcsasp20051 set up by Jean Roth , jroth@nber.org , 21 Jun 2015 14. Source: HCPCSCrosswalk0105.xls 15. ndchcpcsasp200610 set up by Jean Roth , jroth@nber.org , 21 Jun 2015 16. Source: Oct06_ASPNDC-HCPCSCrosswalk_20Sep06.xls 17. ndchcpcsasp20067 set up by Jean Roth , jroth@nber.org , 21 Jun 2015 18. Source: 1 - Jul06_ASPNDC-HCPCSCrosswalk_v3_20Sep06.xls 19. ndchcpcsasp20064 set up by Jean Roth , jroth@nber.org , 21 Jun 2015 20. Source: April06ASPNDC-HCPCSCrosswalk_20Mar06.xls 21. ndchcpcsasp20061 set up by Jean Roth , jroth@nber.org , 21 Jun 2015 22. Source: Jan06ASPNDC-HCPCSCrosswalk_19Dec05.xls 23. ndchcpcsasp200710 set up by Jean Roth , jroth@nber.org , 21 Jun 2015 24. Source: October 2007 ASP NDC-HCPCS Crosswalk 091307.xls 25. ndchcpcsopps200710 set up by Jean Roth , jroth@nber.org , 21 Jun 2015 26. ndchcpcsasp20077 set up by Jean Roth , jroth@nber.org , 21 Jun 2015 27. Source: July07ASPNDC-HCPCS Crosswalk 061907.xls 28. ndchcpcsopps20077 set up by Jean Roth , jroth@nber.org , 21 Jun 2015 29. ndchcpcsasp20074 set up by Jean Roth , jroth@nber.org , 21 Jun 2015 30. Source: April 2007 NDC-HCPCS Crosswalk File 031907v2.xls 31. ndchcpcsopps20074 set up by Jean Roth , jroth@nber.org , 21 Jun 2015 32. ndchcpcsasp20071 set up by Jean Roth , jroth@nber.org , 21 Jun 2015 33. Source: January 2007 NDC-HCPCS Crosswalk 12-18-06v2.xls 34. ndchcpcsopps20071 set up by Jean Roth , jroth@nber.org , 21 Jun 2015 35. ndchcpcsasp200810 set up by Jean Roth , jroth@nber.org , 21 Jun 2015 36. Source: October 2008 ASP NDC_HCPCS Crosswalk 091508.xls 37. ndchcpcsopps200810 set up by Jean Roth , jroth@nber.org , 21 Jun 2015 38. Source: October 2008 OPPS NDC-HCPCS Crosswalk.xls 39. ndchcpcsasp20087 set up by Jean Roth , jroth@nber.org , 21 Jun 2015 40. Source: July 2008 ASP NDC-HCPCS Crosswalk 061608.xls 41. ndchcpcsopps20087 set up by Jean Roth , jroth@nber.org , 21 Jun 2015 42. Source: July 2008 OPPS NDC-HCPCS Croswalk 061608.xls 43. ndchcpcsasp20084 set up by Jean Roth , jroth@nber.org , 21 Jun 2015 44. Source: April 2008 ASP NDC-HCPCS Crosswalk 032008.xls 45. ndchcpcsopps20084 set up by Jean Roth , jroth@nber.org , 21 Jun 2015 46. Source: April 2008 OPPS NDC-HCPCS Crosswalk 032108.xls 47. ndchcpcsasp20081 set up by Jean Roth , jroth@nber.org , 21 Jun 2015 48. Source: January 2008 NDC-HCPCS ASP Crosswalk 121407.xls 49. ndchcpcsopps20081 set up by Jean Roth , jroth@nber.org , 21 Jun 2015 50. Source: January 2008 NDC-HCPCS OPPS Crosswalk 121407.xls 51. ndchcpcsasp200910 set up by Jean Roth , jroth@nber.org , 21 Jun 2015 52. Source: October 2009 ASP NDC_HCPCS Crosswalk 092010.xls 53. ndchcpcsopps200910 set up by Jean Roth , jroth@nber.org , 21 Jun 2015 54. Source: October 2009 OPPS NDC-HCPCS Crosswalk 091409.xls 55. ndchcpcsasp20097 set up by Jean Roth , jroth@nber.org , 21 Jun 2015 56. Source: July 2009 ASP NDC_HCPCS Crosswalk 061709.xls 57. ndchcpcsopps20097 set up by Jean Roth , jroth@nber.org , 21 Jun 2015 58. Source: July 2009 OPPS NDC-HCPCS Crosswalk 061709.xls 59. ndchcpcsasp20094 set up by Jean Roth , jroth@nber.org , 21 Jun 2015 60. Source: April 2009 ASP NDC_HCPCS Crosswalk 032409.xls 61. ndchcpcsopps20094 set up by Jean Roth , jroth@nber.org , 21 Jun 2015 62. Source: April 2009 OPPS NDC-HCPCS Crosswalk 032509.xls 63. ndchcpcsasp20091 set up by Jean Roth , jroth@nber.org , 21 Jun 2015 64. Source: January 2009 NDC_HCPCS Crosswalk 121508.xls 65. ndchcpcsopps20091 set up by Jean Roth , jroth@nber.org , 21 Jun 2015 66. Source: January 2009 OPPS NDC-HCPCS Crosswalk 121508.xls 67. ndchcpcsasp201010 set up by Jean Roth , jroth@nber.org , 21 Jun 2015 68. Source: October 2010 ASP NDC-HCPCS Crosswalk revised 091511.xls 69. ndchcpcsopps201010 set up by Jean Roth , jroth@nber.org , 21 Jun 2015 70. Source: October 2010 OPPS NDC-HCPCS Crosswalk 092410.xls 71. ndchcpcsasp20107 set up by Jean Roth , jroth@nber.org , 21 Jun 2015 72. Source: July 2010 ASP NDC_HCPCS Crosswalk 061611.xls 73. ndchcpcsopps20107 set up by Jean Roth , jroth@nber.org , 21 Jun 2015 74. Source: July 2010 OPPS NDC-HCPCS Crosswalk 061810.xls 75. ndchcpcsasp20104 set up by Jean Roth , jroth@nber.org , 21 Jun 2015 76. Source: April 2010 ASP NDC_HCPCS Crosswalk 092010.xls 77. ndchcpcsopps20104 set up by Jean Roth , jroth@nber.org , 21 Jun 2015 78. Source: April 2010 OPPS NDC-HCPCS Crosswalk 040110.xls 79. ndchcpcsasp20101 set up by Jean Roth , jroth@nber.org , 21 Jun 2015 80. Source: January 2010 ASP NDC HCPCS Crosswalk 092010.xls 81. ndchcpcsopps20101 set up by Jean Roth , jroth@nber.org , 21 Jun 2015 82. Source: Jan 2010 OPPS NDC-HCPCS Crosswalk 121709.xls 83. ndchcpcsasp201110 set up by Jean Roth , jroth@nber.org , 17 Jun 2015 84. Source: October 2011 ASP NDC-HCPCS Crosswalk updated 120911.xls 85. ndchcpcsopps201110 set up by Jean Roth , jroth@nber.org , 17 Jun 2015 86. Source: October 2011 OPPS NDC-HCPCS Crosswalk 091511.xls 87. ndchcpcsasp20117 set up by Jean Roth , jroth@nber.org , 21 Jun 2015 88. Source: July 2011 ASP NDC-HCPCS Crosswalk revised 12152011.xls 89. ndchcpcsopps20117 set up by Jean Roth , jroth@nber.org , 21 Jun 2015 90. Source: July 2011 OPPS NDC-HCPCS Crosswalk 061611.xls 91. ndchcpcsasp20114 set up by Jean Roth , jroth@nber.org , 21 Jun 2015 92. Source: April 2011 ASP NDC-HCPCS Crosswalk revised 09152011.xls 93. ndchcpcsopps20114 set up by Jean Roth , jroth@nber.org , 21 Jun 2015 94. Source: April 2011 OPPS NDC-HCPCS Crosswalk 030911.xls 95. ndchcpcsasp20111 set up by Jean Roth , jroth@nber.org , 21 Jun 2015 96. Source: January 2011 ASP NDC-HCPCS Crosswalk revised 091511.xls 97. ndchcpcsopps20111 set up by Jean Roth , jroth@nber.org , 21 Jun 2015 98. Source: January 2011 OPPS NDC-HCPCS Crosswalk 121610.xls 99. ndchcpcsasp201210 set up by Jean Roth , jroth@nber.org , 21 Jun 2015 100. Source: October 2012 ASP NDC-HCPCS Crosswalk revised 031313.xls 101. ndchcpcsopps201210 set up by Jean Roth , jroth@nber.org , 21 Jun 2015 102. Source: October 2012 OPPS NDC-HCPCS Crosswalk 090612.xls 103. ndchcpcsasp20127 set up by Jean Roth , jroth@nber.org , 21 Jun 2015 104. Source: July 2012 ASP NDC-HCPCS Crosswalk revised 031313.xls 105. ndchcpcsopps20127 set up by Jean Roth , jroth@nber.org , 21 Jun 2015 106. Source: July 2012 OPPS NDC-HCPCS Crosswalk 060712.xls 107. ndchcpcsasp20124 set up by Jean Roth , jroth@nber.org , 21 Jun 2015 108. Source: April 2012 ASP NDC-HCPCS Crosswalk revised 031313.xls 109. ndchcpcsopps20124 set up by Jean Roth , jroth@nber.org , 21 Jun 2015 110. Source: April 2012 OPPS NDC-HCPCS Crosswalk 031512.xls 111. ndchcpcsasp20121 set up by Jean Roth , jroth@nber.org , 21 Jun 2015 112. Source: January 2012 ASP NDC-HCPCS Crosswalk 120911.xls 113. ndchcpcsopps20121 set up by Jean Roth , jroth@nber.org , 21 Jun 2015 114. Source: January 2012 OPPS NDC-HCPCS Crosswalk 120911.xls 115. ndchcpcsasp201310 set up by Jean Roth , jroth@nber.org , 21 Jun 2015 116. Source: October 2013 ASP NDC-HCPCS Crosswalk 083013.xls 117. ndchcpcsopps201310 set up by Jean Roth , jroth@nber.org , 21 Jun 2015 118. Source: October 2013 OPPS NDC-HCPCS Crosswalk 083013.xls 119. ndchcpcsasp20137 set up by Jean Roth , jroth@nber.org , 21 Jun 2015 120. Source: July 2013 ASP NDC-HCPCS Crosswalk updated 083013.xls 121. ndchcpcsopps20137 set up by Jean Roth , jroth@nber.org , 21 Jun 2015 122. Source: July 2013 OPPS NDC-HCPCS Crosswalk 060513.xls 123. ndchcpcsasp20134 set up by Jean Roth , jroth@nber.org , 21 Jun 2015 124. Source: Apr 13 ASP NDC-HCPCS Crosswalk updated 083013.xls 125. ndchcpcsopps20134 set up by Jean Roth , jroth@nber.org , 21 Jun 2015 126. Source: April 2013 OPPS NDC-HCPCS Crosswalk correction - 060513.xls 127. ndchcpcsasp20131 set up by Jean Roth , jroth@nber.org , 21 Jun 2015 128. Source: January 2013 ASP NDC-HCPCS Crosswalk updated 031313.xls 129. ndchcpcsopps20131 set up by Jean Roth , jroth@nber.org , 21 Jun 2015 130. Source: January 2013 OPPS NDC-HCPCS Crosswalk 120612.xls 131. ndchcpcsasp201410 set up by Jean Roth , jroth@nber.org , 21 Jun 2015 132. Source: October 2014 ASP NDC-HCPCS Crosswalk 093014.xls 133. ndchcpcsopps201410 set up by Jean Roth , jroth@nber.org , 21 Jun 2015 134. Source: October 2014 OPPS NDC-HCPCS Crosswalk 090914.xls 135. ndchcpcsasp20147 set up by Jean Roth , jroth@nber.org , 21 Jun 2015 136. Source: July 2014 ASP NDC-HCPCS Crosswalk 061714.xls 137. ndchcpcsopps20147 set up by Jean Roth , jroth@nber.org , 21 Jun 2015 138. Source: July 2014 OPPS NDC-HCPCS Crosswalk 061014.xls 139. ndchcpcsasp20144 set up by Jean Roth , jroth@nber.org , 21 Jun 2015 140. Source: April 2014 ASP NDC-HCPCS Crosswalk 030414.xls 141. ndchcpcsopps20144 set up by Jean Roth , jroth@nber.org , 21 Jun 2015 142. Source: April 2014 OPPS NDC-HCPCS Crosswalk 022714.xls 143. ndchcpcsasp20141 set up by Jean Roth , jroth@nber.org , 21 Jun 2015 144. Source: January 2014 ASP NDC-HCPCS Crosswalk 120313.xls 145. ndchcpcsopps20141 set up by Jean Roth , jroth@nber.org , 21 Jun 2015 146. Source: January 2014 OPPS NDC-HCPCS Crosswalk 120313.xls 147. ndchcpcsasp20157 set up by Jean Roth , jroth@nber.org , 21 Jun 2015 148. Source: July 2015 ASP NDC-HCPCS Crosswalk 052715.xls 149. ndchcpcsopps20157 set up by Jean Roth , jroth@nber.org , 21 Jun 2015 150. Source: July 2015 OPPS NDC-HCPCS Crosswalk 052715.xls 151. ndchcpcsasp20154 set up by Jean Roth , jroth@nber.org , 21 Jun 2015 152. Source: April 2015 ASP NDC-HCPCS Crosswalk 031115.xls 153. ndchcpcsopps20154 set up by Jean Roth , jroth@nber.org , 21 Jun 2015 154. Source: April 2015 OPPS NDC-HCPCS Crosswalk 031115.xls 155. ndchcpcsasp20151 set up by Jean Roth , jroth@nber.org , 21 Jun 2015 156. Source: January 2015 ASP NDC-HCPCS Crosswalk 120414.xls 157. ndchcpcsopps20151 set up by Jean Roth , jroth@nber.org , 21 Jun 2015 158. Source: January 2015 OPPS NDC-HCPCS Crosswalk 120414.xls ndc: 1. The National Drug Code (NDC) serves as a universal product identifier for human drugs and biologics. 2. Each NDC must be reported as an 11-digit code unique to the manufacturer of the specific drug or product. ndcdash: 1. The National Drug Code (NDC) serves as a universal product identifier for human drugs and biologics. 2. Each NDC must be reported as an 11-digit code unique to the manufacturer of the specific drug or product. hcpcs: 1. HCPCS codes are used by Medicare and monitored by the CMS . 2. HCPCS Level II codes are assigned to every service a medical practitioner provides 3. to a Medicare patient including durable medical equipment, prosthetics and orthotics supplies. 4. These codes are an alpha character followed by four numbers. ndc13: 1. The National Drug Code (NDC) serves as a universal product identifier for human drugs and biologics. 2. Each NDC must be reported as an 11-digit code unique to the manufacturer of the specific drug or product. ndcmod: 1. Healthcare Common Procedure Coding System (HCPCS) Level II codes 2. may require the use of modifiers to capture the exact nature of the service. 3. The Level II modifiers are two alphabetic or alphanumeric digits. hcpcsmod: 1. HCPCS Level II codes may require the use of modifiers to capture the exact nature of the service. 2. The Level II modifiers are two alphabetic or alphanumeric digits. relationshipstartdate: 1. The relationship start date between the NDC and HCPCS code. 2. A new relationship start date is listed whenever any of the following occur: 3. New HCPCS code added 4. New NDC code added 5. NDC is reactivated 6. HCPCS code change description that adds a new NDC relationship for the HCPCS code relationshipenddate: 1. The relationship end date between the NDC and HCPCS code. 2. A new relationship end date is listed whenever any of the following occur: 3. HCPCS Code Deletion 4. NDC Withdrawn 5. NDC deactivated hcpcsdescription: 1. The long description of the HCPCS Level II code ndclabel: 1. The following information may be present in this field: 2. Product name given to the product by the manufacturer. 3. Additional information on product characteristics not captured in other fields may be provided. 4. Details of packaging and preparation, such as "dialpak," "fliptop vial," "premixed," and "micronized." 5. Flavors may be listed when applicable. Also shown, when appropriate, is information on package dimensions 6. -- for example, "2 x 5 x 10" - and descriptive material such as "sulfite-free," "refill," and "non-drowsy." 7. The product strength listed in alphabetical order of the active ingredients. 8. For combination products, a hyphen may separate the individual strengths of the active ingredients. 9. For example, the strength of acetaminophen with codeine is expressed as "325 mg-30 mg." numberofitemsinndcpackage: 1. The amount of product contained in the package as defined 2. by the billing unit standard of the National Council for Prescription Drug Programs (NCPDP). ndcpackagemeasure: 1. The total size of the package in volume or number of units contained. ndcpackagetype: 1. The container or package used for the drug product, i.e. vial, bottle, bag, etc. billingunits: 1. The unit of measure when billing NDC units. 2. Provides the two-character abbreviation corresponding to valid units of measure per the NCPDP standard. 3. The only valid values for this field are "ea," "gm," or "ml." hcpcsamount1: 1. The amount of product in a HCPCS billing unit (may be found in the HCPCS description). hcpcsmeasure1: 1. The number of HCPCS units in one NCPDP billing unit. cf: 1. The Conversion Factor (CF) is the rate to convert HCPCS quantity to NDC quantity. 2. This is derived by dividing the NDC amount by the HCPCS amount. startdate1: 1. The Start Date #1 is the relationship start date between the NDC and HCPCS code. enddate1: 1. The End Date #1 is the relationship end date between the NDC and HCPCS code. pkgsize: 1. amount in one item. (ex., For a product that is 100mcg/0.5 ml in one vial, the package size would be 0.5.) pkgqty: 1. Package Quantity: number of items in the NDC (ex., For an NDC that is 4 vials in a shelf pack, the package quantity would be 4.) billunitspkg: 1. Billable Units Per Package: the number of billable units per package (ex., 100 mcg in a package divided by 5 mcg in the dosage descriptor = 20 billable units per package.) hcpcsdosage: 1. Dosage descriptor assigned to the HCPCS code (ex., 5 mcg.) obs: 25,329 vars: 60 12 Jan 2018 10:15 size: 22,542,810 (_dta has notes) ------------------------------------------------------------------------------- storage display value variable name type format label variable label ------------------------------------------------------------------------------- ndc str15 %15s * National Drug Code (NDC) ndcdash str15 %15s * National Drug Code (NDC) with Dashes hcpcs str5 %9s * Healthcare Common Procedure Coding System (HCPCS) change str30 %30s Change newvalue str4 %9s New Value ndc13 str13 %13s * National Drug Code (NDC) with Dashes ndcmod str2 %9s * National Drug Code Modifier Code hcpcsmod str2 %9s * Healthcare Common Procedure Coding System (HCPCS) Modifier Code relationshipstartdate int %td.. * Relationship Start Date relationshipenddate long %td.. * Relationship End Date hcpcsdescription str251 %251s * HCPCS Description ndclabel str93 %93s * NDC Label numberofitemsinndcpackage double %10.0g * Number of Items in NDC Package ndcpackagemeasure str3 %9s * NDC Package Measure ndcpackagetype str3 %9s * NDC Package Type routeofadministration str2 %9s Route of Administration billingunits str2 %9s * Billing Units hcpcsamount1 double %10.0g * HCPCS Amount #1 hcpcsmeasure1 str12 %12s * HCPCS Measure #1 cf double %10.0g * Conversion Factor startdate1 int %td.. * Start Date #1 enddate1 int %td.. * End Date #1 priorstartdate2 int %td.. Prior Start Date #2 priorenddate2 int %td.. Prior End Date #2 priorconversionfactor2 double %10.0g Prior Conversion Factor #2 priorstartdate3 long %td.. Prior Start Date #3 priorenddate3 int %td.. Prior End Date #3 priorconversionfactor3 byte %10.0g Prior Conversion Factor #3 ndcpackagesizequantity double %10.0g NDC Package Size Quantity ndcpackagesizemeasure str2 %9s NDC Package Size Measure ndcpackagetypeamount int %10.0g NDC Package Type Amount ndcpackagetypemeasure str2 %9s NDC Package Type Measure ndcamount1 double %10.0g NDC Amount #1 ndcunitofmeasure1 str9 %9s NDC Unit of Measure #1 ndcamount2 double %10.0g NDC Amount #2 ndcunitofmeasure2 str7 %9s NDC Unit of Measure #2 ndcamount3 byte %10.0g NDC Amount #3 ndcunitofmeasure3 str9 %9s NDC Unit of Measure #3 ndcperamount double %10.0g NDC Per Amount ndcperunitofmeasure str9 %9s NDC Per Unit of Measure billableunitsperpackage double %10.0g Billable Units per Package form str3 %9s Form manufacturersrebate str1 %9s Manufacturer's Rebate rebatestartdate str10 %10s Rebate Start Date rebateenddate str10 %10s Rebate End Date hcpcsamount2 double %10.0g HCPCS Amount #2 hcpcsmeasure2 str2 %9s HCPCS Measure #2 hcpcsamount3 byte %10.0g HCPCS Amount #3 hcpcsmeasure3 str5 %9s HCPCS Measure #3 codedosagedescriptor str14 %14s Code Dosage Descriptor labelername str62 %62s Manufacturer Name drugname str59 %59s Drug Name (Brand Name or Generic Name) pkgsize double %10.0g * Package Size: Amount in one item pkgqty double %10.0g * Package Quantity: Number of items in the NDC billunitspkg double %10.0g * Per Package: the number of billable units per package billunits double %10.0g Billable Units hcpcsdosage str43 %43s * Dosage descriptor assigned to the HCPCS code notes str14 %14s Notes shortdescription str39 %39s Short Description _merge byte %23.0g _merge * indicated variables have notes ------------------------------------------------------------------------------- Sorted by: _merge: 1 master only (1) 2 using only (2) 3 matched (3) 4 missing updated (4) 5 nonmissing conflict (5)