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

Freeze and initial validate LEXICON

I. Generate LB tables and LEXICON from LexBuild (or use the daily backup)

  • Use the daily backup tables form lexBuild or lhc-lx-lexdev01
    • copy Lexbuild tables
      • cp -rp ${BACK_DIR}/Routine.lexBuild/LexBuild/${YEAR}/${MM_DD_YY}.lexsrv1 ${LEX_BUILD_DIR}/data.lexdev/DbTables/Table.${YEAR}.release
      • Use ${LexBuild}/Tools/LoadDb/removeSuffix to clean up the suffix => Make sure remove illegal lexRecords with Eui = E0000000
        • select * from LEX_RECORD where eui = 'E0000000'
        • delete from LEX_RECORD where eui = 'E0000000'

II. Load the tables to LexBuild in lhc-lx-lexdev

  • cd ${LEX_BUILD_DIR}/Tools/LoadDb/
  • removeSuffix
    => Remove time stamp
    => shell> <removeSuffix> <all> <dir> <suffix>
  • Make a copy of the data
    • cd ${LEX_BUILD_DIR}/data.lexdev/DbTables/
    • ln -sf ./Tables.mmddyy ./Tables
  • DbScript
    • 6) Drop tables: delete records + tables
    • 1) Create tables
    • 2) Load tables

III. Double Check - Work on the LexBuild in lhc-lx-lexdev for the following steps
=> Generate Lexicon from LexBuild
=> Double check the frozen copy is OK!

  • Login to lexBuild
  • Use Post-Proc -> Cross-Ref to fix Cross reference
  • Use Post-Proc -> Db Output to Generate Lexicon
  • Compare the following files and make sure they are identical:
    • LEXICON
    • inflVars
    • InflVarsTemp

IV. Obtain the baseline of LEXICON

  • Make a copy of Lexicon.freeze direcotry
    cp -rp ${BACKUP}/Routine.lexBuild/Lexicon/${YEAR}/lexdev.mmddyy ${LEXICON}/Lexicon/data/${YEAR}/data/LEXICON.mmddyy
  • Make a symbolic link of Lexicon.freeze file
    ln -sf ./LEXICON.mmddyy LEXICON.freeze