Follow the links below to access each resource. Please contact us if you have any questions or problems with access.
Finding Diagnosis Codes
Visit this free ICD-9-CM Medical Coding Reference for American ICD-10-CM (diagnosis) and ICD-10-PCS (procedure) medical billing codes: https://www.icd10data.com/. For codes needed prior to 2015, visit http://www.icd9data.com/.
Finding CPT and HCPCS Codes
The Centers for Medicare & Medicaid Services provide a list of Current Procedural Terminology (CPT)/Healthcare Common Procedure Coding System (HCPCS) Codes at https://www.cms.gov/medicare/regulations-guidance/physician-self-referral/list-cpt-hcpcs-codes.
Finding LOINC Codes
After a free registration, you may search for Logical Observation Identifier Names and Codes (LOINC) at https://search.loinc.org/searchLOINC/
Finding RXCUI Codes
The National Library of Medicine provides access to their standard terminology for drugs. RxNav will enable you to find machine-readable RxNorm Concept Unique Identifiers. To start, visit https://rxnav.nlm.nih.gov/ and follow the instructions below.
Instructions:
- Click on RXNav.
- Make sure the drop down option on the search bar is on “String”.
- Enter the drug you’re searching for in the search bar.
- On the Views tab on the side bar, select “Table”
- Copy and Paste into an Excel Spreadsheet and save as a rtf.
Converting RXCUIs to NDCs
This process will enable you to convert RxNorm Concept Unique Identifiers to National Drug Codes. Follow the instructions below.
Instructions:
- You will need to download the 7zip program: https://www.7-zip.org/download.html.
- Copy and paste the RXcui codes into notepad.
- Save as a txt file.
- Open: https://rxnav.nlm.nih.gov/
- Click on RXmix.
- Under the “BUILD” section, select the function “getNDCs” and click “Add to Workflow”.
- Scroll down to the bottom of the screen and click the side tab that says “Batch”
- Next, click “Click to load an Input File” and select the txt file you previously saved.
- Enter your email address in the “Email” box.
- Select the Output Format to be “TEXT”.
- Click “Submit Batch”.
- You will receive 2 emails. The second should contain a link to download the file, click the link.
- Save the file as a GZ file.
- Right click over saved GZ file. Scroll over “7zip”.
- Click “Extract Files”. Select a location like your desktop.
- Open the folder and right click only file. Scroll over 7zip and select “Extract Here”.
- Open the folder and then open the text file.
- Copy and paste information into an excel spreadsheet.
Functional Requirements
The National Patient-Centered Clinical Research Network, PCORnet, offers this example of a functional requirements document. Open the PDF document with this link: Functional Requirements Document (Example)
Query Request – Codes Template
Here we offer two Excel spreadsheets for managing codes. Select Query Request – Codes (Template) for an empty spreadsheet, or select Query Request – Codes (Example) to see an example of a completed spreadsheet.
Well Executed Queries
Proprotein convertase subtilisin/kexin type 9 (PCSK9) inhibitors
For classes of medication for lowering cholesterol levels, we offer the following documents.
- This Word document is offered by the National Patient-Centered Clinical Research Network, PCORnet:
- Effron_PCSK9i Functional Requirements_10232019
- This Excel spreadsheet provides codes based on the International Classification of Diseases: Effron_PCSK9i_ICD_codes
- This Excel spreadsheet provides codes based on Logical Observation Identifier Names and Codes: Effron_PCSK9i_LOINC_codes
- This Excel spreadsheet provides codes related to statin therapy: Effron_PCSK9i_statin_dose
HCV Continuity
For patients with Hepatitis C (HCV), consider the following resource for supporting the continuation of treatment.
- This Excel spreadsheet offers a template for technical specifications for Hepatitis C treatments: TechSpec_template_20181012_EXAMPLE