Front Door Data Resources

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:

  1. Click on RXNav.
  2. Make sure the drop down option on the search bar is on “String”.
  3. Enter the drug you’re searching for in the search bar.
  4. On the Views tab on the side bar, select “Table”
  5. 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:

  1. You will need to download the 7zip program: https://www.7-zip.org/download.html.
  2. Copy and paste the RXcui codes into notepad.
    1. Save as a txt file.
  3. Open: https://rxnav.nlm.nih.gov/
    1. Click on RXmix.
    2. Under the “BUILD” section, select the function “getNDCs” and click “Add to Workflow”.
    3. Scroll down to the bottom of the screen and click the side tab that says “Batch”
    4. Next, click “Click to load an Input File” and select the txt file you previously saved.
    5. Enter your email address in the “Email” box.
    6. Select the Output Format to be “TEXT”.
    7. Click “Submit Batch”.
  4. You will receive 2 emails. The second should contain a link to download the file, click the link.
    1. Save the file as a GZ file.
  5. Right click over saved GZ file. Scroll over “7zip”.
    1. Click “Extract Files”. Select a location like your desktop.
    2. Open the folder and right click only file. Scroll over 7zip and select “Extract Here”.
    3. Open the folder and then open the text file.
    4. 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.

HCV Continuity

For patients with Hepatitis C (HCV), consider the following resource for supporting the continuation of treatment.