Skip Navigation Bar

Unified Medical Language System® (UMLS®)

Columns and Data Elements - 2015AA 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
ATNAttribute nameMRSAT.RRF2 - 629.98varchar(100)
ATNLAttribute name list for a sourceMRSAB.RRF0 - 89656.63varchar(1000)
ATUIUnique identifier for attributeMRSTY.RRF
MRDEF.RRF
MRSAT.RRF
10 - 11
10 - 11
10 - 11
10.55
10.73
10.76
varchar(11)
varchar(11)
varchar(11)
ATVAttribute valueMRSAT.RRF1 - 6219214.26varchar(65000)
AUIUnique identifier for atomMRHIER.RRF
MRDEF.RRF
MRCONSO.RRF
8 - 9
8 - 9
8 - 9
8.32
8.65
8.66
varchar(9)
varchar(9)
varchar(9)
AUI1Unique identifier for first atomMRREL.RRF
MRAUI.RRF
0 - 9
8 - 9
8.40
8.48
varchar(9)
varchar(9)
AUI2Unique identifier for second atomMRREL.RRF
MRAUI.RRF
0 - 9
8 - 9
8.40
8.48
varchar(9)
varchar(9)
AVAverage Length, CharactersMRCOLS.RRF4 - 64.12numeric(5,2)
BTSSize in BytesMRFILES.RRF1 - 107.17integer
CENCCharacter encoding of a source as specified by IANAMRSAB.RRF55.00varchar(20)
CFRCUI frequency for a sourceMRSAB.RRF1 - 63.91integer
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.13integer
CODEUnique Identifier or code for string in sourceMRSAT.RRF
MRCONSO.RRF
0 - 50
1 - 63
4.76
7.30
varchar(100)
varchar(100)
COLColumn or data element nameMRCOLS.RRF2 - 113.80varchar(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_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)
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.53
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.08
0.15
0.19
1.15
1.83
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 - 41.98integer
CXTYContext type for a sourceMRSAB.RRF0 - 315.78varchar(50)
DEFDefinitionMRDEF.RRF3 - 10258221.00varchar(16000)
DESDescriptive NameMRCOLS.RRF
MRFILES.RRF
5 - 136
8 - 42
29.27
18.28
varchar(200)
varchar(200)
DIRSource asserted directionality flagMRREL.RRF0 - 10.16varchar(1)
DOCKEYKey to be documentedMRDOC.RRF2 - 83.58varchar(50)
DTYSQL-92 data type for this columnMRCOLS.RRF7 - 1410.05varchar(20)
EXPLDetailed explanationMRDOC.RRF0 - 94127.68varchar(1000)
FILPhysical FILENAMEMRCOLS.RRF
MRFILES.RRF
9 - 21
9 - 21
10.89
12.13
varchar(50)
varchar(50)
FMTComma separated list of COLMRFILES.RRF7 - 19031.22varchar(300)
FROMEXPRThe expression that a mapping is mapped fromMRSMAP.RRF
MRMAP.RRF
1 - 8
1 - 17
6.67
7.44
varchar(4000)
varchar(4000)
FROMIDMetathesaurus identifier for the entity being mapped fromMRMAP.RRF1 - 177.40varchar(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.96
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_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)
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_KOR.RRF
MRXW_DUT.RRF
MRXW_GER.RRF
MRXW_SPA.RRF
AMBIGLUI.RRF
MRXW_POR.RRF
MRXW_RUS.RRF
MRXW_ITA.RRF
MRXW_JPN.RRF
MRXW_POL.RRF
MRXW_SCR.RRF
MRXW_FRE.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.88
8.00
8.00
8.00
8.00
8.00
8.00
8.01
8.02
8.05
8.06
8.08
8.09
8.09
8.10
8.10
8.10
8.11
8.12
8.14
8.15
8.21
8.22
8.22
8.98
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)
MAPATNMapping attribute name (for future use)MRMAP.RRF0 - 62.18varchar(20)
MAPATVMapping attribute value (for future use)MRMAP.RRF0 - 10.16varchar(4000)
MAPIDMetathesaurus asserted identifier for mappingMRSMAP.RRF
MRMAP.RRF
10 - 11
10 - 11
10.96
10.99
varchar(50)
varchar(50)
MAPINMapping in current subsetMRCUI.RRF
MRAUI.RRF
0 - 1
1
0.94
1.00
char(1)
char(1)
MAPRANKOrder in which mappings in a subset should be appliedMRMAP.RRF0 - 20.38integer
MAPREASONReason for mappingMRCUI.RRF
MRAUI.RRF
0 - 4
4
0.00
4.00
varchar(4000)
varchar(4000)
MAPRESRestriction applicable to this mappingMRMAP.RRF0 - 45216.27varchar(4000)
MAPRULEMachine processible rule applicable to this mappingMRMAP.RRF0 - 2985.69varchar(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
6.75
8.56
varchar(40)
varchar(40)
MAPSIDSource asserted identifier for mappingMRSMAP.RRF
MRMAP.RRF
0
0 - 36
0.00
5.64
varchar(50)
varchar(50)
MAPSUBSETIDMap subset identifier used to identify a subset of related mappings within a map setMRMAP.RRF0 - 31.36varchar(10)
MAPTYPEType of mappingMRMAP.RRF0 - 93.31varchar(50)
MAXMaximum LengthMRCOLS.RRF1 - 51.40integer
METAUIMetathesaurus asserted unique identifierMRSAT.RRF0 - 107.66varchar(50)
MINMinimum LengthMRCOLS.RRF1 - 21.02integer
NSTRNormalized stringMRXNS_ENG.RRF1 - 252838.81varchar(3000)
NWDNormalized wordMRXNW_ENG.RRF1 - 806.36varchar(100)
PAUIUnique identifier for parent atomMRHIER.RRF0 - 98.26varchar(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.48
varchar(10)
varchar(10)
PSTRPreferred name in the previous MetathesaurusCHANGE/DELETEDSUI.RRF
CHANGE/DELETEDLUI.RRF
CHANGE/DELETEDCUI.RRF
1 - 511
1 - 511
3 - 566
53.83
54.04
65.22
varchar(3000)
varchar(3000)
varchar(3000)
PSUIString unique identifier in the previous MetathesaurusCHANGE/DELETEDSUI.RRF8 - 98.59varchar(10)
PTRPath to rootMRHIER.RRF0 - 36297.18varchar(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.06
2.56
varchar(4)
varchar(4)
varchar(4)
varchar(4)
varchar(4)
RELAAdditional relationship labelMRAUI.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
12.98
2.60
6.25
8.33
varchar(100)
varchar(100)
varchar(100)
varchar(100)
varchar(100)
varchar(100)
RGRelationship groupMRREL.RRF0 - 30.08varchar(10)
RMETAVersion of the Metathesaurus where a version is removedMRSAB.RRF0 - 60.26varchar(10)
RSABRoot source abbreviationMRSAB.RRF2 - 155.81varchar(40)
RUIUnique identifier for relationshipMRREL.RRF9 - 109.54varchar(10)
RWSNumber of rowsMRFILES.RRF1 - 85.41integer
SABSource abbreviationMRHIST.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.88
5.28
5.52
5.64
6.26
7.55
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.11
4.38
varchar(50)
varchar(50)
SAUISource asserted atom identifierMRCONSO.RRF0 - 182.38varchar(50)
SCCContent contact info for a sourceMRSAB.RRF0 - 343131.45varchar(1000)
SCITSource citationMRSAB.RRF33 - 445140.04varchar(4000)
SCUISource asserted concept identifierMRCONSO.RRF0 - 505.36varchar(50)
SDUISource asserted descriptor identifierMRCONSO.RRF0 - 132.09varchar(50)
SFSource FamilyMRSAB.RRF2 - 134.17varchar(40)
SLSource of relationship labelsMRREL.RRF2 - 155.52varchar(40)
SLCLicense contact info for a sourceMRSAB.RRF0 - 360158.71varchar(1000)
SONSource Official NameMRSAB.RRF10 - 14548.41varchar(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.60varchar(50)
SSNSource short nameMRSAB.RRF3 - 8921.37varchar(3000)
STNSemantic type tree numberMRSTY.RRF1 - 147.63varchar(100)
STRStringMRCONSO.RRF1 - 291637.00varchar(3000)
STTString typeMRCONSO.RRF2 - 32.01varchar(3)
STYSemantic typeMRSTY.RRF4 - 3916.65varchar(50)
STYPEThe name of the column in MRCONSO.RRF or MRREL.RRF that contains the identifier to which the attribute is attachedMRSAT.RRF3 - 43.23varchar(50)
STYPE1The name of the column in MRCONSO.RRF that contains the first identifier to which the relationship is attachedMRREL.RRF3 - 43.71varchar(50)
STYPE2The name of the column in MRCONSO.RRF that contains the second identifier to which the relationship is attachedMRREL.RRF3 - 43.71varchar(50)
SUIUnique identifier for stringMRSAT.RRF
MRXW_BAQ.RRF
MRXW_DAN.RRF
MRXW_FIN.RRF
MRXW_HEB.RRF
MRXW_DUT.RRF
MRXW_GER.RRF
MRXW_SPA.RRF
MRXW_RUS.RRF
AMBIGSUI.RRF
MRXW_POR.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
4.97
8.00
8.00
8.00
8.00
8.03
8.12
8.14
8.15
8.17
8.17
8.17
8.21
8.25
8.31
8.35
8.48
8.50
8.50
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)
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 - 19
0.00
5.35
varchar(20)
varchar(20)
TFRTerm frequency for a sourceMRSAB.RRF1 - 74.06integer
TOEXPRThe expression that a mapping is mapped toMRMAP.RRF
MRSMAP.RRF
0 - 242
0 - 242
5.90
7.05
varchar(4000)
varchar(4000)
TOIDMetathesaurus identifier for the entity being mapped toMRMAP.RRF0 - 175.47varchar(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
0 - 23
4.22
5.05
varchar(50)
varchar(50)
TSTerm statusMRCONSO.RRF11.00char(1)
TTYTerm type in sourceMRCONSO.RRF
MRRANK.RRF
2 - 11
2 - 11
2.33
2.64
varchar(20)
varchar(20)
TTYLTerm type list for a sourceMRSAB.RRF0 - 12914.67varchar(400)
TUIUnique identifier of Semantic typeMRSTY.RRF44.00char(4)
TYPEType of informationMRDOC.RRF3 - 2112.83varchar(50)
VALUEValueMRDOC.RRF0 - 6214.12varchar(200)
VCUIUnique identifier for versioned SRC conceptMRSAB.RRF0 - 87.53char(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 - 2611.82varchar(40)
VSTARTValid start date for a sourceMRSAB.RRF00.00char(8)
WDWord in lower-caseMRXW_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.58
6.66
6.78
7.00
7.17
7.28
7.37
7.70
8.04
8.16
8.31
8.51
8.62
9.14
9.58
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)

Abbreviation Description File Length of Value in characters Average Length of Value in characters SQL92 Datatype
ATNAttribute nameMRSAT2 - 627.03varchar(100)
ATNLAttribute name list for a sourceMRSAB0 - 88946.33varchar(4000)
ATVAttribute valueMRSAT1 - 6219211.01varchar(65000)
ATXAssociated expressionMRATX5 - 24235.85varchar(300)
AVAverage Length, CharactersMRCOLS4 - 64.11numeric(5,2)
BTSSize in BytesMRFILES1 - 107.14integer
CENCCharacter encoding of a source as specified by IANAMRSAB55.00varchar(20)
CFRCUI frequency for a sourceMRSAB1 - 63.91integer
CLSNumber of columnsMRFILES1 - 21.02integer
CODEUnique Identifier or code for string in sourceMRSAT
MRSO
0 - 50
1 - 63
5.94
7.30
varchar(50)
varchar(50)
COLColumn or data element nameMRCOLS2 - 63.12varchar(10)
CRELRelationship to retired CUI (CUI1) to current CUI (CUI2)MRCUI2 - 32.06varchar(4)
CUIUnique identifier for conceptAMBIG.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)
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.53
8.00
char(8)
char(8)
CURVERCurrent Version flagMRSAB11.00char(1)
CXTYContext type for a source (as per section 2.3.2)MRSAB0 - 315.78varchar(50)
DEFDefinitionMRDEF3 - 10258222.40varchar(16000)
DESDescriptive NameMRCOLS
MRFILES
5 - 56
7 - 42
25.83
18.12
varchar(100)
varchar(100)
DOCKEYKey to be documentedMRDOC2 - 83.56varchar(50)
DTYSQL-92 data type for this columnMRCOLS7 - 149.68varchar(20)
EXPLDetailed explanationMRDOC0 - 94127.34varchar(1000)
FILPhysical FILENAMEMRCOLS
MRFILES
4 - 18
4 - 18
7.41
8.37
varchar(50)
varchar(50)
FMTComma separated list of COLMRFILES7 - 11219.98varchar(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.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)
LRLLeast Restriction LevelMRCON11.00integer
LUIUnique identifier for termCHANGE/MERGED.LUI
MRSAT
MRXW.BAQ
MRXW.DAN
MRXW.FIN
MRXW.HEB
MRXW.SWE
MRXW.LAV
MRXW.KOR
MRXW.DUT
MRXW.GER
MRXW.SPA
AMBIG.LUI
MRXW.POR
MRXW.RUS
MRXW.ITA
MRXW.JPN
MRXW.POL
MRXW.SCR
MRXW.FRE
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.28
8.00
8.00
8.00
8.00
8.00
8.00
8.01
8.02
8.05
8.06
8.08
8.09
8.09
8.10
8.10
8.10
8.11
8.12
8.14
8.15
8.17
8.21
8.22
8.22
8.98
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)
MAPINMapping in current subsetMRCUI0 - 10.94char(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 - 252838.81varchar(3000)
NWDNormalized wordMRXNW.ENG1 - 806.36varchar(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.48
varchar(10)
varchar(10)
PSTRPreferred name in the previous MetathesaurusCHANGE/DELETED.SUI
CHANGE/DELETED.LUI
CHANGE/DELETED.CUI
1 - 511
1 - 511
3 - 566
53.83
54.04
65.22
varchar(3000)
varchar(3000)
varchar(3000)
PSUIString unique identifier in the previous MetathesaurusCHANGE/DELETED.SUI8 - 98.59varchar(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.17varchar(100)
RMETAVersion of the Metathesaurus where a version is removedMRSAB0 - 60.26varchar(10)
RSABRoot source abbreviationMRSAB2 - 155.81varchar(40)
RWSNumber of rowsMRFILES1 - 85.44integer
SABSource abbreviationMRDEF
MRSAT
MRRANK
MRREL
MRSO
MRATX
2 - 13
2 - 13
2 - 15
2 - 15
2 - 15
3
3.87
5.20
5.28
5.32
5.64
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 - 343131.45varchar(1000)
SFSource FamilyMRSAB2 - 134.17varchar(40)
SLSource of relationship labelsMRREL2 - 155.32varchar(40)
SLCLicense contact info for a sourceMRSAB0 - 360158.71varchar(1000)
SONSource Official NameMRSAB10 - 14548.41varchar(3000)
SRLSource Restriction LevelMRSAB
MRSO
1
1
1.00
1.00
integer
integer
STRStringMRCON1 - 291638.57varchar(3000)
STTString typeMRCON2 - 32.01varchar(3)
STYSemantic typeMRSTY4 - 3916.65varchar(50)
SUIUnique identifier for stringMRSAT
MRXW.BAQ
MRXW.DAN
MRXW.FIN
MRXW.HEB
MRXW.DUT
MRXW.GER
MRXW.SPA
MRXW.RUS
AMBIG.SUI
MRXW.POR
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.41
8.00
8.00
8.00
8.00
8.03
8.12
8.14
8.15
8.17
8.17
8.17
8.21
8.25
8.31
8.35
8.38
8.48
8.50
8.50
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)
SUPRESSuppressible flagMRRANK11.00char(1)
SVERRelease date or version number of a sourceMRSAB0 - 195.35varchar(20)
TFRTerm frequency for a sourceMRSAB1 - 74.06integer
TSTerm statusMRCON11.00char(1)
TTYTerm type in sourceMRSO
MRRANK
2 - 11
2 - 11
2.33
2.64
varchar(20)
varchar(20)
TTYLTerm type list for a sourceMRSAB0 - 12914.67varchar(400)
TUIUnique identifier of Semantic typeMRSTY44.00char(4)
TYPEType of informationMRDOC3 - 2112.82varchar(50)
VALUEValueMRDOC0 - 6214.23varchar(200)
VCUIUnique identifier for versioned SRC conceptMRSAB0 - 87.53char(8)
VERLast release version in which CUI1 was validMRCUI66.00varchar(10)
VSABVersioned source abbreviationMRSAB3 - 2611.82varchar(40)
WDWord in lower-caseMRXW.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.58
6.66
6.78
7.00
7.17
7.28
7.37
7.70
8.04
8.16
8.31
8.51
8.62
9.14
9.58
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)