Skip Navigation Bar

Unified Medical Language System® (UMLS®)

Columns and Data Elements - 2016AB Release

All data elements in the Metathesaurus are described in this section. The data elements have been divided into Column Descriptions and Attribute Descriptions. The descriptions are arranged alphabetically by data element abbreviation.

Columns are described for Rich Release Format (RRF) in Table 1, and for Original Release Format (ORF) in Table 2.


Table 1. Columns and Data Elements in Rich Release Format (RRF)

Abbreviation Description File Length of Value in characters Average Length of Value in characters SQL92 Datatype
ATNAttribute nameMRSAT.RRF2 - 6210.05varchar(100)
ATNLAttribute name list for a source.MRSAB.RRF0 - 107051.85varchar(4000)
ATUIUnique identifier for attributeMRSTY.RRF
MRDEF.RRF
MRSAT.RRF
10 - 11
10 - 11
10 - 11
10.60
10.78
10.80
varchar(11)
varchar(11)
varchar(11)
ATVAttribute valueMRSAT.RRF1 - 6219214.65varchar(65000)
AUIUnique identifier for atomMRHIER.RRF
MRDEF.RRF
MRCONSO.RRF
8 - 9
8 - 9
8 - 9
8.37
8.70
8.71
varchar(9)
varchar(9)
varchar(9)
AUI1Unique identifier for first atomMRREL.RRF
MRAUI.RRF
0 - 9
8 - 9
8.47
8.48
varchar(9)
varchar(9)
AUI2Unique identifier for second atomMRREL.RRF
MRAUI.RRF
0 - 9
8 - 9
8.47
8.48
varchar(9)
varchar(9)
AVAverage Length, CharactersMRCOLS.RRF4 - 64.12numeric(5,2)
BTSSize in BytesMRFILES.RRF1 - 107.26integer
CENCCharacter encoding of a source as specified by IANAMRSAB.RRF55.00varchar(20)
CFRCUI frequency for a sourceMRSAB.RRF1 - 73.96integer
CHANGEKEYCONCEPTSTATUS (if history relates to a SNOMED CT concept) or DESCRIPTIONSTATUS (if history relates to a SNOMED CT atom or "description")MRHIST.RRF00.00varchar(1000)
CHANGETYPESource asserted code for type of changeMRHIST.RRF00.00varchar(1000)
CHANGEVALSNOMED CT CONCEPTSTATUS or DESCRIPTIONSTATUS value after the change took placeMRHIST.RRF00.00varchar(1000)
CLSNumber of columnsMRFILES.RRF1 - 21.12integer
CODEUnique Identifier or code for string in sourceMRSAT.RRF
MRCONSO.RRF
0 - 50
1 - 75
4.66
7.32
varchar(100)
varchar(100)
COLColumn or data element nameMRCOLS.RRF2 - 113.74varchar(20)
CUIUnique identifier for conceptMRHIST.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_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_NOR.RRF
MRXW_POL.RRF
MRXW_POR.RRF
MRXW_RUS.RRF
MRXW_SCR.RRF
MRXW_SPA.RRF
MRXW_SWE.RRF
MRXW_TUR.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
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
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)
CUI1Unique identifier for first conceptMRAUI.RRF
MRCUI.RRF
MRREL.RRF
8
8
8
8.00
8.00
8.00
char(8)
char(8)
char(8)
CUI2Unique identifier for second conceptMRCUI.RRF
MRAUI.RRF
MRREL.RRF
0 - 8
8
8
7.59
8.00
8.00
char(8)
char(8)
char(8)
CURVERCurrent Version flagMRSAB.RRF11.00char(1)
CVFContent view flagMRHIST.RRF
MRMAP.RRF
MRSMAP.RRF
MRDEF.RRF
MRHIER.RRF
MRSAT.RRF
MRREL.RRF
MRCONSO.RRF
MRSTY.RRF
0
0
0
0 - 4
0 - 4
0 - 4
0 - 4
0 - 5
0 - 5
0.00
0.00
0.00
0.00
0.11
0.18
0.20
1.05
1.78
varchar(50)
varchar(50)
varchar(50)
varchar(50)
varchar(50)
varchar(50)
varchar(50)
varchar(50)
varchar(50)
CXNThe context number if the atom has multiple contextsMRHIER.RRF1 - 52.00integer
CXTYContext type for a sourceMRSAB.RRF0 - 315.06varchar(50)
DEFDefinitionMRDEF.RRF3 - 10258212.11varchar(16000)
DESDescriptive NameMRCOLS.RRF
MRFILES.RRF
5 - 136
8 - 42
28.95
18.24
varchar(200)
varchar(200)
DIRSource asserted directionality flagMRREL.RRF0 - 10.15varchar(1)
DOCKEYKey to be documentedMRDOC.RRF2 - 83.60varchar(50)
DTYSQL-92 data type for this columnMRCOLS.RRF7 - 1410.02varchar(20)
EXPLDetailed explanationMRDOC.RRF0 - 94126.88varchar(1000)
FILPhysical FILENAMEMRCOLS.RRF
MRFILES.RRF
9 - 21
9 - 21
10.96
12.12
varchar(50)
varchar(50)
FMTComma separated list of COLMRFILES.RRF7 - 19030.16varchar(300)
FROMEXPRThe expression that a mapping is mapped fromMRSMAP.RRF
MRMAP.RRF
1 - 8
1 - 17
6.85
7.43
varchar(4000)
varchar(4000)
FROMIDMetathesaurus identifier for the entity being mapped fromMRMAP.RRF1 - 176.81varchar(50)
FROMRESRestriction applicable to the entity being mapped fromMRMAP.RRF00.00varchar(4000)
FROMRULEMachine processible rule applicable to the entity being mapped fromMRMAP.RRF00.00varchar(4000)
FROMSIDSource asserted identifier for the entity being mapped fromMRMAP.RRF00.00varchar(50)
FROMTYPEThe type of expression that a mapping is mapped fromMRSMAP.RRF
MRMAP.RRF
3 - 4
3 - 4
3.98
3.99
varchar(50)
varchar(50)
HCDSource asserted hierarchical number or code of context member (if it exists)MRHIER.RRF0 - 470.62varchar(50)
IMETAVersion of the Metathesaurus that a source was addedMRSAB.RRF66.00varchar(10)
ISPREFIndicates whether AUI is preferredMRCONSO.RRF11.00char(1)
LATLanguage of Term(s)MRSAB.RRF
CHANGE/DELETEDSUI.RRF
MRCONSO.RRF
MRXNS_ENG.RRF
MRXNW_ENG.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_NOR.RRF
MRXW_POL.RRF
MRXW_POR.RRF
MRXW_RUS.RRF
MRXW_SCR.RRF
MRXW_SPA.RRF
MRXW_SWE.RRF
MRXW_TUR.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
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
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)
LUIUnique identifier for termCHANGE/MERGEDLUI.RRF
MRSAT.RRF
MRXW_BAQ.RRF
MRXW_DAN.RRF
MRXW_FIN.RRF
MRXW_HEB.RRF
MRXW_SWE.RRF
MRXW_LAV.RRF
MRXW_POL.RRF
MRXW_SCR.RRF
MRXW_JPN.RRF
AMBIGLUI.RRF
MRXW_CZE.RRF
MRXW_GER.RRF
MRCONSO.RRF
MRXW_SPA.RRF
MRXW_ENG.RRF
MRXNW_ENG.RRF
MRXNS_ENG.RRF
MRXW_DUT.RRF
MRXW_ITA.RRF
MRXW_RUS.RRF
MRXW_POR.RRF
MRXW_FRE.RRF
MRXW_KOR.RRF
MRXW_NOR.RRF
MRXW_HUN.RRF
MRXW_CHI.RRF
MRXW_EST.RRF
MRXW_GRE.RRF
MRXW_TUR.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
9
9
9
9
0.00
4.71
8.00
8.00
8.00
8.00
8.00
8.00
8.10
8.12
8.14
8.16
8.18
8.25
8.27
8.27
8.29
8.30
8.31
8.44
8.61
8.68
8.74
8.75
8.82
8.98
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)
varchar(10)
varchar(10)
varchar(10)
varchar(10)
MAPATNMapping attribute name (for future use)MRMAP.RRF0 - 61.78varchar(20)
MAPATVMapping attribute value (for future use)MRMAP.RRF0 - 10.00varchar(4000)
MAPIDMetathesaurus asserted identifier for mappingMRSMAP.RRF
MRMAP.RRF
10 - 11
10 - 11
10.98
10.99
varchar(50)
varchar(50)
MAPINMapping in current subsetMRCUI.RRF
MRAUI.RRF
0 - 1
1
0.95
1.00
char(1)
char(1)
MAPRANKOrder in which mappings in a subset should be appliedMRMAP.RRF0 - 20.31integer
MAPREASONReason for mappingMRCUI.RRF
MRAUI.RRF
0 - 4
4
0.00
4.00
varchar(4000)
varchar(4000)
MAPRESRestriction applicable to this mappingMRMAP.RRF0 - 45220.53varchar(4000)
MAPRULEMachine processible rule applicable to this mappingMRMAP.RRF0 - 2985.50varchar(4000)
MAPSETCUICUI of the map setMRMAP.RRF
MRSMAP.RRF
8
8
8.00
8.00
char(8)
char(8)
MAPSETSABSAB of the map setMRSMAP.RRF
MRMAP.RRF
3 - 13
3 - 13
5.88
7.91
varchar(40)
varchar(40)
MAPSIDSource asserted identifier for mappingMRSMAP.RRF
MRMAP.RRF
0
0 - 36
0.00
0.01
varchar(50)
varchar(50)
MAPSUBSETIDMap subset identifier used to identify a subset of related mappings within a map setMRMAP.RRF0 - 31.20varchar(10)
MAPTYPEType of mappingMRMAP.RRF0 - 92.70varchar(50)
MAXMaximum LengthMRCOLS.RRF1 - 51.40integer
METAUIMetathesaurus asserted unique identifierMRSAT.RRF0 - 107.58varchar(50)
MINMinimum LengthMRCOLS.RRF1 - 21.02integer
NSTRNormalized stringMRXNS_ENG.RRF1 - 252837.86varchar(3000)
NWDNormalized wordMRXNW_ENG.RRF1 - 806.43varchar(100)
PAUIUnique identifier for parent atomMRHIER.RRF0 - 98.29varchar(9)
PCUIConcept unique identifier in the previous MetathesaurusCHANGE/DELETEDCUI.RRF
CHANGE/MERGEDCUI.RRF
8
8
8.00
8.00
char(8)
char(8)
PLUILexical unique identifier in the previous MetathesaurusCHANGE/MERGEDLUI.RRF
CHANGE/DELETEDLUI.RRF
0
8 - 9
0.00
8.77
varchar(10)
varchar(10)
PSTRPreferred name in the previous MetathesaurusCHANGE/DELETEDSUI.RRF
CHANGE/DELETEDLUI.RRF
CHANGE/DELETEDCUI.RRF
2 - 1471
3 - 1471
5 - 1471
59.46
60.87
44.58
varchar(3000)
varchar(3000)
varchar(3000)
PSUIString unique identifier in the previous MetathesaurusCHANGE/DELETEDSUI.RRF8 - 98.83varchar(10)
PTRPath to rootMRHIER.RRF0 - 34798.41varchar(1000)
RANKTermgroup rankingMRRANK.RRF44.00integer
RCUIUnique identifier for root SRC conceptMRSAB.RRF88.00char(8)
REASONExplanation of change, if presentMRHIST.RRF00.00varchar(1000)
REFDocumentation Section NumberMRCOLS.RRF00.00varchar(20)
RELRelationship labelMRAUI.RRF
MRMAP.RRF
MRSMAP.RRF
MRCUI.RRF
MRREL.RRF
0
2
2
2 - 3
2 - 3
0.00
2.00
2.00
2.05
2.56
varchar(4)
varchar(4)
varchar(4)
varchar(4)
varchar(4)
RELAAdditional relationship labelMRAUI.RRF
MRCUI.RRF
MRSMAP.RRF
MRMAP.RRF
MRHIER.RRF
MRREL.RRF
0
0
0 - 13
0 - 23
0 - 12
0 - 54
0.00
0.00
11.61
13.68
2.59
6.31
varchar(100)
varchar(100)
varchar(100)
varchar(100)
varchar(100)
varchar(100)
RGRelationship groupMRREL.RRF0 - 30.15varchar(10)
RMETAVersion of the Metathesaurus where a version is removedMRSAB.RRF0 - 60.25varchar(10)
RSABRoot source abbreviationMRSAB.RRF2 - 156.17varchar(40)
RUIUnique identifier for relationshipMRREL.RRF9 - 109.61varchar(10)
RWSNumber of rowsMRFILES.RRF1 - 85.58integer
SABSource abbreviationMRHIST.RRF
MRDEF.RRF
MRREL.RRF
MRRANK.RRF
MRCONSO.RRF
MRSAT.RRF
MRHIER.RRF
0
2 - 13
2 - 15
2 - 15
2 - 15
2 - 13
2 - 11
0.00
3.98
5.50
5.53
5.79
6.19
7.50
varchar(40)
varchar(40)
varchar(40)
varchar(40)
varchar(40)
varchar(40)
varchar(40)
SABINSource in current subsetMRSAB.RRF11.00char(1)
SATUISource asserted attribute identifierMRDEF.RRF
MRSAT.RRF
0 - 15
0 - 36
0.15
4.35
varchar(50)
varchar(50)
SAUISource asserted atom identifierMRCONSO.RRF0 - 182.06varchar(50)
SCCContent contact info for a sourceMRSAB.RRF0 - 332152.22varchar(1000)
SCITSource citationMRSAB.RRF42 - 676159.83varchar(4000)
SCUISource asserted concept identifierMRCONSO.RRF0 - 505.52varchar(50)
SDUISource asserted descriptor identifierMRCONSO.RRF0 - 132.00varchar(50)
SFSource FamilyMRSAB.RRF2 - 134.09varchar(40)
SLSource of relationship labelsMRREL.RRF2 - 155.50varchar(40)
SLCLicense contact info for a sourceMRSAB.RRF0 - 362175.93varchar(1000)
SONSource Official NameMRSAB.RRF10 - 14547.33varchar(3000)
SOURCEUISource asserted unique identifierMRHIST.RRF00.00varchar(50)
SRLSource Restriction LevelMRCONSO.RRF
MRSAB.RRF
1
1
1.00
1.00
integer
integer
SRUISource attributed relationship identifierMRREL.RRF0 - 361.52varchar(50)
SSNSource short nameMRSAB.RRF3 - 8923.71varchar(3000)
STNSemantic type tree numberMRSTY.RRF1 - 147.57varchar(100)
STRStringMRCONSO.RRF1 - 291637.57varchar(3000)
STTString typeMRCONSO.RRF2 - 32.01varchar(3)
STYSemantic typeMRSTY.RRF4 - 3916.20varchar(50)
STYPEThe name of the column in MRCONSO.RRF or MRREL.RRF that contains the identifier to which the attribute is attachedMRSAT.RRF3 - 43.24varchar(50)
STYPE1The name of the column in MRCONSO.RRF that contains the first identifier to which the relationship is attachedMRREL.RRF3 - 43.72varchar(50)
STYPE2The name of the column in MRCONSO.RRF that contains the second identifier to which the relationship is attachedMRREL.RRF3 - 43.72varchar(50)
SUIUnique identifier for stringMRSAT.RRF
MRXW_BAQ.RRF
MRXW_DAN.RRF
MRXW_FIN.RRF
MRXW_HEB.RRF
MRXW_SWE.RRF
AMBIGSUI.RRF
MRXW_GER.RRF
MRXW_JPN.RRF
MRXW_SPA.RRF
MRCONSO.RRF
MRXW_DUT.RRF
MRXNS_ENG.RRF
MRXNW_ENG.RRF
MRXW_ENG.RRF
MRXW_ITA.RRF
MRXW_RUS.RRF
MRXW_POR.RRF
MRXW_FRE.RRF
MRXW_CZE.RRF
MRXW_NOR.RRF
MRXW_HUN.RRF
MRXW_CHI.RRF
MRXW_EST.RRF
MRXW_GRE.RRF
MRXW_KOR.RRF
MRXW_LAV.RRF
MRXW_POL.RRF
MRXW_SCR.RRF
MRXW_TUR.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
9
9
9
9
4.79
8.00
8.00
8.00
8.00
8.17
8.26
8.30
8.30
8.34
8.44
8.45
8.55
8.57
8.57
8.66
8.70
8.76
8.80
8.83
8.98
8.99
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)
SUPPRESSSuppressible flagMRCONSO.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)
SVERRelease date or version number of a sourceMRHIST.RRF
MRSAB.RRF
0
0 - 17
0.00
5.15
varchar(20)
varchar(20)
TFRTerm frequency for a sourceMRSAB.RRF1 - 74.15integer
TOEXPRThe expression that a mapping is mapped toMRMAP.RRF
MRSMAP.RRF
0 - 242
1 - 242
5.18
4.82
varchar(4000)
varchar(4000)
TOIDMetathesaurus identifier for the entity being mapped toMRMAP.RRF0 - 175.41varchar(50)
TORESRestriction applicable to the entity being mapped toMRMAP.RRF00.00varchar(4000)
TORULEMachine processible rule applicable to the entity being mapped toMRMAP.RRF00.00varchar(4000)
TOSIDSource asserted identifier for the entity being mapped toMRMAP.RRF00.00varchar(50)
TOTYPEThe type of expression that a mapping is mapped toMRMAP.RRF
MRSMAP.RRF
0 - 23
4 - 23
4.03
4.41
varchar(50)
varchar(50)
TSTerm statusMRCONSO.RRF11.00char(1)
TTYTerm type in sourceMRCONSO.RRF
MRRANK.RRF
2 - 11
2 - 11
2.37
2.64
varchar(20)
varchar(20)
TTYLTerm type list for a sourceMRSAB.RRF0 - 12913.76varchar(400)
TUIUnique identifier of Semantic typeMRSTY.RRF44.00char(4)
TYPEType of informationMRDOC.RRF3 - 2112.81varchar(50)
VALUEValueMRDOC.RRF0 - 6214.37varchar(200)
VCUIUnique identifier for versioned SRC conceptMRSAB.RRF0 - 87.55char(8)
VENDValid end date for a sourceMRSAB.RRF00.00char(8)
VERLast release version in which CUI1 was validMRAUI.RRF
MRCUI.RRF
6
6
6.00
6.00
varchar(10)
varchar(10)
VSABVersioned source abbreviationMRSAB.RRF3 - 2312.06varchar(40)
VSTARTValid start date for a sourceMRSAB.RRF00.00char(8)
WDWord in lower-caseMRXW_FIN.RRF
MRXW_KOR.RRF
MRXW_CHI.RRF
MRXW_EST.RRF
MRXW_TUR.RRF
MRXW_POR.RRF
MRXW_ITA.RRF
MRXW_HEB.RRF
MRXW_ENG.RRF
MRXW_DAN.RRF
MRXW_SPA.RRF
MRXW_RUS.RRF
MRXW_FRE.RRF
MRXW_GRE.RRF
MRXW_BAQ.RRF
MRXW_LAV.RRF
MRXW_CZE.RRF
MRXW_HUN.RRF
MRXW_DUT.RRF
MRXW_GER.RRF
MRXW_SCR.RRF
MRXW_POL.RRF
MRXW_JPN.RRF
MRXW_NOR.RRF
MRXW_SWE.RRF
1 - 54
1 - 38
1 - 88
1 - 35
1 - 37
1 - 38
1 - 38
1 - 19
1 - 80
1 - 25
1 - 46
1 - 40
1 - 39
1 - 21
1 - 18
1 - 23
1 - 52
1 - 28
1 - 51
1 - 45
1 - 37
1 - 48
1 - 93
1 - 44
1 - 38
10.53
3.28
3.71
4.58
5.23
5.46
5.94
6.12
6.12
6.38
6.60
6.72
6.82
6.83
7.17
7.28
7.38
7.72
7.83
7.96
8.03
8.16
8.83
9.17
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)
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
ATNAttribute nameMRSAT2 - 627.00varchar(100)
ATNLAttribute name list for a sourceMRSAB0 - 99642.81varchar(4000)
ATVAttribute valueMRSAT1 - 6219211.39varchar(65000)
ATXAssociated expressionMRATX5 - 24235.68varchar(300)
AVAverage Length, CharactersMRCOLS4 - 64.10numeric(5,2)
BTSSize in BytesMRFILES1 - 107.26integer
CENCCharacter encoding of a source as specified by IANAMRSAB55.00varchar(20)
CFRCUI frequency for a sourceMRSAB1 - 73.96integer
CLSNumber of columnsMRFILES1 - 21.02integer
CODEUnique Identifier or code for string in sourceMRSAT
MRSO
0 - 50
1 - 75
5.91
7.32
varchar(50)
varchar(50)
COLColumn or data element nameMRCOLS2 - 63.09varchar(10)
CRELRelationship to retired CUI (CUI1) to current CUI (CUI2)MRCUI2 - 32.05varchar(4)
CUIUnique identifier for conceptAMBIG.LUI
AMBIG.SUI
CHANGE/MERGED.CUI
MRATX
MRCON
MRDEF
MRSAT
MRSO
MRSTY
MRXNS.ENG
MRXNW.ENG
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.NOR
MRXW.POL
MRXW.POR
MRXW.RUS
MRXW.SCR
MRXW.SPA
MRXW.SWE
MRXW.TUR
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
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)
CUI1Unique identifier of first conceptMRCUI
MRREL
8
8
8.00
8.00
char(8)
char(8)
CUI2Unique identifier of second conceptMRCUI
MRREL
0 - 8
8
7.59
8.00
char(8)
char(8)
CURVERCurrent Version flagMRSAB11.00char(1)
CXTYContext type for a source (as per section 2.3.2)MRSAB0 - 315.06varchar(50)
DEFDefinitionMRDEF3 - 10258213.20varchar(16000)
DESDescriptive NameMRCOLS
MRFILES
5 - 56
7 - 42
25.67
18.09
varchar(100)
varchar(100)
DOCKEYKey to be documentedMRDOC2 - 83.59varchar(50)
DTYSQL-92 data type for this columnMRCOLS7 - 149.68varchar(20)
EXPLDetailed explanationMRDOC0 - 94126.52varchar(1000)
FILPhysical FILENAMEMRCOLS
MRFILES
4 - 18
4 - 18
7.46
8.34
varchar(50)
varchar(50)
FMTComma separated list of COLMRFILES7 - 11219.81varchar(150)
IMETAVersion of the Metathesaurus that a source was addedMRSAB66.00varchar(10)
LATLanguage of Term(s)MRSAB
CHANGE/DELETED.SUI
MRCON
MRXNS.ENG
MRXNW.ENG
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.NOR
MRXW.POL
MRXW.POR
MRXW.RUS
MRXW.SCR
MRXW.SPA
MRXW.SWE
MRXW.TUR
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
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
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)
LRLLeast Restriction LevelMRCON11.00integer
LUIUnique identifier for termCHANGE/MERGED.LUI
MRSAT
MRXW.BAQ
MRXW.DAN
MRXW.FIN
MRXW.HEB
MRXW.SWE
MRXW.LAV
MRXW.POL
MRXW.SCR
MRXW.JPN
AMBIG.LUI
MRXW.CZE
MRXW.GER
MRSO
MRXW.SPA
MRCON
MRXW.ENG
MRXNW.ENG
MRXNS.ENG
MRXW.DUT
MRXW.ITA
MRXW.RUS
MRXW.POR
MRXW.FRE
MRXW.KOR
MRXW.NOR
MRXW.HUN
MRXW.CHI
MRXW.EST
MRXW.GRE
MRXW.TUR
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
9
9
9
9
0.00
6.14
8.00
8.00
8.00
8.00
8.00
8.00
8.10
8.12
8.14
8.16
8.18
8.25
8.27
8.27
8.29
8.29
8.30
8.31
8.44
8.61
8.68
8.74
8.75
8.82
8.98
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)
varchar(10)
varchar(10)
varchar(10)
varchar(10)
varchar(10)
MAPINMapping in current subsetMRCUI0 - 10.95char(1)
MAXMaximum LengthMRCOLS1 - 51.38integer
MENDMetathesaurus end date for a sourceMRSAB00.00char(8)
MGMachine generated and unverified indicatorMRREL00.00varchar(1)
MINMinimum LengthMRCOLS1 - 21.00integer
MSTARTMetathesaurus start date for a sourceMRSAB00.00char(8)
NSTRNormalized stringMRXNS.ENG1 - 252837.86varchar(3000)
NWDNormalized wordMRXNW.ENG1 - 806.43varchar(100)
PCUIConcept unique identifier in the previous MetathesaurusCHANGE/DELETED.CUI
CHANGE/MERGED.CUI
8
8
8.00
8.00
char(8)
char(8)
PLUILexical unique identifier in the previous MetathesaurusCHANGE/MERGED.LUI
CHANGE/DELETED.LUI
0
8 - 9
0.00
8.77
varchar(10)
varchar(10)
PSTRPreferred name in the previous MetathesaurusCHANGE/DELETED.SUI
CHANGE/DELETED.LUI
CHANGE/DELETED.CUI
2 - 1471
3 - 1471
5 - 1471
59.46
60.87
44.58
varchar(3000)
varchar(3000)
varchar(3000)
PSUIString unique identifier in the previous MetathesaurusCHANGE/DELETED.SUI8 - 98.83varchar(10)
RANKTermgroup rankingMRRANK44.00integer
RCUIUnique identifier for root SRC conceptMRSAB88.00char(8)
REFDocumentation Section NumberMRCOLS00.00varchar(20)
RELRelationship labelMRATX
MRREL
2
2 - 3
2.00
2.64
varchar(3)
varchar(3)
RELAAdditional relationship labelMRREL0 - 545.19varchar(100)
RMETAVersion of the Metathesaurus where a version is removedMRSAB0 - 60.25varchar(10)
RSABRoot source abbreviationMRSAB2 - 156.17varchar(40)
RWSNumber of rowsMRFILES1 - 85.62integer
SABSource abbreviationMRDEF
MRSAT
MRREL
MRRANK
MRSO
MRATX
2 - 13
2 - 13
2 - 15
2 - 15
2 - 15
3
3.98
5.09
5.30
5.53
5.79
3.00
varchar(40)
varchar(40)
varchar(40)
varchar(40)
varchar(40)
varchar(40)
SABINSource in current subsetMRSAB11.00char(1)
SCCContent contact info for a sourceMRSAB0 - 332152.22varchar(1000)
SFSource FamilyMRSAB2 - 134.09varchar(40)
SLSource of relationship labelsMRREL2 - 155.30varchar(40)
SLCLicense contact info for a sourceMRSAB0 - 362175.93varchar(1000)
SONSource Official NameMRSAB10 - 14547.33varchar(3000)
SRLSource Restriction LevelMRSAB
MRSO
1
1
1.00
1.00
integer
integer
STRStringMRCON1 - 291639.06varchar(3000)
STTString typeMRCON2 - 32.01varchar(3)
STYSemantic typeMRSTY4 - 3916.20varchar(50)
SUIUnique identifier for stringMRSAT
MRXW.BAQ
MRXW.DAN
MRXW.FIN
MRXW.HEB
MRXW.SWE
AMBIG.SUI
MRXW.GER
MRXW.JPN
MRXW.SPA
MRSO
MRXW.DUT
MRCON
MRXNS.ENG
MRXNW.ENG
MRXW.ENG
MRXW.ITA
MRXW.RUS
MRXW.POR
MRXW.FRE
MRXW.CZE
MRXW.NOR
MRXW.HUN
MRXW.CHI
MRXW.EST
MRXW.GRE
MRXW.KOR
MRXW.LAV
MRXW.POL
MRXW.SCR
MRXW.TUR
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
9
9
9
9
6.26
8.00
8.00
8.00
8.00
8.17
8.26
8.30
8.30
8.34
8.44
8.45
8.48
8.55
8.57
8.57
8.66
8.70
8.76
8.80
8.83
8.98
8.99
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)
SUPRESSuppressible flagMRRANK11.00char(1)
SVERRelease date or version number of a sourceMRSAB0 - 175.15varchar(20)
TFRTerm frequency for a sourceMRSAB1 - 74.15integer
TSTerm statusMRCON11.00char(1)
TTYTerm type in sourceMRSO
MRRANK
2 - 11
2 - 11
2.37
2.64
varchar(20)
varchar(20)
TTYLTerm type list for a sourceMRSAB0 - 12913.76varchar(400)
TUIUnique identifier of Semantic typeMRSTY44.00char(4)
TYPEType of informationMRDOC3 - 2112.80varchar(50)
VALUEValueMRDOC0 - 6214.48varchar(200)
VCUIUnique identifier for versioned SRC conceptMRSAB0 - 87.55char(8)
VERLast release version in which CUI1 was validMRCUI66.00varchar(10)
VSABVersioned source abbreviationMRSAB3 - 2312.06varchar(40)
WDWord in lower-caseMRXW.FIN
MRXW.KOR
MRXW.CHI
MRXW.EST
MRXW.TUR
MRXW.POR
MRXW.ITA
MRXW.HEB
MRXW.ENG
MRXW.DAN
MRXW.SPA
MRXW.RUS
MRXW.FRE
MRXW.GRE
MRXW.BAQ
MRXW.LAV
MRXW.CZE
MRXW.HUN
MRXW.DUT
MRXW.GER
MRXW.SCR
MRXW.POL
MRXW.JPN
MRXW.NOR
MRXW.SWE
1 - 54
1 - 38
1 - 88
1 - 35
1 - 37
1 - 38
1 - 38
1 - 19
1 - 80
1 - 25
1 - 46
1 - 40
1 - 39
1 - 21
1 - 18
1 - 23
1 - 52
1 - 28
1 - 51
1 - 45
1 - 37
1 - 48
1 - 93
1 - 44
1 - 38
10.53
3.28
3.71
4.58
5.23
5.46
5.94
6.12
6.12
6.38
6.60
6.72
6.82
6.83
7.17
7.28
7.38
7.72
7.83
7.96
8.03
8.16
8.83
9.17
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)
varchar(500)
varchar(500)
varchar(500)
varchar(500)