NormTerm_CUI Table

• I. Db Table

  NormTermCui
  Name	Type	Properties	Notes
  normKeyTerm	VARCHAR(3100)	Index, NOT NULL	Normalized term
  cui	VARCHAR(8)	NOT NULL	Concept 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 Version	Rows
  Meta-2024AA	12,279,091
  Meta-2023AB	12,116,757
  Meta-2023AA	11,929,127
  Meta-2022AB	13,753,197
  Meta-2022AA	13,428,003
  Meta-2021AB	13,338,099
  Meta-2021AA	12,944,270
  Meta-2020AB	12,846,408
  Meta-2020AA	12,390,483
  Meta-2019AB	12,227,428
  Meta-2019AA	11,421,872
  Meta-2018AB	11,334,948
  Meta-2018AA	10,908,150
  Meta-2017AB	10,804,573
  Meta-2017AA	10,391,723
  Meta-2016AB	10,285,050
  Meta-2016AA	9,824,750
  Meta-2015AB	9,601,523
  Meta-2015AA	9,500,098
  Meta-2014AB	9,419,535
  Meta-2014AA	9,065,928
  Meta-2013AB	8,603,754
  Meta-2013AA	8,695,321
  Meta-2012AB	8,607,838
  Meta-2012AA	7,996,479
  Meta-2011AB	7,930,988
  Meta-2011AA	7,350,864