Skip Navigation Bar
NLM logo

Columns and Data Elements - 2023AB

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 - 6211.25varchar(100)
ATNLAttribute name list for a source.MRSAB.RRF0 - 117869.62varchar(4000)
ATUIUnique identifier for attribute.MRSTY.RRF
MRDEF.RRF
MRSAT.RRF
10 - 11
10 - 11
10 - 11
10.64
10.86
10.88
varchar(11)
varchar(11)
varchar(11)
ATVAttribute valueMRSAT.RRF1 - 3598514.76varchar(65000)
AUIUnique identifier for atomMRHIER.RRF
MRDEF.RRF
MRCONSO.RRF
8 - 9
8 - 9
8 - 9
8.60
8.75
8.78
varchar(9)
varchar(9)
varchar(9)
AUI1Unique identifier for first atomMRREL.RRF
MRAUI.RRF
0 - 9
8 - 9
8.52
8.55
varchar(9)
varchar(9)
AUI2Unique identifier for second atomMRREL.RRF
MRAUI.RRF
0 - 9
8 - 9
8.52
8.55
varchar(9)
varchar(9)
AVAverage Length, CharactersMRCOLS.RRF4 - 64.14numeric(5,2)
BTSSize in BytesMRFILES.RRF1 - 107.46integer
CENCCharacter encoding of a source as specified by IANAMRSAB.RRF55.00varchar(20)
CFRCUI frequency for a sourceMRSAB.RRF1 - 64.16integer
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 - 56
1 - 95
4.40
7.53
varchar(100)
varchar(100)
COLColumn or data element nameMRCOLS.RRF2 - 113.71varchar(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_ARA.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
MRXW_UKR.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
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
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)
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
3.71
8.00
8.00
char(8)
char(8)
char(8)
CURVERCurrent Version flagMRSAB.RRF11.00char(1)
CVFContent view flagMRDEF.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
0.98
1.80
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.20integer
CXTYContext type for a sourceMRSAB.RRF0 - 135.13varchar(50)
DEFDefinitionMRDEF.RRF1 - 10939232.01varchar(16000)
DESDescriptive NameMRCOLS.RRF
MRFILES.RRF
5 - 136
8 - 42
28.81
18.25
varchar(200)
varchar(200)
DIRSource asserted directionality flagMRREL.RRF0 - 10.25varchar(1)
DOCKEYKey to be documentedMRDOC.RRF2 - 83.64varchar(50)
DTYSQL-92 data type for this columnMRCOLS.RRF7 - 1410.02varchar(20)
EXPLDetailed explanationMRDOC.RRF0 - 94126.26varchar(1000)
FILPhysical FILENAMEMRCOLS.RRF
MRFILES.RRF
9 - 21
9 - 21
10.99
12.12
varchar(50)
varchar(50)
FMTComma separated list of COLMRFILES.RRF7 - 19029.69varchar(300)
FROMEXPRThe expression that a mapping is mapped fromMRSMAP.RRF
MRMAP.RRF
1 - 9
1 - 18
6.93
8.34
varchar(4000)
varchar(4000)
FROMIDMetathesaurus identifier for the entity being mapped fromMRMAP.RRF1 - 187.39varchar(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 - 510.46varchar(100)
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_ARA.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
MRXW_UKR.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
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
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)
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_SCR.RRF
MRXW_JPN.RRF
AMBIGLUI.RRF
MRCONSO.RRF
MRXW_CZE.RRF
MRXNS_ENG.RRF
MRXW_ENG.RRF
MRXNW_ENG.RRF
MRXW_DUT.RRF
MRXW_GER.RRF
MRXW_SPA.RRF
MRXW_ITA.RRF
MRXW_POR.RRF
MRXW_FRE.RRF
MRXW_RUS.RRF
MRXW_POL.RRF
MRXW_SWE.RRF
MRXW_KOR.RRF
MRXW_NOR.RRF
MRXW_HUN.RRF
MRXW_LAV.RRF
MRXW_ARA.RRF
MRXW_CHI.RRF
MRXW_EST.RRF
MRXW_GRE.RRF
MRXW_TUR.RRF
MRXW_UKR.RRF
0
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
8 - 9
8 - 9
8 - 9
9
9
9
9
9
9
0.00
4.39
8.00
8.00
8.00
8.00
8.17
8.20
8.24
8.42
8.43
8.44
8.44
8.45
8.49
8.54
8.55
8.74
8.75
8.78
8.78
8.84
8.86
8.91
8.98
8.99
8.99
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)
varchar(10)
varchar(10)
MAPATNMapping attribute name (for future use)MRMAP.RRF0 - 62.89varchar(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.46
1.00
char(1)
char(1)
MAPRANKOrder in which mappings in a subset should be appliedMRMAP.RRF0 - 20.50integer
MAPREASONReason for mappingMRCUI.RRF
MRAUI.RRF
0 - 4
4
0.00
4.00
varchar(4000)
varchar(4000)
MAPRESRestriction applicable to this mappingMRMAP.RRF0 - 42937.11varchar(4000)
MAPRULEMachine processible rule applicable to this mappingMRMAP.RRF0 - 33610.76varchar(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
10.58
10.71
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 - 10.50varchar(10)
MAPTYPEType of mappingMRMAP.RRF0 - 94.36varchar(50)
MAXMaximum LengthMRCOLS.RRF1 - 51.40integer
METAUIMetathesaurus asserted unique identifierMRSAT.RRF0 - 108.15varchar(50)
MINMinimum LengthMRCOLS.RRF1 - 21.02integer
NSTRNormalized stringMRXNS_ENG.RRF1 - 252839.50varchar(3000)
NWDNormalized wordMRXNW_ENG.RRF1 - 806.44varchar(100)
PAUIUnique identifier for parent atomMRHIER.RRF0 - 98.48varchar(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.87
varchar(10)
varchar(10)
PSTRPreferred name in the previous MetathesaurusCHANGE/DELETEDSUI.RRF
CHANGE/DELETEDLUI.RRF
CHANGE/DELETEDCUI.RRF
3 - 2930
3 - 2930
5 - 2930
100.65
103.19
217.43
varchar(3000)
varchar(3000)
varchar(3000)
PSUIString unique identifier in the previous MetathesaurusCHANGE/DELETEDSUI.RRF8 - 98.89varchar(10)
PTRPath to rootMRHIER.RRF0 - 345104.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
MRREL.RRF
MRCUI.RRF
0
2
2
2 - 3
2 - 3
0.00
2.00
2.00
2.22
2.54
varchar(4)
varchar(4)
varchar(4)
varchar(4)
varchar(4)
RELAAdditional relationship labelMRAUI.RRF
MRCUI.RRF
MRREL.RRF
MRMAP.RRF
MRSMAP.RRF
MRHIER.RRF
0
0
0 - 54
0 - 37
0 - 37
0 - 12
0.00
0.00
11.42
13.89
19.85
2.71
varchar(100)
varchar(100)
varchar(100)
varchar(100)
varchar(100)
varchar(100)
RGRelationship groupMRREL.RRF0 - 30.12varchar(10)
RMETAVersion of the Metathesaurus where a version is removedMRSAB.RRF0 - 60.15varchar(10)
RSABRoot source abbreviationMRSAB.RRF2 - 155.95varchar(40)
RUIUnique identifier for relationshipMRREL.RRF9 - 109.78varchar(10)
RWSNumber of rowsMRFILES.RRF1 - 85.67integer
SABSource abbreviationMRHIST.RRF
MRDEF.RRF
MRRANK.RRF
MRCONSO.RRF
MRREL.RRF
MRSAT.RRF
MRHIER.RRF
0
2 - 11
2 - 15
2 - 15
2 - 15
2 - 13
2 - 13
0.00
4.11
5.49
5.89
5.96
6.34
7.86
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 - 16
0 - 36
0.52
4.59
varchar(50)
varchar(50)
SAUISource asserted atom identifierMRCONSO.RRF0 - 182.26varchar(100)
SCCContent contact info for a sourceMRSAB.RRF0 - 332152.78varchar(1000)
SCITSource citationMRSAB.RRF52 - 674163.65varchar(4000)
SCUISource asserted concept identifierMRCONSO.RRF0 - 955.33varchar(100)
SDUISource asserted descriptor identifierMRCONSO.RRF0 - 132.51varchar(100)
SFSource FamilyMRSAB.RRF2 - 134.24varchar(40)
SLSource of relationship labelsMRREL.RRF2 - 155.96varchar(40)
SLCLicense contact info for a sourceMRSAB.RRF12 - 346167.91varchar(1000)
SONSource Official NameMRSAB.RRF10 - 14548.47varchar(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 - 362.59varchar(50)
SSNSource short nameMRSAB.RRF3 - 8925.49varchar(3000)
STNSemantic type tree numberMRSTY.RRF1 - 147.78varchar(100)
STRStringMRCONSO.RRF1 - 287539.27varchar(3000)
STTString typeMRCONSO.RRF2 - 32.01varchar(3)
STYSemantic typeMRSTY.RRF4 - 3917.46varchar(50)
STYPEThe name of the column in MRCONSO.RRF or MRREL.RRF that contains the identifier to which the attribute is attachedMRSAT.RRF3 - 43.22varchar(50)
STYPE1The name of the column in MRCONSO.RRF that contains the first identifier to which the relationship is attachedMRREL.RRF3 - 43.65varchar(50)
STYPE2The name of the column in MRCONSO.RRF that contains the second identifier to which the relationship is attachedMRREL.RRF3 - 43.65varchar(50)
SUIUnique identifier for stringMRSAT.RRF
MRXW_BAQ.RRF
MRXW_DAN.RRF
MRXW_FIN.RRF
MRXW_HEB.RRF
AMBIGSUI.RRF
MRXW_JPN.RRF
MRXW_DUT.RRF
MRCONSO.RRF
MRXW_GER.RRF
MRXW_SPA.RRF
MRXNS_ENG.RRF
MRXNW_ENG.RRF
MRXW_ENG.RRF
MRXW_ITA.RRF
MRXW_POR.RRF
MRXW_RUS.RRF
MRXW_FRE.RRF
MRXW_CZE.RRF
MRXW_SWE.RRF
MRXW_NOR.RRF
MRXW_HUN.RRF
MRXW_ARA.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
MRXW_UKR.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
9
9
4.46
8.00
8.00
8.00
8.00
8.34
8.35
8.50
8.56
8.57
8.59
8.63
8.66
8.66
8.78
8.78
8.80
8.83
8.87
8.87
8.98
8.99
9.00
9.00
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)
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 - 15
0.00
5.03
varchar(20)
varchar(20)
TFRTerm frequency for a sourceMRSAB.RRF1 - 74.45integer
TOEXPRThe expression that a mapping is mapped toMRMAP.RRF
MRSMAP.RRF
0 - 242
1 - 242
6.02
6.94
varchar(4000)
varchar(4000)
TOIDMetathesaurus identifier for the entity being mapped toMRMAP.RRF0 - 185.20varchar(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 - 22
3.96
4.36
varchar(50)
varchar(50)
TSTerm statusMRCONSO.RRF11.00char(1)
TTYTerm type in sourceMRCONSO.RRF
MRRANK.RRF
2 - 11
2 - 11
2.37
2.61
varchar(20)
varchar(20)
TTYLTerm type list for a sourceMRSAB.RRF0 - 12915.26varchar(400)
TUIUnique identifier of Semantic typeMRSTY.RRF44.00char(4)
TYPEType of informationMRDOC.RRF3 - 2113.04varchar(50)
VALUEValueMRDOC.RRF0 - 6215.81varchar(200)
VCUIUnique identifier for versioned SRC conceptMRSAB.RRF0 - 87.63char(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 - 2411.40varchar(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_ARA.RRF
MRXW_POR.RRF
MRXW_ITA.RRF
MRXW_HEB.RRF
MRXW_ENG.RRF
MRXW_UKR.RRF
MRXW_DAN.RRF
MRXW_SPA.RRF
MRXW_FRE.RRF
MRXW_RUS.RRF
MRXW_BAQ.RRF
MRXW_GRE.RRF
MRXW_POL.RRF
MRXW_CZE.RRF
MRXW_LAV.RRF
MRXW_DUT.RRF
MRXW_HUN.RRF
MRXW_SCR.RRF
MRXW_GER.RRF
MRXW_SWE.RRF
MRXW_JPN.RRF
MRXW_NOR.RRF
1 - 54
1 - 38
1 - 68
1 - 35
1 - 37
1 - 22
1 - 38
1 - 38
1 - 19
1 - 80
1 - 27
1 - 25
1 - 46
1 - 39
1 - 40
1 - 18
1 - 34
1 - 48
1 - 52
1 - 29
1 - 51
1 - 27
1 - 37
1 - 43
1 - 39
1 - 93
1 - 44
10.53
2.84
3.66
4.57
5.27
5.35
5.70
5.94
6.12
6.14
6.37
6.38
6.61
6.80
7.16
7.17
7.27
7.27
7.44
7.75
7.84
7.85
8.02
8.29
8.32
9.08
9.11
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)
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
ATNAttribute nameMRSAT2 - 627.79varchar(100)
ATNLAttribute name list for a sourceMRSAB0 - 116955.37varchar(4000)
ATVAttribute valueMRSAT1 - 3598512.72varchar(65000)
ATXAssociated expressionMRATX5 - 24235.66varchar(300)
AVAverage Length, CharactersMRCOLS4 - 64.12numeric(5,2)
BTSSize in BytesMRFILES1 - 107.49integer
CENCCharacter encoding of a source as specified by IANAMRSAB55.00varchar(20)
CFRCUI frequency for a sourceMRSAB1 - 64.16integer
CLSNumber of columnsMRFILES1 - 21.02integer
CODEUnique Identifier or code for string in sourceMRSAT
MRSO
0 - 56
1 - 95
6.35
7.53
varchar(50)
varchar(50)
COLColumn or data element nameMRCOLS2 - 63.08varchar(10)
CRELRelationship to retired CUI (CUI1) to current CUI (CUI2)MRCUI2 - 32.54varchar(4)
CUIUnique identifier for conceptAMBIG.LUI
AMBIG.SUI
CHANGE/MERGED.CUI
MRATX
MRCON
MRDEF
MRSAT
MRSO
MRSTY
MRXNS.ENG
MRXNW.ENG
MRXW.ARA
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
MRXW.UKR
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
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
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)
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
3.71
8.00
char(8)
char(8)
CURVERCurrent Version flagMRSAB11.00char(1)
CXTYContext type for a source (as per section 2.3.2)MRSAB0 - 135.13varchar(50)
DEFDefinitionMRDEF1 - 10939232.78varchar(16000)
DESDescriptive NameMRCOLS
MRFILES
5 - 56
7 - 42
25.61
18.10
varchar(100)
varchar(100)
DOCKEYKey to be documentedMRDOC2 - 83.64varchar(50)
DTYSQL-92 data type for this columnMRCOLS7 - 149.67varchar(20)
EXPLDetailed explanationMRDOC0 - 94125.94varchar(1000)
FILPhysical FILENAMEMRCOLS
MRFILES
4 - 18
4 - 18
7.48
8.33
varchar(50)
varchar(50)
FMTComma separated list of COLMRFILES7 - 11219.73varchar(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.ARA
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
MRXW.UKR
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
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
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)
char(3)
char(3)
LRLLeast Restriction LevelMRCON11.00integer
LUIUnique identifier for termCHANGE/MERGED.LUI
MRSAT
MRXW.BAQ
MRXW.DAN
MRXW.FIN
MRXW.HEB
MRXW.SCR
MRXW.JPN
AMBIG.LUI
MRSO
MRXW.CZE
MRCON
MRXNS.ENG
MRXW.ENG
MRXNW.ENG
MRXW.DUT
MRXW.GER
MRXW.SPA
MRXW.ITA
MRXW.POR
MRXW.FRE
MRXW.RUS
MRXW.POL
MRXW.SWE
MRXW.KOR
MRXW.NOR
MRXW.HUN
MRXW.LAV
MRXW.ARA
MRXW.CHI
MRXW.EST
MRXW.GRE
MRXW.TUR
MRXW.UKR
0
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
8 - 9
8 - 9
8 - 9
8 - 9
9
9
9
9
9
9
0.00
6.56
8.00
8.00
8.00
8.00
8.17
8.20
8.24
8.42
8.43
8.44
8.44
8.44
8.45
8.49
8.54
8.55
8.74
8.75
8.78
8.78
8.84
8.86
8.91
8.98
8.99
8.99
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)
varchar(10)
varchar(10)
varchar(10)
MAPINMapping in current subsetMRCUI0 - 10.46char(1)
MAXMaximum LengthMRCOLS1 - 51.38integer
MENDMetathesaurus end date for a sourceMRSAB00.00char(8)
MGMachine generated and unverified indicatorMRREL00.00varchar(1)
MINMinimum LengthMRCOLS1 - 21.01integer
MSTARTMetathesaurus start date for a sourceMRSAB00.00char(8)
NSTRNormalized stringMRXNS.ENG1 - 252839.50varchar(3000)
NWDNormalized wordMRXNW.ENG1 - 806.44varchar(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.87
varchar(10)
varchar(10)
PSTRPreferred name in the previous MetathesaurusCHANGE/DELETED.SUI
CHANGE/DELETED.LUI
CHANGE/DELETED.CUI
3 - 2930
3 - 2930
5 - 2930
100.65
103.19
217.43
varchar(3000)
varchar(3000)
varchar(3000)
PSUIString unique identifier in the previous MetathesaurusCHANGE/DELETED.SUI8 - 98.89varchar(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.28
varchar(3)
varchar(3)
RELAAdditional relationship labelMRREL0 - 5410.57varchar(100)
RMETAVersion of the Metathesaurus where a version is removedMRSAB0 - 60.15varchar(10)
RSABRoot source abbreviationMRSAB2 - 155.95varchar(40)
RWSNumber of rowsMRFILES1 - 85.71integer
SABSource abbreviationMRDEF
MRSAT
MRRANK
MRREL
MRSO
MRATX
2 - 11
2 - 13
2 - 15
2 - 15
2 - 15
3
4.11
5.18
5.49
5.76
5.89
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.78varchar(1000)
SFSource FamilyMRSAB2 - 134.24varchar(40)
SLSource of relationship labelsMRREL2 - 155.76varchar(40)
SLCLicense contact info for a sourceMRSAB12 - 346167.91varchar(1000)
SONSource Official NameMRSAB10 - 14548.47varchar(3000)
SRLSource Restriction LevelMRSAB
MRSO
1
1
1.00
1.00
integer
integer
STRStringMRCON1 - 287541.24varchar(3000)
STTString typeMRCON2 - 32.01varchar(3)
STYSemantic typeMRSTY4 - 3917.46varchar(50)
SUIUnique identifier for stringMRSAT
MRXW.BAQ
MRXW.DAN
MRXW.FIN
MRXW.HEB
AMBIG.SUI
MRXW.JPN
MRXW.DUT
MRSO
MRXW.GER
MRCON
MRXW.SPA
MRXNS.ENG
MRXNW.ENG
MRXW.ENG
MRXW.ITA
MRXW.POR
MRXW.RUS
MRXW.FRE
MRXW.CZE
MRXW.SWE
MRXW.NOR
MRXW.HUN
MRXW.ARA
MRXW.CHI
MRXW.EST
MRXW.GRE
MRXW.KOR
MRXW.LAV
MRXW.POL
MRXW.SCR
MRXW.TUR
MRXW.UKR
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
9
9
6.68
8.00
8.00
8.00
8.00
8.34
8.35
8.50
8.56
8.57
8.59
8.59
8.63
8.66
8.66
8.78
8.78
8.80
8.83
8.87
8.87
8.98
8.99
9.00
9.00
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)
varchar(10)
varchar(10)
SUPRESSuppressible flagMRRANK11.00char(1)
SVERRelease date or version number of a sourceMRSAB0 - 155.03varchar(20)
TFRTerm frequency for a sourceMRSAB1 - 74.45integer
TSTerm statusMRCON11.00char(1)
TTYTerm type in sourceMRSO
MRRANK
2 - 11
2 - 11
2.37
2.61
varchar(20)
varchar(20)
TTYLTerm type list for a sourceMRSAB0 - 12915.26varchar(400)
TUIUnique identifier of Semantic typeMRSTY44.00char(4)
TYPEType of informationMRDOC3 - 2113.04varchar(50)
VALUEValueMRDOC0 - 6215.95varchar(200)
VCUIUnique identifier for versioned SRC conceptMRSAB0 - 87.63char(8)
VERLast release version in which CUI1 was validMRCUI66.00varchar(10)
VSABVersioned source abbreviationMRSAB3 - 2411.40varchar(40)
WDWord in lower-caseMRXW.FIN
MRXW.KOR
MRXW.CHI
MRXW.EST
MRXW.TUR
MRXW.ARA
MRXW.POR
MRXW.ITA
MRXW.HEB
MRXW.ENG
MRXW.UKR
MRXW.DAN
MRXW.SPA
MRXW.FRE
MRXW.RUS
MRXW.BAQ
MRXW.GRE
MRXW.POL
MRXW.CZE
MRXW.LAV
MRXW.DUT
MRXW.HUN
MRXW.SCR
MRXW.GER
MRXW.SWE
MRXW.JPN
MRXW.NOR
1 - 54
1 - 38
1 - 68
1 - 35
1 - 37
1 - 22
1 - 38
1 - 38
1 - 19
1 - 80
1 - 27
1 - 25
1 - 46
1 - 39
1 - 40
1 - 18
1 - 34
1 - 48
1 - 52
1 - 29
1 - 51
1 - 27
1 - 37
1 - 43
1 - 39
1 - 93
1 - 44
10.53
2.84
3.66
4.57
5.27
5.35
5.70
5.94
6.12
6.14
6.37
6.38
6.61
6.80
7.16
7.17
7.27
7.27
7.44
7.75
7.84
7.85
8.02
8.29
8.32
9.08
9.11
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)
varchar(500)
varchar(500)

Last Reviewed: May 1, 2023