Skip Navigation Bar

Unified Medical Language System® (UMLS®)

Columns and Data Elements - 2014AB 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 10.01 varchar(100)
ATNL Attribute name list for a source MRSAB.RRF 0 - 785 55.86 varchar(1000)
ATUI Unique identifier for attribute MRSTY.RRF
MRDEF.RRF
MRSAT.RRF
10 - 11
10 - 11
10 - 11
10.53
10.73
10.75
varchar(11)
varchar(11)
varchar(11)
ATV Attribute value MRSAT.RRF 1 - 15047 13.79 varchar(16000)
AUI Unique identifier for atom MRHIER.RRF
MRDEF.RRF
MRCONSO.RRF
8 - 9
8 - 9
8 - 9
8.29
8.65
8.66
varchar(9)
varchar(9)
varchar(9)
AUI1 Unique identifier for first atom MRREL.RRF
MRAUI.RRF
0 - 9
8 - 9
8.40
8.46
varchar(9)
varchar(9)
AUI2 Unique identifier for second atom MRREL.RRF
MRAUI.RRF
0 - 9
8 - 9
8.40
8.46
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.15 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.96 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.13 integer
CODE Unique Identifier or code for string in source MRSAT.RRF
MRCONSO.RRF
0 - 50
1 - 63
4.86
7.29
varchar(100)
varchar(100)
COL Column or data element name MRCOLS.RRF 2 - 11 3.80 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_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
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
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
7.52
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
1.05
1.78
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 - 4 1.96 integer
CXTY Context type for a source MRSAB.RRF 0 - 31 5.78 varchar(50)
DEF Definition MRDEF.RRF 3 - 10258 219.01 varchar(16000)
DES Descriptive Name MRCOLS.RRF
MRFILES.RRF
5 - 136
8 - 42
29.27
18.28
varchar(200)
varchar(200)
DIR Source asserted directionality flag MRREL.RRF 0 - 1 0.16 varchar(1)
DOCKEY Key to be documented MRDOC.RRF 2 - 8 3.58 varchar(50)
DTY SQL-92 data type for this column MRCOLS.RRF 7 - 14 10.05 varchar(20)
EXPL Detailed explanation MRDOC.RRF 0 - 941 27.76 varchar(1000)
FIL Physical FILENAME MRCOLS.RRF
MRFILES.RRF
9 - 21
9 - 21
10.89
12.13
varchar(50)
varchar(50)
FMT Comma separated list of COL MRFILES.RRF 7 - 190 31.22 varchar(300)
FROMEXPR The expression that a mapping is mapped from MRSMAP.RRF
MRMAP.RRF
1 - 8
1 - 17
6.67
7.07
varchar(4000)
varchar(4000)
FROMID Metathesaurus identifier for the entity being mapped from MRMAP.RRF 1 - 17 7.02 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.96
3.99
varchar(50)
varchar(50)
HCD Source asserted hierarchical number or code of context member (if it exists) MRHIER.RRF 0 - 47 0.64 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.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
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_FIN.RRF
MRXW_HEB.RRF
MRXW_SWE.RRF
MRXW_LAV.RRF
MRXW_KOR.RRF
MRXW_DUT.RRF
MRXW_GER.RRF
MRXW_SPA.RRF
MRXW_POR.RRF
MRXW_RUS.RRF
AMBIGLUI.RRF
MRXW_ITA.RRF
MRXW_JPN.RRF
MRXW_FRE.RRF
MRXW_POL.RRF
MRXW_SCR.RRF
MRXW_CZE.RRF
MRCONSO.RRF
MRXW_ENG.RRF
MRXNS_ENG.RRF
MRXNW_ENG.RRF
MRXW_NOR.RRF
MRXW_HUN.RRF
0
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
0.00
4.95
8.00
8.00
8.00
8.00
8.00
8.00
8.01
8.02
8.04
8.05
8.06
8.07
8.08
8.09
8.09
8.10
8.10
8.10
8.11
8.14
8.20
8.21
8.21
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 - 6 1.18 varchar(20)
MAPATV Mapping attribute value (for future use) MRMAP.RRF 0 - 1 0.20 varchar(4000)
MAPID Metathesaurus asserted identifier for mapping MRSMAP.RRF
MRMAP.RRF
10 - 11
10 - 11
10.96
10.99
varchar(50)
varchar(50)
MAPIN Mapping in current subset MRCUI.RRF
MRAUI.RRF
0 - 1
1
0.94
1.00
char(1)
char(1)
MAPRANK Order in which mappings in a subset should be applied MRMAP.RRF 0 - 2 0.22 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 - 192 0.06 varchar(4000)
MAPRULE Machine processible rule applicable to this mapping MRMAP.RRF 0 - 175 0.03 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.75
7.92
varchar(40)
varchar(40)
MAPSID Source asserted identifier for mapping MRSMAP.RRF
MRMAP.RRF
0
0 - 36
0.00
7.03
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.46 varchar(10)
MAPTYPE Type of mapping MRMAP.RRF 0 - 9 1.81 varchar(50)
MAX Maximum Length MRCOLS.RRF 1 - 5 1.40 integer
METAUI Metathesaurus asserted unique identifier MRSAT.RRF 0 - 10 7.67 varchar(50)
MIN Minimum Length MRCOLS.RRF 1 - 2 1.02 integer
NSTR Normalized string MRXNS_ENG.RRF 1 - 2528 38.74 varchar(3000)
NWD Normalized word MRXNW_ENG.RRF 1 - 80 6.37 varchar(100)
PAUI Unique identifier for parent atom MRHIER.RRF 0 - 9 8.24 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.37
varchar(10)
varchar(10)
PSTR Preferred name in the previous Metathesaurus CHANGE/DELETEDCUI.RRF
CHANGE/DELETEDLUI.RRF
CHANGE/DELETEDSUI.RRF
2 - 566
2 - 525
2 - 525
41.34
47.07
49.19
varchar(3000)
varchar(3000)
varchar(3000)
PSUI String unique identifier in the previous Metathesaurus CHANGE/DELETEDSUI.RRF 8 - 9 8.75 varchar(10)
PTR Path to root MRHIER.RRF 0 - 362 96.54 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
MRCUI.RRF
MRREL.RRF
0
2
2
2 - 3
2 - 3
0.00
2.00
2.00
2.06
2.56
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 - 12
0 - 54
0 - 13
0.00
0.00
14.01
2.59
6.23
8.26
varchar(100)
varchar(100)
varchar(100)
varchar(100)
varchar(100)
varchar(100)
RG Relationship group MRREL.RRF 0 - 3 0.08 varchar(10)
RMETA Version of the Metathesaurus where a version is removed MRSAB.RRF 0 - 6 0.20 varchar(10)
RSAB Root source abbreviation MRSAB.RRF 2 - 15 5.80 varchar(40)
RUI Unique identifier for relationship MRREL.RRF 9 - 10 9.53 varchar(10)
RWS Number of rows MRFILES.RRF 1 - 8 5.43 integer
SAB Source abbreviation MRHIST.RRF
MRDEF.RRF
MRRANK.RRF
MRREL.RRF
MRCONSO.RRF
MRSAT.RRF
MRHIER.RRF
0
2 - 13
2 - 15
2 - 15
2 - 15
2 - 13
2 - 11
0.00
3.85
5.28
5.51
5.63
6.34
7.44
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 - 15
0 - 36
0.10
4.17
varchar(50)
varchar(50)
SAUI Source asserted atom identifier MRCONSO.RRF 0 - 18 2.37 varchar(50)
SCC Content contact info for a source MRSAB.RRF 0 - 343 130.40 varchar(1000)
SCIT Source citation MRSAB.RRF 33 - 445 140.68 varchar(4000)
SCUI Source asserted concept identifier MRCONSO.RRF 0 - 50 5.35 varchar(50)
SDUI Source asserted descriptor identifier MRCONSO.RRF 0 - 13 2.08 varchar(50)
SF Source Family MRSAB.RRF 2 - 13 4.13 varchar(40)
SL Source of relationship labels MRREL.RRF 2 - 15 5.51 varchar(40)
SLC License contact info for a source MRSAB.RRF 0 - 360 158.42 varchar(1000)
SON Source Official Name MRSAB.RRF 10 - 145 48.33 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 1.59 varchar(50)
SSN Source short name MRSAB.RRF 3 - 89 21.42 varchar(3000)
STN Semantic type tree number MRSTY.RRF 1 - 14 7.66 varchar(100)
STR String MRCONSO.RRF 1 - 2916 36.95 varchar(3000)
STT String type MRCONSO.RRF 2 - 3 2.01 varchar(3)
STY Semantic type MRSTY.RRF 4 - 41 16.56 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.22 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.71 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.71 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
MRXW_RUS.RRF
MRXW_POR.RRF
MRXW_SPA.RRF
AMBIGSUI.RRF
MRXW_SWE.RRF
MRXW_ITA.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.04
8.00
8.00
8.00
8.00
8.03
8.11
8.13
8.14
8.14
8.17
8.17
8.20
8.24
8.30
8.34
8.48
8.50
8.50
8.81
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 MRHIST.RRF
MRSAB.RRF
0
0 - 19
0.00
5.38
varchar(20)
varchar(20)
TFR Term frequency for a source MRSAB.RRF 1 - 7 4.10 integer
TOEXPR The expression that a mapping is mapped to MRMAP.RRF
MRSMAP.RRF
0 - 242
0 - 242
6.09
7.06
varchar(4000)
varchar(4000)
TOID Metathesaurus identifier for the entity being mapped to MRMAP.RRF 0 - 15 5.44 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
0 - 23
4.13
4.66
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.33
2.65
varchar(20)
varchar(20)
TTYL Term type list for a source MRSAB.RRF 0 - 129 14.93 varchar(400)
TUI Unique identifier of Semantic type MRSTY.RRF 4 4.00 char(4)
TYPE Type of information MRDOC.RRF 3 - 21 12.82 varchar(50)
VALUE Value MRDOC.RRF 0 - 62 14.11 varchar(200)
VCUI Unique identifier for versioned SRC concept MRSAB.RRF 0 - 8 7.61 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.89 varchar(40)
VSTART Valid start date for a source MRSAB.RRF 0 0.00 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 - 44
1 - 93
1 - 38
10.53
2.95
6.09
6.12
6.38
6.59
6.65
6.78
7.00
7.17
7.28
7.35
7.70
8.05
8.16
8.31
8.52
8.62
9.11
9.57
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.20 varchar(100)
ATNL Attribute name list for a source MRSAB 0 - 764 45.40 varchar(4000)
ATV Attribute value MRSAT 1 - 15047 10.44 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 1 - 10 7.14 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.96 integer
CLS Number of columns MRFILES 1 - 2 1.02 integer
CODE Unique Identifier or code for string in source MRSAT
MRSO
0 - 50
1 - 63
6.04
7.29
varchar(50)
varchar(50)
COL Column or data element name MRCOLS 2 - 6 3.12 varchar(10)
CREL Relationship to retired CUI (CUI1) to current CUI (CUI2) MRCUI 2 - 3 2.06 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 MRCUI
MRREL
8
8
8.00
8.00
char(8)
char(8)
CUI2 Unique identifier of second concept MRCUI
MRREL
0 - 8
8
7.52
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 - 31 5.78 varchar(50)
DEF Definition MRDEF 3 - 10258 220.45 varchar(16000)
DES Descriptive Name MRCOLS
MRFILES
5 - 56
7 - 42
25.83
18.12
varchar(100)
varchar(100)
DOCKEY Key to be documented MRDOC 2 - 8 3.56 varchar(50)
DTY SQL-92 data type for this column MRCOLS 7 - 14 9.68 varchar(20)
EXPL Detailed explanation MRDOC 0 - 941 27.41 varchar(1000)
FIL Physical FILENAME MRCOLS
MRFILES
4 - 18
4 - 18
7.41
8.37
varchar(50)
varchar(50)
FMT Comma separated list of COL MRFILES 7 - 112 19.98 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.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
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.FIN
MRXW.HEB
MRXW.SWE
MRXW.LAV
MRXW.KOR
MRXW.DUT
MRXW.GER
MRXW.SPA
MRXW.POR
MRXW.RUS
AMBIG.LUI
MRXW.ITA
MRXW.JPN
MRXW.FRE
MRXW.POL
MRXW.SCR
MRXW.CZE
MRSO
MRCON
MRXW.ENG
MRXNS.ENG
MRXNW.ENG
MRXW.NOR
MRXW.HUN
0
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
0.00
6.33
8.00
8.00
8.00
8.00
8.00
8.00
8.01
8.02
8.04
8.05
8.06
8.07
8.08
8.09
8.09
8.10
8.10
8.10
8.11
8.14
8.16
8.20
8.21
8.21
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.94 char(1)
MAX Maximum Length MRCOLS 1 - 5 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 0.00 char(8)
NSTR Normalized string MRXNS.ENG 1 - 2528 38.74 varchar(3000)
NWD Normalized word MRXNW.ENG 1 - 80 6.37 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.37
varchar(10)
varchar(10)
PSTR Preferred name in the previous Metathesaurus CHANGE/DELETED.CUI
CHANGE/DELETED.LUI
CHANGE/DELETED.SUI
2 - 566
2 - 525
2 - 525
41.34
47.07
49.19
varchar(3000)
varchar(3000)
varchar(3000)
PSUI String unique identifier in the previous Metathesaurus CHANGE/DELETED.SUI 8 - 9 8.75 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 5.17 varchar(100)
RMETA Version of the Metathesaurus where a version is removed MRSAB 0 - 6 0.20 varchar(10)
RSAB Root source abbreviation MRSAB 2 - 15 5.80 varchar(40)
RWS Number of rows MRFILES 1 - 8 5.47 integer
SAB Source abbreviation MRDEF
MRRANK
MRREL
MRSAT
MRSO
MRATX
2 - 13
2 - 15
2 - 15
2 - 13
2 - 15
3
3.84
5.28
5.30
5.37
5.63
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 - 343 130.40 varchar(1000)
SF Source Family MRSAB 2 - 13 4.13 varchar(40)
SL Source of relationship labels MRREL 2 - 15 5.30 varchar(40)
SLC License contact info for a source MRSAB 0 - 360 158.42 varchar(1000)
SON Source Official Name MRSAB 10 - 145 48.33 varchar(3000)
SRL Source Restriction Level MRSAB
MRSO
1
1
1.00
1.00
integer
integer
STR String MRCON 1 - 2916 38.52 varchar(3000)
STT String type MRCON 2 - 3 2.01 varchar(3)
STY Semantic type MRSTY 4 - 41 16.56 varchar(50)
SUI Unique identifier for string MRSAT
MRXW.BAQ
MRXW.DAN
MRXW.FIN
MRXW.HEB
MRXW.DUT
MRXW.GER
MRXW.RUS
MRXW.POR
MRXW.SPA
AMBIG.SUI
MRXW.SWE
MRXW.ITA
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.46
8.00
8.00
8.00
8.00
8.03
8.11
8.13
8.14
8.14
8.17
8.17
8.20
8.24
8.30
8.34
8.37
8.48
8.50
8.50
8.81
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.38 varchar(20)
TFR Term frequency for a source MRSAB 1 - 7 4.10 integer
TS Term status MRCON 1 1.00 char(1)
TTY Term type in source MRSO
MRRANK
2 - 11
2 - 11
2.33
2.65
varchar(20)
varchar(20)
TTYL Term type list for a source MRSAB 0 - 129 14.93 varchar(400)
TUI Unique identifier of Semantic type MRSTY 4 4.00 char(4)
TYPE Type of information MRDOC 3 - 21 12.82 varchar(50)
VALUE Value MRDOC 0 - 62 14.22 varchar(200)
VCUI Unique identifier for versioned SRC concept MRSAB 0 - 8 7.61 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.89 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 - 44
1 - 93
1 - 38
10.53
2.95
6.09
6.12
6.38
6.59
6.65
6.78
7.00
7.17
7.28
7.35
7.70
8.05
8.16
8.31
8.52
8.62
9.11
9.57
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)