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.

Lexical Tools

Nominalization Tables

  • Tables:

    Nominalization
    NameTypePropertiesNotes
    eui1CHAR(8)NOT NULLEUI: Unique ID 1
    nomTerm1CHAR(70)Index key Nominalization term 1
    cat 1INT Category
    eui2CHAR(8)NOT NULLEUI: Unique ID 2
    nomTerm2CHAR(70)Index key Nominalization term 2
    cat 2INT Category

    Notes:
    The maximum length for nomTerm1 is 69. We use CHAR(70) for this column.
    The maximum length for nomTerm2 is 68. We use CHAR(70) for this column.

  • SQL Examples:

    • Find mapping lexicon terms for "XXX"
      1. SELECT nomTerm2 FROM Nominalization WHERE nomTerm1 = "xxx"
      2. SELECT nomTerm1 FROM Nominalization WHERE nomTerm2 = "xxx"