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

CUI_PT Table

  • I. Db Table

    CuiPt
    NameTypePropertiesNotes
    cuiVARCHAR(8)Index, NOT NULLConcept Unique Identifier
    ptVARCHAR(3100)NOT NULLPreferred Term

  • II. SQL Examples
    • Find preferred term for CUI, "Cxxxxxxx"
      1. SELECT pt FROM CuiPt WHERE EUI= 'Cxxxxxxx';

  • III. Data

    File: ${STMT_DIR}/data/tables/cuiPreferredTerm.data
    Used in smt -pt

    Meta VersionRows
    Meta-2025AB3,453,820
    Meta-2024AB3,426,422
    Meta-2024AA3,382,902
    Meta-2023AB3,361,181
    Meta-2023AA3,312,953
    Meta-2022AB4,661,936
    Meta-2022AA4,553,415
    Meta-2021AB4,536,277
    Meta-2021AA4,440,677
    Meta-2020AB4,412,440
    Meta-2020AA4,280,540
    Meta-2019AB4,258,236
    Meta-2019AA3,847,999
    Meta-2018AB3,822,264
    Meta-2018AA3,665,368
    Meta-2017AB3,639,655
    Meta-2017AA3,465,007
    Meta-2016AB3,436,328
    Meta-2016AA3,250,160
    Meta-2015AB3,221,156
    Meta-2015AA3,114,753
    Meta-2014AB3,091,269
    Meta-2014AA2,972,950
    Meta-2013AB2,880,384
    Meta-2013AA2,918,436
    Meta-2012AB2,885,877
    Meta-2012AA2,669,278
    Meta-2011AB2,611,468
    Meta-2011AA2,404,431