找回密码
 欢迎注册
搜索
热搜: 活动 交友 discuz
查看: 261|回复: 1

UMLS中目前关注的四个表之一[MRCONSO]

[复制链接]
发表于 2007-10-6 12:12:17 | 显示全部楼层 |阅读模式
2.7.1.3.4 Concept Names and Sources (File = MRCONSO.RRF)
There is exactly one row in this file for each atom (each occurrence of each unique string or concept name within each source vocabulary) in the Metathesaurus, i.e., there is exactly one row for each unique AUI in the Metathesaurus. Every string or concept name in the Metathesaurus appears in this file, connected to its language, source vocabularies, and its concept identifier. The values of TS, STT, and ISPREF reflect the default order of precedence of vocabulary sources and term types in MRRANK.RRF.

Col.
Description

CUI
Unique identifier for concept

LAT
Language of term

TS
Term status

LUI
Unique identifier for term

STT
String type

SUI
Unique identifier for string

ISPREF
Atom status - preferred (Y) or not (N) for this string within this concept

AUI
Unique identifier for atom - variable length field, 8 or 9 characters

SAUI
Source asserted atom identifier [optional]

SCUI
Source asserted concept identifier [optional]

SDUI
Source asserted descriptor identifier [optional]

SAB
Abbreviated source name (SAB).  Maximum field length is 20 alphanumeric characters.  Two source abbreviations are assigned:  
  • Root Source Abbreviation (RSAB) — short form, no version information, for example, AI/RHEUM, 1993, has an RSAB of "AIR"
  • Versioned Source Abbreviation (VSAB) — includes version information, for example, AI/RHEUM, 1993, has an VSAB of "AIR93"
Official source names, RSABs, and VSABs are included in Appendix B.4.

TTY
Abbreviation for term type in source vocabulary, for example PN (Metathesaurus Preferred Name) or CD (Clinical Drug). Possible values are listed in Appendix B.3.

CODE
Most useful source asserted identifier (if the source vocabulary has more than one identifier), or a Metathesaurus-generated source entry identifier (if the source vocabulary has none)

STR
String

SRL
Source restriction level

SUPPRESS
Suppressible flag. Values = O, E, Y, or N
O: All obsolete content, whether they are obsolesced by the source or by NLM.
These will include all atoms having obsolete TTYs, and other atoms becoming obsolete that have not acquired an obsolete TTY (e.g. RxNorm SCDs no longer associated with current drugs, LNC atoms derived from obsolete LNC concepts).

E: Non-obsolete content marked suppressible by an editor. These do not have a suppressible SAB/TTY combination.

Y: Non-obsolete content deemed suppressible during inversion. These can be determined by a specific SAB/TTY combination explicitly listed in MRRANK.

N: None of the above

Default suppressibility as determined by NLM (i.e., no changes at the Suppressibility tab in MetamorphoSys) should be used by most users, but may not be suitable in some specialized applications. See the MetamorphoSys documentation (Section 6) for information on how to change the SAB/TTY suppressibility to suit your requirements. NLM strongly recommends that users not alter editor-assigned suppressibility, and MetamorphoSys cannot be used for this purpose.

CVF
Content View Flag. Bit field used to flag rows included in Content View. This field is a varchar field to maximize the number of bits available for use.
Sample Records
C0001175|ENG|P|L0001175|VO|S0010340|Y|A0019182||M0000245|D000163|MSH|PM|D000163|
     Acquired Immunodeficiency Syndromes|0|N||
C0001175|ENG|S|L0001842|PF|S0011877|N|A2878223|103840012|62479008||SNOMEDCT|PT|62479008|AIDS|4|N||
C0001175|ENG|P|L0001175|VC|S0354232|Y|A2922342|103845019|62479008||SNOMEDCT|SY|62479008|
     Acquired immunodeficiency syndrome|4|Y||
C0001175|FRE|P|L0162173|PF|S0226654|Y|A0248753||||INS|MH|d000163|SIDA|3|N||
C0001175|RUS|P|L0904943|PF|S1108760|Y|A1165232||||RUS|MH|D000163|SPID|3|N||
 楼主| 发表于 2007-10-6 12:16:27 | 显示全部楼层
2007AB 版
4963558条记录
主键 AUI
ISPref
4298801
按CUI
1274130
按 lat='ENG' and ts='P'
1780597
按 lat='ENG' and ts='P' and ispref='Y'
1499259
按 lat='ENG' and ts='P' and ispref='Y' and stt='PF'
1274115[最接近1274130]
您需要登录后才可以回帖 登录 | 欢迎注册

本版积分规则

快速回复 返回顶部 返回列表