Skip Navigation Bar

Unified Medical Language System® (UMLS®)

UMLS Quick Start Guide | FAQs | Customer Support | UMLS Site Map

Columns and Data Elements - 2012AA 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)

AbbreviationDescriptionFileLength of Value in charactersAverage Length of Value in charactersSQL92 Datatype
ATN Attribute name MRSAT.RRF 2 - 76 9.00 varchar(100)
ATNL Attribute name list for a source MRSAB.RRF 0 - 751 73.00 varchar(1000)
ATUI Unique identifier for attribute MRDEF.RRF
MRSAT.RRF
MRSTY.RRF		 10 - 11
10 - 11
10 - 11		 10.00
10.00
10.00		 varchar(11)
varchar(11)
varchar(11)
ATV Attribute value MRSAT.RRF 0 - 15047 6.00 varchar(8000)
AUI Unique identifier for atom MRCONSO.RRF
MRDEF.RRF
MRHIER.RRF
MRCXT.RRF		 8 - 9
8 - 9
8 - 9
999999999 - 0		 8.00
8.00
8.00
0.00		 varchar(9)
varchar(9)
varchar(9)
varchar(9)
AUI1 Unique identifier for first atom MRREL.RRF
MRAUI.RRF
MRCOC.RRF		 0 - 9
8 - 9
8 - 9		 8.00
8.00
8.00		 varchar(9)
varchar(9)
varchar(9)
AUI2 Unique identifier for second atom MRCOC.RRF
MRREL.RRF
MRAUI.RRF
MRCXT.RRF		 0 - 9
0 - 9
8 - 9
999999999 - 0		 8.00
8.00
8.00
0.00		 varchar(9)
varchar(9)
varchar(9)
varchar(9)
AV Average Length, Characters MRCOLS.RRF 4 - 6 4.11 numeric(5,2)
BTS Size in Bytes MRFILES.RRF 1 - 10 7.29 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.00 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.00 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.15 integer
COA Attributes of co-occurrence MRCOC.RRF 0 - 264 9.00 varchar(300)
CODE Unique Identifier or code for string in source MRSAT.RRF
MRCONSO.RRF
MRCXT.RRF		 0 - 50
1 - 50
999999999 - 0		 4.00
7.00
0.00		 varchar(50)
varchar(50)
varchar(50)
COF Frequency of co-occurrence MRCOC.RRF 0 - 5 1.00 integer
COL Column or data element name MRCOLS.RRF 2 - 11 3.76 varchar(20)
COT Type of co-occurrence MRCOC.RRF 1 - 3 1.00 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_POL.RRF
MRXW_POR.RRF
MRXW_RUS.RRF
MRXW_SCR.RRF
MRXW_SPA.RRF
MRXW_SWE.RRF
MRCXT.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
8
999999999 - 0		 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
0.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)
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 MRCOC.RRF
MRCUI.RRF
MRAUI.RRF
MRREL.RRF
MRCXT.RRF		 0 - 8
0 - 8
8
8
999999999 - 0		 7.00
7.00
8.00
8.00
0.00		 char(8)
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
MRCXT.RRF		 0
0
0
0
0
0
0
0
0 - 4
0 - 4
999999999 - 0		 0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
1.00
0.00		 integer
integer
integer
integer
integer
integer
integer
integer
integer
integer
integer
CXL Context member label, i.e., ANC for ancestor of this atom, CCP for the atom itself, SIB for sibling of this atom, CHD for child of this atom MRCXT.RRF 999999999 - 0 0.00 char(3)
CXN The context number if the atom has multiple contexts MRHIER.RRF
MRCXT.RRF		 1 - 4
999999999 - 0		 2.00
0.00		 integer
integer
CXS String for context member MRCXT.RRF 999999999 - 0 0.00 varchar(3000)
CXTY Context type for a source MRSAB.RRF 0 - 31 6.00 varchar(50)
DEF Definition MRDEF.RRF 1 - 10258 225.00 varchar(8000)
DES Descriptive Name MRCOLS.RRF
MRFILES.RRF		 5 - 140
8 - 42		 29.64
18.29		 varchar(200)
varchar(200)
DIR Source asserted directionality flag MRREL.RRF 0 - 1 0.00 varchar(1)
DOCKEY Key to be documented MRDOC.RRF 2 - 8 3.00 varchar(50)
DTY SQL-92 data type for this column MRCOLS.RRF 7 - 13 9.87 varchar(20)
EXPL Detailed explanation MRDOC.RRF 0 - 941 29.00 varchar(1000)
FIL Physical FILENAME MRFILES.RRF
MRCOLS.RRF		 7 - 21
9 - 21		 11.92
10.75		 varchar(50)
varchar(50)
FMT Comma separated list of COL MRFILES.RRF 7 - 190 32.04 varchar(300)
FROMEXPR The expression that a mapping is mapped from MRMAP.RRF
MRSMAP.RRF		 1 - 9
1 - 9		 6.00
7.00		 varchar(4000)
varchar(4000)
FROMID Metathesaurus identifier for the entity being mapped from MRMAP.RRF 1 - 9 6.00 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.00
3.00		 varchar(50)
varchar(50)
HCD Source asserted hierarchical number or code of context member (if it exists) MRHIER.RRF
MRCXT.RRF		 0 - 47
999999999 - 0		 0.00
0.00		 varchar(50)
varchar(50)
IMETA Version of the Metathesaurus that a source was added MRSAB.RRF 0 - 6 5.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_POL.RRF
MRXW_POR.RRF
MRXW_RUS.RRF
MRXW_SCR.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
3
3		 2.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)
LUI Unique identifier for term MRSAT.RRF
MRXW_BAQ.RRF
MRXW_DAN.RRF
MRXW_FIN.RRF
MRXW_HEB.RRF
MRXW_SWE.RRF
AMBIGLUI.RRF
MRCONSO.RRF
MRXNS_ENG.RRF
MRXNW_ENG.RRF
MRXW_CZE.RRF
MRXW_DUT.RRF
MRXW_ENG.RRF
MRXW_FRE.RRF
MRXW_GER.RRF
MRXW_HUN.RRF
MRXW_ITA.RRF
MRXW_JPN.RRF
MRXW_KOR.RRF
MRXW_LAV.RRF
MRXW_NOR.RRF
MRXW_POL.RRF
MRXW_POR.RRF
MRXW_RUS.RRF
MRXW_SCR.RRF
MRXW_SPA.RRF
CHANGE/MERGEDLUI.RRF		 0 - 9
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
8 - 9
8 - 9
8 - 9
8 - 9
9		 5.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
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)
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 - 11
10 - 11		 10.00
10.00		 varchar(50)
varchar(50)
MAPIN Mapping in current subset MRCUI.RRF
MRAUI.RRF		 0 - 1
1		 0.00
1.00		 char(1)
char(1)
MAPRANK Order in which mappings in a subset should be applied MRMAP.RRF 0 - 1 0.00 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.00
7.00		 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.00 varchar(10)
MAPTYPE Type of mapping MRMAP.RRF 0 - 3 0.00 varchar(50)
MAX Maximum Length MRCOLS.RRF 1 - 5 1.37 integer
METAUI Metathesaurus asserted unique identifier MRSAT.RRF 0 - 10 7.00 varchar(50)
MIN Minimum Length MRCOLS.RRF 1 - 9 1.38 integer
NSTR Normalized string MRXNS_ENG.RRF 1 - 2754 38.00 varchar(3000)
NWD Normalized word MRXNW_ENG.RRF 1 - 80 6.00 varchar(100)
PAUI Unique identifier for parent atom MRHIER.RRF 0 - 9 8.00 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		 8
8 - 9		 8.00
8.00		 varchar(10)
varchar(10)
PSTR Preferred name in the previous Metathesaurus CHANGE/DELETEDLUI.RRF
CHANGE/DELETEDSUI.RRF
CHANGE/DELETEDCUI.RRF		 2 - 732
2 - 1055
4 - 579		 42.00
45.00
73.00		 varchar(3000)
varchar(3000)
varchar(3000)
PSUI String unique identifier in the previous Metathesaurus CHANGE/DELETEDSUI.RRF 8 - 9 8.00 varchar(10)
PTR Path to root MRHIER.RRF 0 - 370 99.00 varchar(1000)
RANK Termgroup ranking MRRANK.RRF
MRCXT.RRF		 4
999999999 - 0		 4.00
0.00		 integer
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.00 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.00
2.00		 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
MRCXT.RRF		 0
0
0 - 23
0 - 17
0 - 53
0 - 13
999999999 - 0		 0.00
0.00
14.00
2.00
5.00
8.00
0.00		 varchar(100)
varchar(100)
varchar(100)
varchar(100)
varchar(100)
varchar(100)
varchar(100)
RG Relationship group MRREL.RRF 0 - 4 0.00 varchar(10)
RMETA Version of the Metathesaurus where a version is removed MRSAB.RRF 0 - 6 0.00 varchar(10)
RSAB Root source abbreviation MRSAB.RRF 2 - 15 5.00 varchar(20)
RUI Unique identifier for relationship MRREL.RRF 9 - 10 9.00 varchar(10)
RWS Number of rows MRFILES.RRF 1 - 8 5.48 integer
SAB Source abbreviation MRDEF.RRF
MRSAT.RRF
MRCONSO.RRF
MRRANK.RRF
MRREL.RRF
MRHIER.RRF
MRCOC.RRF
MRHIST.RRF
MRCXT.RRF		 2 - 11
2 - 13
2 - 15
2 - 15
2 - 15
2 - 11
3 - 5
6 - 8
999999999 - 0		 3.00
5.00
5.00
5.00
5.00
6.00
3.00
7.00
0.00		 varchar(20)
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 - 16 2.00 varchar(50)
SCC Content contact info for a source MRSAB.RRF 0 - 329 118.00 varchar(1000)
SCIT Source citation MRSAB.RRF 26 - 445 147.00 varchar(4000)
SCUI Source asserted concept identifier MRCONSO.RRF 0 - 50 5.00 varchar(50)
SDUI Source asserted descriptor identifier MRCONSO.RRF 0 - 13 2.00 varchar(50)
SF Source Family MRSAB.RRF 2 - 13 4.00 varchar(20)
SL Source of relationship labels MRREL.RRF 2 - 15 5.00 varchar(20)
SLC License contact info for a source MRSAB.RRF 0 - 337 153.00 varchar(1000)
SON Source Official Name MRSAB.RRF 10 - 145 46.00 varchar(3000)
SOURCEUI Source asserted unique identifier MRHIST.RRF 6 - 17 9.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 - 15 1.00 varchar(50)
SSN Source short name MRSAB.RRF 3 - 89 18.00 varchar(3000)
STN Semantic type tree number MRSTY.RRF 1 - 14 7.00 varchar(100)
STR String MRCONSO.RRF 1 - 2999 36.00 varchar(3000)
STT String type MRCONSO.RRF 2 2.00 varchar(3)
STY Semantic type MRSTY.RRF 4 - 41 17.00 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.00 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.00 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.00 varchar(50)
SUI Unique identifier for string MRSAT.RRF
MRXW_BAQ.RRF
MRXW_DAN.RRF
MRXW_FIN.RRF
MRXW_HEB.RRF
AMBIGSUI.RRF
MRCONSO.RRF
MRXNS_ENG.RRF
MRXNW_ENG.RRF
MRXW_CZE.RRF
MRXW_DUT.RRF
MRXW_ENG.RRF
MRXW_FRE.RRF
MRXW_GER.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
MRCXT.RRF
MRXW_KOR.RRF
MRXW_LAV.RRF
MRXW_POL.RRF
MRXW_SCR.RRF		 0 - 9
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
8 - 9
999999999 - 0
9
9
9
9		 5.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
0.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)
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.00
8.00		 varchar(20)
varchar(20)
TFR Term frequency for a source MRSAB.RRF 1 - 7 4.00 integer
TOEXPR The expression that a mapping is mapped to MRMAP.RRF
MRSMAP.RRF		 0 - 242
0 - 242		 6.00
6.00		 varchar(4000)
varchar(4000)
TOID Metathesaurus identifier for the entity being mapped to MRMAP.RRF 0 - 21 5.00 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.00 varchar(50)
TOTYPE The type of expression that a mapping is mapped to MRMAP.RRF
MRSMAP.RRF		 0 - 23
0 - 23		 6.00
9.00		 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.00
2.00		 varchar(20)
varchar(20)
TTYL Term type list for a source MRSAB.RRF 0 - 352 17.00 varchar(400)
TUI Unique identifier of Semantic type MRSTY.RRF 4 4.00 char(4)
TYPE Type of information MRDOC.RRF 3 - 21 12.00 varchar(50)
VALUE Value MRDOC.RRF 0 - 76 13.00 varchar(200)
VCUI Unique identifier for versioned SRC concept MRSAB.RRF 0 - 8 7.00 char(8)
VEND Valid end date for a source MRSAB.RRF 0 - 8 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.00 varchar(20)
VSTART Valid start date for a source MRSAB.RRF 0 - 8 0.00 char(8)
WD Word in lower-case MRXW_FIN.RRF
MRXW_KOR.RRF
MRXW_HEB.RRF
MRXW_DAN.RRF
MRXW_POR.RRF
MRXW_FRE.RRF
MRXW_SPA.RRF
MRXW_ENG.RRF
MRXW_BAQ.RRF
MRXW_LAV.RRF
MRXW_HUN.RRF
MRXW_ITA.RRF
MRXW_CZE.RRF
MRXW_NOR.RRF
MRXW_SCR.RRF
MRXW_RUS.RRF
MRXW_GER.RRF
MRXW_DUT.RRF
MRXW_POL.RRF
MRXW_SWE.RRF
MRXW_JPN.RRF		 1 - 54
1 - 15
1 - 19
1 - 25
1 - 38
1 - 39
1 - 46
1 - 80
1 - 18
1 - 23
1 - 28
1 - 38
1 - 52
1 - 37
1 - 37
1 - 40
1 - 45
1 - 46
1 - 48
1 - 38
1 - 93		 10.00
2.00
6.00
6.00
6.00
6.00
6.00
6.00
7.00
7.00
7.00
7.00
7.00
8.00
8.00
8.00
8.00
8.00
8.00
9.00
9.00		 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)
XC Has Child MRCXT.RRF 999999999 - 0 0.00 varchar(1)

 

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 - 76 8.02 varchar(100)
ATNL Attribute name list for a source MRSAB 0 - 751 65.76 varchar(4000)
ATV Attribute value MRSAT 0 - 15047 7.94 varchar(8000)
ATX Associated expression MRATX 5 - 242 35.86 varchar(300)
AV Average Length, Characters MRCOLS 4 - 6 4.11 numeric(5,2)
BTS Size in Bytes MRFILES 3 - 10 7.20 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.86 integer
CLS Number of columns MRFILES 1 - 2 1.02 integer
COA Attributes of co-occurrence MRCOC 0 - 264 9.80 varchar(300)
CODE Unique Identifier or code for string in source MRSAT
MRSO		 0 - 50
1 - 50		 6.23
7.18		 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.09 varchar(3)
CREL Relationship to retired CUI (CUI1) to current CUI (CUI2) MRCUI 2 - 3 2.07 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.POL
MRXW.POR
MRXW.RUS
MRXW.SCR
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
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		 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 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.40
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 6.02 varchar(50)
DEF Definition MRDEF 1 - 10258 228.00 varchar(8000)
DES Descriptive Name MRCOLS
MRFILES		 5 - 56
7 - 42		 25.93
18.18		 varchar(100)
varchar(100)
DOCKEY Key to be documented MRDOC 2 - 8 3.50 varchar(50)
DTY SQL-92 data type for this column MRCOLS 7 - 13 9.66 varchar(20)
EXPL Detailed explanation MRDOC 0 - 941 29.39 varchar(1000)
FIL Physical FILENAME MRCOLS
MRFILES		 4 - 18
4 - 18		 7.34
8.30		 varchar(50)
varchar(50)
FMT Comma separated list of COL MRFILES 7 - 112 20.09 varchar(150)
IMETA Version of the Metathesaurus that a source was added MRSAB 0 - 6 5.97 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.POL
MRXW.POR
MRXW.RUS
MRXW.SCR
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
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
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)
LRL Least Restriction Level MRCON 1 1.00 integer
LUI Unique identifier for term MRSAT
MRXW.BAQ
MRXW.DAN
MRXW.FIN
MRXW.HEB
MRXW.SWE
MRXW.DUT
MRXW.LAV
MRXW.GER
MRXW.KOR
MRXW.SPA
AMBIG.LUI
MRXW.POR
MRXW.CZE
MRXW.ITA
MRXW.RUS
MRSO
MRXNS.ENG
MRXW.FRE
MRXW.SCR
MRCON
MRXW.POL
MRXNW.ENG
MRXW.ENG
MRXW.JPN
MRXW.NOR
MRXW.HUN
CHANGE/MERGED.LUI		 0 - 9
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
8 - 9
8 - 9
8 - 9
8 - 9
8 - 9
9		 6.55
8.00
8.00
8.00
8.00
8.00
8.00
8.00
8.01
8.01
8.01
8.02
8.02
8.03
8.03
8.03
8.04
8.04
8.04
8.04
8.05
8.06
8.07
8.07
8.07
8.94
8.99
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)
MAPIN Mapping in current subset MRCUI 0 - 1 0.93 char(1)
MAX Maximum Length MRCOLS 1 - 5 1.39 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.14 char(8)
NSTR Normalized string MRXNS.ENG 1 - 2754 39.71 varchar(3000)
NWD Normalized word MRXNW.ENG 1 - 80 6.34 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		 8
8 - 9		 8.00
8.03		 varchar(10)
varchar(10)
PSTR Preferred name in the previous Metathesaurus CHANGE/DELETED.LUI
CHANGE/DELETED.SUI
CHANGE/DELETED.CUI		 2 - 732
2 - 1055
4 - 579		 42.83
45.44
73.29		 varchar(3000)
varchar(3000)
varchar(3000)
PSUI String unique identifier in the previous Metathesaurus CHANGE/DELETED.SUI 8 - 9 8.42 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.64		 varchar(3)
varchar(3)
RELA Additional relationship label MRREL 0 - 53 4.79 varchar(100)
RMETA Version of the Metathesaurus where a version is removed MRSAB 0 - 6 0.24 varchar(10)
RSAB Root source abbreviation MRSAB 2 - 15 5.58 varchar(20)
RWS Number of rows MRFILES 1 - 8 5.43 integer
SAB Source abbreviation MRDEF
MRREL
MRRANK
MRSAT
MRSO
MRATX		 2 - 11
2 - 15
2 - 15
2 - 13
2 - 15
3		 3.10
5.07
5.08
5.24
5.33
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 - 329 118.86 varchar(1000)
SF Source Family MRSAB 2 - 13 4.25 varchar(20)
SL Source of relationship labels MRREL 2 - 15 5.07 varchar(20)
SLC License contact info for a source MRSAB 0 - 337 153.44 varchar(1000)
SOC Source of co-occurrence information MRCOC 3 - 5 3.01 varchar(20)
SON Source Official Name MRSAB 10 - 145 46.99 varchar(3000)
SRL Source Restriction Level MRSAB
MRSO		 1
1		 1.00
1.00		 integer
integer
STR String MRCON 1 - 2999 38.66 varchar(3000)
STT String type MRCON 2 - 3 2.01 varchar(3)
STY Semantic type MRSTY 4 - 41 17.30 varchar(50)
SUI Unique identifier for string MRSAT
MRXW.BAQ
MRXW.DAN
MRXW.FIN
MRXW.HEB
MRXW.DUT
MRXW.GER
MRXW.POR
MRXW.RUS
MRXW.SPA
AMBIG.SUI
MRXW.ITA
MRXW.SWE
MRXW.JPN
MRXW.FRE
MRSO
MRCON
MRXNS.ENG
MRXNW.ENG
MRXW.ENG
MRXW.CZE
MRXW.NOR
MRXW.HUN
MRXW.KOR
MRXW.LAV
MRXW.POL
MRXW.SCR		 0 - 9
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
8 - 9
8 - 9
9
9
9
9		 6.67
8.00
8.00
8.00
8.00
8.02
8.08
8.10
8.10
8.10
8.11
8.15
8.17
8.22
8.25
8.26
8.29
8.37
8.41
8.41
8.79
8.94
8.99
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)
SUPRES Suppressible flag MRRANK 1 1.00 char(1)
SVER Release date or version number of a source MRSAB 0 - 15 5.26 varchar(20)
TFR Term frequency for a source MRSAB 1 - 7 4.06 integer
TS Term status MRCON 1 1.00 char(1)
TTY Term type in source MRSO
MRRANK		 2 - 11
2 - 11		 2.29
2.89		 varchar(20)
varchar(20)
TTYL Term type list for a source MRSAB 0 - 352 17.80 varchar(400)
TUI Unique identifier of Semantic type MRSTY 4 4.00 char(4)
TYPE Type of information MRDOC 3 - 21 12.63 varchar(50)
VALUE Value MRDOC 0 - 76 13.16 varchar(200)
VCUI Unique identifier for versioned SRC concept MRSAB 0 - 8 7.54 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.93 varchar(20)
WD Word in lower-case MRXW.FIN
MRXW.KOR
MRXW.ENG
MRXW.HEB
MRXW.DAN
MRXW.FRE
MRXW.SPA
MRXW.POR
MRXW.ITA
MRXW.BAQ
MRXW.LAV
MRXW.CZE
MRXW.HUN
MRXW.SCR
MRXW.POL
MRXW.DUT
MRXW.RUS
MRXW.GER
MRXW.NOR
MRXW.JPN
MRXW.SWE		 1 - 54
1 - 15
1 - 80
1 - 19
1 - 25
1 - 39
1 - 46
1 - 38
1 - 38
1 - 18
1 - 23
1 - 52
1 - 28
1 - 37
1 - 48
1 - 46
1 - 40
1 - 45
1 - 37
1 - 93
1 - 38		 10.53
2.95
6.09
6.12
6.38
6.60
6.63
6.78
6.98
7.17
7.28
7.33
7.67
8.06
8.16
8.31
8.53
8.61
8.88
9.50
9.63		 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)