Skip Navigation Bar
 

Unified Medical Language System® (UMLS®)

Columns and Data Elements - 2013AB 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 - 62 9.62 varchar(100)
ATNL Attribute name list for a source MRSAB.RRF 0 - 743 80.42 varchar(1000)
ATUI Unique identifier for attribute MRSAT.RRF
MRSTY.RRF
MRDEF.RRF
10 - 11
10 - 11
10 - 11
10.45
10.50
10.53
varchar(11)
varchar(11)
varchar(11)
ATV Attribute value MRSAT.RRF 0 - 15047 6.62 varchar(16000)
AUI Unique identifier for atom MRHIER.RRF
MRCONSO.RRF
MRDEF.RRF
8 - 9
8 - 9
8 - 9
8.24
8.62
8.64
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.36
8.06
8.39
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.05
8.36
8.39
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 4 - 10 7.45 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.78 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.84 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 - 267 9.77 varchar(300)
CODE Unique Identifier or code for string in source MRSAT.RRF
MRCONSO.RRF
0 - 50
1 - 50
4.86
7.23
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.79 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_POL.RRF
MRXW_POR.RRF
MRXW_RUS.RRF
MRXW_SCR.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
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 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.41
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.15
2.05
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.04 integer
CXTY Context type for a source MRSAB.RRF 0 - 31 5.76 varchar(50)
DEF Definition MRDEF.RRF 1 - 10258 224.27 varchar(16000)
DES Descriptive Name MRCOLS.RRF
MRFILES.RRF
5 - 136
8 - 42
29.21
18.34
varchar(200)
varchar(200)
DIR Source asserted directionality flag MRREL.RRF 0 - 1 0.11 varchar(1)
DOCKEY Key to be documented MRDOC.RRF 2 - 8 3.52 varchar(50)
DTY SQL-92 data type for this column MRCOLS.RRF 7 - 14 9.90 varchar(20)
EXPL Detailed explanation MRDOC.RRF 0 - 941 29.73 varchar(1000)
FIL Physical FILENAME MRCOLS.RRF
MRFILES.RRF
9 - 21
9 - 21
10.84
12.06
varchar(50)
varchar(50)
FMT Comma separated list of COL MRFILES.RRF 7 - 190 31.38 varchar(300)
FROMEXPR The expression that a mapping is mapped from MRMAP.RRF
MRSMAP.RRF
1 - 15
1 - 15
6.96
7.37
varchar(4000)
varchar(4000)
FROMID Metathesaurus identifier for the entity being mapped from MRMAP.RRF 1 - 15 6.90 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.99
varchar(50)
varchar(50)
HCD Source asserted hierarchical number or code of context member (if it exists) MRHIER.RRF 0 - 47 0.57 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_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.92
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
MRXW_LAV.RRF
MRXW_DUT.RRF
MRXW_KOR.RRF
AMBIGLUI.RRF
MRXW_GER.RRF
MRXW_ITA.RRF
MRXW_POR.RRF
MRXW_RUS.RRF
MRXW_SPA.RRF
MRXW_FRE.RRF
MRXW_CZE.RRF
MRXW_JPN.RRF
MRXW_SCR.RRF
MRCONSO.RRF
MRXW_POL.RRF
CHANGE/MERGEDLUI.RRF
MRXNS_ENG.RRF
MRXNW_ENG.RRF
MRXW_ENG.RRF
MRXW_NOR.RRF
MRXW_HUN.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
8 - 9
5.06
8.00
8.00
8.00
8.00
8.00
8.00
8.01
8.01
8.03
8.03
8.04
8.05
8.05
8.05
8.07
8.08
8.08
8.08
8.09
8.10
8.11
8.13
8.13
8.13
8.97
8.99
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 MRSMAP.RRF
MRMAP.RRF
10 - 11
10 - 11
10.70
10.83
varchar(50)
varchar(50)
MAPIN Mapping in current subset MRCUI.RRF
MRAUI.RRF
0 - 1
1
0.93
1.00
char(1)
char(1)
MAPRANK Order in which mappings in a subset should be applied MRMAP.RRF 0 - 1 0.18 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
7.19
7.37
varchar(40)
varchar(40)
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.51 varchar(10)
MAPTYPE Type of mapping MRMAP.RRF 0 - 3 0.23 varchar(50)
MAX Maximum Length MRCOLS.RRF 1 - 5 1.40 integer
METAUI Metathesaurus asserted unique identifier MRSAT.RRF 0 - 10 7.46 varchar(50)
MIN Minimum Length MRCOLS.RRF 1 - 2 1.03 integer
NSTR Normalized string MRXNS_ENG.RRF 1 - 2532 39.05 varchar(3000)
NWD Normalized word MRXNW_ENG.RRF 1 - 80 6.36 varchar(100)
PAUI Unique identifier for parent atom MRHIER.RRF 0 - 9 8.20 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 - 9
8 - 9
8.14
8.36
varchar(10)
varchar(10)
PSTR Preferred name in the previous Metathesaurus CHANGE/DELETEDLUI.RRF
CHANGE/DELETEDSUI.RRF
CHANGE/DELETEDCUI.RRF
1 - 2999
1 - 2999
4 - 610
57.11
58.27
62.20
varchar(3000)
varchar(3000)
varchar(3000)
PSUI String unique identifier in the previous Metathesaurus CHANGE/DELETEDSUI.RRF 8 - 9 8.59 varchar(10)
PTR Path to root MRHIER.RRF 0 - 371 98.77 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.87 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.07
2.58
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 - 54
0 - 13
0.00
0.00
14.45
2.64
5.34
8.02
varchar(100)
varchar(100)
varchar(100)
varchar(100)
varchar(100)
varchar(100)
RG Relationship group MRREL.RRF 0 - 4 0.06 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.72 varchar(40)
RUI Unique identifier for relationship MRREL.RRF 9 - 10 9.46 varchar(10)
RWS Number of rows MRFILES.RRF 2 - 8 5.62 integer
SAB Source abbreviation MRDEF.RRF
MRREL.RRF
MRRANK.RRF
MRCONSO.RRF
MRSAT.RRF
MRHIER.RRF
MRCOC.RRF
MRHIST.RRF
2 - 11
2 - 15
2 - 15
2 - 15
2 - 13
2 - 11
3 - 5
6 - 8
3.10
5.15
5.16
5.29
5.43
6.47
3.01
7.99
varchar(40)
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
0
0.00
0.00
varchar(50)
varchar(50)
SAUI Source asserted atom identifier MRCONSO.RRF 0 - 16 2.41 varchar(50)
SCC Content contact info for a source MRSAB.RRF 0 - 329 121.81 varchar(1000)
SCIT Source citation MRSAB.RRF 37 - 445 145.18 varchar(4000)
SCUI Source asserted concept identifier MRCONSO.RRF 0 - 50 5.28 varchar(50)
SDUI Source asserted descriptor identifier MRCONSO.RRF 0 - 13 2.08 varchar(50)
SF Source Family MRSAB.RRF 2 - 13 4.20 varchar(40)
SL Source of relationship labels MRREL.RRF 2 - 15 5.15 varchar(40)
SLC License contact info for a source MRSAB.RRF 0 - 347 152.84 varchar(1000)
SON Source Official Name MRSAB.RRF 10 - 145 47.84 varchar(3000)
SOURCEUI Source asserted unique identifier MRHIST.RRF 6 - 17 9.07 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 19.58 varchar(3000)
STN Semantic type tree number MRSTY.RRF 1 - 14 7.66 varchar(100)
STR String MRCONSO.RRF 1 - 2864 36.95 varchar(3000)
STT String type MRCONSO.RRF 2 - 3 2.01 varchar(3)
STY Semantic type MRSTY.RRF 4 - 41 16.86 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.17 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.68 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.68 varchar(50)
SUI Unique identifier for string MRSAT.RRF
MRXW_BAQ.RRF
MRXW_DAN.RRF
MRXW_FIN.RRF
MRXW_HEB.RRF
MRXW_DUT.RRF
MRXW_GER.RRF
AMBIGSUI.RRF
MRXW_RUS.RRF
MRXW_POR.RRF
MRXW_SPA.RRF
MRXW_ITA.RRF
MRXW_SWE.RRF
MRXW_JPN.RRF
MRXW_FRE.RRF
MRCONSO.RRF
MRXNS_ENG.RRF
MRXNW_ENG.RRF
MRXW_ENG.RRF
MRXW_CZE.RRF
MRXW_NOR.RRF
MRXW_HUN.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
9
9
9
9
5.15
8.00
8.00
8.00
8.00
8.02
8.09
8.11
8.12
8.13
8.13
8.16
8.17
8.23
8.28
8.30
8.43
8.45
8.45
8.80
8.97
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)
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 - 19
8
5.49
8.00
varchar(20)
varchar(20)
TFR Term frequency for a source MRSAB.RRF 1 - 7 3.98 integer
TOEXPR The expression that a mapping is mapped to MRMAP.RRF
MRSMAP.RRF
0 - 242
0 - 242
6.27
6.60
varchar(4000)
varchar(4000)
TOID Metathesaurus identifier for the entity being mapped to MRMAP.RRF 0 - 13 5.74 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.15 varchar(50)
TOTYPE The type of expression that a mapping is mapped to MRMAP.RRF
MRSMAP.RRF
0 - 23
0 - 23
7.02
9.45
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.31
2.95
varchar(20)
varchar(20)
TTYL Term type list for a source MRSAB.RRF 0 - 360 18.13 varchar(400)
TUI Unique identifier of Semantic type MRSTY.RRF 4 4.00 char(4)
TYPE Type of information MRDOC.RRF 3 - 21 12.63 varchar(50)
VALUE Value MRDOC.RRF 0 - 62 13.31 varchar(200)
VCUI Unique identifier for versioned SRC concept MRSAB.RRF 0 - 8 7.56 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 - 26 11.31 varchar(40)
VSTART Valid start date for a source MRSAB.RRF 0 - 8 0.09 char(8)
WD Word in lower-case MRXW_FIN.RRF
MRXW_KOR.RRF
MRXW_ENG.RRF
MRXW_HEB.RRF
MRXW_DAN.RRF
MRXW_FRE.RRF
MRXW_SPA.RRF
MRXW_POR.RRF
MRXW_ITA.RRF
MRXW_BAQ.RRF
MRXW_LAV.RRF
MRXW_CZE.RRF
MRXW_HUN.RRF
MRXW_SCR.RRF
MRXW_POL.RRF
MRXW_DUT.RRF
MRXW_RUS.RRF
MRXW_GER.RRF
MRXW_NOR.RRF
MRXW_JPN.RRF
MRXW_SWE.RRF
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.59
6.63
6.78
6.98
7.17
7.28
7.34
7.68
8.06
8.16
8.31
8.52
8.62
8.95
9.52
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)

 


Table 2. Columns and Data Elements in Original Release Format (ORF)

AbbreviationDescriptionFileLength of Value in charactersAverage Length of Value in charactersSQL92 Datatype
ATN Attribute name MRSAT 2 - 62 7.98 varchar(100)
ATNL Attribute name list for a source MRSAB 0 - 743 72.73 varchar(4000)
ATV Attribute value MRSAT 0 - 15047 8.13 varchar(16000)
ATX Associated expression MRATX 5 - 242 35.85 varchar(300)
AV Average Length, Characters MRCOLS 4 - 6 4.11 numeric(5,2)
BTS Size in Bytes MRFILES 4 - 10 7.25 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.78 integer
CLS Number of columns MRFILES 1 - 2 1.02 integer
COA Attributes of co-occurrence MRCOC 0 - 267 9.77 varchar(300)
CODE Unique Identifier or code for string in source MRSAT
MRSO
0 - 50
1 - 50
6.26
7.23
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.41
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.76 varchar(50)
DEF Definition MRDEF 1 - 10258 226.62 varchar(16000)
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 - 14 9.67 varchar(20)
EXPL Detailed explanation MRDOC 0 - 941 29.25 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 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.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.92
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.LAV
MRXW.DUT
MRXW.KOR
AMBIG.LUI
MRXW.GER
MRXW.ITA
MRXW.POR
MRXW.RUS
MRXW.SPA
MRXW.FRE
MRXW.CZE
MRXW.JPN
MRXW.SCR
MRSO
MRCON
MRXW.POL
CHANGE/MERGED.LUI
MRXNS.ENG
MRXNW.ENG
MRXW.ENG
MRXW.NOR
MRXW.HUN
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
8 - 9
6.52
8.00
8.00
8.00
8.00
8.00
8.00
8.01
8.01
8.03
8.03
8.04
8.05
8.05
8.05
8.07
8.08
8.08
8.08
8.09
8.10
8.10
8.11
8.13
8.13
8.13
8.97
8.99
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.09 char(8)
NSTR Normalized string MRXNS.ENG 1 - 2532 39.05 varchar(3000)
NWD Normalized word MRXNW.ENG 1 - 80 6.36 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 - 9
8 - 9
8.14
8.36
varchar(10)
varchar(10)
PSTR Preferred name in the previous Metathesaurus CHANGE/DELETED.LUI
CHANGE/DELETED.SUI
CHANGE/DELETED.CUI
1 - 2999
1 - 2999
4 - 610
57.11
58.27
62.20
varchar(3000)
varchar(3000)
varchar(3000)
PSUI String unique identifier in the previous Metathesaurus CHANGE/DELETED.SUI 8 - 9 8.59 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 - 54 4.85 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.72 varchar(40)
RWS Number of rows MRFILES 2 - 8 5.50 integer
SAB Source abbreviation MRDEF
MRREL
MRRANK
MRSAT
MRSO
MRATX
2 - 11
2 - 15
2 - 15
2 - 13
2 - 15
3
3.09
5.07
5.16
5.18
5.29
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 0 - 329 121.81 varchar(1000)
SF Source Family MRSAB 2 - 13 4.20 varchar(40)
SL Source of relationship labels MRREL 2 - 15 5.07 varchar(40)
SLC License contact info for a source MRSAB 0 - 347 152.84 varchar(1000)
SOC Source of co-occurrence information MRCOC 3 - 5 3.01 varchar(40)
SON Source Official Name MRSAB 10 - 145 47.84 varchar(3000)
SRL Source Restriction Level MRSAB
MRSO
1
1
1.00
1.00
integer
integer
STR String MRCON 1 - 2864 38.53 varchar(3000)
STT String type MRCON 2 - 3 2.01 varchar(3)
STY Semantic type MRSTY 4 - 41 16.86 varchar(50)
SUI Unique identifier for string MRSAT
MRXW.BAQ
MRXW.DAN
MRXW.FIN
MRXW.HEB
MRXW.DUT
MRXW.GER
AMBIG.SUI
MRXW.RUS
MRXW.POR
MRXW.SPA
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.64
8.00
8.00
8.00
8.00
8.02
8.09
8.11
8.12
8.13
8.13
8.16
8.17
8.23
8.28
8.30
8.33
8.43
8.45
8.45
8.80
8.97
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 - 19 5.49 varchar(20)
TFR Term frequency for a source MRSAB 1 - 7 3.98 integer
TS Term status MRCON 1 1.00 char(1)
TTY Term type in source MRSO
MRRANK
2 - 11
2 - 11
2.31
2.95
varchar(20)
varchar(20)
TTYL Term type list for a source MRSAB 0 - 360 18.13 varchar(400)
TUI Unique identifier of Semantic type MRSTY 4 4.00 char(4)
TYPE Type of information MRDOC 3 - 21 12.62 varchar(50)
VALUE Value MRDOC 0 - 62 13.39 varchar(200)
VCUI Unique identifier for versioned SRC concept MRSAB 0 - 8 7.56 char(8)
VER Last release version in which CUI1 was valid MRCUI 6 6.00 varchar(10)
VSAB Versioned source abbreviation MRSAB 3 - 26 11.31 varchar(40)
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.59
6.63
6.78
6.98
7.17
7.28
7.34
7.68
8.06
8.16
8.31
8.52
8.62
8.95
9.52
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)