2008AA Section B

United States National Library of Medicine National Institutes of Health

Return to Web Version

Printer-friendly Version

APPENDIX B

METATHESAURUS^® METADATA

B.0 Introduction

Appendix B provides details on Metathesaurus data referenced in Section 2 of this documentation.

B.1 Columns and Data Elements: Lists column and data element abbreviations, names and descriptions in Metathesaurus files in alphabetical order by abbreviation; includes field length and SQL92 datatype information. Provided for both Original Release and Rich Release Formats.

B.1.1 Columns and Data Elements in Rich Release Format (RRF)

B.1.2 Columns and Data Elements in Original Release Format (ORF)

B.2 Attribute Names: Lists attribute names and definitions in alphabetical order by abbreviation.

B.3 Abbreviations Used in Data Elements: Lists abbreviations and definitions of abbreviations used in Metathesaurus data elements, alphabetically by attribute type; includes relationship attributes.

B.4 Source Vocabularies: Lists alphabetically by source abbreviation vocabularies and classifications that are the sources of the concepts, terms and relationships in the Metathesaurus. HIPAA standard and CHI recommended vocabularies and code sets are noted.

B.5 Source and Term Types: Default Order of Precedence and Suppressibility: Lists sources and term types in default order of rank or precedence, used to determine referred names in the Metathesaurus, and notes the default suppressibility status assigned to each Source|Term Type.

B.6 Release Metadata: Provides an overview of the current Metatheasaurus, including summary counts of concepts, names, sources and languages.

B.1 Columns and Data Elements

All data elements in the Metathesaurus are described in this section. The data elements have been divided into Column Descriptions and Attribute Descriptions. The descriptions are arranged alphabetically by data element abbreviation.

Columns are described for Rich Release Format (RRF) in B.1.1, and for Original Release Format (ORF) in B.1.2.

B1.1 Columns and Data Elements in Rich Release Format (RRF)

Abbreviation	Description	File	Length of Value in characters	Average Length of Value in characters	SQL92 Datatype
ATN	Attribute name	MRSAT.RRF	2 - 26	10.13	varchar(50)
ATNL	Attribute name list for a source	MRSAB.RRF	0 - 695	55.31	varchar(1000)
ATUI	Unique identifier for attribute	MRDEF.RRF MRSAT.RRF MRSTY.RRF	10 10 10	10.00 10.00 10.00	varchar(10) varchar(10) varchar(10)
ATV	Attribute value	MRSAT.RRF	0 - 7903	6.17	varchar(8000)
AUI	Unique identifier for atom	MRHIER.RRF MRCONSO.RRF MRDEF.RRF	8 - 9 8 - 9 8 - 9	8.08 8.39 8.49	varchar(9) varchar(9) varchar(9)
AUI1	Unique identifier for first atom	MRREL.RRF MRCOC.RRF MRAUI.RRF	0 - 9 8 - 9 8 - 9	8.11 8.02 8.17	varchar(9) varchar(9) varchar(9)
AUI2	Unique identifier for second atom	MRCOC.RRF MRREL.RRF MRAUI.RRF	0 - 9 0 - 9 8 - 9	8.00 8.11 8.17	varchar(9) varchar(9) varchar(9)
AV	Average Length, Characters	MRCOLS.RRF	4 - 6	4.12	numeric(5,2)
BTS	Size in Bytes	MRFILES.RRF	4 - 10	7.28	integer
CENC	Character encoding of a source as specified by IANA	MRSAB.RRF	5	5.00	varchar(20)
CFR	CUI frequency for a source	MRSAB.RRF	0 - 6	3.75	integer
CHANGEKEY	CONCEPTSTATUS (if history relates to a SNOMED CT concept) or DESCRIPTIONSTATUS (if history relates to a SNOMED CT atom or "description")	MRHIST.RRF	13 - 17	15.81	varchar(1000)
CHANGETYPE	Source asserted code for type of change	MRHIST.RRF	1	1.00	varchar(1000)
CHANGEVAL	SNOMED CT CONCEPTSTATUS or DESCRIPTIONSTATUS value after the change took place	MRHIST.RRF	1 - 2	1.00	varchar(1000)
CLS	Number of columns	MRFILES.RRF	1 - 2	1.14	integer
COA	Attributes of co-occurrence	MRCOC.RRF	0 - 264	9.61	varchar(300)
CODE	Unique Identifier or code for string in source	MRSAT.RRF MRCONSO.RRF	0 - 30 1 - 30	4.96 7.37	varchar(50) varchar(50)
COF	Frequency of co-occurrence	MRCOC.RRF	0 - 5	1.10	integer
COL	Column or data element name	MRCOLS.RRF	2 - 11	3.85	varchar(20)
COT	Type of co-occurrence	MRCOC.RRF	1 - 3	1.10	varchar(3)
CUI	Unique identifier for concept	AMBIGLUI.RRF AMBIGSUI.RRF CHANGE/MERGEDCUI.RRF MRCONSO.RRF MRDEF.RRF MRHIER.RRF MRHIST.RRF MRSAT.RRF MRSTY.RRF MRXNS_ENG.RRF MRXNW_ENG.RRF MRXW_BAQ.RRF MRXW_CZE.RRF MRXW_DAN.RRF MRXW_DUT.RRF MRXW_ENG.RRF MRXW_FIN.RRF MRXW_FRE.RRF MRXW_GER.RRF MRXW_HEB.RRF MRXW_HUN.RRF MRXW_ITA.RRF MRXW_JPN.RRF MRXW_NOR.RRF MRXW_POR.RRF MRXW_RUS.RRF MRXW_SPA.RRF MRXW_SWE.RRF	8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8	8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00	char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8)
CUI1	Unique identifier for first concept	MRAUI.RRF MRCOC.RRF MRCUI.RRF MRREL.RRF	8 8 8 8	8.00 8.00 8.00 8.00	char(8) char(8) char(8) char(8)
CUI2	Unique identifier for second concept	MRCUI.RRF MRCOC.RRF MRAUI.RRF MRREL.RRF	0 - 8 0 - 8 8 8	7.16 7.99 8.00 8.00	char(8) char(8) char(8) char(8)
CURVER	Current Version flag	MRSAB.RRF	1	1.00	char(1)
CVF	Content view flag	MRCOC.RRF MRDEF.RRF MRHIER.RRF MRHIST.RRF MRMAP.RRF MRREL.RRF MRSAT.RRF MRSMAP.RRF MRCONSO.RRF MRSTY.RRF	0 0 0 0 0 0 0 0 0 - 4 0 - 4	0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1.17 2.82	integer integer integer integer integer integer integer integer integer integer
CXN	The context number if the atom has multiple contexts	MRHIER.RRF	1 - 4	1.97	integer
CXTY	Context type for a source	MRSAB.RRF	0 - 31	5.31	varchar(50)
DEF	Definition	MRDEF.RRF	1 - 5796	223.16	varchar(8000)
DES	Descriptive Name	MRCOLS.RRF MRFILES.RRF	5 - 136 8 - 42	29.32 18.40	varchar(200) varchar(200)
DIR	Source asserted directionality flag	MRREL.RRF	0 - 1	0.20	varchar(1)
DOCKEY	Key to be documented	MRDOC.RRF	2 - 8	3.53	varchar(50)
DTY	SQL-92 data type for this column	MRCOLS.RRF	7 - 13	9.27	varchar(20)
EXPL	Detailed explanation	MRDOC.RRF	0 - 416	30.04	varchar(1000)
FIL	Physical FILENAME	MRCOLS.RRF MRFILES.RRF	9 - 21 9 - 21	10.76 12.07	varchar(50) varchar(50)
FMT	Comma separated list of COL	MRFILES.RRF	7 - 190	32.63	varchar(300)
FROMEXPR	The expression that a mapping is mapped from	MRMAP.RRF MRSMAP.RRF	2 - 9 2 - 9	7.88 7.88	varchar(4000) varchar(4000)
FROMID	Metathesaurus identifier for the entity being mapped from	MRMAP.RRF	4 - 9	7.68	varchar(50)
FROMRES	Restriction applicable to the entity being mapped from	MRMAP.RRF	0	0.00	varchar(4000)
FROMRULE	Machine processible rule applicable to the entity being mapped from	MRMAP.RRF	0	0.00	varchar(4000)
FROMSID	Source asserted identifier for the entity being mapped from	MRMAP.RRF	0	0.00	varchar(50)
FROMTYPE	The type of expression that a mapping is mapped from	MRMAP.RRF MRSMAP.RRF	3 - 4 3 - 4	3.95 3.95	varchar(50) varchar(50)
HCD	Source asserted hierarchical number or code of context member (if it exists)	MRHIER.RRF	0 - 43	0.51	varchar(50)
IMETA	Version of the Metathesaurus that a source was added	MRSAB.RRF	6	6.00	varchar(10)
ISPREF	Indicates whether AUI is preferred	MRCONSO.RRF	1	1.00	char(1)
LAT	Language of Term(s)	MRSAB.RRF CHANGE/DELETEDSUI.RRF MRCONSO.RRF MRXNS_ENG.RRF MRXNW_ENG.RRF MRXW_BAQ.RRF MRXW_CZE.RRF MRXW_DAN.RRF MRXW_DUT.RRF MRXW_ENG.RRF MRXW_FIN.RRF MRXW_FRE.RRF MRXW_GER.RRF MRXW_HEB.RRF MRXW_HUN.RRF MRXW_ITA.RRF MRXW_JPN.RRF MRXW_NOR.RRF MRXW_POR.RRF MRXW_RUS.RRF MRXW_SPA.RRF MRXW_SWE.RRF	0 - 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3	2.90 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00	char(3) char(3) char(3) char(3) char(3) char(3) char(3) char(3) char(3) char(3) char(3) char(3) char(3) char(3) char(3) char(3) char(3) char(3) char(3) char(3) char(3) char(3)
LUI	Unique identifier for term	MRSAT.RRF AMBIGLUI.RRF CHANGE/MERGEDLUI.RRF MRCONSO.RRF MRXNS_ENG.RRF MRXNW_ENG.RRF MRXW_BAQ.RRF MRXW_CZE.RRF MRXW_DAN.RRF MRXW_DUT.RRF MRXW_ENG.RRF MRXW_FIN.RRF MRXW_FRE.RRF MRXW_GER.RRF MRXW_HEB.RRF MRXW_HUN.RRF MRXW_ITA.RRF MRXW_JPN.RRF MRXW_NOR.RRF MRXW_POR.RRF MRXW_RUS.RRF MRXW_SPA.RRF MRXW_SWE.RRF	0 - 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8	5.19 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00	char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8)
MAPATN	Mapping attribute name (for future use)	MRMAP.RRF	0	0.00	varchar(20)
MAPATV	Mapping attribute value (for future use)	MRMAP.RRF	0	0.00	varchar(4000)
MAPID	Metathesaurus asserted identifier for mapping	MRMAP.RRF MRSMAP.RRF	10 10	10.00 10.00	varchar(50) varchar(50)
MAPIN	Mapping in current subset	MRCUI.RRF MRAUI.RRF	0 - 1 1	0.90 1.00	char(1) char(1)
MAPRANK	Order in which mappings in a subset should be applied	MRMAP.RRF	0 - 1	0.62	integer
MAPREASON	Reason for mapping	MRCUI.RRF MRAUI.RRF	0 - 4 4	0.00 4.00	varchar(4000) varchar(4000)
MAPRES	Restriction applicable to this mapping	MRMAP.RRF	0	0.00	varchar(4000)
MAPRULE	Machine processible rule applicable to this mapping	MRMAP.RRF	0	0.00	varchar(4000)
MAPSETCUI	CUI of the map set	MRMAP.RRF MRSMAP.RRF	8 8	8.00 8.00	char(8) char(8)
MAPSETSAB	SAB of the map set	MRMAP.RRF MRSMAP.RRF	3 - 13 3 - 13	6.65 6.65	varchar(20) varchar(20)
MAPSID	Source asserted identifier for mapping	MRMAP.RRF MRSMAP.RRF	0 0	0.00 0.00	varchar(50) varchar(50)
MAPSUBSETID	Map subset identifier used to identify a subset of related mappings within a map set	MRMAP.RRF	0 - 1	0.62	varchar(10)
MAPTYPE	Type of mapping	MRMAP.RRF	0 - 3	0.77	varchar(50)
MAX	Maximum Length	MRCOLS.RRF	1 - 4	1.38	integer
METAUI	Metathesaurus asserted unique identifier	MRSAT.RRF	0 - 9	7.49	varchar(50)
MIN	Minimum Length	MRCOLS.RRF	1 - 2	1.03	integer
NSTR	Normalized string	MRXNS_ENG.RRF	1 - 1628	33.46	varchar(3000)
NWD	Normalized word	MRXNW_ENG.RRF	1 - 80	6.32	varchar(100)
PAUI	Unique identifier for parent atom	MRHIER.RRF	0 - 9	8.06	varchar(9)
PCUI	Concept unique identifier in the previous Metathesaurus	CHANGE/DELETEDCUI.RRF CHANGE/MERGEDCUI.RRF	8 8	8.00 8.00	char(8) char(8)
PLUI	Lexical unique identifier in the previous Metathesaurus	CHANGE/DELETEDLUI.RRF CHANGE/MERGEDLUI.RRF	8 8	8.00 8.00	char(8) char(8)
PSTR	Preferred name in the previous Metathesaurus	CHANGE/DELETEDLUI.RRF CHANGE/DELETEDSUI.RRF CHANGE/DELETEDCUI.RRF	2 - 934 2 - 1012 4 - 304	44.14 47.16 48.52	varchar(3000) varchar(3000) varchar(3000)
PSUI	String unique identifier in the previous Metathesaurus	CHANGE/DELETEDSUI.RRF	8	8.00	char(8)
PTR	Path to root	MRHIER.RRF	0 - 360	95.33	varchar(1000)
RANK	Termgroup ranking	MRRANK.RRF	4	4.00	integer
RCUI	Unique identifier for root SRC concept	MRSAB.RRF	8	8.00	char(8)
REASON	Explanation of change, if present	MRHIST.RRF	0 - 50	4.09	varchar(1000)
REF	Documentation Section Number	MRCOLS.RRF	0	0.00	varchar(20)
REL	Relationship	MRAUI.RRF MRMAP.RRF MRSMAP.RRF MRCUI.RRF MRREL.RRF	0 2 2 2 - 3 2 - 3	0.00 2.00 2.00 2.10 2.54	varchar(4) varchar(4) varchar(4) varchar(4) varchar(4)
RELA	Relationship attribute	MRAUI.RRF MRCUI.RRF MRHIER.RRF MRREL.RRF MRMAP.RRF MRSMAP.RRF	0 0 0 - 17 0 - 53 0 - 13 0 - 13	0.00 0.00 2.75 5.94 7.47 7.47	varchar(100) varchar(100) varchar(100) varchar(100) varchar(100) varchar(100)
RG	Relationship group	MRREL.RRF	0 - 2	0.14	varchar(10)
RMETA	Version of the Metathesaurus where a version is removed	MRSAB.RRF	0 - 6	0.20	varchar(10)
RSAB	Root source abbreviation	MRSAB.RRF	2 - 15	5.44	varchar(20)
RUI	Unique identifier for relationship	MRREL.RRF	9	9.00	varchar(10)
RWS	Number of rows	MRFILES.RRF	2 - 8	5.53	integer
SAB	Source abbreviation	MRDEF.RRF MRRANK.RRF MRREL.RRF MRCONSO.RRF MRSAT.RRF MRHIER.RRF MRCOC.RRF MRHIST.RRF	2 - 7 2 - 15 2 - 15 2 - 15 2 - 13 2 - 9 3 - 5 8	3.24 4.82 5.09 5.41 5.79 6.54 3.01 8.00	varchar(20) varchar(20) varchar(20) varchar(20) varchar(20) varchar(20) varchar(20) varchar(20)
SABIN	Source in current subset	MRSAB.RRF	1	1.00	char(1)
SATUI	Source asserted attribute identifier	MRDEF.RRF MRSAT.RRF	0 0	0.00 0.00	varchar(50) varchar(50)
SAUI	Source asserted atom identifier	MRCONSO.RRF	0 - 10	3.28	varchar(50)
SCC	Content contact info for a source	MRSAB.RRF	0 - 259	101.98	varchar(1000)
SCIT	Source citation	MRSAB.RRF	26 - 445	151.55	varchar(4000)
SCUI	Source asserted concept identifier	MRCONSO.RRF	0 - 20	5.03	varchar(50)
SDUI	Source asserted descriptor identifier	MRCONSO.RRF	0 - 13	2.30	varchar(50)
SF	Source Family	MRSAB.RRF	2 - 13	4.23	varchar(20)
SL	Source of relationship labels	MRREL.RRF	2 - 15	5.09	varchar(20)
SLC	License contact info for a source	MRSAB.RRF	0 - 295	147.73	varchar(1000)
SON	Source Official Name	MRSAB.RRF	10 - 145	46.01	varchar(3000)
SOURCEUI	Source asserted unique identifier	MRHIST.RRF	6 - 10	8.98	varchar(50)
SRL	Source Restriction Level	MRCONSO.RRF MRSAB.RRF	1 1	1.00 1.00	integer integer
SRUI	Source attributed relationship identifier	MRREL.RRF	0 - 10	1.33	varchar(50)
SSN	Source short name	MRSAB.RRF	3 - 75	20.16	varchar(3000)
STN	Semantic type tree number	MRSTY.RRF	1 - 14	8.17	varchar(100)
STR	String	MRCONSO.RRF	1 - 1741	33.93	varchar(3000)
STT	String type	MRCONSO.RRF	2 - 3	2.01	varchar(3)
STY	Semantic type	MRSTY.RRF	4 - 41	17.78	varchar(50)
STYPE	The name of the column in MRCONSO.RRF or MRREL.RRF that contains the identifier to which the attribute is attached	MRSAT.RRF	3 - 4	3.63	varchar(50)
STYPE1	The name of the column in MRCONSO.RRF that contains the first identifier to which the relationship is attached	MRREL.RRF	3 - 4	3.70	varchar(50)
STYPE2	The name of the column in MRCONSO.RRF that contains the second identifier to which the relationship is attached	MRREL.RRF	3 - 4	3.70	varchar(50)
SUI	Unique identifier for string	MRSAT.RRF AMBIGSUI.RRF MRCONSO.RRF MRXNS_ENG.RRF MRXNW_ENG.RRF MRXW_BAQ.RRF MRXW_CZE.RRF MRXW_DAN.RRF MRXW_DUT.RRF MRXW_ENG.RRF MRXW_FIN.RRF MRXW_FRE.RRF MRXW_GER.RRF MRXW_HEB.RRF MRXW_HUN.RRF MRXW_ITA.RRF MRXW_JPN.RRF MRXW_NOR.RRF MRXW_POR.RRF MRXW_RUS.RRF MRXW_SPA.RRF MRXW_SWE.RRF	0 - 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8	5.19 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00	char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8)
SUPPRESS	Suppressible flag	MRCONSO.RRF MRDEF.RRF MRRANK.RRF MRREL.RRF MRSAT.RRF	1 1 1 1 1	1.00 1.00 1.00 1.00 1.00	char(1) char(1) char(1) char(1) char(1)
SVER	Release date or version number of a source	MRSAB.RRF MRHIST.RRF	0 - 15 8	5.13 8.00	varchar(20) varchar(20)
TFR	Term frequency for a source	MRSAB.RRF	0 - 7	3.91	integer
TOEXPR	The expression that a mapping is mapped to	MRMAP.RRF MRSMAP.RRF	0 - 242 0 - 242	6.70 6.70	varchar(4000) varchar(4000)
TOID	Metathesaurus identifier for the entity being mapped to	MRMAP.RRF	0 - 21	5.81	varchar(50)
TORES	Restriction applicable to the entity being mapped to	MRMAP.RRF	0	0.00	varchar(4000)
TORULE	Machine processible rule applicable to the entity being mapped to	MRMAP.RRF	0	0.00	varchar(4000)
TOSID	Source asserted identifier for the entity being mapped to	MRMAP.RRF	0 - 10	3.82	varchar(50)
TOTYPE	The type of expression that a mapping is mapped to	MRMAP.RRF MRSMAP.RRF	0 - 23 0 - 23	4.74 4.74	varchar(50) varchar(50)
TS	Term status	MRCONSO.RRF	1	1.00	char(1)
TTY	Term type in source	MRCONSO.RRF MRRANK.RRF	2 - 11 2 - 11	2.52 2.75	varchar(20) varchar(20)
TTYL	Term type list for a source	MRSAB.RRF	0 - 176	16.15	varchar(200)
TUI	Unique identifier of Semantic type	MRSTY.RRF	4	4.00	char(4)
TYPE	Type of information	MRDOC.RRF	9 - 21	12.70	varchar(50)
VALUE	Value	MRDOC.RRF	0 - 53	12.58	varchar(200)
VCUI	Unique identifier for versioned SRC concept	MRSAB.RRF	0 - 8	7.57	char(8)
VEND	Valid end date for a source	MRSAB.RRF	0	0.00	char(10)
VER	Last release version in which CUI1 was valid	MRAUI.RRF MRCUI.RRF	6 6	6.00 6.00	varchar(10) varchar(10)
VSAB	Versioned source abbreviation	MRSAB.RRF	3 - 20	10.64	varchar(20)
VSTART	Valid start date for a source	MRSAB.RRF	0 - 10	0.13	char(10)
WD	Word in lower-case	MRXW_FIN.RRF MRXW_ENG.RRF MRXW_HEB.RRF MRXW_DAN.RRF MRXW_NOR.RRF MRXW_SPA.RRF MRXW_FRE.RRF MRXW_POR.RRF MRXW_ITA.RRF MRXW_BAQ.RRF MRXW_HUN.RRF MRXW_CZE.RRF MRXW_DUT.RRF MRXW_RUS.RRF MRXW_GER.RRF MRXW_JPN.RRF MRXW_SWE.RRF	1 - 54 1 - 80 1 - 19 1 - 25 1 - 26 1 - 46 1 - 39 1 - 38 1 - 38 1 - 18 1 - 20 1 - 52 1 - 46 1 - 36 1 - 45 1 - 93 1 - 38	10.53 6.10 6.12 6.38 6.42 6.59 6.64 6.77 6.98 7.17 7.17 7.91 8.30 8.53 8.65 9.60 9.72	varchar(100) varchar(100) varchar(100) varchar(100) varchar(100) varchar(100) varchar(100) varchar(100) varchar(100) varchar(100) varchar(100) varchar(100) varchar(100) varchar(100) varchar(100) varchar(100) varchar(100)

B.1.2 Columns and Data Elements in Original Release Format (ORF)

Abbreviation	Description	File	Length of Value in characters	Average Length of Value in characters	SQL92 Datatype
ATN	Attribute name	MRSAT	2 - 26	8.84	varchar(50)
ATNL	Attribute name list for a source	MRSAB	0 - 695	55.31	varchar(1000)
ATV	Attribute value	MRSAT	0 - 7903	7.40	varchar(8000)
ATX	Associated expression	MRATX	5 - 242	35.90	varchar(300)
AV	Average Length, Characters	MRCOLS	4 - 6	4.10	numeric(5,2)
BTS	Size in Bytes	MRFILES	4 - 10	7.15	integer
CENC	Character encoding of a source as specified by IANA	MRSAB	5	5.00	varchar(20)
CFR	CUI frequency for a source	MRSAB	0 - 6	3.75	integer
CLS	Number of columns	MRFILES	1 - 2	1.03	integer
COA	Attributes of co-occurrence	MRCOC	0 - 264	9.61	varchar(300)
CODE	Unique Identifier or code for string in source	MRSAT MRSO	0 - 30 1 - 30	6.14 7.37	varchar(50) varchar(50)
COF	Frequency of co-occurrence	MRCOC	0 - 5	1.10	integer
COL	Column or data element name	MRCOLS	2 - 6	3.12	varchar(10)
COT	Type of co-occurrence	MRCOC	1 - 3	1.10	varchar(3)
CREL	Relationship to retired CUI (CUI1) to current CUI (CUI2)	MRCUI	2 - 3	2.10	varchar(4)
CUI	Unique identifier for concept	AMBIG.LUI AMBIG.SUI CHANGE/MERGED.CUI MRATX MRCON MRDEF MRSAT MRSO MRSTY MRXNS.ENG MRXNW.ENG MRXW.BAQ MRXW.CZE MRXW.DAN MRXW.DUT MRXW.ENG MRXW.FIN MRXW.FRE MRXW.GER MRXW.HEB MRXW.HUN MRXW.ITA MRXW.JPN MRXW.NOR MRXW.POR MRXW.RUS MRXW.SPA MRXW.SWE	8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8	8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00	char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8)
CUI1	Unique identifier of first concept	MRCOC MRCUI MRREL	8 8 8	8.00 8.00 8.00	char(8) char(8) char(8)
CUI2	Unique identifier of second concept	MRCUI MRCOC MRREL	0 - 8 0 - 8 8	7.16 7.99 8.00	char(8) char(8) char(8)
CURVER	Current Version flag	MRSAB	1	1.00	char(1)
CXTY	Context type for a source (as per section 2.3.2)	MRSAB	0 - 31	5.31	varchar(50)
DEF	Definition	MRDEF	1 - 5796	223.74	varchar(8000)
DES	Descriptive Name	MRCOLS MRFILES	6 - 56 7 - 42	26.22 17.97	varchar(100) varchar(100)
DTY	SQL-92 data type for this column	MRCOLS	7 - 13	8.63	varchar(20)
FIL	Physical FILENAME	MRCOLS MRFILES	4 - 18 4 - 18	7.32 8.41	varchar(50) varchar(50)
FMT	Comma separated list of COL	MRFILES	7 - 112	20.26	varchar(150)
IMETA	Version of the Metathesaurus that a source was added	MRSAB	6	6.00	varchar(10)
LAT	Language of Term(s)	MRSAB CHANGE/DELETED.SUI MRCON MRXNS.ENG MRXNW.ENG MRXW.BAQ MRXW.CZE MRXW.DAN MRXW.DUT MRXW.ENG MRXW.FIN MRXW.FRE MRXW.GER MRXW.HEB MRXW.HUN MRXW.ITA MRXW.JPN MRXW.NOR MRXW.POR MRXW.RUS MRXW.SPA MRXW.SWE	0 - 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3	2.90 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00	char(3) char(3) char(3) char(3) char(3) char(3) char(3) char(3) char(3) char(3) char(3) char(3) char(3) char(3) char(3) char(3) char(3) char(3) char(3) char(3) char(3) char(3)
LRL	Least Restriction Level	MRCON	1	1.00	integer
LUI	Unique identifier for term	MRSAT AMBIG.LUI CHANGE/MERGED.LUI MRCON MRSO MRXNS.ENG MRXNW.ENG MRXW.BAQ MRXW.CZE MRXW.DAN MRXW.DUT MRXW.ENG MRXW.FIN MRXW.FRE MRXW.GER MRXW.HEB MRXW.HUN MRXW.ITA MRXW.JPN MRXW.NOR MRXW.POR MRXW.RUS MRXW.SPA MRXW.SWE	0 - 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8	6.44 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00	char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8)
MAPIN	Mapping in current subset	MRCUI	0 - 1	0.90	char(1)
MAX	Maximum Length	MRCOLS	1 - 4	1.38	integer
MEND	Metathesaurus end date for a source	MRSAB	0	0.00	char(8)
MG	Machine generated and unverified indicator	MRREL	0	0.00	varchar(1)
MIN	Minimum Length	MRCOLS	1 - 2	1.00	integer
MSTART	Metathesaurus start date for a source	MRSAB	0 - 10	0.13	char(10)
NSTR	Normalized string	MRXNS.ENG	1 - 1628	33.46	varchar(3000)
NWD	Normalized word	MRXNW.ENG	1 - 80	6.32	varchar(100)
PCUI	Concept unique identifier in the previous Metathesaurus	CHANGE/DELETED.CUI CHANGE/MERGED.CUI	8 8	8.00 8.00	char(8) char(8)
PLUI	Lexical unique identifier in the previous Metathesaurus	CHANGE/DELETED.LUI CHANGE/MERGED.LUI	8 8	8.00 8.00	char(8) char(8)
PSTR	Preferred name in the previous Metathesaurus	CHANGE/DELETED.LUI CHANGE/DELETED.SUI CHANGE/DELETED.CUI	2 - 934 2 - 1012 4 - 304	44.14 47.16 48.52	varchar(3000) varchar(3000) varchar(3000)
PSUI	String unique identifier in the previous Metathesaurus	CHANGE/DELETED.SUI	8	8.00	char(8)
RANK	Termgroup ranking	MRRANK	4	4.00	integer
RCUI	Unique identifier for root SRC concept	MRSAB	8	8.00	char(8)
REF	Documentation Section Number	MRCOLS	0	0.00	varchar(20)
REL	Relationship	MRATX MRREL	2 2 - 3	2.00 2.60	varchar(3) varchar(3)
RELA	Relationship attribute	MRREL	0 - 53	5.26	varchar(100)
RMETA	Version of the Metathesaurus where a version is removed	MRSAB	0 - 6	0.20	varchar(10)
RSAB	Root source abbreviation	MRSAB	2 - 15	5.44	varchar(20)
RWS	Number of rows	MRFILES	2 - 8	5.44	integer
SAB	Source abbreviation	MRDEF MRRANK MRREL MRSO MRSAT MRATX	2 - 7 2 - 15 2 - 15 2 - 15 2 - 13 3	3.23 4.82 4.98 5.41 5.61 3.00	varchar(20) varchar(20) varchar(20) varchar(20) varchar(20) varchar(20)
SABIN	Source in current subset	MRSAB	1	1.00	char(1)
SCC	Content contact info for a source	MRSAB	0 - 259	101.98	varchar(1000)
SF	Source Family	MRSAB	2 - 13	4.23	varchar(20)
SL	Source of relationship labels	MRREL	2 - 15	4.98	varchar(20)
SLC	License contact info for a source	MRSAB	0 - 295	147.73	varchar(1000)
SOC	Source of co-occurrence information	MRCOC	3 - 5	3.01	varchar(20)
SON	Source Official Name	MRSAB	10 - 145	46.01	varchar(3000)
SRL	Source Restriction Level	MRSAB MRSO	1 1	1.00 1.00	integer integer
STR	String	MRCON	1 - 1741	35.29	varchar(3000)
STT	String type	MRCON	2 - 3	2.01	varchar(3)
STY	Semantic type	MRSTY	4 - 41	17.78	varchar(50)
SUI	Unique identifier for string	MRSAT AMBIG.SUI MRCON MRSO MRXNS.ENG MRXNW.ENG MRXW.BAQ MRXW.CZE MRXW.DAN MRXW.DUT MRXW.ENG MRXW.FIN MRXW.FRE MRXW.GER MRXW.HEB MRXW.HUN MRXW.ITA MRXW.JPN MRXW.NOR MRXW.POR MRXW.RUS MRXW.SPA MRXW.SWE	0 - 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8	6.44 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.00	char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8)
SUPRES	Suppressible flag	MRRANK	1	1.00	char(1)
SVER	Release date or version number of a source	MRSAB	0 - 15	5.13	varchar(20)
TFR	Term frequency for a source	MRSAB	0 - 7	3.91	integer
TS	Term status	MRCON	1	1.00	char(1)
TTY	Term type in source	MRSO MRRANK	2 - 11 2 - 11	2.52 2.75	varchar(20) varchar(20)
TTYL	Term type list for a source	MRSAB	0 - 176	16.15	varchar(200)
TUI	Unique identifier of Semantic type	MRSTY	4	4.00	char(4)
VCUI	Unique identifier for versioned SRC concept	MRSAB	0 - 8	7.57	char(8)
VER	Last release version in which CUI1 was valid	MRCUI	6	6.00	varchar(10)
VSAB	Versioned source abbreviation	MRSAB	3 - 20	10.64	varchar(20)
WD	Word in lower-case	MRXW.FIN MRXW.ENG MRXW.HEB MRXW.DAN MRXW.NOR MRXW.SPA MRXW.FRE MRXW.POR MRXW.ITA MRXW.BAQ MRXW.HUN MRXW.CZE MRXW.DUT MRXW.RUS MRXW.GER MRXW.JPN MRXW.SWE	1 - 54 1 - 80 1 - 19 1 - 25 1 - 26 1 - 46 1 - 39 1 - 38 1 - 38 1 - 18 1 - 20 1 - 52 1 - 46 1 - 36 1 - 45 1 - 93 1 - 38	10.53 6.10 6.12 6.38 6.42 6.59 6.64 6.77 6.98 7.17 7.17 7.91 8.30 8.53 8.65 9.60 9.72	varchar(100) varchar(100) varchar(100) varchar(100) varchar(100) varchar(100) varchar(100) varchar(100) varchar(100) varchar(100) varchar(100) varchar(100) varchar(100) varchar(100) varchar(100) varchar(100) varchar(100)

Return to Table of Contents

Last reviewed: 01 April 2008
Last updated: 01 April 2008
First published: 20 July 2004
Metadata| Permanence level: Permanent: Stable Content
Previous version