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 - 62	11.45	varchar(100)
ATNL	Attribute name list for a source.	MRSAB.RRF	0 - 1178	70.96	varchar(4000)
ATUI	Unique identifier for attribute.	MRSTY.RRF MRDEF.RRF MRSAT.RRF	10 - 11 10 - 11 10 - 11	10.64 10.87 10.89	varchar(11) varchar(11) varchar(11)
ATV	Attribute value	MRSAT.RRF	1 - 35985	14.24	varchar(65000)
AUI	Unique identifier for atom	MRHIER.RRF MRDEF.RRF MRCONSO.RRF	8 - 9 8 - 9 8 - 9	8.64 8.75 8.79	varchar(9) varchar(9) varchar(9)
AUI1	Unique identifier for first atom	MRREL.RRF MRAUI.RRF	0 - 9 8 - 9	8.55 8.59	varchar(9) varchar(9)
AUI2	Unique identifier for second atom	MRREL.RRF MRAUI.RRF	0 - 9 8 - 9	8.55 8.59	varchar(9) varchar(9)
AV	Average Length, Characters	MRCOLS.RRF	4 - 6	4.13	numeric(5,2)
BTS	Size in Bytes	MRFILES.RRF	1 - 10	7.47	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	4.20	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	0	0.00	varchar(1000)
CHANGETYPE	Source asserted code for type of change	MRHIST.RRF	0	0.00	varchar(1000)
CHANGEVAL	SNOMED CT CONCEPTSTATUS or DESCRIPTIONSTATUS value after the change took place	MRHIST.RRF	0	0.00	varchar(1000)
CLS	Number of columns	MRFILES.RRF	1 - 2	1.11	integer
CODE	Unique Identifier or code for string in source	MRSAT.RRF MRCONSO.RRF	0 - 56 1 - 95	4.23 7.56	varchar(100) varchar(100)
COL	Column or data element name	MRCOLS.RRF	2 - 11	3.69	varchar(20)
CUI	Unique identifier for concept	MRHIST.RRF AMBIGLUI.RRF AMBIGSUI.RRF CHANGE/MERGEDCUI.RRF MRCONSO.RRF MRDEF.RRF MRHIER.RRF MRSAT.RRF MRSTY.RRF MRXNS_ENG.RRF MRXNW_ENG.RRF MRXW_ARA.RRF MRXW_BAQ.RRF MRXW_CHI.RRF MRXW_CZE.RRF MRXW_DAN.RRF MRXW_DUT.RRF MRXW_ENG.RRF MRXW_EST.RRF MRXW_FIN.RRF MRXW_FRE.RRF MRXW_GER.RRF MRXW_GRE.RRF MRXW_HEB.RRF MRXW_HUN.RRF MRXW_ITA.RRF MRXW_JPN.RRF MRXW_KOR.RRF MRXW_LAV.RRF MRXW_LIT.RRF MRXW_NOR.RRF MRXW_POL.RRF MRXW_POR.RRF MRXW_RUS.RRF MRXW_SCR.RRF MRXW_SPA.RRF MRXW_SWE.RRF MRXW_TUR.RRF MRXW_UKR.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 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8	0.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 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) 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 MRCUI.RRF MRREL.RRF	8 8 8	8.00 8.00 8.00	char(8) char(8) char(8)
CUI2	Unique identifier for second concept	MRCUI.RRF MRAUI.RRF MRREL.RRF	0 - 8 8 8	3.76 8.00 8.00	char(8) char(8) char(8)
CURVER	Current Version flag	MRSAB.RRF	1	1.00	char(1)
CVF	Content view flag	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 - 5 0 - 5	0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.96 1.81	varchar(50) varchar(50) varchar(50) varchar(50) varchar(50) varchar(50) varchar(50) varchar(50) varchar(50)
CXN	The context number if the atom has multiple contexts	MRHIER.RRF	1 - 5	2.24	integer
CXTY	Context type for a source	MRSAB.RRF	0 - 13	5.25	varchar(50)
DEF	Definition	MRDEF.RRF	1 - 10914	232.38	varchar(16000)
DES	Descriptive Name	MRCOLS.RRF MRFILES.RRF	5 - 136 8 - 42	28.74 18.30	varchar(200) varchar(200)
DIR	Source asserted directionality flag	MRREL.RRF	0 - 1	0.24	varchar(1)
DOCKEY	Key to be documented	MRDOC.RRF	2 - 8	3.64	varchar(50)
DTY	SQL-92 data type for this column	MRCOLS.RRF	7 - 14	10.01	varchar(20)
EXPL	Detailed explanation	MRDOC.RRF	0 - 941	26.29	varchar(1000)
FIL	Physical FILENAME	MRCOLS.RRF MRFILES.RRF	9 - 21 9 - 21	11.00 12.11	varchar(50) varchar(50)
FMT	Comma separated list of COL	MRFILES.RRF	7 - 190	29.47	varchar(300)
FROMEXPR	The expression that a mapping is mapped from	MRSMAP.RRF MRMAP.RRF	1 - 8 1 - 18	6.91 8.43	varchar(4000) varchar(4000)
FROMID	Metathesaurus identifier for the entity being mapped from	MRMAP.RRF	1 - 18	7.50	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.98 3.99	varchar(50) varchar(50)
HCD	Source asserted hierarchical number or code of context member (if it exists)	MRHIER.RRF	0 - 51	0.43	varchar(100)
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_ARA.RRF MRXW_BAQ.RRF MRXW_CHI.RRF MRXW_CZE.RRF MRXW_DAN.RRF MRXW_DUT.RRF MRXW_ENG.RRF MRXW_EST.RRF MRXW_FIN.RRF MRXW_FRE.RRF MRXW_GER.RRF MRXW_GRE.RRF MRXW_HEB.RRF MRXW_HUN.RRF MRXW_ITA.RRF MRXW_JPN.RRF MRXW_KOR.RRF MRXW_LAV.RRF MRXW_LIT.RRF MRXW_NOR.RRF MRXW_POL.RRF MRXW_POR.RRF MRXW_RUS.RRF MRXW_SCR.RRF MRXW_SPA.RRF MRXW_SWE.RRF MRXW_TUR.RRF MRXW_UKR.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 3 3 3 3 3 3 3 3 3	2.97 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 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) 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 MRXW_BAQ.RRF MRXW_DAN.RRF MRXW_HEB.RRF MRXW_JPN.RRF AMBIGLUI.RRF MRCONSO.RRF MRXNS_ENG.RRF MRXW_CZE.RRF MRXW_ENG.RRF MRXNW_ENG.RRF MRXW_SPA.RRF MRXW_GER.RRF MRXW_DUT.RRF MRXW_FRE.RRF MRXW_ITA.RRF MRXW_POR.RRF MRXW_RUS.RRF MRXW_FIN.RRF MRXW_POL.RRF MRXW_SWE.RRF MRXW_KOR.RRF MRXW_SCR.RRF MRXW_NOR.RRF MRXW_HUN.RRF MRXW_LAV.RRF MRXW_ARA.RRF MRXW_CHI.RRF MRXW_EST.RRF MRXW_GRE.RRF MRXW_LIT.RRF MRXW_TUR.RRF MRXW_UKR.RRF	0 0 - 9 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 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 9 9 9 9 9 9 9	0.00 4.21 8.00 8.00 8.00 8.21 8.26 8.45 8.45 8.45 8.45 8.46 8.56 8.57 8.67 8.74 8.76 8.76 8.79 8.84 8.85 8.86 8.91 8.94 8.98 8.99 8.99 9.00 9.00 9.00 9.00 9.00 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) 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 - 6	2.93	varchar(20)
MAPATV	Mapping attribute value (for future use)	MRMAP.RRF	0 - 1	0.00	varchar(4000)
MAPID	Metathesaurus asserted identifier for mapping	MRSMAP.RRF MRMAP.RRF	10 - 11 10 - 11	10.98 10.99	varchar(50) varchar(50)
MAPIN	Mapping in current subset	MRCUI.RRF MRAUI.RRF	0 - 1 1	0.47 1.00	char(1) char(1)
MAPRANK	Order in which mappings in a subset should be applied	MRMAP.RRF	0 - 2	0.51	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 - 429	38.29	varchar(4000)
MAPRULE	Machine processible rule applicable to this mapping	MRMAP.RRF	0 - 336	11.33	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	10.51 10.68	varchar(40) varchar(40)
MAPSID	Source asserted identifier for mapping	MRSMAP.RRF MRMAP.RRF	0 0 - 36	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.50	varchar(10)
MAPTYPE	Type of mapping	MRMAP.RRF	0 - 9	4.42	varchar(50)
MAX	Maximum Length	MRCOLS.RRF	1 - 5	1.39	integer
METAUI	Metathesaurus asserted unique identifier	MRSAT.RRF	0 - 10	8.25	varchar(50)
MIN	Minimum Length	MRCOLS.RRF	1 - 2	1.03	integer
NSTR	Normalized string	MRXNS_ENG.RRF	1 - 2528	39.43	varchar(3000)
NWD	Normalized word	MRXNW_ENG.RRF	1 - 80	6.45	varchar(100)
PAUI	Unique identifier for parent atom	MRHIER.RRF	0 - 9	8.52	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 - 9	0.00 8.90	varchar(10) varchar(10)
PSTR	Preferred name in the previous Metathesaurus	CHANGE/DELETEDCUI.RRF CHANGE/DELETEDSUI.RRF CHANGE/DELETEDLUI.RRF	1 - 1120 1 - 1120 2 - 1120	69.59 70.47 71.40	varchar(3000) varchar(3000) varchar(3000)
PSUI	String unique identifier in the previous Metathesaurus	CHANGE/DELETEDSUI.RRF	8 - 9	8.91	varchar(10)
PTR	Path to root	MRHIER.RRF	0 - 345	104.37	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	0.00	varchar(1000)
REF	Documentation Section Number	MRCOLS.RRF	0	0.00	varchar(20)
REL	Relationship label	MRAUI.RRF MRMAP.RRF MRSMAP.RRF MRREL.RRF MRCUI.RRF	0 2 2 2 - 3 2 - 3	0.00 2.00 2.00 2.22 2.53	varchar(4) varchar(4) varchar(4) varchar(4) varchar(4)
RELA	Additional relationship label	MRAUI.RRF MRCUI.RRF MRREL.RRF MRMAP.RRF MRSMAP.RRF MRHIER.RRF	0 0 0 - 54 0 - 37 0 - 37 0 - 12	0.00 0.00 11.41 13.75 19.67 2.71	varchar(100) varchar(100) varchar(100) varchar(100) varchar(100) varchar(100)
RG	Relationship group	MRREL.RRF	0 - 3	0.11	varchar(10)
RMETA	Version of the Metathesaurus where a version is removed	MRSAB.RRF	0 - 6	0.12	varchar(10)
RSAB	Root source abbreviation	MRSAB.RRF	2 - 15	5.93	varchar(40)
RUI	Unique identifier for relationship	MRREL.RRF	9 - 10	9.79	varchar(10)
RWS	Number of rows	MRFILES.RRF	1 - 8	5.75	integer
SAB	Source abbreviation	MRHIST.RRF MRDEF.RRF MRRANK.RRF MRCONSO.RRF MRREL.RRF MRSAT.RRF MRHIER.RRF	0 2 - 11 2 - 15 2 - 15 2 - 15 2 - 13 2 - 13	0.00 4.11 5.51 5.90 5.97 6.34 7.88	varchar(40) varchar(40) varchar(40) varchar(40) varchar(40) varchar(40) varchar(40)
SABIN	Source in current subset	MRSAB.RRF	1	1.00	char(1)
SATUI	Source asserted attribute identifier	MRDEF.RRF MRSAT.RRF	0 - 16 0 - 36	0.53 4.41	varchar(50) varchar(50)
SAUI	Source asserted atom identifier	MRCONSO.RRF	0 - 18	2.21	varchar(100)
SCC	Content contact info for a source	MRSAB.RRF	12 - 332	152.43	varchar(1000)
SCIT	Source citation	MRSAB.RRF	52 - 674	162.41	varchar(4000)
SCUI	Source asserted concept identifier	MRCONSO.RRF	0 - 95	5.21	varchar(100)
SDUI	Source asserted descriptor identifier	MRCONSO.RRF	0 - 13	2.64	varchar(100)
SF	Source Family	MRSAB.RRF	2 - 13	4.19	varchar(40)
SL	Source of relationship labels	MRREL.RRF	2 - 15	5.97	varchar(40)
SLC	License contact info for a source	MRSAB.RRF	12 - 346	167.93	varchar(1000)
SON	Source Official Name	MRSAB.RRF	10 - 145	49.30	varchar(3000)
SOURCEUI	Source asserted unique identifier	MRHIST.RRF	0	0.00	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 - 36	2.50	varchar(50)
SSN	Source short name	MRSAB.RRF	3 - 89	26.69	varchar(3000)
STN	Semantic type tree number	MRSTY.RRF	1 - 14	7.78	varchar(100)
STR	String	MRCONSO.RRF	1 - 2875	39.11	varchar(3000)
STT	String type	MRCONSO.RRF	2 - 3	2.01	varchar(3)
STY	Semantic type	MRSTY.RRF	4 - 39	17.44	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.21	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.64	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.64	varchar(50)
SUI	Unique identifier for string	MRSAT.RRF MRXW_BAQ.RRF MRXW_DAN.RRF MRXW_HEB.RRF AMBIGSUI.RRF MRXW_JPN.RRF MRCONSO.RRF MRXW_GER.RRF MRXW_SPA.RRF MRXNS_ENG.RRF MRXNW_ENG.RRF MRXW_DUT.RRF MRXW_ENG.RRF MRXW_POR.RRF MRXW_ITA.RRF MRXW_FRE.RRF MRXW_RUS.RRF MRXW_FIN.RRF MRXW_SWE.RRF MRXW_CZE.RRF MRXW_NOR.RRF MRXW_HUN.RRF MRXW_ARA.RRF MRXW_CHI.RRF MRXW_EST.RRF MRXW_GRE.RRF MRXW_KOR.RRF MRXW_LAV.RRF MRXW_LIT.RRF MRXW_POL.RRF MRXW_SCR.RRF MRXW_TUR.RRF MRXW_UKR.RRF	0 - 9 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 8 - 9 8 - 9 9 9 9 9 9 9 9 9 9 9 9	4.27 8.00 8.00 8.00 8.36 8.36 8.58 8.60 8.60 8.64 8.67 8.67 8.67 8.78 8.79 8.80 8.80 8.84 8.87 8.88 8.98 8.99 9.00 9.00 9.00 9.00 9.00 9.00 9.00 9.00 9.00 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) 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	MRHIST.RRF MRSAB.RRF	0 0 - 15	0.00 4.98	varchar(20) varchar(20)
TFR	Term frequency for a source	MRSAB.RRF	1 - 7	4.50	integer
TOEXPR	The expression that a mapping is mapped to	MRMAP.RRF MRSMAP.RRF	0 - 242 1 - 242	6.06 6.99	varchar(4000) varchar(4000)
TOID	Metathesaurus identifier for the entity being mapped to	MRMAP.RRF	0 - 18	5.26	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	0.00	varchar(50)
TOTYPE	The type of expression that a mapping is mapped to	MRMAP.RRF MRSMAP.RRF	0 - 23 4 - 22	3.96 4.35	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.38 2.60	varchar(20) varchar(20)
TTYL	Term type list for a source	MRSAB.RRF	0 - 129	15.55	varchar(400)
TUI	Unique identifier of Semantic type	MRSTY.RRF	4	4.00	char(4)
TYPE	Type of information	MRDOC.RRF	3 - 21	13.04	varchar(50)
VALUE	Value	MRDOC.RRF	0 - 62	15.81	varchar(200)
VCUI	Unique identifier for versioned SRC concept	MRSAB.RRF	0 - 8	7.68	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 - 24	11.36	varchar(40)
VSTART	Valid start date for a source	MRSAB.RRF	0	0.00	char(8)
WD	Word in lower-case	MRXW_KOR.RRF MRXW_CHI.RRF MRXW_TUR.RRF MRXW_ARA.RRF MRXW_POR.RRF MRXW_ITA.RRF MRXW_HEB.RRF MRXW_ENG.RRF MRXW_UKR.RRF MRXW_DAN.RRF MRXW_SPA.RRF MRXW_FRE.RRF MRXW_EST.RRF MRXW_DUT.RRF MRXW_RUS.RRF MRXW_BAQ.RRF MRXW_POL.RRF MRXW_GRE.RRF MRXW_CZE.RRF MRXW_SCR.RRF MRXW_LAV.RRF MRXW_LIT.RRF MRXW_HUN.RRF MRXW_GER.RRF MRXW_SWE.RRF MRXW_NOR.RRF MRXW_JPN.RRF MRXW_FIN.RRF	1 - 38 1 - 68 1 - 37 1 - 22 1 - 38 1 - 38 1 - 19 1 - 80 1 - 27 1 - 25 1 - 46 1 - 39 1 - 35 1 - 51 1 - 42 1 - 18 1 - 48 1 - 34 1 - 52 1 - 37 1 - 29 1 - 31 1 - 27 1 - 43 1 - 39 1 - 44 1 - 93 1 - 54	2.84 3.65 5.25 5.35 5.72 5.90 6.12 6.14 6.37 6.38 6.61 6.74 6.93 7.15 7.16 7.17 7.24 7.28 7.44 7.70 7.76 7.81 7.86 8.26 8.32 9.11 9.11 9.94	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) 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 - 62	7.80	varchar(100)
ATNL	Attribute name list for a source	MRSAB	0 - 1169	54.92	varchar(4000)
ATV	Attribute value	MRSAT	1 - 35985	12.75	varchar(65000)
ATX	Associated expression	MRATX	5 - 242	35.66	varchar(300)
AV	Average Length, Characters	MRCOLS	4 - 6	4.10	numeric(5,2)
BTS	Size in Bytes	MRFILES	1 - 10	7.50	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	4.20	integer
CLS	Number of columns	MRFILES	1 - 2	1.02	integer
CODE	Unique Identifier or code for string in source	MRSAT MRSO	0 - 56 1 - 95	6.38 7.56	varchar(50) varchar(50)
COL	Column or data element name	MRCOLS	2 - 6	3.07	varchar(10)
CREL	Relationship to retired CUI (CUI1) to current CUI (CUI2)	MRCUI	2 - 3	2.53	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.ARA MRXW.BAQ MRXW.CHI MRXW.CZE MRXW.DAN MRXW.DUT MRXW.ENG MRXW.EST MRXW.FIN MRXW.FRE MRXW.GER MRXW.GRE MRXW.HEB MRXW.HUN MRXW.ITA MRXW.JPN MRXW.KOR MRXW.LAV MRXW.LIT MRXW.NOR MRXW.POL MRXW.POR MRXW.RUS MRXW.SCR MRXW.SPA MRXW.SWE MRXW.TUR MRXW.UKR	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 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 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) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8) char(8)
CUI1	Unique identifier of first concept	MRCUI MRREL	8 8	8.00 8.00	char(8) char(8)
CUI2	Unique identifier of second concept	MRCUI MRREL	0 - 8 8	3.76 8.00	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 - 13	5.25	varchar(50)
DEF	Definition	MRDEF	1 - 10914	233.11	varchar(16000)
DES	Descriptive Name	MRCOLS MRFILES	5 - 56 7 - 42	25.57 18.16	varchar(100) varchar(100)
DOCKEY	Key to be documented	MRDOC	2 - 8	3.64	varchar(50)
DTY	SQL-92 data type for this column	MRCOLS	7 - 14	9.67	varchar(20)
EXPL	Detailed explanation	MRDOC	0 - 941	25.97	varchar(1000)
FIL	Physical FILENAME	MRCOLS MRFILES	4 - 18 4 - 18	7.49 8.32	varchar(50) varchar(50)
FMT	Comma separated list of COL	MRFILES	7 - 112	19.70	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.ARA MRXW.BAQ MRXW.CHI MRXW.CZE MRXW.DAN MRXW.DUT MRXW.ENG MRXW.EST MRXW.FIN MRXW.FRE MRXW.GER MRXW.GRE MRXW.HEB MRXW.HUN MRXW.ITA MRXW.JPN MRXW.KOR MRXW.LAV MRXW.LIT MRXW.NOR MRXW.POL MRXW.POR MRXW.RUS MRXW.SCR MRXW.SPA MRXW.SWE MRXW.TUR MRXW.UKR	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 3 3 3 3 3 3 3 3 3	2.97 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 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) 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 MRXW.BAQ MRXW.DAN MRXW.HEB MRXW.JPN AMBIG.LUI MRSO MRXNS.ENG MRXW.CZE MRXW.ENG MRXNW.ENG MRCON MRXW.SPA MRXW.GER MRXW.DUT MRXW.FRE MRXW.ITA MRXW.POR MRXW.RUS MRXW.FIN MRXW.POL MRXW.SWE MRXW.KOR MRXW.SCR MRXW.NOR MRXW.HUN MRXW.LAV MRXW.ARA MRXW.CHI MRXW.EST MRXW.GRE MRXW.LIT MRXW.TUR MRXW.UKR	0 0 - 9 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 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 8 - 9 9 9 9 9 9 9 9	0.00 6.59 8.00 8.00 8.00 8.21 8.26 8.45 8.45 8.45 8.45 8.46 8.47 8.56 8.57 8.67 8.74 8.76 8.76 8.79 8.84 8.85 8.86 8.91 8.94 8.98 8.99 8.99 9.00 9.00 9.00 9.00 9.00 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) 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.47	char(1)
MAX	Maximum Length	MRCOLS	1 - 5	1.37	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.01	integer
MSTART	Metathesaurus start date for a source	MRSAB	0	0.00	char(8)
NSTR	Normalized string	MRXNS.ENG	1 - 2528	39.43	varchar(3000)
NWD	Normalized word	MRXNW.ENG	1 - 80	6.45	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 - 9	0.00 8.90	varchar(10) varchar(10)
PSTR	Preferred name in the previous Metathesaurus	CHANGE/DELETED.CUI CHANGE/DELETED.SUI CHANGE/DELETED.LUI	1 - 1120 1 - 1120 2 - 1120	69.59 70.47 71.40	varchar(3000) varchar(3000) varchar(3000)
PSUI	String unique identifier in the previous Metathesaurus	CHANGE/DELETED.SUI	8 - 9	8.91	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.28	varchar(3) varchar(3)
RELA	Additional relationship label	MRREL	0 - 54	10.57	varchar(100)
RMETA	Version of the Metathesaurus where a version is removed	MRSAB	0 - 6	0.12	varchar(10)
RSAB	Root source abbreviation	MRSAB	2 - 15	5.93	varchar(40)
RWS	Number of rows	MRFILES	1 - 8	5.80	integer
SAB	Source abbreviation	MRDEF MRSAT MRRANK MRREL MRSO MRATX	2 - 11 2 - 13 2 - 15 2 - 15 2 - 15 3	4.11 5.19 5.51 5.77 5.90 3.00	varchar(40) varchar(40) varchar(40) varchar(40) varchar(40) varchar(40)
SABIN	Source in current subset	MRSAB	1	1.00	char(1)
SCC	Content contact info for a source	MRSAB	12 - 332	152.43	varchar(1000)
SF	Source Family	MRSAB	2 - 13	4.19	varchar(40)
SL	Source of relationship labels	MRREL	2 - 15	5.77	varchar(40)
SLC	License contact info for a source	MRSAB	12 - 346	167.93	varchar(1000)
SON	Source Official Name	MRSAB	10 - 145	49.30	varchar(3000)
SRL	Source Restriction Level	MRSAB MRSO	1 1	1.00 1.00	integer integer
STR	String	MRCON	1 - 2875	41.12	varchar(3000)
STT	String type	MRCON	2 - 3	2.01	varchar(3)
STY	Semantic type	MRSTY	4 - 39	17.44	varchar(50)
SUI	Unique identifier for string	MRSAT MRXW.BAQ MRXW.DAN MRXW.HEB AMBIG.SUI MRXW.JPN MRSO MRXW.GER MRXW.SPA MRCON MRXNS.ENG MRXNW.ENG MRXW.DUT MRXW.ENG MRXW.POR MRXW.ITA MRXW.FRE MRXW.RUS MRXW.FIN MRXW.SWE MRXW.CZE MRXW.NOR MRXW.HUN MRXW.ARA MRXW.CHI MRXW.EST MRXW.GRE MRXW.KOR MRXW.LAV MRXW.LIT MRXW.POL MRXW.SCR MRXW.TUR MRXW.UKR	0 - 9 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 8 - 9 8 - 9 8 - 9 9 9 9 9 9 9 9 9 9 9 9	6.70 8.00 8.00 8.00 8.36 8.36 8.58 8.60 8.60 8.61 8.64 8.67 8.67 8.67 8.78 8.79 8.80 8.80 8.84 8.87 8.88 8.98 8.99 9.00 9.00 9.00 9.00 9.00 9.00 9.00 9.00 9.00 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) 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	4.98	varchar(20)
TFR	Term frequency for a source	MRSAB	1 - 7	4.50	integer
TS	Term status	MRCON	1	1.00	char(1)
TTY	Term type in source	MRSO MRRANK	2 - 11 2 - 11	2.38 2.60	varchar(20) varchar(20)
TTYL	Term type list for a source	MRSAB	0 - 129	15.55	varchar(400)
TUI	Unique identifier of Semantic type	MRSTY	4	4.00	char(4)
TYPE	Type of information	MRDOC	3 - 21	13.04	varchar(50)
VALUE	Value	MRDOC	0 - 62	15.95	varchar(200)
VCUI	Unique identifier for versioned SRC concept	MRSAB	0 - 8	7.68	char(8)
VER	Last release version in which CUI1 was valid	MRCUI	6	6.00	varchar(10)
VSAB	Versioned source abbreviation	MRSAB	3 - 24	11.36	varchar(40)
WD	Word in lower-case	MRXW.KOR MRXW.CHI MRXW.TUR MRXW.ARA MRXW.POR MRXW.ITA MRXW.HEB MRXW.ENG MRXW.UKR MRXW.DAN MRXW.SPA MRXW.FRE MRXW.EST MRXW.DUT MRXW.RUS MRXW.BAQ MRXW.POL MRXW.GRE MRXW.CZE MRXW.SCR MRXW.LAV MRXW.LIT MRXW.HUN MRXW.GER MRXW.SWE MRXW.NOR MRXW.JPN MRXW.FIN	1 - 38 1 - 68 1 - 37 1 - 22 1 - 38 1 - 38 1 - 19 1 - 80 1 - 27 1 - 25 1 - 46 1 - 39 1 - 35 1 - 51 1 - 42 1 - 18 1 - 48 1 - 34 1 - 52 1 - 37 1 - 29 1 - 31 1 - 27 1 - 43 1 - 39 1 - 44 1 - 93 1 - 54	2.84 3.65 5.25 5.35 5.72 5.90 6.12 6.14 6.37 6.38 6.61 6.74 6.93 7.15 7.16 7.17 7.24 7.28 7.44 7.70 7.76 7.81 7.86 8.26 8.32 9.11 9.11 9.94	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) varchar(500) varchar(500) varchar(500) varchar(500) varchar(500) varchar(500) varchar(500) varchar(500) varchar(500)

Back to Top