_dta: 1. ndc_hcpcsxw set up by Jean Roth , jroth@nber.org , 9 Feb 2018 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. obs: 17,825 vars: 49 9 Feb 2018 15:57 size: 11,087,150 (_dta has notes) ----------------------------------------------------------------------------------------- storage display value variable name type format label variable label ----------------------------------------------------------------------------------------- ndc str13 %13s * National Drug Code (NDC) ndcdash str13 %13s * 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 * indicated variables have notes ----------------------------------------------------------------------------------------- Sorted by: ndc ndcmod hcpcs hcpcsmod