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.

The SPECIALIST Lexicon

Validate and Fix LEXICON in LexBuild

  • Step 0:Fix illegal EUI (E0000000):
    If E0000000 exist, remove them in LexBuild
    • select * from LEX_RECORD where eui = 'E0000000'
    • delete from LEX_RECORD where eui = 'E0000000'

  • Step 1:Generate LEXICON from LexBuild
    • Generate Lexicon from WebLexBuild or comand line as follows:
      shell> cd ${LEX_BUILD}/Tools/LoadDb
      shell> GenScript
      1 (Generate Lexicon) => ${BACKUP}/Routine/Lexicon/${YEAR}/LEXICON
      2 (Generate inflVars) => ${BACKUP}/Routine/Lexicon/${YEAR}/inflvars => ${BACKUP}/Routine/Lexicon/${YEAR}/inflvarsTemp
    • Generate database table files from WebLexBuild or comand line as follows:
      shell> cd ${LEX_BUILD}/Tools/LoadDb
      shell> DbScript
      1 (Backup Lexicon)
      1
      4
      12 => ${BACKUP}/Routine/LexBuild/${YEAR}/${DATE}/
    • Backup database tables and Lexicon for the release to lexdev:${LEX_BUILD}/data.${SERVER}/DbTables/Releases/Tables.${YEAR}.release
    • After 2016+, the overnight backup Lexicon tables and Lexicon are used to replace this manual generation step.
    • No lexical record should be waiting for approval for the frozen Lexicon for the release.

Notes: After this point, The flat file, LEXICON, is the only input file used for generating all tables in LEXICON annual release.