United States National Library of Medicine National Institutes of Health

Columns and Data Elements - 2009AB Release

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 Table 1, and for Original Release Format (ORF) in Table 2.

Table 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 - 28	9.97	varchar(50)
ATNL	Attribute name list for a source	MRSAB.RRF	0 - 703	60.99	varchar(1000)
ATUI	Unique identifier for attribute	MRDEF.RRF MRSAT.RRF MRSTY.RRF	10 - 11 10 - 11 10 - 11	10.21 10.21 10.29	varchar(11) varchar(11) varchar(11)
ATV	Attribute value	MRSAT.RRF	0 - 7903	5.98	varchar(8000)
AUI	Unique identifier for atom	MRHIER.RRF MRDEF.RRF MRCONSO.RRF	8 - 9 8 - 9 8 - 9	8.16 8.51 8.53	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.24 8.03 8.31	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.02 8.24 8.31	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	1 - 10	7.33	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	1 - 6	3.84	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.83	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.01	varchar(1000)
CLS	Number of columns	MRFILES.RRF	1 - 2	1.13	integer
COA	Attributes of co-occurrence	MRCOC.RRF	0 - 262	9.77	varchar(300)
CODE	Unique Identifier or code for string in source	MRSAT.RRF MRCONSO.RRF	0 - 30 1 - 30	4.66 7.22	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.82	varchar(20)
COT	Type of co-occurrence	MRCOC.RRF	1 - 3	1.09	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_KOR.RRF MRXW_LAV.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 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 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) 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.34 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 0.94 1.91	integer integer integer integer integer integer integer integer integer integer
CXN	The context number if the atom has multiple contexts	MRHIER.RRF	1 - 4	2.01	integer
CXTY	Context type for a source	MRSAB.RRF	0 - 31	5.92	varchar(50)
DEF	Definition	MRDEF.RRF	1 - 5796	222.63	varchar(8000)
DES	Descriptive Name	MRCOLS.RRF MRFILES.RRF	5 - 136 8 - 42	29.38 18.36	varchar(200) varchar(200)
DIR	Source asserted directionality flag	MRREL.RRF	0 - 1	0.17	varchar(1)
DOCKEY	Key to be documented	MRDOC.RRF	2 - 8	3.55	varchar(50)
DTY	SQL-92 data type for this column	MRCOLS.RRF	7 - 13	9.90	varchar(20)
EXPL	Detailed explanation	MRDOC.RRF	0 - 416	28.88	varchar(1000)
FIL	Physical FILENAME	MRCOLS.RRF MRFILES.RRF	9 - 21 9 - 21	10.80 12.07	varchar(50) varchar(50)
FMT	Comma separated list of COL	MRFILES.RRF	7 - 190	31.98	varchar(300)
FROMEXPR	The expression that a mapping is mapped from	MRMAP.RRF MRSMAP.RRF	1 - 9 1 - 9	6.77 7.38	varchar(4000) varchar(4000)
FROMID	Metathesaurus identifier for the entity being mapped from	MRMAP.RRF	1 - 9	6.70	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	MRSMAP.RRF MRMAP.RRF	3 - 4 3 - 4	3.97 3.98	varchar(50) varchar(50)
HCD	Source asserted hierarchical number or code of context member (if it exists)	MRHIER.RRF	0 - 47	0.53	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_KOR.RRF MRXW_LAV.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 3 3	2.91 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 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) char(3) char(3)
LUI	Unique identifier for term	CHANGE/MERGEDLUI.RRF MRSAT.RRF AMBIGLUI.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_KOR.RRF MRXW_LAV.RRF MRXW_NOR.RRF MRXW_POR.RRF MRXW_RUS.RRF MRXW_SPA.RRF MRXW_SWE.RRF	0 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	0.00 4.91 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	varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10)
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	MRSMAP.RRF MRMAP.RRF	10 - 11 10 - 11	10.42 10.66	varchar(50) varchar(50)
MAPIN	Mapping in current subset	MRCUI.RRF MRAUI.RRF	0 - 1 1	0.92 1.00	char(1) char(1)
MAPRANK	Order in which mappings in a subset should be applied	MRMAP.RRF	0 - 1	0.23	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	MRSMAP.RRF MRMAP.RRF	3 - 13 3 - 13	6.95 7.37	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 - 3	1.44	varchar(10)
MAPTYPE	Type of mapping	MRMAP.RRF	0 - 3	0.29	varchar(50)
MAX	Maximum Length	MRCOLS.RRF	1 - 4	1.38	integer
METAUI	Metathesaurus asserted unique identifier	MRSAT.RRF	0 - 10	7.40	varchar(50)
MIN	Minimum Length	MRCOLS.RRF	1 - 2	1.03	integer
NSTR	Normalized string	MRXNS_ENG.RRF	1 - 1628	39.20	varchar(3000)
NWD	Normalized word	MRXNW_ENG.RRF	1 - 80	6.39	varchar(100)
PAUI	Unique identifier for parent atom	MRHIER.RRF	0 - 9	8.14	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/MERGEDLUI.RRF CHANGE/DELETEDLUI.RRF	0 8	0.00 8.00	varchar(10) varchar(10)
PSTR	Preferred name in the previous Metathesaurus	CHANGE/DELETEDSUI.RRF CHANGE/DELETEDLUI.RRF CHANGE/DELETEDCUI.RRF	2 - 571 2 - 571 3 - 502	60.62 67.80 83.33	varchar(3000) varchar(3000) varchar(3000)
PSUI	String unique identifier in the previous Metathesaurus	CHANGE/DELETEDSUI.RRF	8 - 9	8.27	varchar(10)
PTR	Path to root	MRHIER.RRF	0 - 360	97.29	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 - 70	5.77	varchar(1000)
REF	Documentation Section Number	MRCOLS.RRF	0	0.00	varchar(20)
REL	Relationship label	MRAUI.RRF MRMAP.RRF MRSMAP.RRF MRCUI.RRF MRREL.RRF	0 2 2 2 - 3 2 - 3	0.00 2.00 2.00 2.08 2.57	varchar(4) varchar(4) varchar(4) varchar(4) varchar(4)
RELA	Additional relationship label	MRAUI.RRF MRCUI.RRF MRMAP.RRF MRHIER.RRF MRREL.RRF MRSMAP.RRF	0 0 0 - 23 0 - 17 0 - 53 0 - 13	0.00 0.00 13.99 2.70 5.85 7.87	varchar(100) varchar(100) varchar(100) varchar(100) varchar(100) varchar(100)
RG	Relationship group	MRREL.RRF	0 - 5	0.15	varchar(10)
RMETA	Version of the Metathesaurus where a version is removed	MRSAB.RRF	0 - 6	0.23	varchar(10)
RSAB	Root source abbreviation	MRSAB.RRF	2 - 15	5.49	varchar(20)
RUI	Unique identifier for relationship	MRREL.RRF	9 - 10	9.21	varchar(10)
RWS	Number of rows	MRFILES.RRF	1 - 8	5.49	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 - 11 3 - 5 8	2.99 4.90 5.12 5.43 5.65 6.60 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	2.37	varchar(50)
SCC	Content contact info for a source	MRSAB.RRF	0 - 346	125.53	varchar(1000)
SCIT	Source citation	MRSAB.RRF	34 - 445	151.34	varchar(4000)
SCUI	Source asserted concept identifier	MRCONSO.RRF	0 - 20	5.11	varchar(50)
SDUI	Source asserted descriptor identifier	MRCONSO.RRF	0 - 13	2.04	varchar(50)
SF	Source Family	MRSAB.RRF	2 - 13	4.28	varchar(20)
SL	Source of relationship labels	MRREL.RRF	2 - 15	5.12	varchar(20)
SLC	License contact info for a source	MRSAB.RRF	0 - 346	161.58	varchar(1000)
SON	Source Official Name	MRSAB.RRF	10 - 145	46.67	varchar(3000)
SOURCEUI	Source asserted unique identifier	MRHIST.RRF	6 - 10	9.03	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.14	varchar(50)
SSN	Source short name	MRSAB.RRF	3 - 89	18.81	varchar(3000)
STN	Semantic type tree number	MRSTY.RRF	1 - 14	7.85	varchar(100)
STR	String	MRCONSO.RRF	1 - 1741	37.02	varchar(3000)
STT	String type	MRCONSO.RRF	2 - 3	2.01	varchar(3)
STY	Semantic type	MRSTY.RRF	4 - 41	18.20	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.18	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.63	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.63	varchar(50)
SUI	Unique identifier for string	MRSAT.RRF MRXW_BAQ.RRF MRXW_DAN.RRF MRXW_FIN.RRF MRXW_HEB.RRF MRXW_HUN.RRF MRXW_NOR.RRF MRXW_DUT.RRF MRXW_RUS.RRF AMBIGSUI.RRF MRXW_GER.RRF MRXW_SPA.RRF MRXW_POR.RRF MRXW_ITA.RRF MRXW_FRE.RRF MRCONSO.RRF MRXW_SWE.RRF MRXNS_ENG.RRF MRXW_JPN.RRF MRXNW_ENG.RRF MRXW_ENG.RRF MRXW_CZE.RRF MRXW_KOR.RRF MRXW_LAV.RRF	0 - 9 8 8 8 8 8 8 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 9 9	4.94 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.02 8.03 8.03 8.03 8.04 8.08 8.10 8.11 8.16 8.18 8.20 8.21 8.22 8.77 9.00 9.00	varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10)
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.12 8.00	varchar(20) varchar(20)
TFR	Term frequency for a source	MRSAB.RRF	1 - 7	4.04	integer
TOEXPR	The expression that a mapping is mapped to	MRMAP.RRF MRSMAP.RRF	0 - 242 0 - 242	6.47 6.75	varchar(4000) varchar(4000)
TOID	Metathesaurus identifier for the entity being mapped to	MRMAP.RRF	0 - 21	5.96	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	1.44	varchar(50)
TOTYPE	The type of expression that a mapping is mapped to	MRSMAP.RRF MRMAP.RRF	0 - 23 0 - 23	10.45 7.83	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.45 2.82	varchar(20) varchar(20)
TTYL	Term type list for a source	MRSAB.RRF	0 - 281	16.97	varchar(300)
TUI	Unique identifier of Semantic type	MRSTY.RRF	4	4.00	char(4)
TYPE	Type of information	MRDOC.RRF	9 - 21	12.67	varchar(50)
VALUE	Value	MRDOC.RRF	0 - 53	13.26	varchar(200)
VCUI	Unique identifier for versioned SRC concept	MRSAB.RRF	0 - 8	7.55	char(8)
VEND	Valid end date for a source	MRSAB.RRF	0	0.00	char(8)
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.72	varchar(20)
VSTART	Valid start date for a source	MRSAB.RRF	0 - 8	0.10	char(8)
WD	Word in lower-case	MRXW_FIN.RRF MRXW_KOR.RRF MRXW_HEB.RRF MRXW_ENG.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 MRXW_LAV.RRF	1 - 54 1 - 15 1 - 19 1 - 80 1 - 25 1 - 26 1 - 46 1 - 39 1 - 38 1 - 38 1 - 18 1 - 20 1 - 52 1 - 46 1 - 40 1 - 45 1 - 93 1 - 38 2 - 16	10.53 2.96 6.12 6.16 6.38 6.42 6.61 6.64 6.77 6.98 7.17 7.17 7.31 8.30 8.54 8.59 8.71 9.60 6.65	varchar(500) varchar(500) varchar(500) varchar(500) varchar(500) varchar(500) varchar(500) varchar(500) varchar(500) varchar(500) varchar(500) varchar(500) varchar(500) varchar(500) varchar(500) varchar(500) varchar(500) varchar(500) varchar(500)

Table 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 - 28	8.23	varchar(50)
ATNL	Attribute name list for a source	MRSAB	0 - 703	53.91	varchar(1000)
ATV	Attribute value	MRSAT	0 - 7903	7.48	varchar(8000)
ATX	Associated expression	MRATX	5 - 242	35.89	varchar(300)
AV	Average Length, Characters	MRCOLS	4 - 6	4.11	numeric(5,2)
BTS	Size in Bytes	MRFILES	1 - 10	7.12	integer
CENC	Character encoding of a source as specified by IANA	MRSAB	5	5.00	varchar(20)
CFR	CUI frequency for a source	MRSAB	1 - 6	3.84	integer
CLS	Number of columns	MRFILES	1 - 2	1.02	integer
COA	Attributes of co-occurrence	MRCOC	0 - 262	9.77	varchar(300)
CODE	Unique Identifier or code for string in source	MRSAT MRSO	0 - 30 1 - 30	6.17 7.22	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.14	varchar(10)
COT	Type of co-occurrence	MRCOC	1 - 3	1.09	varchar(3)
CREL	Relationship to retired CUI (CUI1) to current CUI (CUI2)	MRCUI	2 - 3	2.08	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.KOR MRXW.LAV 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 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 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) 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.34 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.92	varchar(50)
DEF	Definition	MRDEF	1 - 5796	223.09	varchar(8000)
DES	Descriptive Name	MRCOLS MRFILES	5 - 56 7 - 42	26.02 18.19	varchar(100) varchar(100)
DOCKEY	Key to be documented	MRDOC	2 - 8	3.52	varchar(50)
DTY	SQL-92 data type for this column	MRCOLS	7 - 13	9.66	varchar(20)
EXPL	Detailed explanation	MRDOC	0 - 416	28.57	varchar(1000)
FIL	Physical FILENAME	MRCOLS MRFILES	4 - 18 4 - 18	7.31 8.31	varchar(50) varchar(50)
FMT	Comma separated list of COL	MRFILES	7 - 112	20.19	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.KOR MRXW.LAV 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 3 3	2.91 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 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) char(3) char(3)
LRL	Least Restriction Level	MRCON	1	1.00	integer
LUI	Unique identifier for term	CHANGE/MERGED.LUI MRSAT AMBIG.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.KOR MRXW.LAV MRXW.NOR MRXW.POR MRXW.RUS MRXW.SPA MRXW.SWE	0 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 8	0.00 6.51 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	varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10)
MAPIN	Mapping in current subset	MRCUI	0 - 1	0.92	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 - 8	0.10	char(8)
NSTR	Normalized string	MRXNS.ENG	1 - 1628	39.20	varchar(3000)
NWD	Normalized word	MRXNW.ENG	1 - 80	6.39	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/MERGED.LUI CHANGE/DELETED.LUI	0 8	0.00 8.00	varchar(10) varchar(10)
PSTR	Preferred name in the previous Metathesaurus	CHANGE/DELETED.SUI CHANGE/DELETED.LUI CHANGE/DELETED.CUI	2 - 571 2 - 571 3 - 502	60.62 67.80 83.33	varchar(3000) varchar(3000) varchar(3000)
PSUI	String unique identifier in the previous Metathesaurus	CHANGE/DELETED.SUI	8 - 9	8.27	varchar(10)
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 label	MRATX MRREL	2 2 - 3	2.00 2.63	varchar(3) varchar(3)
RELA	Additional relationship label	MRREL	0 - 53	5.00	varchar(100)
RMETA	Version of the Metathesaurus where a version is removed	MRSAB	0 - 6	0.23	varchar(10)
RSAB	Root source abbreviation	MRSAB	2 - 15	5.49	varchar(20)
RWS	Number of rows	MRFILES	1 - 8	5.36	integer
SAB	Source abbreviation	MRDEF MRRANK MRREL MRSAT MRSO MRATX	2 - 7 2 - 15 2 - 15 2 - 13 2 - 15 3	2.98 4.90 5.06 5.43 5.43 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 - 346	125.53	varchar(1000)
SF	Source Family	MRSAB	2 - 13	4.28	varchar(20)
SL	Source of relationship labels	MRREL	2 - 15	5.06	varchar(20)
SLC	License contact info for a source	MRSAB	0 - 346	161.58	varchar(1000)
SOC	Source of co-occurrence information	MRCOC	3 - 5	3.01	varchar(20)
SON	Source Official Name	MRSAB	10 - 145	46.67	varchar(3000)
SRL	Source Restriction Level	MRSAB MRSO	1 1	1.00 1.00	integer integer
STR	String	MRCON	1 - 1741	38.85	varchar(3000)
STT	String type	MRCON	2 - 3	2.01	varchar(3)
STY	Semantic type	MRSTY	4 - 41	18.20	varchar(50)
SUI	Unique identifier for string	MRSAT MRXW.BAQ MRXW.DAN MRXW.FIN MRXW.HEB MRXW.HUN MRXW.NOR MRXW.DUT MRXW.RUS AMBIG.SUI MRXW.GER MRXW.SPA MRXW.POR MRXW.ITA MRXW.FRE MRSO MRCON MRXW.SWE MRXNS.ENG MRXW.JPN MRXNW.ENG MRXW.ENG MRXW.CZE MRXW.KOR MRXW.LAV	0 - 9 8 8 8 8 8 8 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 9 9	6.54 8.00 8.00 8.00 8.00 8.00 8.00 8.00 8.02 8.03 8.03 8.03 8.04 8.08 8.10 8.11 8.12 8.16 8.18 8.20 8.21 8.22 8.77 9.00 9.00	varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10) varchar(10)
SUPRES	Suppressible flag	MRRANK	1	1.00	char(1)
SVER	Release date or version number of a source	MRSAB	0 - 15	5.12	varchar(20)
TFR	Term frequency for a source	MRSAB	1 - 7	4.04	integer
TS	Term status	MRCON	1	1.00	char(1)
TTY	Term type in source	MRSO MRRANK	2 - 11 2 - 11	2.45 2.82	varchar(20) varchar(20)
TTYL	Term type list for a source	MRSAB	0 - 281	16.97	varchar(300)
TUI	Unique identifier of Semantic type	MRSTY	4	4.00	char(4)
TYPE	Type of information	MRDOC	9 - 21	12.67	varchar(50)
VALUE	Value	MRDOC	0 - 53	13.35	varchar(200)
VCUI	Unique identifier for versioned SRC concept	MRSAB	0 - 8	7.55	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.72	varchar(20)
WD	Word in lower-case	MRXW.FIN MRXW.KOR MRXW.HEB MRXW.ENG 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 MRXW.LAV	1 - 54 1 - 15 1 - 19 1 - 80 1 - 25 1 - 26 1 - 46 1 - 39 1 - 38 1 - 38 1 - 18 1 - 20 1 - 52 1 - 46 1 - 40 1 - 45 1 - 93 1 - 38 2 - 16	10.53 2.96 6.12 6.16 6.38 6.42 6.61 6.64 6.77 6.98 7.17 7.17 7.31 8.30 8.54 8.59 8.71 9.60 6.65	varchar(500) varchar(500) varchar(500) varchar(500) varchar(500) varchar(500) varchar(500) varchar(500) varchar(500) varchar(500) varchar(500) varchar(500) varchar(500) varchar(500) varchar(500) varchar(500) varchar(500) varchar(500) varchar(500)

Last reviewed: 03 November 2009
Last updated: 03 November 2009
First published: 17 November 2008
Metadata| Permanence level: Permanent: Stable Content
Previous version