Because of a lapse in government funding, the information on this website may not be up to date, transactions submitted via the website may not be processed, and the agency may not be able to respond to inquiries until appropriations are enacted. The NIH Clinical Center (the research hospital of NIH) is open. For more details about its operating status, please visit cc.nih.gov. Updates regarding government operating status and resumption of normal operations can be found at OPM.gov.

Sub-Term Mapping Tools

NormTerm_CUI Table

  • I. Db Table

    NormTermCui
    NameTypePropertiesNotes
    normKeyTermVARCHAR(3100)Index, NOT NULLNormalized term
    cuiVARCHAR(8)NOT NULLConcept Unique Identifier

  • II. SQL Examples
    • Find CUI for term, "XXX"
      1. normXxx = LvgNorm("XXX")
      2. SELECT cui FROM NormTermCui WHERE normKeyTerm= 'NormXxx';

  • III. Data

    File: ${STMT_DIR}/data/tables/normTermCui.data
    Used in smt and mt

    Meta VersionRows
    Meta-2025AA12,756,000
    Meta-2024AB12,492,783
    Meta-2024AA12,279,091
    Meta-2023AB12,116,757
    Meta-2023AA11,929,127
    Meta-2022AB13,753,197
    Meta-2022AA13,428,003
    Meta-2021AB13,338,099
    Meta-2021AA12,944,270
    Meta-2020AB12,846,408
    Meta-2020AA12,390,483
    Meta-2019AB12,227,428
    Meta-2019AA11,421,872
    Meta-2018AB11,334,948
    Meta-2018AA10,908,150
    Meta-2017AB10,804,573
    Meta-2017AA10,391,723
    Meta-2016AB10,285,050
    Meta-2016AA9,824,750
    Meta-2015AB9,601,523
    Meta-2015AA9,500,098
    Meta-2014AB9,419,535
    Meta-2014AA9,065,928
    Meta-2013AB8,603,754
    Meta-2013AA8,695,321
    Meta-2012AB8,607,838
    Meta-2012AA7,996,479
    Meta-2011AB7,930,988
    Meta-2011AA7,350,864