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

STMT - Table Files

I. Version

The STMT table files are symbolic links from preProcess files as described below. They are used as input files for HSqlDb tables.

Tables Lexicon
  • normInflvarEui.data
  • normInflvarCorpus.data
MetaThesaurus
  • cuiPreferredTerm.data
  • normTermCui.data
  • nonSuppressCui.data
Synonyms
  • normTermSynonyms.data
2011AA20112011AA2011
2011Ascii2011Ascii2011AA2011
2011AB20112011AB2011
2012AA20122012AA2012
2012Ascii2012Ascii2012AA2012
2012AB20122012AB2012
2013AA20132013AA2013
2013Ascii2013Ascii2013AA2013
2013AB20132013AB2013
2014AA20142014AA2014
2014Ascii2014Ascii2014AA2014
2014AB20142014AB2014
${YEAR}AA${YEAR}${YEAR}AA${YEAR}
${YEAR}Ascii${YEAR}Ascii${YEAR}AA${YEAR}
${YEAR}AB${YEAR}${YEAR}AB${YEAR}

II. Run Program

These tables can be generated by the following procedures:
Make sure all preProcessed files are generated. It generates needed files under Lex (2013|2013Ascii), Meta (2013AA|2013AB), and Synonyms (2013). the final tables use different combination as shown above to generate table files.
shell> cd ${STMT_DIR}/PreProcess/bin
shell> 2.GenTables
Lexicon Year (2018|2018Ascii)
MetaThesaurus Year (2018AA|2018AB)
Synonym year (2018)
Table year (2018AA|2018AB|2018Ascii)

III. Zip and backup files

  • ${STMT_PREPROC_DIR}/data/Synonyms/${YEAR}/normTermSynonyms.data
    • shell> cp -p normTermSynonyms.data normTermSynonyms.data.${YEAR}
    • shell> tar -czvf normTermSynonyms.data.${YEAR}.tgz normTermSynonyms.data.${YEAR}
    • shell> mv normTermSynonyms.data.${YEAR}.tgz ${BACK_DIR}/Release/STMT/data/files/.
  • ${STMT_PREPROC_DIR}/data/Tables/${VERSION}/normInflvarCorpus.data
    • shell> cp -p normInflvarCorpus.data normInflvarCorpus.data.${YEAR}
    • shell> tar -czvf normInflvarCorpus.data.${YEAR}.tgz normInflvarCorpus.data.${YEAR}
    • shell> mv normInflvarCorpus.data.${YEAR}.tgz ${BACK_DIR}/Release/STMT/data/files/.